Search for entries in the SQL Server database

The management server, the event server and the log server store, for example, the system configuration, alarms, events and log messages in SQL Server databases on one or more SQL Server installations.

You can look for entries in the SQL Server database that is running on your current computer with the Milestone Diagnostics Tool when you need to:

  • Check for log messages

  • Look for events related to a particular device

  • Search for other information.

To start searching the a SQL Server database:

  1. On a relevant server that is connected to an XProtect server, for example XProtect Management Server, open the Diagnostics Tool.exe from the relevant file location.

  2. From the main screen of Milestone Diagnostics Tool, select the SQL Database tab.

  3. Type the words that you want to match entries in the database and click Search. A list of the results is displayed.

    The SQL database search is not case-sensitive. You can look for strings of words without special characters.