Where is the sophos database

Number of Views The connection to the SQL Server is trusted i. If you don't use -E you have to use -U and specify a SQL user account your database admin has created. Specifies the server name and instance name to connect to. To connect to the local server you can rename the server name with a dot.

The default SQL Server instance name for our installers is 'sophos'. Hence it is simpler to specify the '-d' parameter when initially accessing the SQL Server. Specifies the actual SQL query that will be executed against the database. The SQL query is enclosed in double quotes. Access a local SQL Server instance called 'sophos' but do not connect to a particular database. Number of Views 1. Purge: Will remove non-managed computers added to the database before the specified history length.

Will remove the non-managed deleted computer. Any outstanding errors older than 14 days are automatically acknowledged SEC 5.

Delete: Will delete non-managed computers added to the database before the specified history length. The delete action must only be used when specifically asked to do so by Sophos Support. The category qualifier restricts the action to the specified category of entries. By default, the action is performed on all categories apart from auditing and computers.

The purging of Auditing and Computer data must be called specifically on its own by running, for example: PurgeDB. Note: encryptionSessions is no longer valid from SEC 5.