question

optradba avatar image
optradba asked

WSUS/DHCP Automation

Hi Everyone, I am looking at automating the process of checking missing monthly MS- patches and compare the machine names with that of the records coming from the DHCP. One of the initial problems I faced was trying to connect to the DHCP databases from my SQL Server. Is there a way to automate this step, having to connect to the DHCP server periodically, and compare the data gathered from this step with the data that I shall be getting by querying the WSUS Databases? Thanks in Advance. m@k!
automation
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Shawn_Melton avatar image
Shawn_Melton answered
I'm not aware of any method of applying T-SQL script through SQL Server to the DHCP databases. The only method I have seen is using WMI commands which could be done with VBScript or PowerShell.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

optradba avatar image optradba commented ·
Thanks for the reply, meltondba. Can you please share with me your code just so i could have an idea on how to do this?
0 Likes 0 ·
Shawn_Melton avatar image Shawn_Melton commented ·
Looking at the WMI VBscripts it appears those only handle the local machine, not hitting th DHCP server. With PowerShell I believe the Scripting Guys over on Technet may have wrote up something to make changes to a DHCP server but don't know if they have something to read.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.