Find DSC status of machines connected via OMS

I have DSC linked to OMS to retrieve logs of machine status and whatnot. What I'm looking for is the ability to show the DSC compliance status of the machines connected. So, let's say I have 4 ...

Azure Log Analytics

azure monitor

Noa Kuperberg
Dec 18, 2017
Hi Paul,

You're actually very close to the syntax you need, if I got you correctly I think this is it:

AzureDiagnostics

| summarize count() by Category, ResultType

You can try it on our playground

Also, you might want to check out our tutorial on aggregations, it's exactly on this topic, might help.

Paul MacKinnon

Copper Contributor

Dec 19, 2017

Legend, this was getting me close to what I wanted. I ended up doing:

AzureDiagnostics
| summarize count() by Category == "DscNodeStatus", ResultType

Noa Kuperberg

Microsoft

Dec 19, 2017

Hey Paul,
If what you want is to count by ResultType, only for a specific Category, use this:

AzureDiagnostics
| where Category == "DscNodeStatus" 
| summarize count() by ResultType

The syntax you used counts records per result type in other categories as well.

Forum Discussion

Find DSC status of machines connected via OMS