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

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