Greetings all,
I'm trying to use the PowerShell Run Command Script to collect service status information but I can't seem to get it to do what I want and could use a little help. The command I am running is "Get-CimInstance -ClassName Win32_Service -Filter "Startmode='Auto'" | Select-Object Name,@{n="Started";e={[int]$_.Started}}" and I am trying to collect data on it. Service started is 1 and stopped is 0.

Basically the end result is I need to build a report around a group of services on select services to list them as running/stopped. I'm doing this in SSRS. I tried using the NT_ServiceDown script but it collects data on all services, not just the ones set to automatic, (I just put a support request in on that).

If I could get the PS script to collect that data that would be great. Any help would be greatly appreciated. Hope I make sense here in what I am trying to do.