October 20, 2015 at 8:27 am
The Network team at my job asked me to identify over 1000 service accounts in AD and note if they are active or not.
How can I query the master.dbo.server_principals tables on all of our servers and return the 'name' field into one database
remotely?
Once I have all the login-names in one table I'll compare that to the Network team's Excel file.
Thanks
October 20, 2015 at 8:35 am
In SSMS, choose Registered Servers from the View menu. Register any server as a Central Management Server. Right-click on that server and choose New Group, and create a group call AD Accounts or something like that. Add the servers you want to check into that group. Now right-click on the group name and choose New Query. Type your query into the new window. When you press Execute, it'll run against all servers in the group, and you can copy and paste the results into Excel or wherever you need them.
John
October 20, 2015 at 11:26 am
That worked perfect. Thank You so much
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply