Fixing the PowerON – PowerBI SCCM Current Branch 1806 Dashboard Queries

In our environment we’re seeing failures on some of the queries because we have multiple devices coming back when there should only be a single record.  I’ve created a gist with the updated SQL queries all you have to do is open up the corresponding queries and editing the root query running in SCCM.  Let me know if you find any additional edge cases where there could be potential fixes needed.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.