Video Screencast Help

In the Resource Manager, Hardware Summary, the "Last Full Inventory Received" and "Last Delta Hardware Inventory Received" do not display the date of the last Full or Delta HW Inventories.

Created: 24 Apr 2013
Language Translations
David_Spoons's picture
+1 1 Vote
Login to vote

Description of issue:

In the Symantec Management Console open a client computer's Resource Manager. Select "Summaries > Hardware Summary". Under "Agent" the "Last Full Inventory Received" and "Last Delta Hardware Inventory Received" have no date. They only display two dashes, "--". Or the date displayed may not correctly reflect the latest run of either a Full or Delta HW Inventory.

The customer runs both Full and Delta HW Gather Inventory tasks and Full and Delta HW Inventory policies.

This has been seen on 7.1 SP2 and 7.1 SP2 MP1. It may be applicable to other versions as well.

Cause:

The SQL query used to populate those dates calls for the Guid of the built in "Collect Full Inventory" and "Collect Delta Hardware Inventory" policies.

The customer was using clones of those two policies as well as the Gather Inventory tasks. Since the Guids of the customer's cloned policies and tasks do not match what the SQL query is looking for, the "Last Full Inventory Received" and "Last Delta Hardware Inventory Received" dates will only show two dashes or the last time the built in policies successfully ran.

This is an extract from the SQL query showing what it is looking for:

LEFT JOIN (SELECT MAX (et.EndTime) [End Time], _ResourceGuid,
ParentTaskInstanceGuid FROM Evt_Task_Instances et
      JOIN ItemVersions iv
            ON iv.VersionGuid = et.TaskVersionGuid
            AND iv.ItemGuid = 'D05A9560-426D-4AB4-B9A1-CD8C9B7C0B8F' 
      GROUP BY _ResourceGuid, ParentTaskInstanceGuid)d
ON d._ResourceGuid = vi.Guid  
LEFT JOIN (SELECT MAX (et1.EndTime) [End Time], _ResourceGuid,
ParentTaskInstanceGuid FROM Evt_Task_Instances et1 
      JOIN ItemVersions iv1
            ON iv1.VersionGuid = et1.TaskVersionGuid
            AND iv1.ItemGuid = 'E99C532D-7C34-4C01-B799-88406FCDDD22'
      GROUP BY _ResourceGuid, ParentTaskInstanceGuid)e
 

The Guid 'D05A9560-426D-4AB4-B9A1-CD8C9B7C0B8F' is the built in "Collect Full Inventory" policy Guid.
The Guid 'E99C532D-7C34-4C01-B799-88406FCDDD22' is the built in "Collect Delta Hardware Inventory" policy Guid.
The [End Time] is the last date and time the policy successfully ran. The full query then uses the aliases "Last Full Inventory Received" and "Last Delta Hardware Inventory Received" for the two end times.

If that date is required then you will have to run the built in "Collect Full Inventory" and "Collect Delta Hardware Inventory" policies. SQL gurus may be able to modify the query but such a modification is neither endorsed or supported by Symantec.