Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Archive > 2017December18 - Deletes > Unable to view the Custom Table with SQL Query using non-admin account

Unable to view the Custom Table with SQL Query using non-admin account

Created by John Salvani, last modified by Kevin.Swinson on Dec 18, 2017

Views: 815 Votes: 0 Revisions: 8

Overview

Unable to view the Custom Table with SQL Query using non-admin account. However, logging in as Admin on the Orion Web Console shows the SQL Custom Table.

Environment

NPM 10.6 and later

Cause 

SQL rights is limited for non-admin accounts for security reasons.

Resolution

Use SWQL (swis) query instead of SQL:

For example:

SELECT

s.Name,

s.LastRunDate,

s.LastRunDuration,

s.LastRunStatus,

s.SqlApplication.InstanceName,

s.SqlApplication.Node.Caption as Server

FROM Orion.APM.SqlJobInfo s

WHERE s.LastRunStatus = 0

 

Screen.png

 

 

Reference: https://thwack.solarwinds.com/thread/77584

Last modified

Tags

Classifications

Public