No hardware and software inventory for some clients

[Naz Jiwani]

I have one primary site and several secondary sites at remote offices. On a couple of the remote sites, I am not getting hardware or software inventory from any clients except the site server itself. There is nothing in the resource explorer for any of the clients. The client on the site server was installed manually but pushed out from the console InventoryAgent.logto PCs and laptops for the site.

 

I have attached the inventoryagent log for one of the clients. Could someone help with this?

 

Thanks

Naz

[Peter van der Woude]

How did you configure your inventories?

[Naz Jiwani]

How did you configure your inventories?

 

Thanks for the quick response Peter.

Schedule is set to run every day for both hardware and software inventory client agents. The max custom MIF file size is set to 250KB. Please let me know if you require any other information.

[Eswar Koneti]

Thanks for the quick response Peter.

Schedule is set to run every day for both hardware and software inventory client agents. The max custom MIF file size is set to 250KB. Please let me know if you require any other information.

 

 

From the log you posted,client sent its inventory report to Site server.You will have to check site server log files if there is any problem in processing the inventory info to database.

 

 

Please check this blog on troubleshooting the inventory sent by clients ? http://blogs.technet.com/b/sudheesn/archive/2010/05/31/troubleshooting-sccm-part-ii-hardware-inventory.aspx

 

 

can you check if you see any issues for inventory_data_loader component processing clien info?

[Naz Jiwani]

From the log you posted,client sent its inventory report to Site server.You will have to check site server log files if there is any problem in processing the inventory info to database.

 

 

Please check this blog on troubleshooting the inventory sent by clients ? http://blogs.technet.com/b/sudheesn/archive/2010/05/31/troubleshooting-sccm-part-ii-hardware-inventory.aspx

 

 

can you check if you see any issues for inventory_data_loader component processing clien info?

 

Here's a relevant section from dataldr.log on the primary site server for a 'problem' PC:

 

Thread: 11812 will use GUID GUID:E3ACA55B-8839-42A4-9C3C-6E5173C7015F SMS_INVENTORY_DATA_LOADER 31/03/2011 11:21:25 11812 (0x2E24)

Processing Inventory for Machine: PC53603 Version 1.94 Generated: 02/03/2011 10:25:55 SMS_INVENTORY_DATA_LOADER 31/03/2011 11:21:25 11812 (0x2E24)

Pragma delete found in inventory group MICROSOFT|SYSTEM_CONSOLE_USAGE|1.0. Deleting group... SMS_INVENTORY_DATA_LOADER 31/03/2011 11:21:25 11812 (0x2E24)

Begin transaction: Machine=PC53603(GUID:E3ACA55B-8839-42A4-9C3C-6E5173C7015F) SMS_INVENTORY_DATA_LOADER 31/03/2011 11:21:25 11812 (0x2E24)

ERROR - attempt to update non-existent row. Invalid command: exec pWorkstationStatus_DATA 1,8578,'03/31/2011 11:21:25',1,'2/3/2011 10:25','4294967390',2057,0 SMS_INVENTORY_DATA_LOADER 31/03/2011 11:21:25 11812 (0x2E24)

Rollback transaction: Machine=PC53603(GUID:E3ACA55B-8839-42A4-9C3C-6E5173C7015F) SMS_INVENTORY_DATA_LOADER 31/03/2011 11:21:25 11812 (0x2E24)

Remote client hardware inventory resync generated for client GUID:E3ACA55B-8839-42A4-9C3C-6E5173C7015F; update/insert result = 2 SMS_INVENTORY_DATA_LOADER 31/03/2011 11:21:25 11812 (0x2E24)

Send resync command to local site for machine GUID:E3ACA55B-8839-42A4-9C3C-6E5173C7015F. SMS_INVENTORY_DATA_LOADER 31/03/2011 11:21:25 11812 (0x2E24)

STATMSG: ID=2722 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=FREYA SITE=S01 PID=17364 TID=11812 GMTDATE=Thu Mar 31 10:21:25.738 2011 ISTR0="PC53603" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_INVENTORY_DATA_LOADER 31/03/2011 11:21:25 11812 (0x2E24)

Cannot process MIF Xdkn3165a.MIF, moving it to C:\Program Files (x86)\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\c8b01k37.MIF SMS_INVENTORY_DATA_LOADER 31/03/2011 11:21:25 11812 (0x2E24)

STATMSG: ID=2703 SEV=W LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=FREYA SITE=S01 PID=17364 TID=11812 GMTDATE=Thu Mar 31 10:21:25.738 2011 ISTR0="Xdkn3165a.MIF" ISTR1="C:\Program Files (x86)\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\c8b01k37.MIF" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_INVENTORY_DATA_LOADER 31/03/2011 11:21:25 11812 (0x2E24)

Done: Machine=PC53603(GUID:E3ACA55B-8839-42A4-9C3C-6E5173C7015F) code=2 (18 stored procs in Xdkn3165a.MIF) SMS_INVENTORY_DATA_LOADER 31/03/2011 11:21:25 11812 (0x2E24)

 

Does this indicate some problem? Sorry I have very little experience of SCCM.

[Eswar Koneti]

Cannot process MIF Xdkn3165a.MIF, moving it to C:\Program Files (x86)\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\c8b01k37.MIF

 

Could you please open the file with notepad and see if the computer is what you are looking issue with.

 

If so,try to run the Discovery data record cycle agent on the client(which has issues) and see if that resolves it.

 

for inventory data loader issues (failed to process the bad mif files) and various reasons why this occurs ,take a look at this blog http://eskonr.com/2010/01/inventory-data-loader-issues-in-sccm-inboxes/

[Naz Jiwani]

 

Could you please open the file with notepad and see if the computer is what you are looking issue with.

 

If so,try to run the Discovery data record cycle agent on the client(which has issues) and see if that resolves it.

 

for inventory data loader issues (failed to process the bad mif files) and various reasons why this occurs ,take a look at this blog http://eskonr.com/2010/01/inventory-data-loader-issues-in-sccm-inboxes/

 

Hello Eswar

 

I am still trying to resolve this issue!

 

I have just dug out an old email from previous sysadmin who implied that the issue is to do with a mismatch in serial numbers between the site control file and the records in the SiteControl table within SQL. There were also a lot of delta records created in the SiteControl table for the serial number when there should only be 1 master and 1 delta.

 

Unfortunately the sysadmin did not document the fix! How can I clean up the SiteControl table so that the hardware and software inventory is added to the database.

 

Naz

[Naz Jiwani]

Hello Eswar

 

I am still trying to resolve this issue!

 

I have just dug out an old email from previous sysadmin who implied that the issue is to do with a mismatch in serial numbers between the site control file and the records in the SiteControl table within SQL. There were also a lot of delta records created in the SiteControl table for the serial number when there should only be 1 master and 1 delta.

 

Unfortunately the sysadmin did not document the fix! How can I clean up the SiteControl table so that the hardware and software inventory is added to the database.

 

Naz

 

An update:

I deleted the managements points on two of the secondary sites where the clients hardware and software inventories were not appearing in the database, now it's working. I am now seeing the inventory being collected. I am not sure why it's working now and whether it's ok to add the management points back. Any advice would be appreciated.