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…