IP and MAC addresses

Last Post 11 Mar 2010 06:19 AM by PaulMcKibben. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
PaulMcKibben
New Member
New Member

--
10 Mar 2010 07:40 PM
I am looking for a way to read the IP and MAC addresses of my servers through T-SQL. Can someone point me in the right direction?

Thank you
gunneyk
New Member
New Member

--
11 Mar 2010 06:15 AM
Paul,

TSQL is not the best place to try and do something like that. It's simply not what it was intended to do. But you can write an app or dll etc that can query the servers and pump the data into sql server. Or perhaps create an extended sp or a CLR sp that does the work. I recommend you look at PowerShell for tasks like that. Here are some examples:

http://msdn.microsoft.com/en-us/lib...S.85).aspx
http://www.powershellpro.com/powers...i-methods/
http://www.codeproject.com/KB/IP/ob...ation.aspx


PaulMcKibben
New Member
New Member

--
11 Mar 2010 06:19 AM
Thank you.


Acceptable Use Policy
---