September 13, 2018 at 3:34 pm
We have a large quantity of sql servers in a few locations. It would be extremely helpful to provide a list of these servers to a utility and get a list of the sql server service accounts each server uses.
Does such a utility exist?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
September 14, 2018 at 12:02 am
Hi,
do you mean something like that:
SELECT servicename,
last_startup_time,
service_account
FROM sys.dm_server_services
Best regards,
Andreas
September 14, 2018 at 10:39 am
close. I'd like to feed the utility a list of sql servers. It reads the list and produces a list of the sql service accounts for each server.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
September 14, 2018 at 11:33 am
Since this is something you might need outside of SQL Server, perhaps needing the SSIS, SSAS , etc items, you might want to look at PoSh. You could read a list of servers and then search out the service accounts. Since there are potentially instances as well, I might look at reading the services list with Get-Service.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply