DaveRick

SDP SQL Restrictions

Discussion created by DaveRick on Mar 1, 2011
Latest reply on Mar 5, 2011 by mrixon

I'm wondernig if others have seen issues with this but we are having problems running certain SQL code within the SDP.  For example the following SQL works perfectly fine through other selection methods but when ran from the SDP or Unified Monitoring we get errors:

 

SELECT d.source as 'Host', d.target as 'Disk', (cast((MAX(r.samplevalue)/1024) as decimal (18,4))) as 'Usage MB', (cast((MAX(r.samplemax)/1024) as decimal (18,4))) as 'Total MB'
from RN_QOS_DATA_0020 r, s_qos_data d
where d.table_id = r.table_id
and r.sampletime between dateadd ("day", -1, getdate()) and getdate()
and d.source like '%usdb%'
and d.target not like '%C%'
group by d.source, d.target
order by 'Usage MB' desc

 

What we see is a message saying: The multi-part identifier "d.source" could not be bound.

 

I've tried dumbing down the query but nothing seems to be helping.  Has anyone else ran into this problem?

Outcomes