PowerShell Check all SolarWinds Services are running within the environment as a morning check

I'm trying to run a morning check to ensure that all SolarWinds and SQL based services are running within the environment.

I've got this far with it and it isn't working at the moment;

$myServiceArray=@()
$myServiceArray="*Solar*","*SQL*"

Foreach($Service in $myServiceArray){

Try {

$servers = Get-Content "C:\SolarWinds\PowerShell\TEST.txt"
$Result=Get-Service -ComputerName $servers -Name $Service |Select Hostname,Service,Status > C:\SolarWinds\PowerShell\Results.txt
}

And I'm getting this within the text file;

Hostname Service Status
-------------- ---------- --------

Running
Stopped
Running
Stopped

Would appreciate any help to get this working.

Thanks

Find more posts tagged with

orion_sdk

solarwinds

Services

PowerShell

solarwinds orion sdk

Accepted answers

KMSigma.SWI

You are using the wrong property names from Select-Object.

I just threw this together and it seems to work the way you are intending.

$myServiceArray = @()
$myServiceArray = "Solar*", "*SQL*"

$Report = @()
ForEach( $Service in $myServiceArray ) {
    try {

        $servers = Get-Content -Path ".\ServerList.txt"
        $Results = Get-Service -ComputerName $servers -DisplayName $Service | Select-Object -Property MachineName, DisplayName, Status 
        if ( $Results ) {
            $Report += $Results
        }
    }
    catch {
        Write-Error -Message "Something went sideways"
    }
}
if ( $Report ) {
    $Report | Out-File -FilePath ".\Results.txt" -Force
}

Results File Contents:

MachineName  DisplayName                                         Status
-----------  -----------                                         ------
NOCKMSMPE01v SolarWinds NetFlow Service                         Running
NOCKMSMPE01v SolarWinds Orion Module Engine                     Running
NOCKMSMPE01v SolarWinds SFTP/SCP Server                         Stopped
NOCKMSMPE01v SolarWinds TFTP Server                             Running
NOCKMSMPE01v SolarWinds Administration Service                  Running
NOCKMSMPE01v SolarWinds Agent                                   Running
NOCSQL01     SolarWinds Agent                                   Running
NOCKMSMPE01v SolarWinds Alerting Service V2                     Running
NOCKMSMPE01v SolarWinds Cortex                                  Running
NOCKMSMPE01v SolarWinds HighAvailability                        Running
NOCKMSMPE01v SolarWinds Log Manager for Orion Polling Service   Running
NOCKMSMPE01v SolarWinds Recommendations                         Running
NOCKMSMPE01v SolarWinds Log Manager for Orion Syslog Service    Running
NOCKMSMPE01v SolarWinds Log Manager for Orion Trap Service      Running
NOCKMSMPE01v SolarWinds Collector Service                       Running
NOCKMSMPE01v SolarWinds Information Service V3                  Running
NOCKMSMPE01v SolarWinds JMX Bridge                              Running
NOCKMSMPE01v SolarWinds Job Engine v2                           Running
NOCKMSMPE01v SolarWinds WPM Playback Player Proxy               Running
NOCKMSMPE01v SolarWinds WPM Playback Player                     Running
NOCSQL01     SQL Full-text Filter Daemon Launcher (MSSQLSERVER) Running
NOCSQL01     SQL Server (MSSQLSERVER)                           Running
NOCSQL01     SQL Server Browser                                 Running
NOCSQL01     SQL Server Agent (MSSQLSERVER)                     Running
NOCSQL01     SQL Server CEIP service (MSSQLSERVER)              Running
NOCSQL01     SQL Server VSS Writer                              Running

All comments

KMSigma.SWI

You are using the wrong property names from Select-Object.

I just threw this together and it seems to work the way you are intending.

$myServiceArray = @()
$myServiceArray = "Solar*", "*SQL*"

$Report = @()
ForEach( $Service in $myServiceArray ) {
    try {

        $servers = Get-Content -Path ".\ServerList.txt"
        $Results = Get-Service -ComputerName $servers -DisplayName $Service | Select-Object -Property MachineName, DisplayName, Status 
        if ( $Results ) {
            $Report += $Results
        }
    }
    catch {
        Write-Error -Message "Something went sideways"
    }
}
if ( $Report ) {
    $Report | Out-File -FilePath ".\Results.txt" -Force
}

Results File Contents:

MachineName  DisplayName                                         Status
-----------  -----------                                         ------
NOCKMSMPE01v SolarWinds NetFlow Service                         Running
NOCKMSMPE01v SolarWinds Orion Module Engine                     Running
NOCKMSMPE01v SolarWinds SFTP/SCP Server                         Stopped
NOCKMSMPE01v SolarWinds TFTP Server                             Running
NOCKMSMPE01v SolarWinds Administration Service                  Running
NOCKMSMPE01v SolarWinds Agent                                   Running
NOCSQL01     SolarWinds Agent                                   Running
NOCKMSMPE01v SolarWinds Alerting Service V2                     Running
NOCKMSMPE01v SolarWinds Cortex                                  Running
NOCKMSMPE01v SolarWinds HighAvailability                        Running
NOCKMSMPE01v SolarWinds Log Manager for Orion Polling Service   Running
NOCKMSMPE01v SolarWinds Recommendations                         Running
NOCKMSMPE01v SolarWinds Log Manager for Orion Syslog Service    Running
NOCKMSMPE01v SolarWinds Log Manager for Orion Trap Service      Running
NOCKMSMPE01v SolarWinds Collector Service                       Running
NOCKMSMPE01v SolarWinds Information Service V3                  Running
NOCKMSMPE01v SolarWinds JMX Bridge                              Running
NOCKMSMPE01v SolarWinds Job Engine v2                           Running
NOCKMSMPE01v SolarWinds WPM Playback Player Proxy               Running
NOCKMSMPE01v SolarWinds WPM Playback Player                     Running
NOCSQL01     SQL Full-text Filter Daemon Launcher (MSSQLSERVER) Running
NOCSQL01     SQL Server (MSSQLSERVER)                           Running
NOCSQL01     SQL Server Browser                                 Running
NOCSQL01     SQL Server Agent (MSSQLSERVER)                     Running
NOCSQL01     SQL Server CEIP service (MSSQLSERVER)              Running
NOCSQL01     SQL Server VSS Writer                              Running

SW_United

OK I've managed to get a PowerShell script to work;

$Servers = Get-Content "C:\SolarWinds\PowerShell\TEST-servers.txt"
$listServices = 'SolarWindsAdministration','SolarWindsAgent64','SolarWindsAlertingServiceV2','SWCollectorService','SolarWindsCortex','SolarWindsHighAvailability','SWInfoServiceSvcV3','SWJobEngineSvc2','NetFlowService','OrionModuleEngine','SolarWindsRecommendations','SolarWinds SFTP Server*','SolarWindsSyslogService','SolarWindsTrapService','W3SVC','MSSQLSERVER','SQLSERVERAGENT','SQLBrowser*','SQLTELEMETRY*','SQLWriter'

$problems = @()

$servers = $servers | sort



foreach ($server in $servers)
{foreach ($listservice in $listservices)
{
if
(($service_status = (Get-Service -ErrorAction SilentlyContinue -computername $server -Name $listservice).status))
{
$problems += "$server, $listservice, $service_status"

}

}

}

Write-Output $problems > C:\SolarWinds\PowerShell\TEST-Results.txt

[string]$final = ($problems)

Hopefully this might help others when they want to quickly check their environments.

KMSigma.SWI

That's the thing I like the most about PowerShell - there are multiple ways to do it.

SW_United

Thanks @KMSigma.SWI. I like your script output layout so will use yours. Much appreciated

KMSigma.SWI

As you like. Like I said, there's no one single way to do things.