Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pacnum
New Member

Monitor Environment using Power BI and Active Directory

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

 

 

2 REPLIES 2
v-xuding-msft
Community Support
Community Support

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.

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.

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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.