PENDING need a query or report to get the status of a service from SCCM clients

[venkateshcme_81]

we have around 17K clients in our environment recently we found that some services are not running in some systems because of which there are problems
can we get a sql query or a report to find the status of a service (started , running, stopped , disabled) from all the clients (SMS00001-collection)

 

[Garth]

Have you looked at the built-in reports for this.

 

[venkateshcme_81]

Have you looked at the built-in reports for this.

Yes but nothing found in case if your confident about any built in report to get the status of a service (running stopped or disabled) for all computers sms0001 let me know so that I can check and I will get back to you

 

[Garth]

Your first stop should be with the builtin report. Since there are report for Service, if they don't give you exactly what you need then you need to create a clone of a report that is closest to what you want, edit the query itself to give you the results.

 

[venkateshcme_81]

sorry could not catch you.....

 

[Garth]

sorry could not catch you.....

If they are not what you want. you need to create your own.

 

[venkateshcme_81]

i have checked the internal in built reports no luck and SQL script or any other way.