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.
That shouldn’t be a problem, but it would help to see your current script first.
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