How to collect each Service name and its Status in Windows?

Here's a command that should do the job:

for /f "tokens=2" %s in ('sc query state^= all ^| find "SERVICE_NAME"') do
    @(for /f "tokens=4" %t in ('sc query %s ^| find "STATE     "') do @echo %s is %t)

How it works:

First sc query state= all | find "SERVICE_NAME" is run. This command is designed to give you the service names, one per line. The carets ^ (which I have removed here) are necessary in order to escape the special characters that you want to affect the sc command and not the for command itself.

Then the initial for /f parses the above output to remove the standard "SERVICE_NAME:" prefix from each line, giving you pure service names. At this point the output looks like this:

C:\>for /f "tokens=2" %s in ('sc query state^= all ^| find "SERVICE_NAME"') do @echo %s
AdobeFlashPlayerUpdateSvc
AeLookupSvc
ALG
AppIDSvc
Appinfo
AppMgmt
aspnet_state
AudioEndpointBuilder
AudioSrv

This output is then fed to the next for /f, which runs sc query servicename, finds the line with the state, and isolates the 4th "word" (the current state).

Finally, the name of each service is printed along with its state (at this point you can choose to do something different if you wish).

Important note: If you run this inside a batch file, the percent signs (e.g. at %s) need to be doubled.

Try Get-Service

PowerShell has Get-Service. It has a little less detail than sc.exe.

Try SC.exe

sc.exe query state= all

(Note: sc query state=all will NOT work. You NEED the space sign after the equals sign. Otherwise you will get this weird error: [SC] EnumQueryServicesStatus:OpenService FAILED 1060: The specified service does not exist as an installed service.)

Source: https://ss64.com/nt/sc.html

By the way

sc query | findstr SERVICE_NAME

will show only active (RUNNING) services, so there is no need to filter status (STATE).

Try SC with findstr syntax that supports multiple filtered items:

sc query state= all | findstr "SERVICE_NAME STATE"

or

sc query state= all | findstr "DISPLAY_NAME STATE"

or both

sc query state= all | findstr "SERVICE_NAME DISPLAY_NAME STATE"