[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 822
  • Last Modified:

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?
  • 2
1 Solution
Hi OWilliams

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.

OWilliamsAuthor Commented:
Would you know of any third party utilities that can located PST files and the size of them?

By default, Only the .exe files are queried on the local computer. This includes all the fixed drives on the computer. So I guess locations wouldn't be a problem as long as the computer is a SMS client.

You can enable the Software Inventory for PST's by
 Site Database->Site Hierarchy-><Site Name>->Site Settings->Client Agents
Right click on Software  Inventory Client Agent->Properties
On the Inventory collection tab, Add the .pst file as a new entry below the .exe entry.
Once the client computer reports back the inventory data according to the schedule, You should be able to see all the inventoried PST files.

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.



Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now