Author Posts

October 6, 2013 at 5:12 pm

I want to run a script that gets all the shares and permissions on a Windows server. The script works fine on my workstation, but the output is in Excel (*not* csv). How do I run the script on a server from my workstation that will still create the output in Excel on my workstation? Is this even possible? Thanks.

October 6, 2013 at 6:27 pm

That shouldn't be a problem, but it would help to see your current script first.

October 7, 2013 at 7:08 am

Use get-wmiobject Win32_Share -computername XXX to get the data remotely. You can then run it from your workstation.

As a tip it is far, far faster to create a CSV file and import it into Excel than it is to write directly into Excel