DX Application Performance Management

Expand all | Collapse all

CA Tuesday Tip: APM Export Tool Vs. Canned Reports

  • 1.  CA Tuesday Tip: APM Export Tool Vs. Canned Reports

    Posted 08-08-2011 04:38 AM
    CA Wily Tuesday Tip by Hallett German, Services Architect for 8/9/2011

    APM Export Tool vs. Canned Reports

    For the majority of APM users, the APM Customer Experience canned reports are more than adequate in presenting their application health. But for some
    customers, they may need to consider using the APM Export Tool instead for the following situations.

    - when needing custom percentiles for reports involving transaction time, size, and throughput. Currently, the canned report cannot customize
    percentile values in reports.
    - when statistical aggregations are needed for a selected time period.
    - when specific defect information needs to be extracted.
    - when custom graphs and reports need to be produced from the raw data.
    - when data or statistics for a specific combination of time, business service/transactions, user groups, etc. are needed.
    - when a custom report can be created by extending the export tool Java code.

    If you haven't use the tool before, please take teh opportunity to do so. If you have, please respond to this tip with other uses of the tool.

    Notes:
    1. The Export Tool can be found here: https://community.wilytech.com/entry!default.jspa?categoryID=604&externalID=2893&fromSearchPage=true
    2. A tech note on report options can be found here: https://communities.ca.com/documents/2301951/dedba930-d370-48d5-957b-73f3b9d1523d
    3. Make sure that you use the correct export tool for your APM version. Else the tool will not work and give unexpected error messages.


  • 2.  RE: CA Tuesday Tip: APM Export Tool Vs. Canned Reports

    Posted 08-08-2011 07:29 PM
    Hallett,
    CEM Export Tool is no longer available on wilytech.com. Can you add it to the Document Library, or add it to your post?

    -Hiko


  • 3.  RE: CA Tuesday Tip: APM Export Tool Vs. Canned Reports

    Posted 08-09-2011 07:38 AM
    Hiko:
    Thanks for your note. Before I posted the article, I tried the link that was included and it was working.

    I added the 9.0.5 and later export tool under the Tools section which is a peer folder to the best practices document. You can grab it from there


  • 4.  RE: CA Tuesday Tip: APM Export Tool Vs. Canned Reports

    Posted 06-08-2012 05:28 PM
    I know it's too late for a response, but what it's worth i use this tool everyday, i have a quick view portal that i created for app owners to look at a snapshot of daily/weekly and monthly reports. additionally we use this tool monthly to extract Application Transaction Response times (non aggregated) every month and upload that in our internal enterprise portal for reviews.

    Thanks
    Ashish Vashisht


  • 5.  RE: CA Tuesday Tip: APM Export Tool Vs. Canned Reports

    Posted 08-12-2012 07:32 AM
    Dear Ashish:
    It is never too late for a response! Thanks for sharing!!


  • 6.  RE: CA Tuesday Tip: APM Export Tool Vs. Canned Reports

    Posted 08-09-2011 07:29 AM
    Thanks Hal for this great Tuesday Tip.
    Has anyone else gotten good results from the APM Export Tool?

    Chime in!

    Mary


  • 7.  RE: CA Tuesday Tip: APM Export Tool Vs. Canned Reports

    Posted 08-09-2011 02:40 PM
    Mary,
    I've not used the tool previously,so I'm looking forward to using it.
    I've worked with Shubhra previously on using Jasper to extract data into CSV format, which worked really well for a previous employer.

    -Hiko


  • 8.  RE: CA Tuesday Tip: APM Export Tool Vs. Canned Reports

    Posted 11-15-2011 11:43 AM
    Good Morning,

    Has anyone been able to get the export tool to work? We are on 9.0.7.1, and I have tried a couple different options, and always get a StackOverflowError. Just wonder if it is just me doing something wrong, or perhaps an issue with the tool?

    Craig

    error:

    /introscope/Introscope9.0.7.1/jre/bin/java -jar CEMExportTool.jar -host vamonapp33 -username cschar -password xxxxxxxx -port 8082 -command 1 -output data.csv -interval 3 -start "11/10/2011 00:00:00" -end "11/10/2011 23:59:00"
    CEM Host: vamonapp33
    CEM webservice login username: cschar
    CEM webservice login password: *******
    CEM webservice listen port: 8082
    command number: 1
    Export file : data.csv
    Aggregation Type: 3
    Query start time : 11/10/2011 00:00:00
    Query end time : 11/10/2011 23:59:00
    - Redirect requested but followRedirects is disabled
    Exception in thread "main" java.lang.StackOverflowError
    at org.apache.axis.AxisFault.addHostnameIfNeeded(AxisFault.java:881)
    at org.apache.axis.AxisFault.initFromException(AxisFault.java:280)
    at org.apache.axis.AxisFault.<init>(AxisFault.java:181)
    at org.apache.axis.AxisFault.makeFault(AxisFault.java:101)
    at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:154)
    at org.apache.axis.transport.http.HTTPSender.readFromSocket(HTTPSender.java:727)
    at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:144)
    at org.apache.axis.transport.http.HTTPSender.readFromSocket(HTTPSender.java:727)
    at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:144)
    at org.apache.axis.transport.http.HTTPSender.readFromSocket(HTTPSender.java:727)
    at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:144)

    ..........


  • 9.  RE: CA Tuesday Tip: APM Export Tool Vs. Canned Reports

    Posted 11-15-2011 12:06 PM
    I of course posted too quickly. Found the issue. You must use IP address for the TESS host, not name. The below format works:

    /introscope/Introscope9.0.7.1/jre/bin/java -jar CEMExportTool.jar -host 10.224.53.21 -username cschar -password xxxxxxxx -port 8082 -command 32 -output data.csv -start "11/08/2011 00:00:00" -end "11/14/2011 17:59:00" -appname "MOCHA" -usergroup "UserGroupTim-10.56.0.0"

    Hope this helps anyone else wanting to use this.

    Craig