https://community.hpe.com/t5/server-management-systems/sim-database-table-question-on-discovery-date/m-p/4317232#M35470 I am creating a view that uses the devices table of the SIM 5.2 database. In that table is the "Discovered" date field which contains a serial number defined as a biginit. In the previous CIM7 database it was defined as a datetime field. The problem I am having is converting the serial number to a readable date such as 12/03/2008 and time of discovery. Has anyone attempted to convert this serial number, which I believe might be based on the miliseconds passed from a start time? Wed, 03 Dec 2008 14:34:33 GMT Floyd O 2008-12-03T14:34:33Z https://community.hpe.com/t5/server-management-systems/sim-database-table-question-on-discovery-date/m-p/4317232#M35470 I am creating a view that uses the devices table of the SIM 5.2 database. In that table is the "Discovered" date field which contains a serial number defined as a biginit. In the previous CIM7 database it was defined as a datetime field. The problem I am having is converting the serial number to a readable date such as 12/03/2008 and time of discovery. Has anyone attempted to convert this serial number, which I believe might be based on the miliseconds passed from a start time? Wed, 03 Dec 2008 14:34:33 GMT https://community.hpe.com/t5/server-management-systems/sim-database-table-question-on-discovery-date/m-p/4317232#M35470 Floyd O 2008-12-03T14:34:33Z