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
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.
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
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |