Help with Hardware Inventory

[RobinArm]

Hi

 

I am trying to get a Hardware inventory from an estate of around 200 XP and Win7 PC's. I've followed various troubleshooting guides but have not yet been able to work out exactly where it is falling over. I am using a Win7 client for testing this.

 

I've initalised an inventory of the the client and can see from the inventoryAgent.log that the data was collected. I think the problem is that the data is not being transferred as there is nothing in the ccmexec.log. If my understanding of the process is correct so far what should my next step be?

[RobinArm]

I've checked the MP_Hinv.log and can see that a report was received from my test PC but when I looked in the dataldr.log file on the config manager server I found this:

 

Processing Inventory for Machine: Win7testPC Version 1.3 Generated: 01/12/2013 9:24:29 SMS_INVENTORY_DATA_LOADER 07/03/2013 09:33:29 3992 (0x0F98)
Pragma delete found in inventory group MICROSOFT|SYSTEM_DEVICES|1.0. Deleting group... SMS_INVENTORY_DATA_LOADER 07/03/2013 09:33:30 3992 (0x0F98)
Pragma delete found in inventory group MICROSOFT|PNP_DEVICE_DRIVER|1.0. Deleting group... SMS_INVENTORY_DATA_LOADER 07/03/2013 09:33:30 3992 (0x0F98)
Begin transaction: Machine=DGC03324(GUID:D079B78E-DD21-4127-BC80-4A0E8DD3F521) SMS_INVENTORY_DATA_LOADER 07/03/2013 09:33:30 3992 (0x0F98)
ERROR - attempt to update non-existent row. Invalid command: exec pWorkstationStatus_DATA 1,4845,'03/07/2013 09:33:29',1,'1/12/2013 09:24','4294967299',1033,0 SMS_INVENTORY_DATA_LOADER 07/03/2013 09:33:30 3992 (0x0F98)
Rollback transaction: Machine=DGC03324(GUID:D079B78E-DD21-4127-BC80-4A0E8DD3F521) SMS_INVENTORY_DATA_LOADER 07/03/2013 09:33:30 3992 (0x0F98)
Remote client hardware inventory resync generated for client GUID:D079B78E-DD21-4127-BC80-4A0E8DD3F521; update/insert result = 2 SMS_INVENTORY_DATA_LOADER 07/03/2013 09:33:30 3992 (0x0F98)
Send resync command to local site for machine GUID:D079B78E-DD21-4127-BC80-4A0E8DD3F521. SMS_INVENTORY_DATA_LOADER 07/03/2013 09:33:30 3992 (0x0F98)
STATMSG: ID=2722 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=DGPA-MGT3 SITE=DPA PID=5880 TID=3992 GMTDATE=Thu Mar 07 09:33:30.131 2013 ISTR0="DGC03324" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_INVENTORY_DATA_LOADER 07/03/2013 09:33:30 3992 (0x0F98)
Cannot process MIF XHHFLF8PE.MIF, moving it to E:\Apps\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\yz8wv1z8.MIF SMS_INVENTORY_DATA_LOADER 07/03/2013 09:33:30 3992 (0x0F98)
STATMSG: ID=2703 SEV=W LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=DGPA-MGT3 SITE=DPA PID=5880 TID=3992 GMTDATE=Thu Mar 07 09:33:30.146 2013 ISTR0="XHHFLF8PE.MIF" ISTR1="E:\Apps\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\yz8wv1z8.MIF" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_INVENTORY_DATA_LOADER 07/03/2013 09:33:30 3992 (0x0F98)
Done: Machine=Win7TestPC(GUID:D079B78E-DD21-4127-BC80-4A0E8DD3F521) code=2 (28 stored procs in XHHFLF8PE.MIF) SMS_INVENTORY_DATA_LOADER 07/03/2013 09:33:30 3992 (0x0F98)

So I'm taking this to mean that the info was received but CCM was not able to process it correctly. Unfortunatly the guides I've been checking don't say much about fixing the problem. Other than the inventory reporting the PC is fine with the CCM client and is receiving software updates as well as our own software installs.

[GarthMJ]

There are two things.

 

1. This should fix itself.
2. If this doesn’t fix itself within 2 HW inventory cycles (default 14 days), the only way to fix this is to force a full inventory to occur. Download this tool and force a full inventory http://sourceforge.net/projects/smsclictr/