2. Select the MS Access option and specify the full path (including the file name) of your Microsoft Access database backend.
NOTE 1: If the specified database file does not exist, it will be created.
NOTE 2: if the specified database file already exists and belongs to a previous version of GFI LANguard, you will be asked whether you want to over-write the existing information.
3. Click OK to finalize your settings.
2. Select the MS SQL Server option and choose the SQL Server that will be hosting the database from the provided list of servers discovered on your network.
3. Specify the SQL Server credentials or select the Use NT authority credentials option to authenticate to the SQL server using windows account details.
4. Click on OK to finalize your settings.
NOTE 1: If the specified server and credentials are correct, GFI LANguard will automatically log on to your SQL Server and create the necessary database tables. If the database tables already exist, it will re-use them.
NOTE 2: When using NT authority credentials, make sure that GFI LANguard services are running under an account that has both access and administrative privileges on the SQL Server databases.
Use the Saved Scan Results tab to maintain your database backend and delete saved scan results that are no longer required. Deletion of non-required saved scan results can be achieved manually as well as automatically through scheduled database maintenance.
3. To let GFI LANguard manage database maintenance for you, select Scans generated during the last to automatically delete scan results which are older than a specific number of days/weeks or months or
Scans per scan target per profile in number of to retain only a specific number of recent scan results.
3. Click on Delete selected computer(s) button to delete scanned computer data.
NOTE 1: Deleting computers from the database is a one-way operation that will also delete all computer related data from the database.
Once deleted, this data is no longer recoverable.
NOTE 2: While this is a very efficient mechanism for freeing up licenses previously occupied by unused nodes, note that this affects the long-term security reporting capabilities of GFI LANguard Where long term security reporting must be ascertained, or in environments where security databases must be intact, it is highly advisable to not delete any data whatsoever. In such scenarios, it is advisable that more licenses are acquired to cater for network growth or expansion.
3. To automate the repair and compact process on an Microsoft Access database backend select One time only to schedule a onetime Microsoft Access database repair and compact or
Every to execute a repair and compact process on a regular schedule. Specify the date, time and frequency in days/weeks or months at which the compact and repair operations will be executed on your database backend.
