Sunday, May 18, 2014

SQL Query To List Excluded Servers With RegRead

This SQL query will allow you to retrieve or list the machines in the excluded Servers list for your SMS server exclusions using the extended procedure RegRead.
SQL Query:
Exec Master..Xp_RegRead
‘HKEY_LOCAL_MACHINE’,
‘Software\Microsoft\Sms\Components\Sms_Discovery_Data_Manager’,
‘ExcludeServers’

No comments:

Post a Comment