EcoStruxure IT forum
Schneider Electric support forum about installation and configuration for DCIM including EcoStruxure IT Expert, IT Advisor, Data Center Expert, and NetBotz
Link copied. Please paste this link to share this article on your social media post.
Posted: 2024-05-01 08:11 AM
I'm using the IT Advisor REST API and I'm trying to parse the installDate field available on most assets.
It looks like the field is the number of milliseconds from some Epoch date, but I wasn't able to find the exact date in any of the documentation.
Here's a few example values from my site:
installDate: 1578632272450
installDate: 1578632305054
installDate: 1578632331520
Using Jan 1st, 1970 gives plausible results, but I need to know the exact time & date to use, and if the install date is UTC time or local time to give a correct conversion.
As far as I can tell, this date isn't available in the Web or Software UI, only the audit log which, again, gives me a plausible but not exact value for installDate.
Thank you!
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2024-05-01 06:33 PM
Hi @MichaelTelford,
ITA uses Unix Epoch time, which is the number of seconds or milliseconds since 1/1/1970, which we use milliseconds. This time should be in Greenwich Mean Time (GMT) as per my testing.
installDate: 1714613227696
Converted installDate using a epoch time converter:
GMT around the time the asset was created:
This shows that 1/1/1970 is used as the date, and that GMT time is used for the stored value. Hopefully this helps!
Regards,
Cory
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2024-05-01 06:33 PM
Hi @MichaelTelford,
ITA uses Unix Epoch time, which is the number of seconds or milliseconds since 1/1/1970, which we use milliseconds. This time should be in Greenwich Mean Time (GMT) as per my testing.
installDate: 1714613227696
Converted installDate using a epoch time converter:
GMT around the time the asset was created:
This shows that 1/1/1970 is used as the date, and that GMT time is used for the stored value. Hopefully this helps!
Regards,
Cory
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2024-05-02 06:33 AM
Perfect, thank you!
Link copied. Please paste this link to share this article on your social media post.
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.