Need to list some values from agent metrics using CLW, wothout using the report templates. A query in CLW such as
get raw historical data from agents matching HostUATxx(.*) and metrics matching "CPU:Processor\ Count" for past 1 minute
works just fine, though it gives 4 rows per metric. However, while executing similar CLW for other metrics such as "Agent\ Stats:Build\ and\ Release" results into blank rows. I presume, this is because of text metrics limitation on 'history' view, as is evident in Introscope Workstation as well.
Will be great, if anybody has some suggestion to get it going.
CLW historical query won't work for the metric in question "Agent Stats:Build and Release" because it's a String metric and don't get stored in Smartstor, can only be viewed in live mode.
Here is a way to accomplish what you want although will require use of Report Templates
Step 1- Create a metric grouping which matches on "Agent\ Stats:Build\ and\ Release" for required agents
Step 2- Create a new Report Template for e.g called as Test and add a Metric Data Table as an element
Step 3- In the right hand side in Data Properties tab chose the above Metric Grouping created
Step 4(Most Important)- In Display Properties tab scroll to the "Table Columns:" and choose "Text Value"
Step 5- Save Report template, enable and preview it to make sure that the required Build and Release information is present
Step 6- Run below command using CLW to generate the report and save it locally for e.g
generate report named "Test" in management module named "<Name of MM containing Report Template>" to <filename>.pdf
Hi Kulbir, thanks for your reply. However, I was looking at the alternatives for Report template creation under any management module as such. Exploring the way to display the current value of a specific metric. Creating a report template or a metric grouping requires another record creation within some management module, which people forget to remove after one-time use, and want to avoid that.
Ayaz I do believe there is a value for creating Report Template for the Build and Release information metric as it could be used for upgrade planning of Agents or getting list of all agent versions deployed in the environment, anyways if that doesn't work for you then only other option I can think is using APM Webservices API specifically the MetricsDataService. Check out APM API Reference Guide for more details on the operations and usage and feel free to open a support issue if you need further assistance with above.
On a further combinations testings, the following command on the CLW worked just fine.
get historical data from agents matching (.*) and metrics matching (Agent Stats:Build and Release) for past 1 minute with frequency of 60 seconds
Thanks Kulbir for your suggestion. Really appreciate your help.