Inventory PST files based on computers in the Organizational Unit (OU) in Active Directory

Question

Inventory PST files based on computers in the Organizational Unit (OU) in Active Directory

APTOS 221

Hello, I'm looking for a script/tool to collect information on all PST files located in user computers. What is the best and most efficient way to accomplish this?I have an inventory with this informations :
ComputerName,UserName,EmailAddress,Pst File name,Pst File Location,Pst File Size

Regards

Catherine Kyalo 2,090 Microsoft Employee

You could leverage PowerShell scripting. However, this task requires administrative rights on the target machines and the ability to reach those machines over the network. There would be factors to consider such as: size of the PST files.

I found a sample script that you can review

$computers = Get-ADComputer -Filter * -SearchBase "OU=YourOU,DC=domain,DC=com"

foreach($computer in $computers){
    $computername = $computer.Name
    if(Test-Connection -ComputerName $computername -Count 1 -Quiet){
        $pst = Get-ChildItem -Path \\$computername\c$\ -Include *.pst -Recurse -ErrorAction SilentlyContinue | Select-Object -Property FullName
        foreach($file in $pst){
            $properties = @{
                ComputerName = $computername
                PstFilePath = $file.FullName
            }
            New-Object -TypeName PSCustomObject -Property $properties | Export-Csv -Path C:\PSTInventory.csv -NoTypeInformation -Append
        }
    }
}

Your answer

Catherine Kyalo 2,090 Reputation points Microsoft Employee

2024-03-15T11:05:34.9233333+00:00

You could leverage PowerShell scripting. However, this task requires administrative rights on the target machines and the ability to reach those machines over the network. There would be factors to consider such as: size of the PST files.

I found a sample script that you can review

$computers = Get-ADComputer -Filter * -SearchBase "OU=YourOU,DC=domain,DC=com" foreach($computer in $computers){ $computername = $computer.Name if(Test-Connection -ComputerName $computername -Count 1 -Quiet){ $pst = Get-ChildItem -Path \\$computername\c$\ -Include *.pst -Recurse -ErrorAction SilentlyContinue | Select-Object -Property FullName foreach($file in $pst){ $properties = @{ ComputerName = $computername PstFilePath = $file.FullName } New-Object -TypeName PSCustomObject -Property $properties | Export-Csv -Path C:\PSTInventory.csv -NoTypeInformation -Append } } }

Share via

Inventory PST files based on computers in the Organizational Unit (OU) in Active Directory

Your answer