Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

reports for the machines

Created: 06 Sep 2012 | 4 comments

Can I get a reports for the machines with following details in NS 7.1 Sp1

  • Name of the Machine
  • Latest Delta Software inventory date
  • Latest Delta Hardware inventory date
  • Latest Full inventory date

Thanks,

Pravash

Comments 4 CommentsJump to latest comment

odami's picture

You can't really get a report like that beause there is no "Full Inventory" Flag in the console. "Full" inventory is just a scan for Hardware/Software/User information. So realistically you want a report that looks like:

Name of the Machine - Basic Inventory - Hardware - Software - User Inventory.

And that report looks like this: 

With BasicInventory (ModifiedDate, Guid) AS

(

Select CAST (MAX (rus.ModifiedDate) AS DATETIME) [Inventory Collection Time]

,rus.ResourceGuid

From ResourceUpdateSummary rus

WHERE rus.InventoryClassGuid = 'C74002B6-C7B9-47BB-A5D6-3031AF73BB8D'

GROUP BY rus.ResourceGuid

)

,

HardwareInventory (ModifiedDate, Guid) AS

(

Select CAST (MAX (rus.ModifiedDate) AS DATETIME) [Inventory Collection Time]

,rus.ResourceGuid

From ResourceUpdateSummary rus

WHERE rus.InventoryClassGuid = '46E11E1E-BAD3-437F-8140-3E7173C982ED'

GROUP BY rus.ResourceGuid

)

,

SoftwareInventory(ModifiedDate, Guid) AS

(

Select CAST (MAX (rus.ModifiedDate) AS DATETIME) [Inventory Collection Time]

,rus.ResourceGuid

From ResourceUpdateSummary rus

WHERE rus.InventoryClassGuid = '1960C684-9BD6-450C-95F0-E5BF8AA45A77' OR

 rus.InventoryClassGuid = '324AAA03-D5D2-4853-98E8-5483E4F4EABC' OR

 rus.InventoryClassGuid = '88077BE9-9F64-41AD-98DF-C7AC7E0FA8F3'

GROUP BY rus.ResourceGuid

)

,UserInventory(ModifiedDate, Guid) AS

(

Select CAST (MAX (rus.ModifiedDate) AS DATETIME) [Inventory Collection Time]

,rus.ResourceGuid

From ResourceUpdateSummary rus

WHERE rus.InventoryClassGuid = '58F06E50-1CA0-4720-A847-074428B35C17'

GROUP BY rus.ResourceGuid

)

Select vc.Name, bi.ModifiedDate AS 'Basic Inventory'

,hw.ModifiedDate AS 'Hardware Inventory'

,sw.ModifiedDate AS 'Software Inventory'

,ui.ModifiedDate AS 'User Inventory'

From vComputer vc

JOIN BasicInventory bi

ON vc.Guid = bi.Guid

JOIN HardwareInventory hw

ON vc.Guid = hw.Guid

JOIN SoftwareInventory sw

ON vc.Guid = sw.Guid

JOIN UserInventory ui

ON vc.Guid = ui.Guid

ORDER BY 1

 
Cheers
odami's picture

If this report worked be sure to mark it as a solution.

Falquian's picture

odami:

Thumbs up :)

Thanks a lot for this report.

Kind regards:

     Falquian

If this post is useful to you, remember to mark it as a solution ;)

Sachin Sawant's picture

Odami Thanx for qury