Hi @D D ,
I have done some tests and research on your question. We can query it by the special services used by SCOM management servers and gateway servers.
1, Make sure that the service information is collected by "Hardware Inventory" Client Settings. For example:
(By default, "Default Client Settings" already contains these. If not, please create it manually)
2, Run hardware inventory to gather service information.
3, Then run following query:
> Select SMS_R_System.Name, SMS_G_System_SERVICE.DisplayName from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceId = SMS_R_System.ResourceId where DisplayName = "Servicename"
Below is an example with a service, just for your reference:
This thread for your reference:
SCCM CB | WQL Query to find the specific Service is Running (microsoft.com)
Looking forward to your feedback.
Best regards
Cherry
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.