'get_filesystem' with option PATH_FOLDER_COUNT using * wildcard cannot be used to filter the folder names

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The 'get_filesystem' with option PATH_FOLDER_COUNT using * wildcard cannot be used to filter the folder names. It is by designed that the pattern is not applied on folders.

Environment

OS: Unix

Resolution

As a possible workaround is to use the UNIX/Linux command "ls -la" in the PROCESS tab and use PREP_PROCESS_REPORT function within the PORST-PROCESS tab of your JOBS as shown below. 

--------------------------------------------------------------------------- 
:DEFINE &COUNTER#, unsigned 
:SET &HND# = PREP_PROCESS_REPORT("JOBS",, "REP", "d*bi*") 
:PROCESS &HND# 
: SET &RET# = GET_PROCESS_LINE(&HND#) 
: PRINT &RET# 
: SET &COUNTER# = &COUNTER# + 1 
:ENDPROCESS 
:SET &TOTAL#=FORMAT(&COUNTER#,"0") 
:PRINT &TOTAL# 
--------------------------------------------------------------------------- 

The filter d*b* makes sure that it is a directory and the directory name starts with b*. This can be modified depending on your requirements.