OWilliams
asked on
SQL Query for SMS report
Does anyone have a SQL Query that I can use to pull the size of PST files in different file locations for a custom SMS report?
ASKER
Would you know of any third party utilities that can located PST files and the size of them?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm assuming you wish to associate it to the user? Although you can capture all PSTs on computers/servers it's difficult to associate it to a specific user, especially since the default names are usually outlook.pst. My thoughts are that you capture it within the users session, then append the user information with the psts found, in theory the pst files captured will depend on the users privileges, although it wouldn't help if the user was a Local Administrator. Unless all the PSTs reside within the users profile in which case stirrins' suggestion above should work.
To find the path of Users PSTs' within registry is rather difficult as the paths are written in hex making it difficult for scripts to decipher.
Cheers
To find the path of Users PSTs' within registry is rather difficult as the paths are written in hex making it difficult for scripts to decipher.
Cheers
Unfortunately PST files aren't part of the standard applications that SMS reports on, it only does .exe, .com etc.. The only way to have it added is to create a custom .mif file deploy it to all your systems and than wait for the information to be captured. However this would be quite difficult as from your post it seems that the PST files are in different locations. The only other way I could think of as a quick fix was to create a package that runs for all staff which then updated a csv file or spreadsheet, with the PST information.
Cheers