Sep 22 2018
12:02 AM
- last edited on
Apr 07 2022
05:29 PM
by
TechCommunityAP
Sep 22 2018
12:02 AM
- last edited on
Apr 07 2022
05:29 PM
by
TechCommunityAP
I'm a rookie into using Dashboards, PowerBI, Query, so bear with me, if my questions are basic :)
1. I would like to setup an Custom Update Dashboard on Azure, that contains the following views:
Chile servers with missing critical updates or security updates
Denmark servers with missing critical updates or security updates
Norway servers with missing critical updates or security updates
Chile client computers with missing critical updates or security updates
Denmark client computers with missing critical updates or security updates
Norway client computers with missing critical updates or security updates
I'm hoping to be able to filter by RemoteIPCountry and OSVersion or similar
It would be perfert with a nice graph per country with possibility to drill down
How do I do that ?
2. I have also read that I should be able to clone current views in Log Analytics View Designer, but in my case, I don't see any of the standard OMS views in the View Designer - just a clean template
Cheers
Morten
Nov 18 2018 06:01 AM
Hi,
I see the OS information is not always populated in the "Update" table, so if that's the case you can join on the "Heartbeat" table, like in this query:
Update | where UpdateState == "Needed" and Optional == "false" and Classification in ("Security Updates", "Critical Updates") | join kind= leftouter ( Heartbeat | summarize by Computer, OSType, RemoteIPCountry, Version ) on Computer | project TimeGenerated, SourceComputerId, PublishedDate, Title, Classification, Computer, OSType1, Version, Product, RemoteIPCountry
note that in the last "project" line, I include OSType1 (taken from Heartbeat table) instead of OSType (from the Update table) which is empty. That way you also get the Version (of the OS) and RemoteIPCountry to filter by. I hope the OS Type and version together can help you identify client vs server OSs.
HTH,
Noa