1. Download the attached portRange.sql file and copy it to your NFA Console server.
2. On the NFA Console server open a command prompt to the directory where you copied portRange.sql file and run:
mysql reporter < portRange.sql
3. Then login to mysql with:
4. Then run the query below where will return a list of ports between 65000-65535 that have not been used as part of an Application Definition that can be used as the Destination Port in a new Application Definition.
mysql -D reporter -t -e "select id from portrange where id not in(select newport from application_mappings);" > AvailablePorts.sql