cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

This product reached the end of support date on March 31, 2021.

What is Time Range in XML Report Definition?

genesius_jarom1
Organizer

Some of you probably have figured this out, but I had to work it out for myself.

I am editing the XML report definition (?) and looking for ways to modify and manipulate the report without having to use the DMI editor. I came across this code in the XML.

  <timeRange timeRangeId="fixed" resolutionId="HOUR">
<rangeFixed begin="1444737600000" end="1444741200000" />
</timeRange>

I decided to decipher what the 13-digit number used in the begin and end parameters means. Here are my findings.

Using today's date (Oct 13, 2015), a Resolution of 1 Period with a Time of 8:00 am and a Range of 5 minutes.
begin = 1,444,737,600,000
end = 1,444,737,900,000
dif b/e = 300,000

Since there are 3000 seconds in 5 minutes, the 13-digit number is a measurement in thousandths of a second.

1 Period (5 mins) = 300,000
1 Hour = 3,600,000
1 Day = 86,400,000
1 Week = 604,800,000

This is what would be added or subtracted to manipulate the Time Range with the XML definition.

Checking the attached Excel file what-is-time-in-dcrum-xml-report-export-definition.xlsx it can determined the Start of Global Computer Time (SGCT) was Jan 1, 1970 at Midnight.

Please let me know if my calculations off.

Thanks and God bless,

Genesius

PS If you have any other insights to how to manipulate the XML Report Definition, or have any documentation on what each of the tags within the XML means, please share them in a new posting.

3 REPLIES 3

adam_piotrowicz
Dynatrace Pro
Dynatrace Pro

Genesius,

Epoch time stamps can be easily converted or verified on http://www.epochconverter.com/.

genesius_jarom1
Organizer

Thanks Adam,

Well at least I understand how it works now.

Thanks and God bless,

Genesius

chris_v
Dynatrace Pro
Dynatrace Pro

There's even a epoch time converter in the Diagnostics Console.

AMD data files include a hex encoded epoch timestamp in the names, so you know which interval they belong too.