Monitor Environment using Power BI and Active Directory

[pacnum]

Hi All,

I would like to use Power BI and Active Directory to monitor our environment. I would especially like to be able to check for latest patch installs, which date they were installed, adn when the servers ( or workstations ) were last rebooted.

Our current patch system looks after a number of serevrs in our orginisation, ( but not all of them )

I wish to use PowerBI to catch ALL systems on our nextwork, using the Active Directory data source.

I can pull Computer Name, Created date, Operating System Info etc from the AD data soruce, but having difficuklty finding any options for patches.

If I use powershell command - Get-WmiObject - I can find this info out, so I'm hoping this info is hidden somewhere and someone can help me find it 🙂

Cheers for you help,

Danny

[v-xuding-msft]

Hi @pacnum ,

Please reference the links:

https://www.biinsight.com/power-bi-and-active-directory-for-system-administrators/

https://www.youtube.com/watch?v=szLAmNZKCZ0

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pacnum]

Hi - Thanks for these links.

I have seen, and created our own orginisations PC and Server group chart, based on the info provided in https://www.biinsight.com/power-bi-and-active-directory-for-system-administrators/ and it's been very helpful.

I have not however been able to find any tag, or item within this that can show either SCCM or Windows Updates status.

Any help here would be much appriciated.

Again, thanks for your help,

Danny