Inventory OS discrepancies
Running CMS 7.1 SP MP1.1
For those who are running XP Embedded in their environments. I see that inventory reporting insofar as the OS is concerned comes back incorrect.
When I do a basic inventory run then it modifies the Inv_AeX_AC_Identification table with the correct OS Name, in this instance Microsoft Windows XP Embedded. It does not however do anything to the Inv_OS_Operating_System_Windows table. The Inv_OS_Operating_System_Windows seems to be modified by a hardware inventory run. This table though contains the incorrect OS name for the device.
Further to this issue, it seems as if the hardware inventory run at some point causes the Inv_AeX_AC_Identification table to be modified, thus showing the same as what's in the other table. Doing a basic inventory run on the device then changes it back again. The following SQL query is what I use to show the issue (I'm using a subset so just ignore the filters:
SELECT Inv_AeX_AC_Identification._ResourceGuid, Inv_AeX_AC_Identification.Name, Inv_AeX_AC_Identification.[OS Name],
Inv_OS_Operating_System_Windows.Name AS [INV_OS_Operating_System Result]
FROM Inv_AeX_AC_Identification INNER JOIN
Inv_OS_Operating_System_Windows ON Inv_AeX_AC_Identification._ResourceGuid = Inv_OS_Operating_System_Windows._ResourceGuid
WHERE (Inv_AeX_AC_Identification.Name LIKE N'PSHORN%')
order by Inv_AeX_AC_Identification.Name
The below is the sort of response it am getting
_ResourceGuid Name OS Name INV_OS_Operating_System Result
02694A5C-2D88-4619-8E21-05C6377D4617 PSHornPOSd03 Microsoft Windows XP Embedded Microsoft Windows XP Professional
7D84D4A3-BFB8-4736-BF35-5BFF78BD1BDC PSHornPOSd04 Microsoft Windows XP Embedded Microsoft Windows XP Professional
D4D2F49D-D74A-4BFC-8172-6AF3BCA4BA7F PSHornPOSd05 Microsoft Windows XP Embedded Microsoft Windows XP Professional
DAD1EDC9-4BA2-45D8-BBF6-984784691D82 PSHornPOSd06 Microsoft Windows XP Embedded Microsoft Windows XP Professional
B096DCB0-080A-4B08-9393-283FF1980FBF PSHornPOSd07 Microsoft Windows XP Embedded Microsoft Windows XP Professional
Sorry for the formatting, attaching a screen shot as well.
Anyone have an idea as to why this is? It seems as if the hardware inventory query is bringing back incorrect results.