Automating RACF Administration with PowerShell

25th of June, 2019 / / No Comments

Automating RACF Administration with PowerShell? Yes, I’m writing this post from the past as it is 2019 and certain technologies are not in my job description anymore like Faxing Solutions and Mainframe Administration. I guess its been one of those months. Recently I needed to automate some RACF Administration tasks. Naturally I wanted to perform this with my favourite scripting tool, PowerShell.

After much searching, I couldn’t find any references to anyone doing such a thing.… [Keep reading] “Automating RACF Administration with PowerShell”

Microsoft Identity Manager PowerShell Management Agent for Oracle Internet Directory

18th of June, 2019 / / No Comments

Why a FIM/MIM PowerShell Management Agent for Oracle Internet Directory? Why not just use the Generic LDAP Connector for Microsoft Identity Manager? I needed an integration solution that was able to update an Oracle Database behind Oracle Internet Directory. That meant I required a solution that was able to use LDAP to get visibility as to who/what was in OID, but then make updates into an Oracle DB. That functionality I wanted to be contained on a single Management Agent, not an MA for the Database and another for LDAP.… [Keep reading] “Microsoft Identity Manager PowerShell Management Agent for Oracle Internet Directory”

Azure NSG security rule management like a boss with PowerShell and CSVs

14th of June, 2019 / / 2 Comments

Originally this blog post was posted on Lucian’s blog. Check it out, or check him out on @LucianFrango on Twitter.

* * *

Network Security Groups (NSG) are pretty good. I don’t mind them that much as for what they are, they do a good job. Designing them can be a little tricky, having to know all the nuances of working with them. When it comes to implementing them, changing them at scale… well that’s where things can be a little tiresome.… [Keep reading] “Azure NSG security rule management like a boss with PowerShell and CSVs”

Querying Oracle Internet Directory (LDAP) with PowerShell

13th of June, 2019 / / No Comments

If you are an IT Professional it is highly likely you are very familiar with Microsoft Active Directory and in turn PowerShell and LDAP. At some point though you may need to integrate with another LDAP directory such as Oracle Internet Directory and you find it isn’t as straight forward as Active Directory and the rich tooling it comes with. I’ve had to create interfaces with numerous LDAP directories over the years but its been quite a long time since I had to integrate with Oracle Internet Directory.… [Keep reading] “Querying Oracle Internet Directory (LDAP) with PowerShell”

Using PowerShell to query Oracle DB’s without using the Oracle Client – Oracle Data Provider for .NET

11th of June, 2019 / / No Comments

With every Identity and Access Management project comes the often tactical integration with heritage/legacy systems that can often assist with their decommissioning. That is exactly what I was having to do a couple of weeks ago with Oracle. My public frustration with installing the Oracle Client on a Windows Server 2016 host to allow me to integrate Microsoft Identity Manager with Oracle saw me rewarded with an unsolicited but fantastic response from Sylvan Laurence. The suggestion was to use the Oracle Data Provider for .NET… [Keep reading] “Using PowerShell to query Oracle DB’s without using the Oracle Client – Oracle Data Provider for .NET”

Get/Update SailPoint IdentityNow Global Reminders and Escalation Policies

31st of May, 2019 / / No Comments 
Update: Oct 2019. Global Reminders and Escalation Policies can be easily managed using the SailPoint IdentityNow PowerShell Module.

SailPoint IdentityNow Access Requests for Roles or Applications usually require approvals which are configured on the associated Role or Application. The Approval could be by the Role/Application Owner, a Governance Group or the Requestor’s Manager. However for reminders and escalation policies the configuration is only available to be retrieved and set via the API. The SailPoint Identity Now api/v2/org API is used to configure these Global Reminders and Escalation Policies.… [Keep reading] “Get/Update SailPoint IdentityNow Global Reminders and Escalation Policies”

Goodbye GoDaddy WebHosting, Hello Azure Static Website

30th of May, 2019 / / 1 Comment

Way back in the 2000’s I got pulled into the commercial side of the Craft Beer Industry. I’d spent the previous 10+ years perfecting some eclectic beer styles and my professional brewing mates figured it was time to unleash them on the unsuspecting public. With any enterprising venture (but especially beer) you need a website to get the message out. I had a brand new 27″ iMac so I hacked together a simple one page website using the now defunct Apple iWeb.… [Keep reading] “Goodbye GoDaddy WebHosting, Hello Azure Static Website”

Extracting a list of Azure AD App Proxy applications with PowerShell

24th of May, 2019 / / 2 Comments

Recently during the Azure AD Application Proxy (App Proxy) deployment project with one of our clients, I was asked to give a list of applications that are on-boarded into App Proxy. Namely the client needed the Internal Url, External URL & DisplayName of the application. Usually there are two ways of doing that. One way is to export them manually into a csv file or alternatively: automate it! If there are small number of applications, then exporting them manually wouldn’t take that long but a long-term solution is to automate it.… [Keep reading] “Extracting a list of Azure AD App Proxy applications with PowerShell”

Reactive Properties in Xamarin Forms

23rd of May, 2019 / / No Comments

In this post, we will look at using Xamarin Forms in a more reactive manner, which will give more control over validation and synchronous UI updates, with potential to easily add custom animations.

The primary components for a Xamarin Forms mobile app are view models, presenters, services, repositories, business layers, DTOs etc. All interaction with a mobile app can be thought of as a series of asynchronous events handled by the view model. All interactions with the underlying layer, i.e… [Keep reading] “Reactive Properties in Xamarin Forms”

Azure AD Log Analytics KQL queries via API with PowerShell

21st of May, 2019 / / No Comments

Log Analytics is a fantastic tool in the Azure Portal that provides the ability to query Azure Monitor events. It provides the ability to quickly create queries using KQL (Kusto Query Language). Once you’ve created the query however you may want to run that query through automation negating the need to use the Azure Portal every time you want to get the associated report data.

In this post I detail;

  • creating a Log Analytic Workspace
  • enabling API Access
  • querying Log Analytics using the REST API with PowerShell
  • outputting data to CSV

Create a Workspace

We want to create a Workspace for our logs and queries.… [Keep reading] “Azure AD Log Analytics KQL queries via API with PowerShell”