Question

Need help with writing a Windows PowerShell script that will perform the following functions:

Search your computer for files ending with a .doc, .docx, .xls, or .xlsx file extension.

Output the filenames and sizes (in groups by file extension) to a text file named “File_Summary.txt”. The output should also conclude with a total of the number of files and total file size for each file extension.

Include comments in the script code to document the functionality of the script.

I am new to this so any help on writing the code or where to begin will be helpful.

Answer 1

Answer:
# PowerShell script to list the files with .doc,.docx,.xls extension and write output to text file
#assign your computer path to path variable
$path = C:\windows\system32
$Dir = get-childitem path -recurse
$searchPaths = Get-ChildItem -Path path -Directory
#List variable search for the given extension where * means consider all the files with .doc,... extensions
#Group-Object -Property Directory count the number of files found for each extension
$List = Get-ChildItem -Path $searchPaths -recurse -filter *.doc,*.docx,*,*.xls,*.xlsx | Group-Object -Property Directory
#ouput is written to the File_Summary.txt file
#please change below 'C:\Output\File_Summary.txt' output file path if required
$List |ft fullname |out-file C:\Output\File_Summary.txt

#resources to learn PowerShell Scripting
#good place - https://devblogs.microsoft.com/scripting/weekend-scripter-the-best-ways-to-learn-powershell/
#https://docs.microsoft.com/en-us/powershell/
#http://powershelltutorial.net/
#Best Of Luck