I seem to have an issue with the Disk Space Used% frame in the instance overview. I have tried to modify the query that pills data in various ways…but I continue to get the following error
convert frame from rows error: duplicate column names are not allowed, found identical name “” at column indices 1 and 2
Here is the query
select time=date_last_seen, left([volume_name],2)+ ’ ’ + isnull(label,’’),1.0-[free_space_percentage]
where sql_instance = ‘$sql_instance’
order by left([volume_name],2)
If you run the query by itself on the database server and replace ‘$sql_instance’ with the server name, the query works. From trouble shooting, it seems to be the where clause that is causing the issue. I have tried different variations of “Where sql_instance =…” but nothing seems to work.