DX Application Performance Management

Expand all | Collapse all

Exporting Dashboard data periodically

Jump to Best Answer
  • 1.  Exporting Dashboard data periodically

    Posted 01-16-2017 06:51 AM

    Hi There,

    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?

    Environment scenario:

    1) Introscope 9.6

    2) .NET Agent.

     

    Any suggestion is greatly appreciated.

     

    Best Regards,

    Joydip



  • 2.  Re: Exporting Dashboard data periodically
    Best Answer

    Posted 01-17-2017 09:21 AM

    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 information
    https://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-FlatFileProperties
    https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC595376.html
    https://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,

    Regards,

    Sergio



  • 3.  Re: Exporting Dashboard data periodically

    Posted 01-17-2017 09:42 AM

    Hi Joydip,

     

    Please let us know if Sergio's response has answered your question.

     

    Regards,

    Matt