I needed to send a list of open files from our file server to the helpdesk so they could contact the users that were still using the old systems. I wanted to give them something other than a screen shot so I went digging for a powershell script. I found this which uses openfile.exe but within powershell pipes the output to a nice grid view.
openfiles /Query /S 2K12R2 /FO CSV /V | ConvertFrom-Csv | Out-GridView
Source: Get open files on a remote server – It For DummiesIt For Dummies
I took it and tweaked it to a file so the helpdesk could open it in excel
openfiles /Query /S Server /FO CSV /V | out-file c:\temp\files.csv
2 Responses
[…] date: 8/13/2015 Social sharing volume in the past week: 1 15 1 0 “Get open files on a remote server with powershell – Savage Nomads” I needed to send a list of open files from our file server to the helpdesk so they could contact […]
[…] “Get open files on a remote server with powershell – Savage Nomads” I needed to send a list of open files from our file server to the helpdesk so they could contact the users that were still using the old systems. I wanted to give them something other than a screen shot so I went digging for a powershell script. I found this which uses openfile.exe but within powershell pipes the output to a nice grid view.Publish date: 8/12/2015 Social sharing volume in the past week: [su_button onclick=”return false; ” background=”#00acee” icon=”icon: twitter”]2[/su_button] [su_button onclick=”return false; ” background=”#3b5998″ icon=”icon: facebook”]1[/su_button] [su_button onclick=”return false; ” background=”#0077b5″ icon=”icon: linkedin”]0[/su_button] [su_button onclick = “return false;” background = “#dd4b39” icon = “icon: google-plus”]1[/su_button] […]