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