This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Custom table with SQL Query only for Admins?

Hi all

Made a view with a custom table component. Set that up with a SQL-query:

SELECT TOP 1000

      s.Name

      ,s.LastRunDate

      ,convert(TIME,dateadd(ss,s.LastRunDuration,0)) as RunDuration

      ,s.LastRunStatus

 

   ,a.name as 'SQL-Instance'

   ,n.Caption as Server

  FROM APM_SqlBbJobInfo s

  join apm_application a on a.ID=s.ApplicationID

  join nodes n on a.nodeid=n.nodeid

  where s.lastrunstatus=0

Lets us see all SQL jobs in all servers that failed last run time.

The view works perfect for admins. Only admins. If you don't have admin privileges then you get:

"Report resource failed to properly initialize"

Message: Invoke failed, check fault information.

ErrorSite: mscorlib.RealProxy.HandleReturnMessage

ErrorType: System.ServiceModel.FaultException`1[[SolarWinds.InformationService.Contract2.InfoServiceFaultContract, SolarWinds.InformationService.Contract2, Version=2015.1.0.187, Culture=neutral, PublicKeyToken=null]]

Should it be like this? How can I fix that?

/Thanks!