Skip to main content

Powershell Code Snippet to list all sub folders and its modified date

Code snippet below is able to get the folder names and its modified date and write the output to a text file.

I used this piece of code to get hundreds of subfolders in a shared folder and Powershell did a really nice job, the script just runs in a few seconds and able to get the list of the folder and it’s modified date.

The reason I made this piece code is for folder archiving purposes.

To check one by one a hundreds of folders is not just practical. Unless you really have a nice reason to do it.

To check which folder is being currently used or which folder has never been accessed for a couple of years.

This piece of Powershell code snippet below can do the job.

To run Powershell script, most of the sites will recommend to get a self-signed certificate and modify Powershell settings to trust self-signed cert.

I did run this piece of code without generating a self –signed certificate.

Powershell has a GUI interface in which you can run the code, without any hassle of configuring the Powershell settings or generating a certificate.

If you want to quickly run a Powershell code and get the results instantly or to check for any errors in your code, ISE will come to the rescue.

Powershell comes with Powershell ISE (ISE – Integrated Scripting Environment).

If your using Windows 2012 or Windows 8, just go to Start Menu and type “ISE”. Results will pop out a PowerShell ISE, click on it to runt ISE Powershell.

Or if you’re using Windows 7 type ISE on the search box.

On ISE Powershell window there are two panes, on the top pane is where you put or paste your code.

The bottom pane is the result or the output pane which will give the status of the code, if there’s an error it will show immediately.

Select and copy the code below, and paste it to the top pane. On the toolbar you will see like a play button. Click the “Play” button to run the code snippet below.

Before running the code, of course you need to change this lines to your desired location:

Source folder path: $items :

Get-ChildItem -Path "\\192.168.1.1\Proposals" or

$items = Get-ChildItem -Path "D:\Proposals"

Output File Path Result:

 $item.Name + "`t" + $item.LastWriteTime | Out-File d:\myfolderlist.txt -Append

The output will be something like this:

  Folder Name {tab line} Modified Date and Time

Once you have the result, you can open it on an excel file for further processing or you can print it out and decide which folder to archive or which folder to delete.

======== START OF CODE SNIPPET========
#  comment for Powershell not executed
# initialize the items variable with the
# contents of a directory
#UNC or Network Path
$items = Get-ChildItem -Path "\\192.168.1.1\Proposals"
#Path on the drive itself
#$items = Get-ChildItem -Path "D:\Proposals"

#you can use UNC path or you can use c:\sharedfolder\subfolders
#any location on your hard drive you want to get the list of folders and sub folders
# enumerate the items array
foreach ($item in $items)
{
# if the item is a directory, then process it and save it to text file
if ($item.Attributes -eq "Directory") {
$item.Name + "`t" + $item.LastWriteTime | Out-File d:\myfolderlist.txt -Append
}
}
======== END OF CODE SNIPPET========

==============================

=========================

Comments

Popular posts from this blog

Notepad++ convert multiple lines to a single line and vice versa

Notepad++ is an awesome text editing tool, it can accept regex to process the text data. If the data is in a “.csv” format or comma separated values which is basically just a text file that can either be opened using a text editor, excel or even word. Notepad++ can process the contents of the file using regex. Example if the data has multiple rows or lines, and what is needed is to convert the whole lines of data into a single line. Notepad++ can easily do it using regex. However, if the data is on a single line and it needs to be converted into multiple lines or rows then regex can also be used for this case. Here’s an example on how to convert multiple rows or lines into a single line. Example data: Multiple rows, just a sample data. Press Ctrl+H, and  on "Find what" type: [\r\n]+ and on "Replace with" type with: , (white space) --white space is needed if need to have a space in between the data. See image below, "Regular Expression" must be se

WMIC get computer name

WMIC get computer model, manufacturer, computer name and  username. WMIC is a command-line tool and that can generate information about computer model, its manufacturer, its username and other informations depending on the parameters provided. Why would you need a command line tool if there’s a GUI to check? If you have 20 or 100 computers, or even more. It’s quite a big task just checking the GUI to check the computer model and username. If you have remote computers, you need to delegate someone in the remote office or location to check. Or you can just write a batch file or script to automate the task. Here’s the code below on how get computer model, manufacturer and the username. Open an elevated command prompt and type:     wmic computersystem get "Model","Manufacturer", "Name", "UserName" Just copy and paste the code above, the word “computersystem” does not need to be change to a computer name. A

How to check office version from command line

The are quite a few ways to check office version it can be done via registry, PowerShell or VBScript and of course, good old command line can also do it. Checking Windows office version whether it is Office 2010, Office, 2013, Office 2016 or other version is quite important to check compatibility of documents; or just a part of software inventory. For PowerShell this simple snippet can check the office version: $ol = New-Object -ComObject Excel.Application $ol . Version The command line option will tell you where’s the path located; the result will also tell whether office is 32-bit, 64-bit and of course the version of the office as well. Here’s the command that will check the office version and which program directory the file is located which will tell whether it’s 32-bit or 64-bit. Command to search for Excel.exe: DIR C:\ /s excel.exe | find   /i "Directory of"  Above command assumes that program files is on  C: drive. Sample Outpu