Remove Print Job Error thru PowerShell

Recently I was working on building a printer management solution using Powershell where admins can input the printer name and remove the error from the print queue. Our print servers are running windows 2008 & admin server is windows 2008 R2 from where we run scripts or scripting solutions. Printer management Module is available for…

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…

Certificate expiry Alert

This script has been written long ago but started using it now, not a complex logic/code but assisted few of our teams to monitor their enviornment certificates 60 days before expiry. here is what it does: Read the CSV file   Read  Cert name, expiry , alert email & Type $CertName = $i.CertName $Expiry =…

Skip DNS registration for Particular IP Addresses

Today I am sharing a TIP which can be used to skip DNS registration of some of the IP addresses (when you have assigned multiple IP to a single NIC). When NIC’s are multiple , its easy to just uncheck the box for DNS registration as shown below:(register this connection’s address in DNS ) Challenge…

Export Sharepoint List to CSV

This script will assist in exporting the Sharepoint List contents in csv format. It would be useful in scenarios where you want to export list & further feed some other system to complete further processing. Example which is being shared was used in one of the automation where IT people can fill the form for…

Change Mail directories path IIS SMTP

We had a need to install the SMTP server for some application but we want to change the default Mail directories path: Unfortunately you can’t just do it from IIS management console, for modifying the default paths you need metabase explorer. However you can change the Badmail directory from IIS console: (right click smtp server –>…