SDP text object with SQL query

Discussion created by rflud on Apr 27, 2010
Latest reply on Apr 28, 2010 by rflud

I'm using this query in SDP to display information in a text object:


Select COUNT(distinct source) from s_qos_data where probe =  'interface_traffic' and origin = 'EMC'


The query works when I test it but when the dashboard is published and you mouse over the text object SDP says it's an invalid query.  Any idea why?


My other question is what do you have to do to get the SQL query to show the result in the text object?