Category Archives: Powershell, VBS, VBA and other scripting.

test-connections – ping a list of addresses from a csv file and report result.

Posted in Powershell, VBS, VBA and other scripting. | Tagged , | Comments Off on test-connections – ping a list of addresses from a csv file and report result.

powershell script to create and export a certificate

When you have an internal Microsoft Certificate Authority you can create certificates for all your devices which will be trusted by all the domain member computer. Domain members will automatically have a certificate generated for them. Devices such as switches, … Continue reading

Posted in Powershell, VBS, VBA and other scripting. | Comments Off on powershell script to create and export a certificate

IP4 Network Scanning using powershell.

sometimes you want to scan a subnet to see what devices are on it. If you need to scan from inside the more secure environment you can’t install any extra software on it. Machines with the minimum attack surface. This … Continue reading

Posted in Powershell, VBS, VBA and other scripting. | Comments Off on IP4 Network Scanning using powershell.

One drive Camera Roll – folder for each month

If you use one drive to backup your photos and videos from your phone you might have noticed it puts all of the files in one folder per year. I find it much easier to put one folder for month, … Continue reading

Posted in Hints and Tips, Powershell, VBS, VBA and other scripting. | Comments Off on One drive Camera Roll – folder for each month

Cleaning up old DNS NS records in an Active Directory forest

Cleaning up old DNS NS records in an Active Directory forest, needed some powershell to help remove all the old DNS server names from various domains that have been removed from the forest over time or demoted / decommissioned.

Posted in Powershell, VBS, VBA and other scripting., System Administration | Comments Off on Cleaning up old DNS NS records in an Active Directory forest

Dump all Distribution Groups -Exchange Server Powershell

Getting the members of each distribution group into a CSV file on an exchange server is easy using powershell. This will create one CSV file per group.

Posted in Powershell, VBS, VBA and other scripting., System Administration | Comments Off on Dump all Distribution Groups -Exchange Server Powershell

Exchange server message tracking logs – examine them using powershell and excel

The Exchange server interface for examining message tracking logs forces you to put in one mailbox to search before you can do anything else. If you need to find emails sent from one outside person to groups of users or … Continue reading

Posted in Powershell, VBS, VBA and other scripting., System Administration | Comments Off on Exchange server message tracking logs – examine them using powershell and excel

Moving (copying) a VM between standalone ESX hosts. – using ovftool

Download ovftool from VMware (https://my.vmware.com/group/vmware/get-download?downloadGroup=OVFTOOL430UPDATE3) For example copy a machine called jetfun from host – esxhost1 to esxhost2 – replace the new with the new hosts “vm network” overwrite any machine with the same name there place the new machine … Continue reading

Posted in Powershell, VBS, VBA and other scripting., System Administration | Tagged | Comments Off on Moving (copying) a VM between standalone ESX hosts. – using ovftool

Saving passwords for use in powershell scripts.

the get-credential command gets a username/password pair interactively. these can be created and saved to a file, making this file a secure document means that only the user who created it can use it. this means if you want to … Continue reading

Posted in Powershell, VBS, VBA and other scripting., System Administration | Tagged , | Comments Off on Saving passwords for use in powershell scripts.

Mail Tips – show when recipients are external.

Office 365 / Exchange has the option to warn you if you are sending to external people. To stop that “oops – that wasnt meant to go outside” feeling after you have sent it. https://social.technet.microsoft.com/Forums/en-US/800c1b34-52d8-44d5-a5e1-186305caf91f/how-to-set-specific-external-domainrecipient-warning-before-sending-by-mailtips?forum=exchangesvradminlegacy In summary this is how … Continue reading

Posted in Powershell, VBS, VBA and other scripting. | Comments Off on Mail Tips – show when recipients are external.