PeopleSoft HRMS System Configuration Insight (PSFTHRMSSCI)

To extract the files in script-based extraction:

  1. Edit the ExtractPSFTHRSCI_SQLBackend_Support.bat file.
  2. Comment the object's select query for which you don’t want to extract in the ExtractPSFTHRSCI_SQLBackend_Support.bat file. Just rewrite the Query as shown in the example. Please refer the example given below. 
    ECHO Extracting PSACCESSPRFL --Started 
BCP "SELECT '' " queryout "%2\PSACCESSPRF.txt" -t $$$$!@** -r -w -S "%1" -U "%5"
-P "%6" REM BCP "SELECT 
NULL,'@B$R@C!I#D#',LTRIM(RTRIM(SYMBOLICID)),VERSION, LTRIM(RTRIMqueryout "% 
(ACCESSID)),LTRIM(RTRIM(ACCESSPSWD)),ENCRYPTED FROM %7.PSACCESSPRFL" 
2\PSACCESSPRFL.txt" -t $$$$!@** -r $$$$!@**###\n -w -S "%1" -U "%5" -P "%6" 
echo Extracting PSACCESSPRFL -- Completed