Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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

Tags

This page has no custom tags.

Classifications

Public