Discovering SQL Error log location

Idea ID 2698004

Discovering SQL Error log location

0 Votes

The current MSSQL discovery pattern cannot locate MSSQL error logs' location. These logs are crucial for our monitoring team to create monitoning templates that will be used for our customers when they want their MSSQL servers monitored. Someone from the MSSQL team has created a sql command that he hopes will help in expanding the current MSSQL discovery pattern to find the location of the error log files.

Here's the sql command from the MSSQL team member:
SELECT
value_data AS [Errorlog directory]
FROM sys.dm_server_registry
WHERE
registry_key LIKE N'%MSSQLServer\Parameters' and convert(varchar,value_data) like '-e%'

This query will provide output as follows –
Errorlog directory
-eC:\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG

They need to truncate first 2 character i.e. “-e” which will give directory location.
Not quite sure where this directory can be placed once this has been added and we can discover the error log location.

1 Comment
Micro Focus Expert
Micro Focus Expert
Status changed to: Waiting for Votes

Thank you for sharing your idea! It’s open for comments and kudos, and we’re looking forward to input from the community. Once there is enough community traction, it will be further reviewed by the product team

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.