Software inventory installation date 0000-00-00

[Claus Hansen]

Windows agent 2.1.1 - Windows 2008 - Windows 7 - Windows 8.
We get installation date 0000-00-00.

[Holger Schletz (holger-schletz)]

The date reported by the agent is generally unreliable. It can have various formats like Y/m/d or m/d/Y (on the same system) or contain garbage like "0000//0/0/00". The server passes this value directly to MySQL which silently accepts any invalid date input and turns it into... a different kind of garbage (0000-00-00).

The agent should try to validate the value and either convert it to a unified format (preferrably ISO8601) or discard unparseable input so that the XML file is consistent.

[Sylvie (sylvie-cozic)]

Hello,

It seems to me there are 3 cases :

- Software is found in the registry (...\uninstall key); the field InstallDate exists and value is formatted YYYYMMDD -> value in xml/ocs file is correct and formatted YYYY/MM/DD; value is correct in table "softwares".

- Software is found in the registry (...\uninstall key); the field InstallDate doesn't exist -> value in xml/ocs file is "0000//0/0/00"; value in table "softwares" is "0000-00-00 00:00:00"

- Software is an hotfixe (found in WMI class Win32_QuickFixEngineering)-> value in xml/ocs file is correct and formatted "D/M/YYYY"; value in table "softwares" is "0000-00-00 00:00:00"

The issue is with the last 2 cases... the first one is working correctly...

Regards,

Sylvie