In the event an administrator needs a listing of all the queries being run by an edgeCore instance, there are two methods to produce that data:

• Administrators can run a Node script for SQL feeds (Windows/Linux).
• Administrators can run ./edge.sh scriptutil if they do not have Node (Linux).

Run a Node Script for SQL Feeds

Prerequisite: Download the queryExtract.js file:

To use the Node script:

1. Take a full backup of your edgeCore server.
2. Place the backup .zip file in a directory on a machine with Node JS installed.
3. Unzip the backup file.
4. Place queryExtract.js in the /entities directory and run the following (node queryExtract.js $pathToBackup/entities).
   This will output the results to the console. You can also output the results to file appending whatever command is needed by your OS.

Run ./edge.sh scriptutil

• For SQL feeds, run the following on a backup file:
  ./edge.sh scriptutil -s ~/scripts/sqlFeedReport.js -f ../exports/myExport.zip > sqlFeedReport.out
  
  sqlFeedReport.js example

• Or for all SQL feeds and transforms run the following:
  ./edge.sh scriptutil -s ~/Downloads/sqlReport.js  -f ~/Documents/edge_exports/edDemo-edgeSuite-export-20171027-220832.155.zip > sql-report.out
  
  sqlReport.js example