6 Replies Latest reply on Mar 22, 2017 9:10 AM by seyhmusatli

    SWQL works in studio but not in Website

    seyhmusatli

      After migrating to NPM 12.1 I've decided to update my SQL queries to SWQL queries since row limit started to bother me and searchable textbox seems to be legit.

       

      My swql query looks like:

       

      select 
      case when ccs.Availability=1 then 'Up' else 'Down' end as STATUS,
      '/NetPerfmon/images/Small-' + case when ccs.Availability=1 then 'Up' else 'Down' end + '.gif' as _IconFor_STATUS,
      n.Caption, c.Name,
      ccs.TimeStamp, 
      ccs.LastTimeUp, 
      ccs.ErrorMessage
      from 
      Orion.Nodes n, Orion.APM.Component c, Orion.APM.Application a, Orion.APM.CurrentComponentStatus ccs
      where 
      n.NodeID=a.NodeID and 
      ccs.ApplicationID=a.ID and 
      ccs.ComponentID=c.ComponentID and 
      a.Name like 'Windows %' and 
      c.Name <> 'Task Scheduler' and
      (c.Status=1 or c.Status=2) and
      a.Unmanaged=0
      

       

      It works perfectly on swql studio but not on custom query on website. Any comments?

       

      Thanks.