Monitoring Mode Count

[MikeL]

Is their a way in DT Dashboard to create a single Tile or Table showing the count of Host set in Full Stack & Infra mode. Then if that count changes, the tiles changes color based on simple threshold, simply way to check dynamically.
Script example or Demo Dashboard we can clone to grab that tile. 
We have some scenarios where some of our hundreds of VM Monitoring Mode get changed without notice.

[dannemca]

Yes, you can

Using this simple DQL you can achieve this:

fetch dt.entity.host
| fields entity.name, monitoringMode
| filterOut isNull(monitoringMode)
| summarize Total = count(),by:{monitoringMode}

Then you play around with visualizations and thresholds to achieve what you need.

Regards.