로그인
 
홈라이브러리학습다운로드지원커뮤니티포럼
Resources for IT Professionals >
> 
> 
Hardware inventory showing outdated information in resource explorer and SQL reports.

Answered Hardware inventory showing outdated information in resource explorer and SQL reports.

  • 2012년 5월 16일 수요일 오전 8:15
     
     
    로그인하여 투표
    0
     

    Hi,

    For example some software that was installed on PC0001 was removed in January and is still being displayed as installed by our SQL reports, it is also being displayed in SCCM's "Add / Remove Programs on a specific computer" report. despite running full hardware Scans over the last few weeks on this client, I have found that when looking in resource explorer the last hardware Scan was completed on 05/12/2011 at 08:59.

    When looking at the "InventoryAgent.log" on the client PC I have the following status from 15/05/2012 15:30.

    "Inventory: Successfully sent report. Destination:mp:MP_HinvEndpoint, ID: {3F553219-A612-4CE3-B129-0E9DBF702867}, Timeout: 80640 minutes MsgMode: Signed, Not Encrypted"

    According to this log there have been many "successfully Sent Report" status.

    I have only noticed this on a few clients but am concerned that it may end up a bigger problem than expected!

    If anyone has any ideas regarding this it would be much appreciated.

    Regards

    Mike

    • 편집됨 SECMike 2012년 5월 16일 수요일 오전 8:16
    •  
     

모든 응답

  • 2012년 5월 16일 수요일 오전 8:29
     
     
    로그인하여 투표
    0

    Hi,

    Are there any errors in System Status? Any errors in the dataldr.log? Are other hardware inventory values updating for the client? is the last hardware inventory date updated?

    Here is great guide that can assist you in troubleshooting:http://blogs.technet.com/b/sudheesn/archive/2010/05/31/troubleshooting-sccm-part-ii-hardware-inventory.aspx

    Regards,
    Jörgen

    -- My System Center blog ccmexec.com -- Twitter @ccmexec


     
  • 2012년 5월 16일 수요일 오전 8:48
     
     
    로그인하여 투표
    0

    Hi,

    looking in the dataldr.log i get the following,

    Processing Inventory for Machine: PC0001   Version 1.21  Generated: 05/15/2012 09:57:22 SMS_INVENTORY_DATA_LOADER 15/05/2012 09:58 16560 (0x40B0)
    Pragma delete found in inventory group MICROSOFT|SYSTEM_CONSOLE_USAGE|1.0.  Deleting group... SMS_INVENTORY_DATA_LOADER 15/05/2012 09:58 16560 (0x40B0)
    Pragma delete found in inventory group MICROSOFT|SYSTEM_DEVICES|1.0.  Deleting group... SMS_INVENTORY_DATA_LOADER 15/05/2012 09:58 16560 (0x40B0)
    Pragma delete found in inventory group MICROSOFT|CCM_RECENTLY_USED_APPS|1.0.  Deleting group... SMS_INVENTORY_DATA_LOADER 15/05/2012 09:58 16560 (0x40B0)
    Pragma delete found in inventory group MICROSOFT|PNP_DEVICE_DRIVER|1.0.  Deleting group... SMS_INVENTORY_DATA_LOADER 15/05/2012 09:58 16560 (0x40B0)
    Begin transaction: Machine=PC0001(GUID:5855560C-A290-4CCF-9A8C-2D7C441FAB86) SMS_INVENTORY_DATA_LOADER 15/05/2012 09:58 16560 (0x40B0)
    WARNING - Outdated report will be discarded. (sp return code = 8) SMS_INVENTORY_DATA_LOADER 15/05/2012 09:58 16560 (0x40B0)
    Rollback transaction: Machine=PC0001(GUID:5855560C-A290-4CCF-9A8C-2D7C441FAB86) SMS_INVENTORY_DATA_LOADER 15/05/2012 09:58 16560 (0x40B0)
    Cannot process MIF XH11Y6DEX.MIF, moving it to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\791khsso.MIF SMS_INVENTORY_DATA_LOADER 15/05/2012 09:58 16560 (0x40B0)
    STATMSG: ID=2703 SEV=W LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=SECVASUTL05 SITE=SEC PID=18748 TID=16560 GMTDATE=Tue May 15 08:58:32.861 2012 ISTR0="XH11Y6DEX.MIF" ISTR1="C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\791khsso.MIF" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_INVENTORY_DATA_LOADER 15/05/2012 09:58 16560 (0x40B0)
    Done: Machine=PC0001(GUID:5855560C-A290-4CCF-9A8C-2D7C441FAB86) code=4 (203 stored procs in XH11Y6DEX.MIF) SMS_INVENTORY_DATA_LOADER 15/05/2012 09:58 16560 (0x40B0)

    from looking at the log it appears that it "Cannot process MIF" im not sure why this is happening though

    Regards

     
  • 2012년 5월 16일 수요일 오후 1:13
    중재자
     
     
    로그인하여 투표
    0
    To fix it, force a full HW inventory using SCCM Client Center on that PC.

    http://www.enhansoft.com/

     
  • 2012년 5월 16일 수요일 오후 1:47
     
     
    로그인하여 투표
    0

    A full inventory has been run on all of our clients including this machine since our SCCM solution was deployed in 2010.

     
  • 2012년 5월 16일 수요일 오후 2:03
    중재자
     
     
    로그인하여 투표
    0

    If you want to correct the issue above, you need to force a full inventory to occur on that PC only.  This will reset the delta flag and allow new inventory files to not be rejected by CM07.

    http://www.enhansoft.com/

     
  • 2012년 5월 16일 수요일 오후 2:12
     
     
    로그인하여 투표
    0

    This step has also been completed earlier this week through both client centre and "Right Click Tools"

    Could this be caused by a large MIF file? if thats possible is there any way to find out?

    Regards

     
  • 2012년 5월 17일 목요일 오전 4:28
     
     
    로그인하여 투표
    0

    Hi SECMike,

    Since hardware inventory failed in Data loader component, please try to enable SQL logging and check the insertion of data. Also if you have issue with the component SMS_INVENTORY_DATA_LOADER a site reset can help.

    Thanks

     
  • 2012년 5월 17일 목요일 오전 8:10
     
     
    로그인하여 투표
    0
     

    Thanks for the advice Quan,

    I will enable SQL logging this afternoon and see what the results are. I’m pretty certain it’s not inserting any Hardware inventory data from that specific machine into the database, I also on the off chance checked the software inventory status for that Client and that has been working without issues. The last Software inventory was completed yesterday.

    I am wondering if Deleting uninstalling the client and deleting the Client from the SCCM system will treat this PC as a new client and possibly resolve itself like this?

    • 편집됨 SECMike 2012년 5월 17일 목요일 오전 8:11
    •  
     
  • 2012년 5월 17일 목요일 오전 10:31
    중재자
     
     
    로그인하여 투표
    0

    Look at this article, http://www.myitforum.com/articles/8/view.asp?id=11236 , it is written for SMS 2003 but still applies to CM07. Where is the last place that the full inventory mif gets too?

    http://www.enhansoft.com/

     
  • 2012년 5월 17일 목요일 오전 11:00
     
     
    로그인하여 투표
    0

    Thanks Garth,

    So i ran another Full Hardware Inventory and followed its progress through the Logs on the Client and the MP

    What i discovered was that the Client is successfully sending the inventory data to the MP but looking at the the MP_Hinv.log it does not appear to be recieved.

    I did however find that the MP_Hinv.log is showing that a Delta report has been recieved (earlier this morning)




    Log from MP_HINV.log

    Hinv Retry: ******************* Start of Task ********************* MP_HinvEndpoint 17/05/2012 09:54 8224 (0x2020)
    Hinv Sax: loading C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\HinvAttachment7EZBO7ZE.xml MP_HinvEndpoint 17/05/2012 09:54 8224 (0x2020)
    Delta report from client PC0001, action description = Hardware MP_HinvEndpoint 17/05/2012 09:54 8224 (0x2020)
    Hinv Task: Translate report attachment to file "C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\H6YWSX9U.MIF" returned 0 MP_HinvEndpoint 17/05/2012 09:54 8224 (0x2020)
    Hinv Retry: ******************* End of Task ********************* MP_HinvEndpoint 17/05/2012 09:54 8224 (0x2020)

    I had a look in the %Program Files%\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS on the site server but the MIF files isn't in there.





    Log from dataldr.log

    Processing Inventory for Machine: 203508LT   Version 1.1  Generated: 05/17/2012 09:53:19 SMS_INVENTORY_DATA_LOADER 17/05/2012 09:54 5092 (0x13E4)
    Pragma delete found in inventory group MICROSOFT|SYSTEM_CONSOLE_USER|1.0.  Deleting group... SMS_INVENTORY_DATA_LOADER 17/05/2012 09:54 5092 (0x13E4)
    Pragma delete found in inventory group MICROSOFT|SYSTEM_DEVICES|1.0.  Deleting group... SMS_INVENTORY_DATA_LOADER 17/05/2012 09:54 5092 (0x13E4)
    Pragma delete found in inventory group MICROSOFT|PNP_DEVICE_DRIVER|1.0.  Deleting group... SMS_INVENTORY_DATA_LOADER 17/05/2012 09:54 5092 (0x13E4)
    Pragma delete found in inventory group MICROSOFT|SYSTEM_CONSOLE_USAGE|1.0.  Deleting group... SMS_INVENTORY_DATA_LOADER 17/05/2012 09:54 5092 (0x13E4)
    Pragma delete found in inventory group MICROSOFT|PNP_DEVICE_DRIVER|1.0.  Deleting group... SMS_INVENTORY_DATA_LOADER 17/05/2012 09:54 5092 (0x13E4)
    Begin transaction: Machine=203508LT(GUID:5855560C-A290-4CCF-9A8C-2D7C441FAB86) SMS_INVENTORY_DATA_LOADER 17/05/2012 09:54 5092 (0x13E4)
    WARNING - Outdated report will be discarded. (sp return code = 8) SMS_INVENTORY_DATA_LOADER 17/05/2012 09:54 5092 (0x13E4)
    Rollback transaction: Machine=203508LT(GUID:5855560C-A290-4CCF-9A8C-2D7C441FAB86) SMS_INVENTORY_DATA_LOADER 17/05/2012 09:54 5092 (0x13E4)
    Cannot process MIF XH6YWSX9U.MIF, moving it to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\6u5679ja.MIF SMS_INVENTORY_DATA_LOADER 17/05/2012 09:54 5092 (0x13E4)
    STATMSG: ID=2703 SEV=W LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=SECVASUTL05 SITE=SEC PID=18748 TID=5092 GMTDATE=Thu May 17 08:54:30.609 2012 ISTR0="XH6YWSX9U.MIF" ISTR1="C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\6u5679ja.MIF" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_INVENTORY_DATA_LOADER 17/05/2012 09:54 5092 (0x13E4)
    Done: Machine=203508LT(GUID:5855560C-A290-4CCF-9A8C-2D7C441FAB86) code=4 (184 stored procs in XH6YWSX9U.MIF) SMS_INVENTORY_DATA_LOADER 17/05/2012 09:54 5092 (0x13E4)



    • 편집됨 SECMike 2012년 5월 17일 목요일 오전 11:07
    •  
     
  • 2012년 5월 24일 목요일 오전 8:00
     
     
    로그인하여 투표
    0

    After following this a bit more carefully i have discovered the following message from dataldr.log

    Moving MIF file C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\H16X92DA.MIF to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\process\H16X92DA.MIF SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 3800 (0x0ED8)
    Started the machine MIF processing thread, thread ID = 1B7C SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 3800 (0x0ED8)
    Worker thread 7464 starting execution. SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)
    Done with job queueing. SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7036 (0x1B7C)
    Blocking until completion. SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7036 (0x1B7C)
    Thread: 0 is using GUID SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)
    Thread: 7464 will use GUID GUID:D2AC0665-3494-4284-A4E7-7A21AC72A744 SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)
    Processing Inventory for Machine: 908510PC   Version 1.35  Generated: 05/23/2012 11:07:35 SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)
    Pragma delete found in inventory group MICROSOFT|SYSTEM_CONSOLE_USAGE|1.0.  Deleting group... SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)
    Pragma delete found in inventory group MICROSOFT|CCM_RECENTLY_USED_APPS|1.0.  Deleting group... SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)
    Begin transaction: Machine=908510PC(GUID:D2AC0665-3494-4284-A4E7-7A21AC72A744) SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)
    Commit transaction: Machine=908510PC(GUID:D2AC0665-3494-4284-A4E7-7A21AC72A744) SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)
    Done: Machine=908510PC(GUID:D2AC0665-3494-4284-A4E7-7A21AC72A744) code=0 (31 stored procs in XH9JXY9X1.MIF) SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)
    Thread: 7464 is using GUID SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)
    Thread: 7464 will use GUID GUID:5855560C-A290-4CCF-9A8C-2D7C441FAB86 SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)
    ERROR: File size exceeds defined maximum. SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)
    STATMSG: ID=2719 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=SECVASUTL05 SITE=SEC PID=2584 TID=7464 GMTDATE=Wed May 23 11:50:09.625 2012 ISTR0="C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\Process\H16X92DA.MIF" ISTR1="5000000" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)
    Cannot process MIF H16X92DA.MIF, moving it to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\fj9p02eq.MIF SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)
    STATMSG: ID=2703 SEV=W LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=SECVASUTL05 SITE=SEC PID=2584 TID=7464 GMTDATE=Wed May 23 11:50:09.687 2012 ISTR0="H16X92DA.MIF" ISTR1="C:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS\fj9p02eq.MIF" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)
    Done: Machine=(GUID:5855560C-A290-4CCF-9A8C-2D7C441FAB86) code=4 (0 stored procs in H16X92DA.MIF) SMS_INVENTORY_DATA_LOADER 23/05/2012 12:50 7464 (0x1D28)

    If in fact it is over the size limit, how can this be rectified?

    Regards

     
  • 2012년 5월 24일 목요일 오전 10:37
    중재자
     
     답변됨
    로그인하여 투표
    0

    MaxMifSize regkey on the primary site:  http://www.madanmohan.com/2010/11/hardware-inventory-not-being-processed.html

    Note that even if you make the regkey larger than 50mb, ConfigMgr has a hard limit of 50, regardless of what you might set that regkey to be.

    If you think your mif files are larger than 50, then I have 2 suggestions for you:

    1.  If you don't use 3rd party apps which rely on ccm_recentlyusedapps data (you'll know if you do; if you don't know, then ask your vendors) then in your sms_def.mof file, change ccmrecentlyused apps from TRUE to FALSE.  CCMRUA is primary used to create the software metering rules for you, on your behalf, so that you don't have to do so manually.  If you don't use Software Metering, and/or you are ok with the rules you have now, changing this from true to false will SIGNIFICANTLY reduce mif size from clients.

    2.  If for whatever reason you need to keep CCMRUA on, then do this on those specific clients with the 50mb or larger mif sizes:  http://myitforum.com/cs2/blogs/skissinger/archive/2009/07/03/selectively-disable-ccm-recentlyusedapps-per-client.aspx   In general, it's citrix servers or heavily used terminal servers that seem to have 50mb or larger mif file sizes.  (That's who I target, anyway--all our citrix servers and the occasional terminal server).

    Oh, a third suggestion (just because 2012 is released): move to CM12, so that you can use Custom Client Agent Settings, and uncheck RecentlyUsedApps in the Default Client Agent Settings, and create 2 Custom Client Agent Settings:  1 for Citrix servers (and leave RUA unchecked) and 1 for EveryoneElse (and check RUA on for them)

    Standardize. Simplify. Automate.

    • 답변으로 제안됨 Garth JonesMVP, Moderator 2012년 6월 24일 일요일 오후 6:03
    • 답변으로 표시됨 SECMike 2012년 6월 25일 월요일 오전 7:56
    •  
     
  • 2012년 6월 2일 토요일 오후 2:00
     
     
    로그인하여 투표
    0

    Check the last HW inventory date,

    query is

    SELECT     SYS.Netbios_Name0 AS 'NetBIOS Name', SIS.SMS_Installed_Sites0 AS 'SMS Site', WS.LastHWScan, DATEDIFF([day], WS.LastHWScan, GETDATE())

                          AS 'Days Since HWScan', SYS.Operating_System_Name_and0, SYS.Client_Version0

    FROM         dbo.v_GS_WORKSTATION_STATUS WS INNER JOIN

                          dbo.v_R_System SYS ON WS.ResourceID = SYS.ResourceID INNER JOIN

                          dbo.v_RA_System_SMSInstalledSites SIS ON WS.ResourceID = SIS.ResourceID INNER JOIN

                                          dbo.v_FullCollectionMembership FCM ON WS.ResourceID = FCM.ResourceID            

    WHERE     (WS.LastHWScan < DATEADD([day], - 200, GETDATE()))

    and initiate the action tab for HW from client, and also check the version no of client.

    Sharad Singh | My blogs: SharadTech | Twitter: @MrLucknowWale |

     
  • 2012년 6월 4일 월요일 오후 1:16
    중재자
     
     
    로그인하여 투표
    0
    SecMike, is this resolved?

    Standardize. Simplify. Automate.

     
  • 2012년 6월 6일 수요일 오전 8:12
     
     답변됨
    로그인하여 투표
    0

    Sherry,

    at the moment im testing a way to fix this.

    I have as you advised removed some of the information that is collected from software meetering and increased the Max Mif size. I have also removed the client software and removed computers records from the SCCM database for all PC's that have not provided a hardware inventory for 30+ days. I have tested this with a couple of PC's and it was successfull so am trying it on all that have not inventoried

    I will close in a couple of days when i am sure it has resolved the issue.

    Regards

    • 답변으로 제안됨 Garth JonesMVP, Moderator 2012년 6월 24일 일요일 오후 6:03
    • 답변으로 표시됨 SECMike 2012년 6월 25일 월요일 오전 7:56
    •