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
Store

When using SWQL Studio, and trying to query a table for UDT, receive error, "Must Declare the scalar variable "@ip"

I am trying to use a UDT.USER.History query and it comes right back with the error above. I have NOT changed anything. I merely loaded the Query for that table and tried to execute it with the resulting error.

Any ideas as to why this will give such an error when I have not changed the native query?

Find more posts tagged with

Accepted answers

All comments

KMSigma.SWI

Can you post the actual query in a code block? (P.S. If you select SQL as the code type, it'll render easier on the eyes.)

jm_sysadmin

Piggybacking on this, the specific query will make a big difference, it likely has parameter you need to populate.

highstone351

Apparently, when I did a restart on the server, last week, some of this was fixed. Of course I did not have a way of checking it until today.

if it happens again, I will submit the proof. I had been working on this issue for almost a month!

Thanks anyway,

Mark