Advanced Client Cache

Thanks goes out to Dave Berry, who sent in this query.

 

 

SELECT

v_GS_COMPUTER_SYSTEM.Name0 as ‘PC Name’,

v_GS_SMS_ADVANCED_CLIENT_CACH.Location0,

v_GS_SMS_ADVANCED_CLIENT_CACH.Size0

FROM

v_GS_SMS_ADVANCED_CLIENT_CACH, v_GS_COMPUTER_SYSTEM

Where

v_GS_SMS_ADVANCED_CLIENT_CACH.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID

ORDER BY

v_GS_COMPUTER_SYSTEM.Name0

Leave a Reply

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