SA Collector Feed List through ODBC

Continuing my effort to document the various ways I've used the ODBC connector for the NetQoS products, I'm going to post a couple of the queries and controls I've built and that I use in production.  Today's query comes from a need to review all the collector feeds for all the collectors on two different master consoles.  Collector feeds are configured for each collection NIC on standard collectors.  I haven't run this query on a MC with a MTP connected, but it should result in the same thing.
The query comes from three different tables and results in a list of feeds and options to edit each collector.  Unfortunately, the functionality to directly modify the feed properties within the GUI isn't present yet, but something like it should be coming soon.  Here's the SelectCommand and OdbcConnection String to put in the configuration.xml:

<selectcommand name="SACollectors" property="False" supportedviewtypes="Table"> <![CDATA[ select convert(concat( '<a target=\'_blank\' href=\'//', c.PropValue, '/SuperAgent/Admin/', 'editAdminCollectors.aspx?CollID=', b.probe_id, '\'>', a.probe_desc, '</a>' ) using utf8) as Collector_Name, b.probe_id as Collector_ID, b.feed_index as Feed_Index, b.probe_id * b.feed_index as Sorter, convert(inet_ntoa(a.address) using utf8)  as Mgmt, convert(inet_ntoa(a.monitor_address)  using utf8) as Monitor1, convert(inet_ntoa(a.monitor_address2)  using utf8) as Monitor2, a.ip_addresses as IP_Address_List, b.feed_name as Feed_Name, convert(inet_ntoa(b.listen_ip) using utf8)  as Listen_IP, b.options as Options from probes a, probe_feeds b, performance_center_properties c where b.inactive=0 and a.probe_id=b.probe_id and c.propname='DS.ConsoleHost'; ]]> </SelectCommand> <odbcconnectionstring Name="SAMC">Driver={MySQL ODBC 5.1 Driver};Server=192.168.23.67;Port=3308;Option=3;Database=super;User=super;Password=nqsuper;</OdbcConnectionString>
To create the view, run the following SQL commands against the NPC server:

INSERT INTO controls SELECT if(min(id)-1>0,min(id)-1,29999), 'SuperAgent Collector Feeds', 'Graph', 'NetVoyant-ODBC', '/nqWidgets/Integration/wicTable.ascx', 1, 0x200000, 0, 0, 0, 1, '|nc|g|', '', 'Y' FROM controls WHERE datasourcetype=0x200000; INSERT INTO control_properties (ControlID, Editable, PropertyName, PropertyValue) VALUES (-1, 'N', 'Title', 'SuperAgent Collector Feeds'), (-1, 'N', 'DisplayColumns', 'Collector_Name;Collector_ID;Feed_Index;Mgmt;Monitor1;Monitor2;IP_Address_List;Feed_Name;Listen_IP;Options'), (-1, 'N', 'DisplayFormats', 'string,string,string,string,string,string,string,string,string,string'), (-1, 'N', 'DisplayNames', 'Collector Name,Collector ID,Feed Index,Management IP,Monitor 1 IP,Monitor 2 IP,IP Address List,Feed Name,Listen IP,Options'), (-1, 'N', 'ColumnWidths', ',,,,,,,,,'), (-1, 'N', 'HorizontalAlignments', 'Left,Left,Left,Left,Left,Left,Left,Left,Left,Left'), (-1, 'N', 'SortField', 'Sorter'), (-1, 'N', 'SortDirection', 'Asc'), (-1, 'N', 'Integration.Parameter.SelectCommandName', 'SACollectors'), (-1, 'N', 'Integration.DataType', 'SelectCommand'), (-1, 'N', 'Integration.Parameter.DateTimeFormat', 'yyyy-MM-dd HH:mm'), (-1, 'N', 'Integration.Parameter.TopN', '200'), (-1, 'N', 'Integration.Parameter.OdbcConnectionStringName','SAMC'); UPDATE control_properties SET ControlID = ( select min(id) from controls where datasourcetype=0x200000) WHERE ControlID = -1;