List PSTs

SELECT
CS.Name0,
CS.UserName0,
SF.FileName,
SF.FileSize,
SF.FileModifiedDate,
SF.FilePath
FROM
dbo.v_GS_COMPUTER_SYSTEM CS,
dbo.v_GS_SoftwareFile SF,
dbo.v_GS_SYSTEM SYS
WHERE
SYS.ResourceID = CS.ResourceID
AND SF.ResourceID = CS.ResourceID
AND SYS.SystemRole0=’Workstation’
AND SF.FileName Like ‘%.pst’
Order By
CS.Name0,
SF.FileName

Leave a Reply

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