Video Screencast Help

reports

Created: 16 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."