- Related Topics
- Profiler Task Summary
- Profiler Overview
Managing the Profiler Database (NSM Procedure)
The following topics provide procedures for managing the Profiler database:
Displaying Profiler Database Information
Purpose
Data discovered by Profiler is stored in a database located on the NSM GUI server. Use the steps in this procedure to display information about the Profiler database.
Action
To display Profiler database information:
- In the NSM navigation tree, select Investigate > Security Monitor > Profiler.
- Click the Show DB Information icon in the upper right corner to view specific details about the Profiler database, including the database size.
Querying the Profiler Database
Purpose
Data discovered by Profiler is stored in a database located on the NSM GUI server. Use the steps in this procedure to query the Profiler database.
Action
To query records in the database:
- Log into the NSM GUI server as the Postgres SQL user. By default, the Postgres SQL user is netscreen.
- Navigate to the directory where the Profiler DB is located: /usr/local/nsmpsql/bin.
- Run any Postgres SQL command. For example, you
can type the following command:
./psql -d profilerDb
Purging the Profiler Database
Data discovered by Profiler is stored in a database located on the NSM GUI server. When the database reaches a maximum size (4 GB by default), it begins purging records (oldest first) automatically. The Profiler stops purging records when it reaches a certain set minimum size (3 GB by default).
Use the steps in this procedure to purge the Profiler database, if needed.
To change automatic purge settings, from the NSM main menu, select Tools > Preferences and modify the Profiler database settings.
To purge the database immediately:
- In the NSM navigation tree, select Investigate > Security Monitor > Profiler.
- Click the Clear All DB icon in the upper right corner.
