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