network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 5 months |
| seen | Nov 24 '12 at 22:32 | |
| stats | profile views | 1 |
|
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 |
