Windows Patching Dashboard

i all,

We’re looking to build a comprehensive Windows patching dashboard in LogicMonitor to support compliance, vulnerability management, and visibility across our customer environments (we're an MSP).

We currently monitor patching via the WinUpdate_PatchStatus DataSource, but we’d like to expand that with more widgets and deeper insights.

Host-level metrics we want:

• Pending updates count
• Failed updates count
• Last successful update time
• Reboot required (true/false)
• Recent installed or pending KBs (if possible)

Dashboard-wide summary widgets:

• Top 10 hosts with most pending updates
• Percentage of Windows servers that are fully patched
• Pie chart: compliant vs pending vs failed
• Compliance trends over time
• Breakdown by group, tag, or customer

Nice to have:

• Table view showing last 5 patches per server
• Alert integration (e.g., warning if failed updates > X)
• Multi-tenant filters using tags like env=prod or customer=x
• Reusable dashboard layout for other clients or environments

What we already have in place:

• WinUpdate_PatchStatus active
• Proper WMI permissions & Collector access
• Basic auto properties like auto.updatecount, auto.lastupdate

Looking for:

• Dashboard JSON exports with any of the above
• Custom DataSources (PowerShell-based?) to enrich with KBs
• General tips on patching visibility and compliance via LogicMonitor

Would appreciate anything you can share — we’ll happily post our version once we finalize it!

Thanks in advance!

Admine

LM certified Monitoring Professional