Run script on server, output to Excel on Workstation?

This topic contains 2 replies, has 3 voices, and was last updated by  Richard Siddaway 3 years, 11 months ago.

  • Author
    Posts
  • #10557

    unixhand
    Participant

    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

    Dave Wyatt
    Moderator

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

  • #10568

    Richard Siddaway
    Moderator

    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

You must be logged in to reply to this topic.