System/Server Health Status using PowerShell

System/Server Health Status using PowerShell


Support team or System Administrators who are willing to get the system health check status can use this script. This script has been written in Powershell and it can generate reports in HTML format.

This script can give you below information:

Hardware:

To Get Manufacturer, Model, No. Of Logical Processors, Installed Memory.

 Code:  Get-WmiObject -class Win32_ComputerSystem -ComputerName $Computername | Select-Object Name,Domain,Manufacturer, Model,NumberOfLogicalProcessors,@{ Name = "Installed Memory (GB)" ; Expression = { "{0:N0}" -f( $_.TotalPhysicalMemory / 1gb ) } }           


CPU Details:

To Get  CPU speed, Current CPU Usage in %,

 Code: Get-WmiObject win32_processor | Select-Object SystemName,@{ Expression = { $_.MaxClockSpeed/1000 } ; Name = "CPU Speed in GHz." } ,NumberOfCores,NumberOfLogicalProcessors,@{ Name = "Current CPU Ussage in % " ; Expression = { $_.LoadPercentage } }




Memory Usage:
To Get Total Memory, Free memory, Used Memory.

Code: Get-WmiObject win32_operatingsystem | Select-object @{ Name = "Total Memory(MB) " ; expression = { "{0:N0}" -f($_.TotalVisibleMemorySize / 1024)  } } , @{ Name = "Free Memory(MB) " ; Expression = { "{0:N0}" -f ($_.FreePhysicalMemory / 1024) } },@{ Name = "Used Memeory(MB)" ; Expression = {"{0:N0}" -f (($_.TotalVisibleMemorySize-$_.FreePhysicalMemory) / 1024) } }

Hard Disk Information:

To Get Device Mount Point, Size of Hard Drive, Free Space Left, Percentage of Free Space
Code: Get-WmiObject win32_operatingsystem | Select-object @{ Name = "Total Memory(MB) " ;expression = { "{0:N0}" -f($_.TotalVisibleMemorySize / 1024)  } } , @{ Name = "Free Memory(MB) " ; Expression = { "{0:N0}" -f ($_.FreePhysicalMemory / 1024) } },@{ Name = "Used Memeory(MB)" ; Expression = {"{0:N0}" -f (($_.TotalVisibleMemorySize-$_.FreePhysicalMemory) / 1024) } }


Last Bootup Time:

To Get Operating System Used, Last Reboot on

Code: Get-WmiObject win32_operatingsystem | Select-object @{ Name = "Total Memory(MB) " ;expression = { "{0:N0}" -f($_.TotalVisibleMemorySize / 1024)  } } , @{ Name = "Free Memory(MB) " ; Expression = { "{0:N0}" -f ($_.FreePhysicalMemory / 1024) } },@{ Name = "Used Memeory(MB)" ; Expression = {"{0:N0}" -f (($_.TotalVisibleMemorySize-$_.FreePhysicalMemory) / 1024) } }

Services Running:

To Get Total Memory, Free memory, Used Memory.
Code: Get-WmiObject -Class Win32_Service -ComputerName $Computername |
 Where-Object { ($_.StartMode -eq "Auto") -and ($_.State -eq "Running") -and ($_.Name -eq "MySQL") -or ($_.Name -eq "AppHostSvc") } |  Select-Object SystemName, DisplayName, Name, StartMode, State, Description |  ConvertTo-Html -Fragment -PreContent "<h2>Services  Running </h2>"  Out-String

Top 5 Application Events Log:

To Get Index, Time, Entry Type, Source, Instance Id.

Code: Get-EventLog "Application" -Newest 5 | Select-Object Index,Time,EntryType,Source, InstanceID, Message 

OUTPUT : 

Output Link:
 

https://drive.google.com/file/d/0B9AQ1D2DEgAkRExxWE1SSXREVUk/edit?usp=sharing

https://drive.google.com/file/d/0B9AQ1D2DEgAkRExxWE1SSXREVUk/edit?usp=sharing

Download the Script :

https://drive.google.com/file/d/0B9AQ1D2DEgAkNFpuZnIzYnU1N0k/edit?usp=sharing


https://drive.google.com/file/d/0B9AQ1D2DEgAkNFpuZnIzYnU1N0k/edit?usp=sharing






If you have any queries and any one want any help in scripting or in enhancing this script please.

Suggestions and Queries are always welcome.





Comments

Post a Comment

Popular posts from this blog

Observium: Configuring Microsoft Windows 2008 Server SNMP Agent

Image
1 . Open Control Pannel. 2. Right click on “ Programs & Features ” and click on “ Turn Windows Features on or off" 3 . Expand “ SNMP Services ” and select “ SNMP Service ” click Next 4. Click Install 5. Close  Programs & Features ” 6. Open Ädministraive Tools and clicket Services 7. Expand Configuration and select Services,  Select SNMP Service , right click and select properties 8 . Select the “ Agent ” tab 9. Type the contact name responsible for this server or email address 10 . Type the location eg, Hyderabad,India. 11 . Tick the following  Physical Datalink and subnetwork  SNMP Trap Service - Agent 12 . Select the “ Traps ” tab 13 . Type in the community string you are using in your environment and select “ Add to list ” 14 . Click “ Add ” 15 . Type the IP of the Observium ServerSNMP Trap Service - Traps 16 . Select “ Security ” tab 17 . Ensure “ Send authentication trap ” is
Read more

AWS: Upgrade PV Drivers on Windows Instances

Image
Amazon Windows AMIs contain a set of drivers to permit access to Xen virtualized hardware. These drivers are used by Amazon EC2 to map instance store and Amazon EBS volumes to their devices. If your Windows instance is launched from a Windows Server 2012 R2 AMI, it uses AWS PV drivers. If your Windows instance uses RedHat drivers, you can upgrade to Citrix drivers. If you are already using Citrix drivers, you can upgrade the Citrix Xen guest agent service. To verify which driver your Windows instance uses , open  Network Connections  in Control Panel and view the  Local Area Connection . Check whether the driver is one of the following: AWS PV Network Device Citrix PV Ethernet Adapter RedHat PV NIC Driver Alternatively, you can check the output from the  pnputil -e  command. AWS PV Drivers Windows Server 2012 R2 AMIs include AWS PV drivers. The AWS PV drivers are stored in the %ProgramFiles%\Amazon\Xentools directory. This directory also contains public symbo
Read more

How to configure Incremental backups for MSSQL Database

Image
Incremental Database Backup : Create a folder for the backup in the Hardisk (Ex: C:\SQL_backup\Incrementail) 1. Open SQL Server Management Studio and connect using windows credentials. 2. Click Management   and select Maintenance Plans . 3. Right-Click on Maintenance Plans and select New Maintenance Plans, Give naming Convention as Incremental_DB_Backup . 4. In Left side of Server Management Studio there will be a Tool Box within Maintenance Plan Tasks   5. Drag and drop the Back Up Database Task and Maintenance Clean Task in the Incremental_DB_Backup   Design area.   6. Right Click on the Back Up Database Task and select Edit .   7. Select the Type of Backup you want to do as Differential 8. Select the Database In Database(s)   in these database list (Ex: TestDB.)   9. Select Create a Backup file for every database , select Create a sub-directory for each database 10. Give the path where we want to store the database backup as C:\SQL_backup\I
Read more