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...