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

PTE

-
PTE Free materials হুমাইরা https://www.bdword.com/english-to-bengali-dictionary-learn-3000-plus-common-words-a-page-1 https://www.bdword.com/english-to-bengali-dictionary-learn-3000-plus-common-words-a-page-1 Score https://medium.com/@avinashadluri/how-i-achieved-90-score-in-pte-exam-d229b76e8f6d Score-Guide https://pearsonpte.com/wp-content/uploads/2017/08/Score-Guide.pdf PTE Preparation https://ptetutorials.com/users/videos.aspx https://pearsonpte.com/the-test/format/english-speaking-writing/personal-introduction/ https://dictation.io/ Listening / Audio https://listenaminute.com/index.html https://breakingnewsenglish.com/1911-2002.html https://learnenglish.britishcouncil.org/general-english/audio-zone https://learningenglish.voanews.com/ Writing   https://www.youtube.com/watch?v=AdyRgrOEzx8 http://www.pearsonlongman.com/languageleader/pdf/PTEA_RR_Advanced.pdf https://www.quora.com/Which-test-would-be-easier-IELTS-or-PTE-Pearson-Test-Of-English PTE Fr
Read more