When was the last File collection done?

ELECT
v_GS_COMPUTER_SYSTEM.Name0,
SoftwareInventoryStatus.LastCollFileUpdateDate
FROM
SoftwareInventoryStatus SoftwareInventoryStatus,
v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM
WHERE
v_GS_COMPUTER_SYSTEM.ResourceID = SoftwareInventoryStatus.ClientId

Leave a Reply

Your email address will not be published. Required fields are marked *