Using the workstation you can perform the following.
1. Create a new metric grouping and use the following parameters.
Agent Expression = (.*)\|(.*)\|(.*) and Metric Expression = .*:Metric Count
2. Create a new dashboard.
3. Add a graph to the new dashboard.
4. Select a Data Option for the Graph. (Choose the Metric Grouping just created. )
5. Enable the Filter on the Sort/Filter tab of the graph (May need to increase number of top results. )
Using the CLW workstation you can run the following query.
get historical data from agents matching (.*) and metrics matching (.*:Metric Count) for past 1 minute with frequency of 60 seconds
An example with the full command would look like this.
C:\APM\jre\bin\java.exe -Xmx128M -Duser=admin -Dpassword= -Dhost=localhost -Dport=5001 -jar C:\APM\lib\CLWorkstation.jar get historical data from agents matching (.*) and metrics matching (.*:Metric Count) for past 1 minute with frequency of 60 seconds
This will return data that includes the current value of the metric count for metrics. You can organize and sort the results within a csv file.