Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Machines Missing Hardware Inventory

Created: 08 Apr 2013 | 10 comments

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.
Operating Systems:

Comments 10 CommentsJump to latest comment

Sachin Sawant's picture

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.
--

huseinm's picture

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' 
mahbu_basha2003@yahoo.com's picture

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.

huseinm's picture

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?

mahbu_basha2003@yahoo.com's picture

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.

The Gaffer's picture

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.

Christina_'s picture

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

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

etk1131's picture

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?

JeanWilson's picture

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

Christina_'s picture

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