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

 
Participant
5 years, 6 months ago.

  • Author
    Posts
  • #10557

    Participant
    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

    Member
    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

    Participant
    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.

denizli escort samsun escort muğla escort ataşehir escort kuşadası escort