Powershell and SQL Server

For one of my powershell project(EOL/Skob migration)   that has become huge and  I required to use sql table to report /Log about each migration from start till end, along with any errors that are encountered. This can be helpful in checking the status for particular user for past dates, querying in a fast manner,…

Exchange Remote Hosted Archives

For one of our customers we are using a process to migrate the PST from EntepriseVault to archives on Exchange online. The process that we are following till now is : Migrate the Exchange mailbox to EOL. Enable the Remote Archive Upload the PST via Azure. This process is working great for us but customer…

Exchange Health Check – Monitor and Alert

This is the updated version of the below script: https://gallery.technet.microsoft.com/scriptcenter/Exchange-2010-Health-Check-7be55c87 Enhancements have been done so that Email Alert is generated when state is critical. New in this script is: $ALert = “Yes” $htmlreporting = “Yes” $smtphost = “smtp.labtest.com” $from = “Exchange2010Status@labtest.com” $from1 = “SysMonitoring@labtest.com” $to = “Vikass@labtest.com” $hrs = (get-date).Addhours(-24) if $alert is yes than…

Microsoft Excel cannot access the file -PS Script

Sharing a TIP on Scheduling a script that contains excel code. One of my Script that uses excel was running fine when I was launching it interactively but if scheduled thru Task scheduler it wasn’t working & threw below errors: Microsoft Excel cannot access the file There are several possible reasons: The file name or…