Uptime vs. Boot Up Time Reporting

[Nick H]

Using the Reporting functions.

In the one area of "Inventory",
I can get the actual date of the [b]System Boot Up Time.[/b]
This has a readable human acceptable date time.


While in another report throug the "Operating System" I can get the [b]System Up Time[/b].
This has a large number similar to 1123779570000

Is this in milliseconds? Seconds?
Else how can I convert it to a date? or Time frame (14 days ago, etc.)?
I know it's not JULIAN format...

Ultimately, I want to know when the servers last reboot was, including historical reboots.

I am hoping to get this info out of the SIM Database, SIM has a MS SQL DB.

[Nick H]

I found this is a Unix time stamp to the millisecond (I think).

Looking at a Unix Time Stamp converter (e.g. http://www.onlineconversion.com/unix_time.htm)
input your number 1123779570000
remove the last three digits. Click Convert.

Unfortunately, I am finding the data in the database is not always correct. Unless there is something else I am missing... :/