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

reports

Created: 15 Jul 2013 • Updated: 17 Jul 2013 | 8 comments
This issue has been solved. See solution.

Hi Support,

 

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

Comments 8 CommentsJump to latest comment

Sachin Sawant's picture

Hi swati,

That means you wont, how many time which inventory run on machine...

swatikale's picture

Hi Sachin,

 

I need a report in mention above teb with date.

Sachin Sawant's picture

check this query,

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

SOLUTION
anthonypascucci's picture

Pretty handy report

Thx

swatikale's picture

Hi Sachin Sawant,

 

I will check and revert back to you... thanks 

Sachin Sawant's picture

Hi Swati kale thanx for a mark as solution.

Ambesh_444's picture

Nice and helpful query Sachin.

Thumbs up...!!!!!!!!!!!!!!!! 

these query will help many eng...

 

Thank& Regards,

Ambesh

"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."