AnsweredAssumed Answered

Script CLW change format timestamp

Question asked by Alexandre_Magno84 on Aug 24, 2016
Latest reply on Aug 29, 2016 by Alexandre_Magno84

Hi Guys 

 

I'm running a CLW script but the results show timestamp "Tue Aug 23 10:46:50 BRT 2016", is there some way to change this out to something like "23/08/2016 10:46:50"

 

Command:

java -Duser.timezone=America/Sao_Paulo -Duser.formatdate="DD/MM/YYYY" -Xmx128M -Duser=admin -Dpassword=XXXXXXX -Dhost=localhost -Dport=5001 -jar CLWorkstation.jar get historical data from agents matching .*Custom.* and metrics matching .*AS400_BVSA_DISK_BUSY_MAX.* for past 5 minute with frequency of 60 seconds

 

Out:

 

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, Custom Metric Host (Virtual), Custom Metric Process (Virtual), Custom Metric Agent (Virtual), , AS400_BVSA_DISK_BUSY_MAX, Unknown, 60, Fri Jul 01 17:50:41 BRT 2016, Fri Jul 01 17:45:30 BRT 2016, Fri Jul 01 17:46:30 BRT 2016, 4, Long, 10, 6, 10 , , , , ,

Outcomes