Client Management Suite

 View Only
Expand all | Collapse all

Machines Missing Hardware Inventory

  • 1.  Machines Missing Hardware Inventory

    Posted Apr 08, 2013 04:40 PM

    We have NS 7.1 SP2. Some machines are not showing the Hardware Inventory and support gave us a SQL query which clears Hardware Inventory data from the tables and we ran a Full Inventory on that machine and the fields got populated. Here is the query

     

    set datahash = NULL 
    where ResourceGuid = 'machine guid here' 
    and inventoryclassguid in ( 
    SELECT dc.guid 
    FROM DataClass dc JOIN vItem vi ON vi.[Guid] = dc.[Guid] 
    JOIN vProduct vp ON vp.ProductGuid = vi.ProductGuid 
    where vp.name = 'inventory solution' 
     
    We needed a way to run this on all machines that are missing the Hardware data. Any help is appreciated.


  • 2.  RE: Machines Missing Hardware Inventory

    Posted Apr 15, 2013 07:52 AM

     

    Kindly try this first,

     

    http://www.symantec.com/connect/forums/how-show-report-result-more-50k-row-cms-71

     
     

    To change it system-wide, go to your coresettings.config file and change this line:

    <customSetting key="ReportMaxRowCount" type="local" value="50000" />

    It can be found in C:\ProgramData\Symantec\SMP\Settings.

    If you want to change that limitation for a single report, you will have to right click and choose Export. Then, find the embedded SQL and add this line at the very top:

    SET ROWCOUNT 0 --Unlimited

    If the report is simply running a stored procedure, then you will have to go into Management Studio and modify the stored proc directly and add that same line above.
    --

     



  • 3.  RE: Machines Missing Hardware Inventory

    Posted Apr 15, 2013 10:18 AM

    Thanks Sachin.

    I created a filter of all managed machines and then excluded machines with the hardware inventroy. I took the guids of the remainder and added to excel and replaced the guids in the belwo script. I dumped all the rows from Excel into SQL Management Studio and executed the script which cleared the tables for affected machines and then ran Full Inventory to populate them. All good now.

     

    set datahash = NULL 
    where ResourceGuid = 'machine guid here' 
    and inventoryclassguid in ( 
    SELECT dc.guid 
    FROM DataClass dc JOIN vItem vi ON vi.[Guid] = dc.[Guid] 
    JOIN vProduct vp ON vp.ProductGuid = vi.ProductGuid 
    where vp.name = 'inventory solution' 


  • 4.  RE: Machines Missing Hardware Inventory

    Posted Apr 15, 2013 10:56 AM

    Hi Huseinm,

    In ur environment we have the same problem, Can i have a step by step guide on how to achieve this, It would be very helpful for me to try on.



  • 5.  RE: Machines Missing Hardware Inventory

    Posted Apr 15, 2013 12:05 PM

    Hi Mahbu

    Before we go this path, did you make sure the Inventory Plugin install policy is on? Can you check a few affected machines and verify Altiris Inventory Agent is installed?



  • 6.  RE: Machines Missing Hardware Inventory

    Posted Apr 17, 2013 03:06 AM

    The easiest thing to do would simply be to set the datahash to NULL on all Inventory Classes in the ResourceUpdateSummary table.

    When the server receives inventory from a client, it compares a hash of the data to the hash recorded in the ResourceUpdateSummary table. If the hashes match the server thinks it has recorded the data already and discards the inventory information. By setting the hash in the ResourceUpdateSummary table to NULL, the server will process the inventory information, populate the respective inventory tables and then update the ResourceUpdateSummary table.

    UPDATE ResourceUpdateSummary
    SET datahash = NULL
    WHERE InventoryClassGuid in ( SELECT dc.guid
    FROM DataClass dc JOIN vItem vi ON vi.[Guid] = dc.[Guid]
    JOIN vProduct vp ON vp.ProductGuid = vi.ProductGuid
    where vp.name = 'inventory solution' )

    The load on the server will be higher for a while as more processing will be required for the inventory received from the clients, but you will be certain of having all of the various classes populated and up to date.



  • 7.  RE: Machines Missing Hardware Inventory

    Posted Apr 17, 2013 05:19 AM

    Hi huseinm,

     

    Yes inventory plugin inventory policy is on and good going , added to that all machines where the hardware details missing , In all of them the Inventory agent is installed.



  • 8.  RE: Machines Missing Hardware Inventory

    Posted Aug 22, 2013 12:45 PM

    There is a tech note created with this information as well - TECH199812

    http://www.symantec.com/docs/TECH199812



  • 9.  RE: Machines Missing Hardware Inventory

    Posted Aug 28, 2013 07:21 AM

    I followed TECH199812 and am still having issues.  I also tried using the query

    update ResourceUpdateSummary

    set datahash = NULL

    where ResourceGuid = 'machine guid' and inventoryclassguid in (

    SELECT dc.guid

    FROM DataClass dc JOIN vItem vi ON vi.[Guid] = dc.[Guid]

    JOIN vProduct vp ON vp.ProductGuid = vi.ProductGuid

    where vp.name = 'inventory solution'

    )

    and got 0 rows affected for one of my machines that's having this issue.  Any other suggestions?



  • 10.  RE: Machines Missing Hardware Inventory

    Posted Sep 10, 2013 02:19 PM

    I am having this issue as well, where some machines are missing HW information



  • 11.  RE: Machines Missing Hardware Inventory

    Posted Nov 04, 2013 01:06 PM

    Hardware Inventory is not reporting all, indeed most, of the dataclasses.

    A point fix for 7.1 SP2 MP1 v4 was created in ETrack 3154889. Please contact Support for this point fix. The fix will be included in the 7.1 SP2 MP2 v6 roll-up.

    http://www.symantec.com/docs/TECH206527