Search for entries in the SQL database

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

You can look for entries in the SQL database that is running on your current machine 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 SQL 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, click on the SQL Database search 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.