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 > 2018Jan2 - Deletes > Queries Using CTE Fail in Web Report Writer

Queries Using CTE Fail in Web Report Writer

Created by Michael Almadova, last modified by Kevin.Swinson on Jan 02, 2018

Views: 755 Votes: 0 Revisions: 5

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