This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Learn More

Remove From My Forums

Service Details On Local & Remote Machines

Question
0

Sign in to vote
Hello Forum

Is there a way to get the following information for the SQL Server Services in a domain: -

Host Name
Service Name (E.g, SQL Server, SQL Server Agent etc)
Instance Name
Startup Account
Startup Type (Automatic, manual etc)
Status (Running/Stopped)

We're wanting to grab this information and store it in a Table.

Please click "Mark As Answer" if my post helped. Tony C.
- Edited by Anthony C-UK Monday, October 10, 2016 11:24 AM Added host name
Monday, October 10, 2016 11:01 AM

Answers

0

Sign in to vote
Hello Anthony,

One easy way is to utilize PowerShell, you can find a small script here: Check SQL Server related services on several machines

Or a bit more complex: Create Inventory of SQL Server in Network as Html
Olaf Helper
[ Blog] [ Xing] [ MVP]
- Marked as answer by Anthony C-UK Monday, October 10, 2016 11:49 AM
Monday, October 10, 2016 11:42 AM

All replies

0

Sign in to vote
Check this:

select * from sys.dm_server_services

Please click "Mark As Answer" if my post helped. Vijay.
Monday, October 10, 2016 11:19 AM
0

Sign in to vote

This will only work if the Service is up and running, is there a way to get the information from the Operating System?
Please click "Mark As Answer" if my post helped. Tony C.

Monday, October 10, 2016 11:23 AM
0

Sign in to vote
Hello Anthony,

One easy way is to utilize PowerShell, you can find a small script here: Check SQL Server related services on several machines

Or a bit more complex: Create Inventory of SQL Server in Network as Html
Olaf Helper
[ Blog] [ Xing] [ MVP]
- Marked as answer by Anthony C-UK Monday, October 10, 2016 11:49 AM
Monday, October 10, 2016 11:42 AM
0

Sign in to vote

Thanks Olaf; looks like this will give us just what we need.
Please click "Mark As Answer" if my post helped. Tony C.

Monday, October 10, 2016 11:50 AM