powershell

Listing windows services statuses with Powershell

by

$stopingServices=Get-Service | Where-Object {$_.status -eq “stoping”} $startingServices=Get-Service | Where-Object {$_.status -eq “starting”} $runningServices=Get-Service | Where-Object {$_.status -eq “running”} $stoppedServices=Get-Service | Where-Object {$_.status -eq “stopped”} if($startingServices){ Write-Host “`nStarting Services: $startingServices” } if($stopingServices){ Write-Host “`nStoping Services: $stopingServices” } if($runningServices){ Write-Host “`nRunning Services: $runningServices” } if($stoppedServices){ Write-Host “`nStopped Services: $stoppedServices” }

Listing IIS Application Pool Memory usage in PowerShell

by

Open Powershell as an Administrator on the web server, then run: $apmem= gwmi -ComputerName localhost -NS ‘root\WebAdministration’ -class ‘WorkerProcess’ | select PSComputerName, AppPoolName,ProcessId , @{n=’RAM’;e={ [math]::round((Get-Process -Id $_.ProcessId -ComputerName $_.PSComputerName).WorkingSet / 1Mb) }} | sort RAM -Descending | ft -AutoSize echo $apmem You should see something like: PS C:\Windows\system32> C:\scripts\appool.ps1 PSComputerName AppPoolName ProcessId RAM ————– … Read more

CredSSP authentication problem in Powershell Remote Queries

by

If you receive the following error while running remote .exe files from in powershell. UNKNOWN: WEB SERVICE STATUS [vmserver01] Connecting to remote server failed with the following error message : The WinRM client cannot process the request. CredSSP authentication is currently disabled in the client configuration. Change the client configuration and try the request again. … Read more

How to troubleshoot memory issues when executing remote Powershell queries

by

If you are receiving “Processing data for a remote command failed with the following error message: The WSMan provider” message from the PS Queries (e.g. on the Nagios) All you have to do is log on the target computer, and run powershell with Administrator Rights. Then you can increase Powershell memory with below commands You can … Read more

How to connect Oracle DB with PowerShell

by

# Load the ODP assembly [Reflection.Assembly]::LoadFile(“C:\oracle\11.2.0\client_2\odp.net\bin\4\Oracle.DataAccess.dll”)|Out-Null # #vars&cons $stations =@{ “424”=”Istanbul”; “421”=”İzmir” } $dbuser=”user” $dbpasswd=”password” connect to Oracle $constr = ” User Id=$dbuser; Password=$dbpasswd; Data Source=CITIES ” $conn= New-Object Oracle.DataAccess.Client.OracleConnection($constr) $conn.Open() Create a datareader for a SQL statement $sql=”select stationid from CITIES.SWITCHPARAMETER where switchid = ‘2’ ” $command = New-Object Oracle.DataAccess.Client.OracleCommand( $sql,$conn) $reader=$command.ExecuteReader() Write out … Read more