Where's the Update Compliance love?

%3CLINGO-SUB%20id%3D%22lingo-sub-2053738%22%20slang%3D%22en-US%22%3EWhere's%20the%20Update%20Compliance%20love%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2053738%22%20slang%3D%22en-US%22%3E%3CP%3EAre%20there%20any%20workbooks%20for%20Update%20Compliance%20reporting%2C%20alerting%20etc%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20do%20people%20use%20other%20tools%20for%20this%3F%20I%20haven't%20seen%20a%20single%20workbook%20for%20UC.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2056899%22%20slang%3D%22en-US%22%3ERe%3A%20Where's%20the%20Update%20Compliance%20love%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2056899%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F233141%22%20target%3D%22_blank%22%3E%40Fergus%20Strachan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20this%20is%20what%20you%20are%20looking%20for%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.cloudsma.com%2F2019%2F06%2Fazure-automation-update-management-workbook%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EAzure%20Automation%20Update%20Management%20Workbook%20-%20(cloudsma.com)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2071939%22%20slang%3D%22en-US%22%3ERe%3A%20Where's%20the%20Update%20Compliance%20love%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2071939%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F453722%22%20target%3D%22_blank%22%3E%40hspinto%3C%2FA%3E%26nbsp%3BNo%2C%20that's%20the%20Azure%20server%20update%20solution.%20I'm%20looking%20at%20the%20Intune-managed%20endpoint%20update%20solution%20%22Update%20compliance%22.%3C%2FP%3E%3CP%3EDespite%20the%20MEM%20portal%20telling%20us%20to%20use%20UC%20for%20update%20reporting%2C%20they%20appear%20to%20have%20given%20us%20zero%20dashboards%20for%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEDIT%3A%20That's%20not%20to%20say%20Billy's%20article%20isn't%20useful.%20It's%20great%20for%20getting%20some%20better%20understanding%20of%20workbooks%2C%20but%20it's%20for%20a%20different%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Are there any workbooks for Update Compliance reporting, alerting etc?

 

Or do people use other tools for this? I haven't seen a single workbook for UC.

4 Replies

@hspinto No, that's the Azure server update solution. I'm looking at the Intune-managed endpoint update solution "Update compliance".

Despite the MEM portal telling us to use UC for update reporting, they appear to have given us zero dashboards for it.

 

EDIT: That's not to say Billy's article isn't useful. It's great for getting some better understanding of workbooks, but it's for a different solution.

@Fergus Strachan 

 

There are example queries in the Azure Monitor Github, but no Workbook - yet.   I did copy & paste them across a while back into a Workbook, but don't have the source data to test them.  I have provided it here, in case you would like to use it as a start, or can suggest what you need?
Ultimately it would be good to add this back to the AzureMonitorCommunity Github for all to use.


How to install a Workbook from a file (in case you need it) CliveW-MSFT/KQLpublic: My useful KQL and Azure Monitor workbooks (Public) (github.com)

My sample Workbook (untested) 
KQLpublic/KQL/Workbooks/WaaSUpdateInsights at master · CliveW-MSFT/KQLpublic (github.com)


Thanks 

@CliveWatson Thanks Clive. And apologies for taking to wrong to reply, I'd lost hope and didn't think to look back here. ;)

I appreciate it, and I'll give them a go when I get a moment.

Ferg.