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