Forum Discussion
Solved
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 ...
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, ResultTypeYou 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.
Noa Kuperberg
Microsoft
MicrosoftHi 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.
Legend, this was getting me close to what I wanted. I ended up doing:
AzureDiagnostics | summarize count() by Category == "DscNodeStatus", ResultType
- Noa Kuperberg
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.