16 reputation
2
bio website
location
age
visits member for 1 year, 8 months
seen Nov 24 '12 at 22:32

Nov
24
comment Complex SQL Query
Yes, multiple index numbers per host, one per interface via the key/pair table. Ip address is stored in the host.hostname variable, and the actual hostname is in host.description.
Nov
24
comment Complex SQL Query
While it works, it makes a ton of duplicate results. Is there a way to make the snmp_index unique per host? Right now it spits out the same index for every interface in the table, multiplied by every interface. How do you restrict it so: ON host.id = ifIdx.host_id if ifIdx.field_value = whatever value the snmp index is for that table row.
Nov
24
awarded  Scholar
Nov
24
comment Complex SQL Query
That's one hell of a query! It works! Thank you!
Nov
24
awarded  Student
Nov
24
asked Complex SQL Query