Coloring a particular a Row result with PowerShell

cls
$services=Get-Service -name '*sql*'
$services|
ForEach-Object{
$Know=$_
if($_.Status -eq "Running")
{

 Write-Host   $Know.Status, $Know.Name,$Know.DisplayName -foregroundcolor Green -Separator ' : '
}
else
{
Write-Host    $Know.Status, $Know.Name, $Know.DisplayName -foregroundcolor Red -Separator ' : '
}
}

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server