CMPivot Refresh Query
Add a refresh button for CMPivot queries so you can hit “Refresh” or “F5” to get fresh query results.
If you run a query like “Service | where State != ‘Running’ | where StartMode == ‘Auto’” you get results. Say you waited 5 minutes and wanted to run the same query again to see if something changed. If you hit Run Query without changing the Entity, it just shows you your cached query results instead of doing a fresh run of the query. Please invent us a button to get fresh results. :)
Randall Kender commented
I would like to point out that this is a much needed feature. We've started using CM Pivot for everything, it is one of the best features really, but most importantly we use it during server validation after patching or software deployments. Everything from checking services like mentioned above, drive space, running processes, installed software, crash dumps, event logs, etc.
We normally have 10 or so queries we run through on a collection after maintenance to make sure everything is working. But once we've used the results and fixed the issues, say by running scripts against devices or remediating in other ways, it would be nice to have a refresh button somewhere that tells CMPivot you want all past data cleared and any new queries are from live data.
Also some kind of notification if you re-run queries that you are now working with cashed data would be helpful. It is obvious to most people who use the tool when the results come up instantly, but still would like to know for sure that you've got cached results.