In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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