It seems like your browser didn't download the required fonts. Please revise your security settings and try again.

How to Remove a Single PST File from the Database

  • Last updated on

This article refers to the Barracuda PST Enterprise version 2.2.

In PST Enterprise version 2.2, you cannot remove knowledge of remove knowledge of discovered or processed PST files from the web site / administration console. Use the steps in this article to remove a PST file entry from the PST Enterprise database using standard SQL tools. Note that the PST file is not deleted and no data in the PST file is modified. Instead PST Enterprise no longer recognizes the file. The PST will be discovered and listed again the next time the client toool runs on the workstation.

  1. Log in to SQL Management Studio as the PSTEnterpriseAdmin user.
  2. Execute the following SQL statement, replacing machinename, pstfilepath, and pst_title with the values of the PST you wish to remove:

    DECLARE @pstid bigint;
    SET @pstid =
    (SELECT id
    FROM [PSTEnterprise].dbo.PSTFile
    WHERE machine = 'machinename'
    AND filepath = 'pstfilepath.pst'
    AND title = 'pst_title');

     

    DELETE
    FROM [PSTEnterprise].dbo.[PSTPolicyHistory]
    WHERE PST_id = @pstid;


    DELETE
    FROM [PSTEnterprise].dbo.PSTFile
    WHERE ID = @pstid;

     
  3. Refresh the website administration console to verify the PST file has been removed.