Powershell Script find pst files on network

spiceuser-iy7ut · 2019-03-06T15:53:43.000Z

Good morning,

I’m in need of searching our network for all pst files with the location, size, last modified and system name. I came across the following script, but I am having issues getting it to work correctly. It doesn’t gather information for all systems in the text file, it will run but only export information for the last system in the text file. Any help would be greatly appreciated!

$Computers = Get-Content -Path “C:\Comps.txt”
Foreach ($Computer in $Computers)
{
$PstFiles = Get-Wmiobject -namespace “root\CIMV2” -computername $Computer -Query “Select * from CIM_DataFile
Where Extension = ‘pst’”
$output = @()
foreach ($file in $PstFiles)
{
if($File.FileName)
{
$pstinfo = “” | select Computer, Path, FileSize, LastModified, LastAccessed
$filepath = $file.description
$query = “ASSOCIATORS OF {Win32_LogicalFileSecuritySetting=' $filepath
'} WHERE AssocClass=Win32_LogicalFileOwner ResultRole=Owner”

#$Owner = @(Get-Wmiobject -namespace “root\CIMV2” -computername $Computer -Query $query)
#$Owner = $Owner[0]
$pstinfo.Computer = $Computer
$pstinfo.Path = $filepath
$pstinfo.FileSize = $file.FileSize/1GB
#$pstinfo.Owner = “$($Owner.ReferencedDomainName)$($Owner.AccountName)”
$pstinfo.LastModified = [System.Management.ManagementDateTimeConverter]::ToDateTime($($file.LastModified))
$pstinfo.LastAccessed = [System.Management.ManagementDateTimeConverter]::ToDateTime($($file.LastAccessed))
$output += $pstinfo
}
}
}
$output | Export-Csv c:\pstdetails.csv -NoClobber -NoTypeInformation

Thanks!

Neally · 2019-03-06T15:55:13.000Z

Welcome

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

spiceuser-iy7ut · 2019-03-06T16:03:19.000Z

Updated post. Thank you and sorry about that.

jitensh · 2019-03-06T17:48:26.000Z

better use get-childitem on c:\users\documents and app data folder that might be super slow

ejreynolds · 2019-03-06T18:07:48.000Z

Run PowerShell with a domain admin account (or an account that has access to each computer you’re searching.) Length is Size measured in bytes.

$Computers = Get-Content -Path "C:\Comps.txt"
Foreach ($Computer in $Computers)
{
Get-ChildItem -Path '\\${Computer}\C$' -Recurse -Filter *.pst | select Name,Directory,LastWriteTime,Length | Export-Csv C:\PSTs.csv -NoTypeInformation -Append
}

craigduff · 2019-03-06T23:13:10.000Z

Having this line

$output = @()

Inside the foreach loop causes it to reset for each computer. It needs moved above the foreach.