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!