PeopleSoft FISCM System Configuration Insight (PSFTFISCMSYSCI)

To exclude tables in script-based extraction:

  1. Edit the ExtractPSFTFISCMSYSCI_SQLBackend_Support.bat file.
  2. Comment the object's select query for which you don’t want to extract in the ExtractPSFTFISCMSYSCI_SQLBackend_Support.bat file. Just rewrite the query as shown in the example given below.

    Example: 

    
ECHO Extracting PSACCESSPRFL --Started 
CP "SELECT '' " queryout "%2\ PSACCESSPRFL.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