One of our applications inserts log records in a few SQL Server tables and we want to ingest those entries.
I installed a windows collector and configured the scripts described here:
When I run MSSQL_Monitor.bat in the console, I can see the results of my custom query successfully but the collector doesn't seem to be doing anything. All see is entries like this:
Microsoft (R) Windows Script Host Version 5.8
Copyright (C) Microsoft Corporation. All rights reserved.
None of the rows returned by the query are collected.
Is there a specfic way the SQL query should be written so that the rows returned are collected?
Please sign in to leave a comment.