CMPivot Queries
Since SCCM 1806, Microsoft have included a great tool called CMPivot to perform live queries across all currently connected SCCM clients, excluding those which are offline. Based on the Kusto query language that is also used for Azure Log Analytics, you can build queries to search or report on something…