Return
-
Title
REGEX expression for SQL Server log file path in "Microsoft SQL Server Error Log" datasource does not return results -
Description
When creating a REGEX expression to define similar SQL Server log file paths in the "Microsoft SQL Server Error Log" datasource, the InTrust server gathering fails with:The specified log doesn't exist.The issue only occurs when the folder of similar names are on the root drive. Such as:- C:\MSSQL.INTRUST\MSSQL\Log\ERRORLOG*
- C:\MSSQL.ADMIN\MSSQL\Log\ERRORLOG*
- C:\MSSQL.VMWARE\MSSQL\Log\ERRORLOG*
The REGEX expression used would be similar to the following:C:\\MSSQL.(\w*)\\MSSQL\\Log -
Cause
There is an issue with how the InTrust server parses REGEX expressions when the wildcards are used on the root drive (c: in this example). -
Resolution
WORKAROUND 1
Nest the SQL logs in another folder on the root drive. Such as:
- C:\SQLLog\MSSQL.INTRUST\MSSQL\Log\ERRORLOG*
- C:\SQLLog\MSSQL.ADMIN\MSSQL\Log\ERRORLOG*
- C:\SQLLog\MSSQL.VMWARE\MSSQL\Log\ERRORLOG*
The REGEX expression used would be similar to the following:C:\\SQLLog\MSSQL.(\w*)\\MSSQL\\LogWORKAROUND 2
Create a separate "Microsoft SQL Server Error Log" datasource for each SQL error log directory.STATUS
Waiting for fix in a future release of InTrust.
-
Defect ID
ST86683