export serverlist + IP addresses

[pivst01]

hi All,

 

how can i get the easiest way a serverlist from APM9.6 please?

 

i tried CLWorkstation.jar list agents matching \(.*\) that gave me the agentlist, but some servers have 10-20applications (=agents), so i cant use this export as it contains duplicated entries.

 

and i didnt find similar command for serverlist in CLW.

 

i tried to generate a report via MGMT module too and get this list, but couldnt figure out any sophisticated way to get it.

 

any idea please?

 

PS: in addition, if you have any tip, how to get an IP address list with the servers too, it would be great. via report i cant export string, if im correct and the IP address is saved as string.

 

thank you,

stefan

[pivst01]

FYI, my solution is this:
i used the command below to get the hosts with IP addresses via CLW:

 

../jre/bin/java -Duser=Admin -Dpassword=*** -jar CLWorkstation.jar get historical data from agents matching ".*" and metrics matching ".*IP Address*" for past 1 minute with frequency of 60 s

 

where i got some duplicated lines as it is filtered for the IP addresses and some hosts have more agents, i.e s08982um:

 

../jre/bin/java -Duser=Admin -Dpassword=Gumkac23 -jar CLWorkstation.jar get historical data from agents matching ".*" and metrics matching ".*IP Address*" for past 1 minute with frequency of 60 s

 

Domain, Host, Process, AgentName, Resource, MetricName, Record Type, Period, Intended End Timestamp, Actual Start Timestamp, Actual End Timestamp, Value Count, Value Type, Integer Value, Integer Min, Integer Max, Float Value, Float Min, Float Max, String Value, Date Value

SuperDomain,s08982umw,WebSphere,Cell01/RTEC4-11,Host,IP Address,Unknown,60,Tue Apr 28 10:49:22 CEST 2015,Tue Apr 28 10:48:15 CEST 2015,Tue Apr 28 10:49:15 CEST 2015,1,String,,,,,,,10.215.130.14,

SuperDomain,CZZSP0WW104,.NET Process,RA22011,Host,IP Address,Unknown,60,Tue Apr 28 10:49:22 CEST 2015,Tue Apr 28 10:48:15 CEST 2015,Tue Apr 28 10:49:15 CEST 2015,1,String,,,,,,,10.215.116.14,

SuperDomain,s08986wyy,WebSphere,Cell01/Rssb2_a071,Host,IP Address,Unknown,60,Tue Apr 28 10:49:22 CEST 2015,Tue Apr 28 10:48:15 CEST 2015,Tue Apr 28 10:49:15 CEST 2015,1,String,,,,,,,10.215.13.84,

SuperDomain,s08982vsq,WebSphere,Cell01/RPDC1-11,Host,IP Address,Unknown,60,Tue Apr 28 10:49:22 CEST 2015,Tue Apr 28 10:48:15 CEST 2015,Tue Apr 28 10:49:15 CEST 2015,1,String,,,,,,,10.215.130.11,

SuperDomain,s08982umw,WebSphere,Cell01/RTES4-11,Host,IP Address,Unknown,60,Tue Apr 28 10:49:22 CEST 2015,Tue Apr 28 10:48:15 CEST 2015,Tue Apr 28 10:49:15 CEST 2015,1,String,,,,,,,10.215.130.14,

..

 

so i took this list and put into excel, where i just removed the duplicated lines and i got all the hosts, where introscope agent is implemented.

[Viruvaibhav_apm]

Hi Stefan,

 

Any updates ?

 

Regards,

Vaibhav

[Viruvaibhav_apm]

Hi Stefan,

 

Regarding the server list, the easiest and convenient way which I prefer is using Management Module Agent Filter option.

 

So what you can do is, Create a Management Module, click on newly created MM and in the "agent expressions" formfield, put (.*) Regex.

 

Once you apply, it will list out all the Instances with server names in tabular format. You can copy paste that to Excel for your convenience. This would be a bit hectic if you are having too many Domains, but I find this useful to know the Server-JVM's reporting to my Domain.

 

Hope it helps.

 

Regards,

Vaibhav