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?