PENDING sccm query to check if specific service is running

[Hemald]

Is there any query in sccm to pull the machines with a specific service is running or not for a installed software. In our organization CMPivot is disabled. The application that I am looking is not in Add Remove Programs .Can some one kindly help

 

[Garth]

Is there any query in sccm to pull the machines with a specific service is running or not for a installed software. In our organization CMPivot is disabled. The application that I am looking is not in Add Remove Programs .Can some one kindly help

Isn't there a builtin report for this? can't access my lab right now.
otherwise you can find the sql view here to create your own report. https://learn.microsoft.com/en-us/m...lviews/sql-server-views-configuration-manager