PowerShell Script to Create OMS Saved Searches that Maps OpsMgr ACS Reports

Written by Tao Yang

Microsoft’s PFE Wei Hao Lim has published an awesome blog post that maps OpsMgr ACS reports to OMS search queries (https://blogs.msdn.microsoft.com/wei_out_there_with_system_center/2016/07/25/mapping-acs-reports-to-oms-search-queries/)

There are 36 queries on Wei’s list, so it will take a while to manually create them all as saved searches via the OMS Portal. Since I can see that I will reuse these saved searches in many OMS engagements, I have created a script to automatically create them using the OMS PowerShell Module AzureRM.OperationalInsights.

So here’s the script:

You must run this script in PowerShell version 5 or later. Lastly, thanks Wei for sharing these valuable queries with the community!

3 comments on “PowerShell Script to Create OMS Saved Searches that Maps OpsMgr ACS Reports

  1. Pingback: SCOM ACS Reports in OMS - go 2 azure

  2. Pingback: System Center Ocak 2017 Bülten – Sertaç Topal

  3. Pingback: System Center Ocak 2017 Bülten – Christopher Golden Blog

Leave a Reply