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