It's possible obtain total number of transactions in APM 10.8?

[Daniel Alberto Quiroz Mendez]

Hi.

I am looking at the best way to generate a report in which the client requires to see how many transactions are associated with WebServices\|Server\|WebForms_Authorization_(.*) on all nodes. and how many of those transactions exceed times of 3000 ms.

 

I try node by node but i don´t understand what are refering "count".

For example i want show in my report somthing like

Node	Webservice	Total transactions	Total slow transactions	Average response time	Maximum response time
Node 1	webservice 1	100	21	10	11110
	webservice 2	253	163	5	12325
	webservice 3	300	15	100	10000
	webservice 4	452	114	400	30000
Node 2	webservice 1	552	35	520	56000
	webservice 2	662	69	1000	20030
	webservice 3	772	69	69	3000
	webservice 4	882	122	2410	2000

The idea is to apply this in a report template. Has anyone done it before?

[Haruhiko Davis]

I'd recommend using a JS calculator so you can do the math you need on the values, then create your report. You could also export the raw metrics via CLW into CSV format to create your report.

[Daniel Alberto Quiroz Mendez]

Thanks Haruhiko.

I will try with the CLW, in the past i execute de .JAR but don´t run nothing maybe my java version is the issue.

You know what is counter in the picture that i attach?

Thanks for your help

[Haruhiko Davis]

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/application-performance-management/10-8/using/apm-command-line-workstation/clw-command-reference.html

[Daniel Alberto Quiroz Mendez]

I was working with java -Xmx128M -Dduser=Admin -Ddhost=172.18.x.x -Ddport=5001 -Dintroscope.clw.tt.mode=Asynch -jar CLWorkstation.jar trace transactions exceeding 5 seconds in agents matching "(.*)" for 600 seconds. But work from the moment that i use it to future traces. Do you know a way  to export the metrics on a certain time date from last week and detailing the webservice of my interest?

[Haruhiko Davis]

Look at the examples for extracting persistent data for CLW.

[Daniel Alberto Quiroz Mendez]

Hi I try with this command:

java -Xmx128M -Dduser=Admin -Ddhost=172.x.x.x -Ddport=5001 -Dintroscope.clw.tt.mode=Asynch -jar CLWorkstation.jar get historical data from agents matching (.*webappsalud.*) and metrics matching (WebForms_Authorization_(.*):Average Response Time \(ms\)) between \"2024-07-01 00:00:00\" and \"2024-07-07 11:59:00\" with frequency of 60 seconds

and the cmd view is this:

To write the traces in .CSV file i add 

Dintroscope.clw.tt.filename=output.csv

and the cmd write error:

• Error: Could not find or load main class Dintroscope.clw.tt.filename=output.csv

later i add:

Dintroscope.clw.tt.filename=output.csv
- Dintroscope.clw.tt.dirname=F:\Program Files\CA APM\Introscope10.8.0.27\lib

and the error is:

• Error: Could not find or load main class Files\CA

How i can get metrics in a csv file?

Thanks!

[Haruhiko Davis]

Daniel,

Just redirect the stdout to a file.