Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

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: 821 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