Hello Imran:
APM Command-Line Workstation
https://docops.ca.com/ca-apm/10-1/en/using/apm-command-line-workstation/
I use this command to get cpu metrics and its value in a historical range of time
java -Xmx128M -Duser=admin -Dpassword=**** -Dhost=apmhost.company.com -Dport=5001 -jar CLWorkstation.jar get historical data from agents matching "Host\|Process\|Agent" and metrics matching "CPU:(.*)" between \"2018-10-01 00:00:00\" and \"2018-10-31 23:59:59\" with frequency of 3600 seconds > cpu_historical_metrics.csv
I use this command to get all cpu metrics and its value for last x minutes, under CPU node
java -Xmx128M -Duser=admin -Dpassword=**** -Dhost=apmhost.company.com -Dport=5001 -jar CLWorkstation.jar get historical data from agents matching ".*\|.*\|.*" and metrics matching "CPU:(.*)" for past 1440 minutes with frequency of 3600 seconds > cpu_historical_metrics.csv
|
To query agent/metrics from SmartStor Data:
https://docops.ca.com/ca-apm/10-1/en/administrating/configure-enterprise-manager/configure-and-manage-smartstor-data
.\SmartStorTools.bat test_regex -agents "SuperDomain\|Host\|Process\|Agent" -src {EM_HOME}\data
<EM_Home>\tools>SmartStorTools.bat test_regex -metrics ".*Socket.*" -src <path to data directory>
Also there are option to just list this metrics, remove or copy
Hope to help you
Regards,
Richard