Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Archive > 2018Jan2 - Deletes > Queries Using CTE Fail in Web Report Writer

Queries Using CTE Fail in Web Report Writer

This article is slated for Deletion. Do not update this article. If you have questions please send a message to mt-feedback@solarwinds.com

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

Views: 759 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