1 Reply Latest reply on Sep 17, 2019 5:02 PM by Luis Morales

    Is it possible to run MS SQL custom query using Patrol for MSsql

    Abhay Bhagat
      Share This:

      Dear ,

       

      Is it possible to run MS SQL custom query using Patrol for MSsql .

       

      I already read Using custom SQL queries - Documentation for BMC PATROL for Microsoft SQL Server 9.6 - BMC Documentation

       

      but could not understand that is it works only for health of a Microsoft SQL Server or can I get some data from the custom queries ,

       

      Regards

      Abhay

        • 1. Re: Is it possible to run MS SQL custom query using Patrol for MSsql
          Luis Morales

          Hi Abhay,

           

          you can run any query for health and non health in custom query section, this section was designed in order to let customers monitor their own queries but please keep in mind that if you would like to monitor something specific, the KM shows only numerical value returned by the query from first line and first column as documentation mentions. If value returned is not numerical in first line and fist column, the KM still will execute the query but Value parameter will not show data. Nevertheless the KM will return values for Number of records, Query status and Response time parameters.

           

          If you got some issues with SQL custom queries, please feel free to raise ticket in Customer Support.

           

          Regards,

          Luis.