AD Connect pass-through authentication & SSSO

This post walks you through two things: an upgrade of an existing AD Connect installation converting from ADFS to pass-through authentication Turning off ADFS setting up pass-through authentication and single sign on Recently Microsoft announced the new Azure AD Pass-Through Authentication and Seamless Single Sign-on. It’s a way of signing in to AAD (Azure AD) and AAD services using on-prem credentials as a reputable replacement to ADFS. This also includes any any third party apps all like Concour or SalesForce as well as custom apps. You can use AAD Premium to setup SAML 2.0 authentication to any custom app that supports claims…

Automatic MP3 tagging

A requirement for my business was to capture information for every song I had. The information required was the Composer (the person/s that wrote the song), the Year and the Record Label. I have over 13,000 songs and doing this on a manual basis would be an administration nightmare. So I used my PowerShell skills and set out to achieve what I found was a very reliable manual process, but turned into an automatic process. The most reliable process that I can find to date is: To grab the Record Label information from iTunes and a site http://staff.australian-charts.com/ to be used as…

Dropbox in PowerShell and as Windows Service

Dropbox comes in handy as a way of distributing files across systems. You can easily get files to a whole fleet of computers and then use PowerShell to automate tasks. If you ever wanted to run Dropbox as a Windows Service so it starts with Windows before a user logs in, follow the instructions below. But first you need this tool srvany Delete the Dropbox service: sc delete “Dropbox Service” Run the following command: sc create Dropbox binPath= “C:\…\srvany.exe” DisplayName= “Dropbox Service” Choose properties on Dropbox service > Click on tab “Log On” > Click “This account“, and select the appropriate account in order…

OMS PowerShell

Below is some example PowerShell which integrates with OMS (Operations Management Suite). It has some examples on how you can pull out OMS saved searches and run saved searches. It also has some examples of gathering some information from the Security & Audit solution working with some particular security domains. To be able to use PowerShell against OMS successfully, you can’t logon to PowerShell using a Microsoft account. You need to use an organisational based account. This same account would need to have the necessary permissions against OMS. I recommend you install this Azure PowerShell module https://github.com/Azure/azure-powershell/releases/tag/v3.0.0-September2016 as this contains the cmdlets you…

PowerShell Fuzzy Lookup

You might know about my most favourite add-in for Microsoft Excel called Fuzzy Lookup. It’s the best, most accurate and fastest tool to compare a string of text against a table of data. For example, I can have a table of songs (my entire music library of 12K+ songs), then in another table I can have a list of songs that a radio station has played over the past week – for example. With Fuzzy lookup, I can compare the two tables. Table A which contains songs played on a radio station and Table B which represents my library. For each…

Azure Automation using Azure AD SPNs

This is similar to my other blog post I did recently on sequentially starting and stopping virtual machines where I demonstrated setting up Azure automation using a normal user account in Azure AD as the credential. There is also another blog post I did about setting up SPNs (Service Principal Names) in Azure AD – similar to service accounts. So this blog post merges both Azure Automation and SPNs for credentials together. The difference being, you just need to add an additional Azure Automation Variable for the Azure Tenant ID. You’ll will need to set yourself up an SPN first using my script,…