Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

Inventory OS discrepancies

Created: 06 Mar 2013
chalks's picture

Hi

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.

 

Cheers

Jacques

 

 

Operating Systems: