Posts

Showing posts from 2017

How to collect any existing patch/KB information on the server

If required to collect any existing patch/KB information on the server please use the below simple command, it will provide complete output in to simple HTML file.   WMIC  QFE  LIST  FULL /Format:HTable > C:\HotfixList.HTM  -------------> need to be run this command.

Creating an LVM Logical Volume on Multiple Disks

Creating an LVM Logical Volume on Multiple Disks This example creates an LVM logical volume called new_logical_volume that consists of the disks at /dev/sda1, /dev/sdb1, and /dev/sdc1 /dev/sdd1 Creating the Physical Volumes To use disks in a volume group, you label them as LVM physical volumes. Warning This command destroys any data on /dev/sda1, /dev/sdb1, and /dev/sdc1, /dev/sdd1 # pvcreate /dev/sda1 /dev/sdb1 /dev/sdc1 /dev/sdd1 Creating the Volume Group The following command creates the volume group new_vol_group. # vgcreate new_vol_group /dev/sda1 /dev/sdb1 /dev/sdc1 /dev/sdd1 Volume group "new_vol_group" successfully created You can use the vgs command to display the attributes of the new volume group. # vgs Creating the Logical Volume The following command creates the logical volume new_logical_volume from the volume group new_vol_group. This example creates a logical volume that uses 4TB of the volume group.   # lvcreate -L4T -n new_logi...

Servers Monthly uptime report Script

#To Obtain uptime report of the VMs. You need to create and update the list of Server name sin List.txt file on C:\temp   $servers = Get-Content C:\temp\List.txt foreach ($s in $servers) { try { $a=Get-WmiObject -ComputerName $s -Class Win32_OperatingSystem -ErrorAction ‘Stop’ $b = $a.convertToDateTime($a.Lastbootuptime) [TimeSpan]$LastBoot = New-TimeSpan $b $(Get-Date) (‘{0} {1}Day(s),{2}Hour(s),{3}Min(s),{4}Seconds’ -f $s,$LastBoot.Days,$lastboot.Hours,$LastBoot.Minutes, $LastBoot.Seconds) | out-file C:\temp\UptimeReport.txt -append -Encoding ascii } Catch { (‘{0} Server is notreachable’ -f $s)| Out-File C:\temp\offline.txt -Append -Encoding ascii } }

Step-By-Step: Creating a SQL Server 2012 AlwaysOn Availability Group

https://blogs.technet.microsoft.com/canitpro/2013/08/19/step-by-step-creating-a-sql-server-2012-alwayson-availability-group/

Servers Backup Status Report Generation and Servers Uptime Report generation

Image
Servers Backup Status Report Generation   To Generate the Backup status report for Backups > Go to Azure portal > Recovery Service Vault > Backup vaults (We have 3 vaults for Farm servers) Here in Vault for example: Go to Jobs > Backup jobs Select the filter option to generate the failed jobs report. Please update the parameters as mentioned below. (Start date end should for the required month.) Jobs will be filtered, and failed jobs can be captured as below. You can also export the same in CSV format using export Jobs option. You need to calculate the Backup KPI using below formula. Farm 01 PROD = 10 VMs Total Jobs = 10 Jobs/Day & 300 Jobs/Month Successful backups = 297 Failures = 3 Service Degradation = 1 % Healthy = 99% Customers Servers Uptime Report generation For sample customer Azure VMS uptime reports are generated through a Monitoring solution - OMS (Operations Management suite) ...