WD / Powershell

-
WD
Spotfire SQL
--SELECT * FROM TMP_MVX_REPORT_SQL_LOG order by REG_TIMESTAMP desc 
--Press ctrl + c to copy sql




#IMPORTANT AND CONCERNS
# -Set the $percentCritcal and $percentWarning basing on requirements
# -$Users: Set the user names for email notification
# -$reportPath : Set the report path basing on the location where you want to store the reports
# -$computers: refer the location Servers.txt in which all the machine names added to monitor
# -$smtpServer: set the SMTP server which you want to use for email notitifcation
#*********************************************************#

# Continue even if there are errors
$ErrorActionPreference = "Continue";

# Set your warning and critical thresholds
$percentWarning = 25;
$percentCritcal = 10;

# EMAIL PROPERTIES
 # Set the recipients of the report.
 $users = "Tan.ChengKean@wdc.com,NobleKing.Constantin@wdc.com,MOHAMMAD.NAZMUL.HUDA.RUBOL.CHOWDHURY@wdc.com,Abhishek.KumarAshu@wdc.com"; 
  

# REPORT PROPERTIES
 # Path to the report
  $reportPath = "D:\Diskspace\Logs\";  # set the location on wehere you want to store the reports

 # Report name
  $reportName = "DiskSpaceRpt_$(get-date -format ddMMyyyy).html";

# Path and Report name together
$diskReport = $reportPath + $reportName

#Set colors for table cell backgrounds
$redColor = "#FF0000"
$orangeColor = "#FBB917"
$whiteColor  = "#FFFFFF"
$greenColor  =  "#00FF00"

# Count if any computers have low disk space.  Do not send report if less than 1.
$i = 0;

# Get computer list to check disk space
$computers = Get-Content "D:\Diskspace\servers.txt";  #Set the location of server.txt file which contain all the server and desktop names which you want to monitor the disk space.
$datetime = Get-Date -Format "MM-dd-yyyy_HHmmss";

# Remove the report if it has already been run today so it does not append to the existing report
If (Test-Path $diskReport)
    {
        Remove-Item $diskReport
    }

# Cleanup old files..
$Daysback = "-7"  #Set to clean the reports which are older than 7 days
$CurrentDate = Get-Date;
$DateToDelete = $CurrentDate.AddDays($Daysback);
Get-ChildItem $reportPath | Where-Object { $_.LastWriteTime -lt $DatetoDelete } | Remove-Item;

# Create and write HTML Header of report
$titleDate = get-date -uformat "%m-%d-%Y - %A %H:%M:%S"
$header = " 
  'Content-Type' content='text/html; charset=iso-8859-1'>
-->
  '100%'>
  '#548DD4'>
 
'7' height='30' align='center'>
  'calibri' color='#003399' size='4'>WD Server Disk Space  Report for $titledate  
"
 Add-Content $diskReport $header

# Create and write Table header for report
 $tableHeader = "
 '100%'> 

'10%' align='center'>Server

'5%'  align='center'>Drive 

'10%' align='center'>Total Capacity(GB)

'10%' align='center'>Used Capacity(GB)

'10%' align='center'>Free Space(GB)

'5%'  align='center'>Freespace 


"
Add-Content $diskReport $tableHeader
 
# Start processing disk space
  foreach($computer in $computers)
 { 
 $disks = Get-WmiObject -ComputerName $computer -Class Win32_LogicalDisk -Filter "DriveType = 3 AND DeviceID != 'P:'"
 $computer = $computer.toupper()
 $isEmailSend = 0
  foreach($disk in $disks)
 {        
  $deviceID = $disk.DeviceID;
        $volName = $disk.VolumeName;
  [float]$size = $disk.Size;
  [float]$freespace = $disk.FreeSpace; 
  $percentFree = [Math]::Round(($freespace / $size) * 100);
  $sizeGB = [Math]::Round($size / 1073741824, 2);
  $freeSpaceGB = [Math]::Round($freespace / 1073741824, 2);
        $usedSpaceGB = $sizeGB - $freeSpaceGB;
        $color = $whiteColor;
                       
# Set background color to Orange if just a warning

  if($percentFree -lt $percentWarning)      
    {
    $color = $orangeColor 
            }
  else{
   $color =$greenColor 
   }
# Set background color to Orange if space is Critical
      if($percentFree -lt $percentCritcal)
        {
        $color = $redColor
        $isEmailSend =1
       }        
 
 # Create table data rows 
    $dataRow = " 
'10%'>$computer 
'5%' align='center'>$deviceID 
'10%' align='center'>$sizeGB 
'10%' align='center'>$usedSpaceGB 
'10%' align='center'>$freeSpaceGB 
'5%' bgcolor=`'$color`' align='center'>$percentFree % 

"
Add-Content $diskReport $dataRow;
Write-Host -ForegroundColor DarkYellow "$computer $deviceID percentage free space = $percentFree";
    $i++  
 
 }
}

# Create table at end of report showing legend of colors for the critical and warning
 $tableDescription = "


'100%'>
  'White'> 
           
'15%' align='center' bgcolor='#00FF00'>Info - greater than 25% free space will be in green color

   
'10%' align='center' bgcolor='#FBB917'>Warning - less than 25% free space

'10%' align='center' bgcolor='#FF0000'>Critical - less than 10% free space


"
 Add-Content $diskReport $tableDescription
 Add-Content $diskReport "
"

# Send Notification if alert $i is greater then 0
if ($isEmailSend  -gt 0)
{
    foreach ($user in $users)
{
        Write-Host "Sending Email notification to $user"
  
  $smtpServer = "smtp.wdc.com" #set the SMTP server
  $smtp = New-Object Net.Mail.SmtpClient($smtpServer)
  $msg = New-Object Net.Mail.MailMessage
  $msg.To.Add($user)
        $msg.From = "Tan.ChengKean@wdc.com" # set the user name from which email should send
                         
  $msg.Subject = "WD Server Disk Space Report for $titledate"
        $msg.IsBodyHTML = $true
        $msg.Body = get-content $diskReport
  $smtp.Send($msg)
        $body = ""
    }
  }





#IMPORTANT AND CONCERNS
# -Set the $percentCritcal and $percentWarning basing on requirements
# -$Users: Set the user names for email notification
# -$reportPath : Set the report path basing on the location where you want to store the reports
# -$computers: refer the location Servers.txt in which all the machine names added to monitor
# -$smtpServer: set the SMTP server which you want to use for email notitifcation
#*********************************************************#

# Continue even if there are errors
$ErrorActionPreference = "Continue";

# Set your warning and critical thresholds
$percentWarning = 25;
$percentCritcal = 10;

# EMAIL PROPERTIES
 # Set the recipients of the report.
 $users = "Tan.ChengKean@wdc.com,NobleKing.Constantin@wdc.com,MOHAMMAD.NAZMUL.HUDA.RUBOL.CHOWDHURY@wdc.com,Abhishek.KumarAshu@wdc.com"; 
 

# REPORT PROPERTIES
 # Path to the report
  $reportPath = "D:\Diskspace\Logs\";  # set the location on wehere you want to store the reports

 # Report name
  $reportName = "DiskSpaceRpt_$(get-date -format ddMMyyyy).html";

# Path and Report name together
$diskReport = $reportPath + $reportName

#Set colors for table cell backgrounds
$redColor = "#FF0000"
$orangeColor = "#FBB917"
$whiteColor  = "#FFFFFF"
$greenColor  =  "#00FF00"

# Count if any computers have low disk space.  Do not send report if less than 1.
$i = 0;

# Get computer list to check disk space
$computers = Get-Content "D:\Diskspace\servers.txt";  #Set the location of server.txt file which contain all the server and desktop names which you want to monitor the disk space.
$datetime = Get-Date -Format "MM-dd-yyyy_HHmmss";

# Remove the report if it has already been run today so it does not append to the existing report
If (Test-Path $diskReport)
    {
        Remove-Item $diskReport
    }

# Cleanup old files..
$Daysback = "-7"  #Set to clean the reports which are older than 7 days
$CurrentDate = Get-Date;
$DateToDelete = $CurrentDate.AddDays($Daysback);
Get-ChildItem $reportPath | Where-Object { $_.LastWriteTime -lt $DatetoDelete } | Remove-Item;

# Create and write HTML Header of report
$titleDate = get-date -uformat "%m-%d-%Y - %A %H:%M:%S"
$header = "
   
   
 
  DiskSpace Report
 
 
    
   

   
   
  WD Server Disk Space  Report for $titledate
 
  
  
  
"
 Add-Content $diskReport $header

# Create and write Table header for report
 $tableHeader = "
  

   
 Server
 Drive 
 Total Capacity(GB)
 Used Capacity(GB)
 Free Space(GB)
 Freespace 

 "
Add-Content $diskReport $tableHeader
 
# Start processing disk space
  foreach($computer in $computers)
 { 
 $disks = Get-WmiObject -ComputerName 172.21.41.251 -Class Win32_LogicalDisk -Filter "DriveType = 3 AND DeviceID != 'P:'"
 $computer = $computer.toupper()
 $isEmailSend = 0
  foreach($disk in $disks)
 {       
  $deviceID = $disk.DeviceID;
        $volName = $disk.VolumeName;
  [float]$size = $disk.Size;
  [float]$freespace = $disk.FreeSpace; 
  $percentFree = [Math]::Round(($freespace / $size) * 100);
  $sizeGB = [Math]::Round($size / 1073741824, 2);
  $freeSpaceGB = [Math]::Round($freespace / 1073741824, 2);
        $usedSpaceGB = $sizeGB - $freeSpaceGB;
        $color = $whiteColor;

# Set background color to Orange if just a warning

  if($percentFree -lt $percentWarning)     
    {
    $color = $orangeColor 
}
  else{
   $color =$greenColor 
   }
# Set background color to Orange if space is Critical
      if($percentFree -lt $percentCritcal)
        {
        $color = $redColor
$isEmailSend =1
       }       
 
 # Create table data rows 
    $dataRow = "
   
        $computer
  $deviceID 
  $sizeGB
  $usedSpaceGB
  $freeSpaceGB
  $percentFree % 
 
 "
Add-Content $diskReport $dataRow;
Write-Host -ForegroundColor DarkYellow "$computer $deviceID percentage free space = $percentFree";
    $i++ 
 
 }
}

# Create table at end of report showing legend of colors for the critical and warning
 $tableDescription = "


 
    
Info - greater than 25% free space will be in green color
    Warning - less than 25% free space
 Critical - less than 10% free space

 "
 Add-Content $diskReport $tableDescription
 Add-Content $diskReport "
"
# Send Notification if alert $i is greater then 0
if ($isEmailSend  -gt 0)
{
    foreach ($user in $users)
{
        Write-Host "Sending Email notification to $user"
 
  $smtpServer = "smtp.wdc.com" #set the SMTP server
  $smtp = New-Object Net.Mail.SmtpClient($smtpServer)
  $msg = New-Object Net.Mail.MailMessage
  $msg.To.Add($user)
        $msg.From = "Tan.ChengKean@wdc.com" # set the user name from which email should send

  $msg.Subject = "WD Server Disk Space Report for $titledate"
        $msg.IsBodyHTML = $true
        $msg.Body = get-content $diskReport
  $smtp.Send($msg)
        $body = ""
    }
  }

Comments

Post a Comment

Popular posts from this blog

Travel RESUME CV

-
Image
ceac.state.gov purbachal sector 21, end of purbachal 300 ft road, just behind the new China Bangladesh Exhibition Center Project (New Banijjo Mela Location) This vlog is about Purbachal Lake & Lake fantasy restaurant which is beside the lake. This lake is also called Lake-21 as this is situated in sector 21 of Purbachal Town. Location: Lake Fatasy Restaurent https://goo.gl/maps/9nLvLbrWvxVEsDBb7 iCrest SDN BHD Senior Software Developer   From Feb 2018 to Present. C-1-06, CoPlace 2, 2260, Jalan Usahawan 1, City :  Cyberjaya, STATE :  Selangor, POST CODE:  63000 Malaysia. Tel:  +603 8319 2405   | Fax:  +603 8319 6905  |  website:  www.icrest.com.my Data Path Ltd Senior Software Engineer Ambon Complex, 7th, 8th and 9th Floor, 99 Mohakhali Commercial Area Dhaka POST CODE:   1212 Bangladesh Phone: 880-2-9863216  From June 2012 to Feb 2018. Spectrum Engineering Consortium Ltd Software Engineer BDBL Bhaban (7th Floor), 12 Kazi Nazrul I
Read more

Tablig

-
  তাবলীগের মাগরিব বাদ বয়ান করার নিয়ম ভাই ও দোস্ত বোজর্গ আল্লাহ পাকের এহছান ফজল ও করম, আমরা বিভিন্ন গোত্রের লোক একত্রিত হয়ে মাগরিবের ফরজ নামাজ আদায় করেছি এবং তার পর দ্বীনের এক ফিকির নিয়ে বসতে পেরেছি, তার জন্য আমরা আল্লাহর শোকর আদায় করি, সকলে বলি আলহামদুলিল্লাহ। আল্লাহ তায়ালা কোরআন পাকে এরশাদ করেন (লায়িন শাকার তুম লা-আজিদান্নাকুম, ওয়ালায়িন কাফার তুম ইনøা আজাবি লা-শাদীদ)। আমার নেয়ামত পেয়ে যে নেয়ামতের শোকর গুজারী করে আমি তার নেয়ামত বাড়িয়ে দেই এবং যে নেয়ামতের অস্বীকার কওে আমি তার নেয়ামত ছিনিয়ে নেই ও আজাবে গ্রেপ্তার করি। সমগ্র মানব জাতির সুখ শান্তি সফলতা কামিয়াবী আল্লাহ তা’আলা একমাত্র দ্বীনের মধ্যে রেখেছেন। দ্বীন জিন্দেগীতে তখনই প্রতিষ্ঠিত হবে যখন তার জন্য মেহনত করা হবে। সুতরাং যে কেহ খাছ নিয়তে নিজের জান মাল, সময় নিয়েক আল্লাহর রাস্তায় বের হয়ে ছহী তরিকায় মেহনত করবে ইনশাআল্লাহ অতি সহজেই তার মধ্যে পূরা দ্বীনের উপর চলার যোগ্যতা পয়দা হবে। দ্বীন আল্লাহর নিকট বড়ই মাহবুব। দ্বীন দুনিয়ার বুকে দাওয়াতের মাধ্যমে প্রতিষ্ঠিত হয়েছে। দাওয়াত হচ্ছে ঈমানের মেহনত। হযরত ইছা (আঃ)-এর পরে ছয়শত বৎসরের উর্দ্ধে দাওয়াতে
Read more