SCCM – Report on PST File Locations

microsoft black logo

Last updated on April 17th, 2023 at 12:36 am

Read Time:2 Minute, 25 Second

Users love to keep their email for as long as they possibly can, but when IT Admins start telling them to archive their email because their mailbox is too big, sometimes things get worse and PST files end up being created all over your corporate Filestores. Even worse than that, users will create their PST files and keep them locally on a computer in some obscure location (normally AppData…!) and when it comes to rebuild time, they do not tell you about these PST files and it’s all your fault that you have exterminated 15 years of emails about cakes being in the kitchen!

Start the Fightback

Well, first things first, we need to know where these PST files are, be it on local machines or on network Filestores. So using Configuration Manager, we will set our Client settings to inventory PST files when the Software Inventory is run.

To do this, go into your Client Settings within your Configuration Manager Console and click on the Software Inventory option:

SCCM Software Inventory
SCCM Software Inventory

Once in the Software Inventory section, click on the Set Types button:

SCCM Software Inventory Set Types
SCCM Software Inventory Set Types

When the pop-up appears, click on the yellow button and add *.pst and click the OK button, this will now appear in your files of files to inventory:

SCCM - Report on PST File Locations 1
SCCM File Collection

Now what will happen is that your Configuration Manager Clients on the end users machines and servers (if you have the client on servers…) will inventory all the PST files on the machine and then report back to your Configuration Manager server and then inject the data into your database.

SQL Query

Now that you have started the harvesting process of collecting the PST information, you will now want to report on it.

There are many different ways of producing this information using SSRS, PowerBI or just a basic SQL query. For the purposes of this guide, we are going to show you where you gather this information from and you can then edit the query to add whatever extra information you want, like computer name, username etc.

The below query will give you a basic SQL output of the PST files that it has in it’s database:

SELECT
 SF.Filename as [Filename],
 SF.FileSize as [File Size],
 SF.FilePath as [File Path]
FROM v_GS_SoftwareFile SF
 WHERE SF.FileName LIKE '%pst'

You can also use this same process for reporting on torrent files, MP3 files, MP4 files – the list goes on depending on how much you want to report on this data.

More Queries

Our full range of SQL and WQL Collection queries are available here.

Feedback

If you have any questions or feedback on this guide, please feel free to leave us a message below using our comments section. We aim to get back to you as soon as we can.

Click to rate this post!
[Total: 0 Average: 0]

Free Subscription

If you want to be notified when we post more quality guides like this one, sign up to our free subscription service and you will receive an email when a new post is live.

Join 441 other subscribers.

No need to worry, we will not be filling your inbox with spam and you can unsubscribe anytime you like.


12 thoughts on “SCCM – Report on PST File Locations

  1. Any help on adding the computer name onto this report so one can see where the PST file is located?

Leave us a message...

This site uses Akismet to reduce spam. Learn how your comment data is processed.