Loupe Desktop - Log Message Search - Installation
In This Topic
Requirements
Log Message Search relies on SQL Server Full Text Search (FTS). It requires a SQL Standard or higher SQL Server (SQL Express is not supported) with Full Text Search enabled. Confirm that your database server has this feature enabled before enabling the Log Message Search Addin.
Since all of the lifting is done within SQL Server, every computer that's going to take advantage of Log Message Search needs access to the SQL Server. This includes any Loupe Desktop that will run queries and any private Loupe Server which is the best place to index data.
The search database can grow significantly since it stores each unique caption, description, and exception message. Allow significant room for growth. Additionally, since many calls can be made to index each session it's important there is good bandwidth between the Loupe Server and the SQL Server.
Enabling Log Search On Your Server
If you are operating your own Loupe Server (as opposed to using the Gibraltar Software Loupe Service) the first step is to enable the Search Extension on the Loupe Server using the Loupe Server Administrator.
- Start the Loupe Server Administrator on the Loupe Server
- Select Extensions from the Server node in the Tree View.
- Select the Search Extension and click Enable. This will display the Log Message Search configuration dialog.
- Enter the database server & database name and select how the Loupe Server will authenticate to the database. We recommend using the same security information Loupe Server itself is using since those are already proven.
- Click OK to complete enabling the Search Addin. Additional configuration can be done via Loupe Desktop.
- Restart the Loupe Service and Loupe Web Site on the server for the change to take effect.
Within a minute of the service restarting you should notice that the SQL Database becomes populated with a simple schema. As new sessions arrive they will be analyzed and their log messages placed in this database. If you don't see a schema, review the Loupe Server Service logs locally on the Loupe Server or the SQL Server's logs for an indication on where the problem is.
Enabling Log Search in Loupe Desktop
Each user of Loupe Desktop will need to individually enable the Search addin. To do this:
- Go to the Backstage area in Loupe Desktop (the orange tab in the upper left)
- Select the Manage Extensions view.
- Select the Search Extension and click Enable. This will display the Log Message Search configuration dialog.
- If the server is already configured the database server & name will be defaulted for you. Otherwise, enter the database server & database name.
- Configure how you will authenticate to the database.
- Click OK to complete enabling the Search Addin.
- Restart Loupe Desktop to complete enabling the Extension.
You'll now notice a Search node in the User Repository tree view as well as other addin-specific UI extensions.
See Also