In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

i have to run powershell script through run command tool.

curator_at_work
8 - Asteroid

i have to run a powershell script through run command tool to check the size of folder and sub-folder of a c-drive, purpose of this ti manage disk space issue, now i am not able to configure run command tool, what to with write source, command, command argument and read result. i am trying hit and trial method but no success. and i am pasting command in text input tool before run command tool

 
 

 

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

Hi @curator_at_work ,

 

Here is a tool mastery about the run command tool. https://community.alteryx.com/t5/Tool-Mastery/Tool-Mastery-Run-Command/ta-p/31548

 

Below, you have a PowerShell + run command tool example.

https://knowledge.alteryx.com/index/s/article/How-To-Use-PowerShell-with-Alteryx-1583460190246

 

Things to keep in mind:

1. Remove the header and the delimiter from the ps script being created (not sure if you had done it)

2. Output is optional. If you connect a tool there, you will have to provide an input file to be read (you are doing it already)

3. Add the powershell command

 

Best,

Fernando V.

 

 

 

curator_at_work
8 - Asteroid

hi @fmvizcaino 
below is the powershell script to get the drive folder , sub folder and files with size , creation date , modifies date
"

 Get-ChildItem -Path "C:\" -Recurse | Select-Object FullName,

    @{Name="Size (Bytes)";Expression={$_.Length}},

    CreationTime,

    LastWriteTime |

Export-Csv -Path C:\downloads\DriveContent9.txt -NoTypeInformation "

that i want to run via run command tool, and do the further data processing and cleaning in alteryx, can u plz guide how to configure each and evrey thing in run command tool