Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Orion Report Problem

I have a rather complex SQL query, but I certainly don't believe that the complexity alone is creating the issue that I am now seeing.

What I am seeing is that a previously created, currently functional query works flawlessly as it is written. I have found though that upon creating a new query with the exact same structure I get the following error:

The column prefix 'Nodes' does not match with a table name or alias name used in the query.

I know this issue isn't created by any errors in syntax, because the existing one works perfectly. Even if I go to copy the fully functional query and create a new report with it, the new report gives me the same error. Is something different in Orion causing this issue... or is it just some kind of bug?

Find more posts tagged with

Accepted answers

All comments

qle

Can you post the query?

dhardy

Select '<a href=hxxp://xxxxxx/NetPerfMon/Report.asp?Report=Core+Routers+Inventory>Core Routers</a>', (SELECT Count (*) AS Count FROM Nodes
WHERE
(
(Nodes.Category = 'Core Router') AND
( Nodes.Status <> '9')
)
) Union

Select '<a href=hxxp://xxxxxx/NetPerfMon/Report.asp?Report=Substation+Routers>Substation Routers</a>', (SELECT Count (*) FROM Nodes
WHERE
(
(Nodes.Category = 'SubRouter') AND
( Nodes.Status <> '9')
)
) Union

Select '<a href=hxxp://xxxxxx/NetPerfMon/Report.asp?Report=Managed+Switches>Managed Switches</a>', (SELECT Count (*) FROM Nodes
WHERE
(
(Nodes.Category = 'ManagedSW') AND
( Nodes.Status <> '9')
)
) Union

Select '<a href=hxxp://xxxxxx/NetPerfMon/Report.asp?Report=ION+7330s>ION 7330s</a>', (SELECT Count (*) FROM Nodes
WHERE
(
(Nodes.Category = '7330') AND
( Nodes.Status <> '9')
)
) Union

Select '<a href=hxxp://xxxxxx/NetPerfMon/Report.asp?Report=ION+8600s>ION 8600s</a>', (SELECT Count (*) FROM Nodes
WHERE
(
(Nodes.Category = '8600') AND
( Nodes.Status <> '9')
)
) Union

Select '<a href=hxxp://xxxxxx/NetPerfMon/Report.asp?Report=Terminal+Servers>Terminal Servers</a>', (SELECT Count (*) FROM Nodes
WHERE
(
(Nodes.Category = 'Terminal Server') AND
( Nodes.Status <> '9')
)
) Union

Select '<a href=hxxp://xxxxxx/NetPerfMon/Report.asp?Report=VSATs>VSATs</a>', (SELECT Count (*) FROM Nodes
WHERE
(
(Nodes.Category = 'VSAT') AND
( Nodes.Status <> '9')
)
) Union

Select '<a href=hxxp://xxxxxx/NetPerfMon/Report.asp?Report=Access+Points>Access Points</a>', (SELECT Count (*) FROM Nodes
WHERE
(
(Nodes.Category = 'Access Point') AND
( Nodes.Status <> '9')
)
) Union

Select 'Total Nodes', (SELECT Count (*) FROM Nodes
WHERE
(
    ( Nodes.Status <> '9') AND
    (Nodes.Category = 'Access Point') OR
    ( Nodes.Status <> '9') AND
    (Nodes.Category = 'VSAT') OR
    ( Nodes.Status <> '9') AND
    (Nodes.Category = 'Core Router') OR
    ( Nodes.Status <> '9') AND
    (Nodes.Category = 'SubRouter') OR
    ( Nodes.Status <> '9') AND
    (Nodes.Category = 'ManagedSW') OR
    ( Nodes.Status <> '9') AND
    (Nodes.Category = '7330') OR
    ( Nodes.Status <> '9') AND
    (Nodes.Category = '8600') OR
    ( Nodes.Status <> '9') AND
    (Nodes.Category = 'Terminal Server') OR
    ( Nodes.Status <> '9') AND
    (Nodes.Category = 'Server')
)
)