Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Network Performance Monitor (NPM) > 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 MindTouch on Jun 23, 2016

Views: 8 Votes: 0 Revisions: 7

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
23:54, 22 Jun 2016

Tags

Classifications

Public