Run script on server, output to Excel on Workstation?

Welcome Forums General PowerShell Q&A Run script on server, output to Excel on Workstation?

This topic contains 2 replies, has 3 voices, and was last updated by

5 years, 10 months ago.

  • Author
  • #10557

    Topics: 2
    Replies: 1
    Points: 0
    Rank: Member

    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.

  • #10558

    Topics: 9
    Replies: 2322
    Points: 0
    Rank: Member

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

  • #10568

    Topics: 0
    Replies: 669
    Points: 0
    Rank: Member

    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

The topic ‘Run script on server, output to Excel on Workstation?’ is closed to new replies.