1 Reply Latest reply on May 11, 2017 12:40 AM by tdanner

    Can a swql query be used to query SQL Server 2012 database that is not related to Solarwinds?

    dsweir

      Silly question, but I am stuck.  Our BI team wanted to use Solarwinds SQL User Experience Monitor to alert on errors that occurred on Sharepoint Services Reporting Server (SSRS).  The ExecutionLog table to contains data "rsSuccess" about success or failure when reports are run.  I was given the query which is below.  When I use this within the experience monitor it fails with the error "Unable to convert query result" 

       

      SELECT

      CONVERT(VARCHAR(13), TimeStart, 20) AS 'Date'

      ,InstanceName

      ,count(*) 'Report Count'

      FROM [sps_ssrs_10_onestop_reportserver].[dbo].[ExecutionLog] e with (nolock)

        join [sps_ssrs_10_onestop_reportserver].[dbo].Catalog c with (nolock)

        on e.ReportID = c.ItemID

         WHERE TimeStart between '2017-05-01 00:00:00' and '2017-05-09 23:59:59'

        and status <> 'rsSuccess'

      group by CONVERT(VARCHAR(13), TimeStart, 20), InstanceName

      order by CONVERT(VARCHAR(13), TimeStart, 20), InstanceName

       

      The monitor would trigger if there were more than 10 errors over a given period of time.  My SWQL and SQL skills are a bit lacking and I am wits end.  I found that the convert string doesnt work in SWQL, and I cannot find a proper replacement, or I am missing something where in the documentation.

       

      Thanks in advance for any assistance provided.