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" />
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,
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.