Bigfix Database Time

Hi Guys,

We have created a baseline today 9/6/2019 11:00 AM and deleted it today 9/6/2019 3:30 PM.

Upon checking the Database about the Baseline History, who created and deleted it, I saw the “CreationTime” column 9/6/2019 2:00 AM and the “LastModificationTime” is the same day in 2:00 AM.

Is it possible that the clock of our database is different? but the time in the OS of Database server is the same as the Application Server.

We are in Philippine Standard Time +08
Please help.

Thank you.

Regards,
Pogi

One of many reasons we recommend not looking into the database directly. Consider it Not Documented.

If I had to guess, it would make a lot of sense for the database to store records in UTC time.

1 Like

Hi Sir @JasonWalker,

Ahh that is why it has different creation time.
I’ll get back with this, if I had additional info.

thank you sir.