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 > Network Performance Monitor (NPM) > Queries Using CTE Fail in Web Report Writer

Queries Using CTE Fail in Web Report Writer

Created by Michael Almadova, last modified by MindTouch on Jun 23, 2016

Views: 8 Votes: 0 Revisions: 4

Overview

Queries Using CTE fail in Web Report Writer, but will run in Report writer. 

 

Environment

  • NPM 11.5.2

 

Cause 

 

A semicolon is missing in front of the command ;WITH CTE AS.

Resolution

  1. Add the semicolon in front of the;WITH CTE AS command and this will run in Web reports. 

 

 

 

 

Last modified

Tags

This page has no custom tags.

Classifications

Public