Is there any option available, using which we can schedule an export mechanism of any dashboard data points within a time-frame?
Use case is as below:
1) We have an alert for dynamic SQL queries response time.
2) The alert is placed on a dashboard.
3) From Introscope client, using "Export" option we can export the data points (which includes the SQL queries) as CSV.
4) But can we schedule some kind of script/CLW commands - which will automatically export from the dashboard data in CSV and save it in a prescribed location?
1) Introscope 9.6
2) .NET Agent.
Any suggestion is greatly appreciated.
Hello Joydip,There is not an option to export dashboard data, I suggest you to open an Idea/enhancement request for this current limitation.
Here are some suggestions you might want to discuss, consider or try to implement:
a) create reports based on metric groupings available from the dashboards, then use CLW to export this informationhttps://docops.ca.com/ca-apm/10-5/en/using/apm-command-line-workstation/clw-command-reference#CLWCommandReference-GenerateReport
b) Enable and configure Persistent Collection Settings, in case of Flat File, data will be already available for analysis in CSV format, but you would still need to mechanism to extract the right data based on your dashboard content.see:https://docops.ca.com/ca-apm/10-5/en/administrating/properties-files-reference/introscopeenterprisemanager-properties#IntroscopeEnterpriseManager.properties-FlatFilePropertieshttps://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC595376.htmlhttps://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC1521038.html
c) We added the “Export to CSV” option in Webview 9.7, we use a separate servlet to download this data as csv (/apm/export?id=xxxxx), maybe you can automate this action using seleniumhq browser automation.
d) I believe, as part of the new export feature in 9.7, we built an export framework to support webview exports, maybe CA services can help you implement something for you.
I hope this helps,
Please let us know if Sergio's response has answered your question.