Author Archives: Jeff Turner

About Jeff Turner

Technical director of Nano Tera Network Solutions.

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.

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.

connect to online exchange

Lots of places explaining how to do this but in summary you may have to change your execution policy settings ( Set-ExecutionPolicy bypass ) also remember if you have MFA enabled you will need to make an app password or … Continue reading

Posted in Powershell, VBS, VBA and other scripting. | Comments Off on connect to online exchange

creating log files with date and time in their names.

Often want to create a log file from a cmd batch script which is unique for each day for /F “tokens=1-6 delims=/ ” %%A in (‘date /t’) do ( set dt=%%D_%%C_%%B_) for /F “tokens=1-6 delims=: ” %%A in (‘time /t’) … Continue reading

Posted in Powershell, VBS, VBA and other scripting. | Tagged | Comments Off on creating log files with date and time in their names.