Software inventory installation date 0000-00-00

Bug #1387081 reported by Claus Hansen on 2014-10-29
16
This bug affects 3 people
Affects Status Importance Assigned to Milestone
OCS Inventory: Windows Agent
Undecided
Unassigned

Bug Description

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

Holger Schletz (holger-schletz) wrote :

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) wrote :

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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers