i have to run powershell script through run command tool.

Question

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

Screenshot 2025-01-29 171825.png

Screenshot 2025-01-29 171757.png

curator_at_work · Answer

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

fmvizcaino · Answer

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.