Query Historical Data via CLW for Sub-Node details

[Viruvaibhav_apm]

Hi Experts,

 

Can you please help me to know what would be the CLW Quey syntax to get historical data for All Individual Servlets Responses Per interval.

 

To elaborate, in Investigator we have "Servlets" folder which it self has Responses Per Interval metric and whose data could be retrieved using below command -

 

Java -Xmx128m <EM_Logon> -jar CLW.jar get historical data from agents matching (.*) and metrics matching (Servlets:Responses Per Interval) for past 1 minute

 

But If I want to get details of my individual servlet, what would be there for 'metrics matching' in query ?

 

Lets say we have three servlets under servlet folder - Servlet1, ABC1, XYZ2.

 

Please suggest.

 

Regards,

Vaibhav

[Viruvaibhav_apm]

Hi Experts,

 

Any help will be much appreciated.

 

Regards,

Vaibhav

[Guenter DI Grossberger]

Hi Vaibhav,

 

just insert a wildcard .* after Servlets:

 

Java -Xmx128m <EM_Logon> -jar CLW.jar get historical data from agents matching (.*) and metrics matching (Servlets.*:Responses Per Interval) for past 1 minute

 

Ciao,

Guenter

[Viruvaibhav_apm]

Thanks Guenter. That really works.

 

But I have one more doubt (though you resolved it but asking out of curiosity), that how to make sure that we have only three servlet responses per interval data and not as a whole.

 

In other words, how can we use this Regex expression - "Servlets\|([^\|:]*):Responses Per Interval" in the above query which will restrict the data for  - 'Servlets:Responses Per Interval' metric.

 

Hope I clearly stated my problem.

 

Regards,

Vaibhav

[Guenter DI Grossberger]

Hi Vaibhav,

 

you should be able to use the same regex from the CLW. Have you tried?

 

Ciao,

Guenter

 

P.S. Please mark the question as answered.

[Viruvaibhav_apm]

Nopes.
When I use - (Servlets\|([^\|:]*):Responses Per Interval), it prompts with - ':Responses was unexpected this time'

 

[I thought I will mark answered once I get this Answer, but let me mark it now ]

[Guenter DI Grossberger]

Both (Servlets\|.*:Responses Per Interval) and  (Servlets\|[^\|:]*:Responses Per Interval) worked for me.

Ciao,

Guenter

[Viruvaibhav_apm]

Okies.. got it... I was putting extra () that making my expression not working.

 

Many thnaks Guenter_Grossberger

 

Regards,

Vaibhav