on 12-07-2009 01:07 PM
Guesstimations aside, I wanted to know what kind of data we would be able to move into our FSA Vault so wrote a small Powershell script to do this.
The script connects to a named NTFS folder and reads the first level of subfolders beneath it one by one, where each subfolder is the name of a Windows file server that I want to scan
The script then connects to the server, queries (via WMI) the shares on that server - excluding the Excludes array for Hidden/Admin - then runs a get-childitem using our 6 month not modified policy and specified file extensions - this is in essense a 'dir' on steroids, and adds counters for each type of file found
The script then writes a text file, named per found share, into the server folder detailing the Share name, it's Physical path, the Amount of In scope files found, the Total size of the Share and the Post Archive size of the Share
This will enable an FSA implementor to forward plan how much data on each server/share is going to go into the archive
Customisation notes:
The NTFS folder is under $strSearchPath
The Excludes are written in the $arrExcludes
The 6 month not modified is selected here: " where {$_.lastwritetime -lt (get-date).adddays(-180)} | "
The File extensions are selected here: -include *.jpg, *.avi, *.tif, *.csv, *.bmp, *.mpg, *.mp3, *.wmv,*.psd, *.*.mov, *.tiff,`
*.wav, *.mp4, *.mp2, *.gif, *.zip, *.ppt, *.msg, *.nrg, *.cdr, *.iso, *.vsd,`
*.pps, *.gif, *.pdf, *.doc, *.rtf, *.docx, *.xls , *.bak , *.xlsx , *.old ,`
*.tar , *.xlsb, *.xlsm |