A rather unique situation i desperately need help with
Moderators: Developers, Moderators
-
RustedKnight
- Posts: 39
- Joined: Fri Mar 18, 2016 8:49 am
A rather unique situation i desperately need help with
I am attaching 3 image files. Some how I have had sever graph templates and some data templates get renamed no nothing (see cacti-2.png and cacti-3.png). This causes an issue as can be seen in the graph tree image cacti-1.png. Does anyone know a way I can sort this kind of issue out? I am running cacti 0.8.8b and management is not allowing an upgrade which I know really needs to be done. If it matters any this is running on a linux machine.
- Attachments
-
- cacti-3.png (23.46 KiB) Viewed 1425 times
-
- cacti-2.png (11.48 KiB) Viewed 1425 times
-
- cacti-1.png (4.31 KiB) Viewed 1425 times
Re: A rather unique situation i desperately need help with
I would check your log files for any errors, both the cacti and apache/ngix depending on what you are using.
Cacti Developer & Release Manager
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
-
RustedKnight
- Posts: 39
- Joined: Fri Mar 18, 2016 8:49 am
Re: A rather unique situation i desperately need help with
The graphs themselves work. Its just I cant select the template, nor sort by the template. And I am not seeing any errors that cannot be explained by other issues (network outages and such).
Re: A rather unique situation i desperately need help with
It will be a local issue with the errors being reported in either apache or cacti logs (if its being reported).
unfortunately, I'm not well versed on pre-1.x table structures so I can't just magic some SQL to check it.
unfortunately, I'm not well versed on pre-1.x table structures so I can't just magic some SQL to check it.
Cacti Developer & Release Manager
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
Re: A rather unique situation i desperately need help with
The width of the columns changes between your pages. This suggests that names are being inserted, you just can't see them. Have you tried highlighting the area were the text should be to see if it's a colour issue?
Cacti Developer & Release Manager
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
-
RustedKnight
- Posts: 39
- Joined: Fri Mar 18, 2016 8:49 am
Re: A rather unique situation i desperately need help with
When I highlight the area there is no text.
-
phalek
- Developer
- Posts: 2838
- Joined: Thu Jan 31, 2008 6:39 am
- Location: Kressbronn, Germany
- Contact:
Re: A rather unique situation i desperately need help with
Back to the basic. Let's check if the SQL query is working. Can you execute the following statement and paste/attach the output in here ?
Code: Select all
SELECT
data_template.id,
data_template.name,
data_input.name AS data_input_method,
data_template_data.active AS active
FROM (data_template,data_template_data)
LEFT JOIN data_input ON (data_template_data.data_input_id = data_input.id)
WHERE data_template.id = data_template_data.data_template_id
AND data_template_data.local_data_id = 0;
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusReporting
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusReporting
Re: A rather unique situation i desperately need help with
Strange that your columns adjust in size if there is no text. They should always be the same size then unless it's the later fields changing their sizes. Run the SQL phalek gave you as that will give us some more info.
Cacti Developer & Release Manager
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
-
RustedKnight
- Posts: 39
- Joined: Fri Mar 18, 2016 8:49 am
Re: A rather unique situation i desperately need help with
mysql> SELECT data_template.id, data_template.name, data_input.name AS data_input_method, data_template_data.active AS active FROM (data_template,data_template_data) LEFT JOIN data_input ON (data_template_data.data_input_id = data_input.id) WHERE data_template.id = data_template_data.data_template_id AND data_template_data.local_data_id = 0;
+-----+-----------------------------------------------------+---------------------------------------------------------------------+--------+
| id | name | data_input_method | active |
+-----+-----------------------------------------------------+---------------------------------------------------------------------+--------+
| 3 | ucd/net - Hard Drive Space | Get SNMP Data (Indexed) | on |
| 4 | ucd/net - CPU Usage - System | Get SNMP Data | on |
| 5 | ucd/net - CPU Usage - User | Get SNMP Data | on |
| 6 | ucd/net - CPU Usage - Nice | Get SNMP Data | on |
| 7 | Karlnet - Noise Level | Get SNMP Data (Indexed) | on |
| 8 | Karlnet - Signal Level | Get SNMP Data (Indexed) | on |
| 9 | Karlnet - Wireless Transmits | Get SNMP Data (Indexed) | on |
| 10 | Karlnet - Wireless Re-Transmits | Get SNMP Data (Indexed) | on |
| 11 | Unix - Load Average | Unix - Get Load Average | on |
| 13 | Linux - Memory - Free | Linux - Get Memory Usage | on |
| 15 | Linux - Memory - Free Swap | Linux - Get Memory Usage | on |
| 16 | Unix - Processes | Unix - Get System Processes | on |
| 17 | Unix - Logged in Users | Unix - Get Logged In Users | on |
| 18 | Unix - Ping Host | Unix - Ping Host | on |
| 19 | Netware - Total Users | Get SNMP Data | on |
| 20 | Netware - Total Logins | Get SNMP Data | on |
| 22 | Netware - File System Reads | Get SNMP Data | on |
| 23 | Netware - File System Writes | Get SNMP Data | on |
| 24 | Netware - Cache Checks | Get SNMP Data | on |
| 25 | Netware - Cache Hits | Get SNMP Data | on |
| 26 | Netware - Open Files | Get SNMP Data | on |
| 27 | Cisco Router - 5 Minute CPU | Get SNMP Data | on |
| 30 | ucd/net - Load Average - 1 Minute | Get SNMP Data | on |
| 31 | ucd/net - Load Average - 5 Minute | Get SNMP Data | on |
| 32 | ucd/net - Load Average - 15 Minute | Get SNMP Data | on |
| 33 | ucd/net - Memory - Buffers | Get SNMP Data | on |
| 34 | ucd/net - Memory - Free | Get SNMP Data | on |
| 35 | Netware - Volumes | Get SNMP Data (Indexed) | on |
| 36 | Netware - Directory Entries | Get SNMP Data (Indexed) | on |
| 37 | Unix - Hard Drive Space | Get Script Data (Indexed) | on |
| 38 | | Get SNMP Data (Indexed) | on |
| 39 | | Get SNMP Data (Indexed) | on |
| 40 | | Get SNMP Data (Indexed) | on |
| 41 | | Get SNMP Data (Indexed) | on |
| 42 | Netware - CPU Utilization | Get SNMP Data (Indexed) | on |
| 43 | Host MIB - Hard Drive Space | Get Script Server Data (Indexed) | on |
| 44 | Host MIB - CPU Utilization | Get Script Server Data (Indexed) | on |
| 45 | Host MIB - Processes | Get SNMP Data | on |
| 46 | Host MIB - Logged in Users | Get SNMP Data | on |
| 47 | ucd/net - Memory - Cache | Get SNMP Data | on |
| 48 | SNMP - Generic OID Template | Get SNMP Data | on |
| 246 | Cyan Gig Port RxTx Power | Get SNMP Data (Indexed) | on |
| 296 | Mimosa - System - Uptime | Get SNMP Data | on |
| 227 | AirOS_5.5 Channel | Get SNMP Data | on |
| 228 | AirOS-5.5 CPU | Get SNMP Data | on |
| 224 | Brocade - 1 Minute Average CPU Usage | Get SNMP Data (Indexed) | on |
| 248 | Cisco EnvMon Power | Get SNMP Data (Indexed) | on |
| 252 | Cisco UBR FEC Errors | Get SNMP Data (Indexed) | on |
| 291 | Raisecomm Memory | Get SNMP Data (Indexed) | on |
| 51 | User Counts from DB | Count Users From DB | on |
| 290 | Raisecomm Temerature | Get SNMP Data (Indexed) | on |
| 289 | Raisecomm CPU Usage | Get SNMP Data (Indexed) | on |
| 52 | MiraPoint - Storage Space | Get SNMP Data (Indexed) | on |
| 53 | MiraPoint - Users and Inboxes | Get SNMP Data (Indexed) | on |
| 54 | MiraPoint - Message Flow | Get SNMP Data (Indexed) | on |
| 55 | MiraPoint - Average Message Size | Get SNMP Data (Indexed) | on |
| 56 | MiraPoint - MTA Messages | Get SNMP Data (Indexed) | on |
| 57 | MiraPoint - MTA Recipients | Get SNMP Data (Indexed) | on |
| 58 | MiraPoint - RAID Storage | Get SNMP Data (Indexed) | on |
| 59 | MiraPoint - RAID Commands | Get SNMP Data (Indexed) | on |
| 60 | MiraPoint - RAID Throughput | Get SNMP Data (Indexed) | on |
| 61 | MiraPoint - RAID Latency | Get SNMP Data (Indexed) | on |
| 62 | MiraPoint - WebMail Sessions | Get SNMP Data (Indexed) | on |
| 63 | MiraPoint - WebMail Sort Operations | Get SNMP Data (Indexed) | on |
| 64 | MiraPoint - WebMail Times | Get SNMP Data (Indexed) | on |
| 65 | MiraPoint - WebMail Actions | Get SNMP Data (Indexed) | on |
| 66 | MiraPoint - WebMail Messages | Get SNMP Data (Indexed) | on |
| 67 | MiraPoint - CPU1 Usage | Get SNMP Data | on |
| 68 | MiraPoint - CPU2 Usage | Get SNMP Data | on |
| 69 | MiraPoint - IMAP Connections | Get SNMP Data | on |
| 70 | MiraPoint - SMTP Connections | Get SNMP Data | on |
| 71 | MiraPoint - SMTP Delivery Queue | Get SNMP Data | on |
| 72 | MiraPoint - SSL Connections | Get SNMP Data | on |
| 73 | APC - Output Amps | Get SNMP Data | on |
| 74 | APC - Battery Temperature | Get SNMP Data | on |
| 75 | APC - Input Frequency | Get SNMP Data | on |
| 76 | APC - Output Frequency | Get SNMP Data | on |
| 77 | APC - Output Load | Get SNMP Data | on |
| 78 | APC Smart UPS - Input Voltage | Get SNMP Data | on |
| 79 | APC Smart UPS - Output Voltage | Get SNMP Data | on |
| 80 | APC Smart UPS - Runtime | Get SNMP Data | on |
| 81 | APC Smart UPS - On Battery | Get SNMP Data | on |
| 82 | Cisco ASA - Current Connections | Get SNMP Data | on |
| 83 | Cisco ASA - IPsec Tunnels | Get SNMP Data | on |
| 84 | Cisco ASA - AnyConnect Tunnels | Get SNMP Data | on |
| 85 | Cisco ASA - WebVPN Tunnels | Get SNMP Data | on |
| 86 | Cisco ASA - IPsec L2L Tunnels | Get SNMP Data | on |
| 87 | Cisco ASA - IKE Dropped Packets - dropped_in | Get SNMP Data | on |
| 88 | Cisco ASA - IKE Dropped Packets - dropped_out | Get SNMP Data | on |
| 89 | Cisco ASA - IKE Traffic - traffic_out | Get SNMP Data | on |
| 90 | Cisco ASA - IKE Traffic - traffic_in | Get SNMP Data | on |
| 91 | Cisco ASA - Memory Free | Get SNMP Data | on |
| 92 | Cisco ASA - Memory Used | Get SNMP Data | on |
| 93 | Cisco ASA - 5 Minute CPU | Get SNMP Data | on |
| 94 | | Get SNMP Data (Indexed) | on |
| 116 | APC - Last Transfer | Get SNMP Data | on |
| 115 | APC - External Temp Threshold | Get SNMP Data | on |
| 114 | APC - External Temperature | Get SNMP Data | on |
| 112 | APC - Battery Runtime | Get SNMP Data | on |
| 113 | APC - Battery # Total Packs | Get SNMP Data | on |
| 110 | VMware ESX - VM NIC traffic | Get Script Server Data (Indexed) | on |
| 111 | APC - Battery Capacity | Get SNMP Data | on |
| 109 | VMware ESX - VM NIC packets | Get Script Server Data (Indexed) | on |
| 107 | VMware ESX - VM disk read/write (kB) | Get Script Server Data (Indexed) | on |
| 108 | VMware ESX - VM memory usage | Get Script Server Data (Indexed) | on |
| 106 | VMware ESX - VM disk read/write operations | Get Script Server Data (Indexed) | on |
| 104 | Cyan Chassis - FEC Errors | Get SNMP Data (Indexed) | on |
| 105 | VMware ESX - VM CPU usage | Get Script Server Data (Indexed) | on |
| 103 | APC - Battery # Bad Packs | Get SNMP Data | on |
| 95 | Interface - Upstream FEC | Get SNMP Data (Indexed) | on |
| 96 | Interface - Bandwidth Utilization | Get SNMP Data (Indexed) | on |
| 97 | Interface - Modems per Upstream | Get SNMP Data (Indexed) | on |
| 98 | Interface - UGS | Get SNMP Data (Indexed) | on |
| 99 | Interface - Upstream SNR | Get SNMP Data (Indexed) | on |
| 100 | Interface - Upstream Utilization | Get SNMP Data (Indexed) | on |
| 102 | IP Local Pool Summary | IP Local Pool Summary | on |
| 215 | C4 USx CMs | Get SNMP Data (Indexed) | on |
| 216 | C4 USx MER | Get SNMP Data (Indexed) | on |
| 101 | Cisco PPPoE Sessions | Get SNMP Data | on |
| 214 | C4 USx SNR | Get SNMP Data (Indexed) | on |
| 117 | APC - Output KvA Threshold | Get SNMP Data | on |
| 118 | APC - Output KvA | Get SNMP Data | on |
| 119 | APC PDU Phase 1 Load | Get SNMP Data | on |
| 120 | APC PDU Phase 2 Load | Get SNMP Data | on |
| 121 | APC PDU Phase 3 Load | Get SNMP Data | on |
| 122 | APC Rack PDU - Load Phase 1 | Get SNMP Data | on |
| 123 | APC Rack PDU - Load Phase 2 | Get SNMP Data | on |
| 124 | APC Rack PDU - Load Phase 3 | Get SNMP Data | on |
| 125 | APC Rack PDU - Low Threshold Level | Get SNMP Data | on |
| 126 | APC Rack PDU - Overload Level | Get SNMP Data | on |
| 127 | APC Rack PDU - Warning Level | Get SNMP Data | on |
| 128 | Cisco 65xx - SFP statistics | Get Script Data (Indexed) | on |
| 129 | Cisco Transceiver Current Data Template | Get SNMP Data | on |
| 130 | CNI Custom Cisco ENVMON Temp | Get SNMP Data | on |
| 131 | Dakus - Show Table Entries | Get SNMP Data (Indexed) | on |
| 132 | ESXi - CPU Load per VM | ESXi - stats | on |
| 133 | ESXi - CPU Load per VS | ESXi - stats | on |
| 134 | ESXi - IO Load per VM | ESXi - stats | on |
| 135 | ESXi - IO Load per VS | ESXi - stats | on |
| 136 | ESXi - MEM Load per VM | ESXi - stats | on |
| 137 | ESXi - MEM Load per VS | ESXi - stats | on |
| 138 | ESXi - NET Load per VM | ESXi - stats | on |
| 139 | ESXi - NET Load per VS | ESXi - stats | on |
| 140 | Foundry - CPU | Get SNMP Data | on |
| 141 | Foundry - Memory | Get SNMP Data | on |
| 142 | Foundry SI - Aged Sessions | Get SNMP Data | on |
| 143 | Foundry SI - Connections | Get SNMP Data | on |
| 144 | Foundry SI - Drops | Get SNMP Data | on |
| 145 | Foundry SI - FIN/RST Sessions | Get SNMP Data | on |
| 146 | Foundry SI - Sessions | Get SNMP Data | on |
| 147 | Individual Cable Modem | Individual CM Graphing | on |
| 148 | TrippLite EstimatedChargeRemaining | Get SNMP Data | on |
| 149 | TrippLite upsBatteryVoltage | Get SNMP Data | on |
| 150 | TrippLite upsInputVoltage | Get SNMP Data | on |
| 151 | TrippLite upsOutputVoltage | Get SNMP Data | on |
| 152 | TrippLite upsSecondsOnBattery | Get SNMP Data | on |
| 153 | VMware ESX - ESX Memory - Console | Get SNMP Data | on |
| 154 | VMware ESX - ESX Memory - Free | Get SNMP Data | on |
| 155 | VMware ESX - ESX Memory - Total | Get SNMP Data | on |
| 156 | VMware ESXi - CPU Load | ESXi - Get CPU Load | on |
| 157 | VMware ESXi - MEM Usage | ESXi - Get MEM Load | on |
| 158 | VMware ESXi - Network Usage | ESXi - Get NET Load | on |
| 159 | VMware ESX - VMFS Usage | ESX - VMFS check | on |
| 160 | DHCP Used Leases | Get DHCP Count | on |
| 161 | NetApp Cache Age | Get SNMP Data | on |
| 162 | NetApp CPU % Busy | Get SNMP Data | on |
| 163 | NetApp NFS Ops - 64-bit | Get SNMP Data | on |
| 164 | NetApp Cifs Ops - 64-bit | Get SNMP Data | on |
| 165 | NetApp Http Ops - 64-bit | Get SNMP Data | on |
| 166 | NetApp iSCSI Ops - 64-bit | Get SNMP Data | on |
| 167 | NetApp FCP Ops - 64-bit | Get SNMP Data | on |
| 168 | Percona MyISAM Indexes DT | Percona Get MySQL Stats/MyISAM Indexes IM | on |
| 169 | Percona MyISAM Key Cache DT | Percona Get MySQL Stats/MyISAM Key Cache IM | on |
| 170 | Percona InnoDB Buffer Pool DT | Percona Get MySQL Stats/InnoDB Buffer Pool IM | on |
| 171 | Percona InnoDB I/O DT | Percona Get MySQL Stats/InnoDB I/O IM | on |
| 172 | Percona InnoDB Insert Buffer DT | Percona Get MySQL Stats/InnoDB Insert Buffer IM | on |
| 173 | Percona InnoDB Insert Buffer Usage DT | Percona Get MySQL Stats/InnoDB Insert Buffer Usage IM | on |
| 174 | Percona InnoDB Semaphores DT | Percona Get MySQL Stats/InnoDB Semaphores IM | on |
| 175 | Percona InnoDB Row Operations DT | Percona Get MySQL Stats/InnoDB Row Operations IM | on |
| 176 | Percona MySQL Table Locks DT | Percona Get MySQL Stats/MySQL Table Locks IM | on |
| 177 | Percona MySQL Connections DT | Percona Get MySQL Stats/MySQL Connections IM | on |
| 178 | Percona MySQL Replication DT | Percona Get MySQL Stats/MySQL Replication IM | on |
| 179 | Percona MySQL Query Cache DT | Percona Get MySQL Stats/MySQL Query Cache IM | on |
| 180 | Percona MySQL Query Cache Memory DT | Percona Get MySQL Stats/MySQL Query Cache Memory IM | on |
| 181 | Percona MySQL Command Counters DT | Percona Get MySQL Stats/MySQL Command Counters IM | on |
| 182 | Percona MySQL Select Types DT | Percona Get MySQL Stats/MySQL Select Types IM | on |
| 183 | Percona MySQL Sorts DT | Percona Get MySQL Stats/MySQL Sorts IM | on |
| 184 | Percona MySQL Temporary Objects DT | Percona Get MySQL Stats/MySQL Temporary Objects IM | on |
| 185 | Percona MySQL Network Traffic DT | Percona Get MySQL Stats/MySQL Network Traffic IM | on |
| 186 | Percona InnoDB Buffer Pool Activity DT | Percona Get MySQL Stats/InnoDB Buffer Pool Activity IM | on |
| 187 | Percona InnoDB I/O Pending DT | Percona Get MySQL Stats/InnoDB I/O Pending IM | on |
| 188 | Percona InnoDB Log DT | Percona Get MySQL Stats/InnoDB Log IM | on |
| 189 | Percona MySQL Binary/Relay Logs DT | Percona Get MySQL Stats/MySQL Binary/Relay Logs IM | on |
| 190 | Percona InnoDB Transactions DT | Percona Get MySQL Stats/InnoDB Transactions IM | on |
| 191 | Percona InnoDB Transactions Active/Locked DT | Percona Get MySQL Stats/InnoDB Transactions Active/Locked IM | on |
| 192 | Percona MySQL Files and Tables DT | Percona Get MySQL Stats/MySQL Files and Tables IM | on |
| 193 | Percona MySQL Threads DT | Percona Get MySQL Stats/MySQL Threads IM | on |
| 194 | Percona InnoDB Memory Allocation DT | Percona Get MySQL Stats/InnoDB Memory Allocation IM | on |
| 195 | Percona InnoDB Adaptive Hash Index DT | Percona Get MySQL Stats/InnoDB Adaptive Hash Index IM | on |
| 196 | Percona InnoDB Internal Hash Memory Usage DT | Percona Get MySQL Stats/InnoDB Internal Hash Memory Usage IM | on |
| 197 | Percona InnoDB Tables In Use DT | Percona Get MySQL Stats/InnoDB Tables In Use IM | on |
| 198 | Percona InnoDB Current Lock Waits DT | Percona Get MySQL Stats/InnoDB Current Lock Waits IM | on |
| 199 | Percona InnoDB Lock Structures DT | Percona Get MySQL Stats/InnoDB Lock Structures IM | on |
| 200 | Percona InnoDB Checkpoint Age DT | Percona Get MySQL Stats/InnoDB Checkpoint Age IM | on |
| 201 | Percona InnoDB Row Lock Time DT | Percona Get MySQL Stats/InnoDB Row Lock Time IM | on |
| 202 | Percona InnoDB Row Lock Waits DT | Percona Get MySQL Stats/InnoDB Row Lock Waits IM | on |
| 203 | Percona InnoDB Semaphore Waits DT | Percona Get MySQL Stats/InnoDB Semaphore Waits IM | on |
| 204 | Percona InnoDB Semaphore Wait Time DT | Percona Get MySQL Stats/InnoDB Semaphore Wait Time IM | on |
| 205 | Percona MySQL Processlist DT | Percona Get MySQL Stats/MySQL Processlist IM | on |
| 206 | Percona MySQL Transaction Handler DT | Percona Get MySQL Stats/MySQL Transaction Handler IM | on |
| 207 | Percona MySQL Handlers DT | Percona Get MySQL Stats/MySQL Handlers IM | on |
| 208 | Percona MySQL Query Time Histogram (Count) DT | Percona Get MySQL Stats/MySQL Query Time Histogram (Count) IM | on |
| 209 | Percona MySQL Query Response Time (Microseconds) DT | Percona Get MySQL Stats/MySQL Query Response Time (Microseconds) IM | on |
| 210 | Interface - Traffic | Get SNMP Data (Indexed) | on |
| 213 | Z1- Docsis SNR | Get SNMP Data (Indexed) | on |
| 212 | DOCSIS - CMTS CM Counts | DOCSIS - CMTS CM Count | on |
| 217 | C4 USx FEC | Get SNMP Data (Indexed) | on |
| 231 | Air5_5 CPE Info | Get SNMP Data (Indexed) | on |
| 218 | Cisco EnvMon Temperature | Get SNMP Data (Indexed) | on |
| 223 | ASR 9k Temperature (SNMP INDEXED) | Get SNMP Data (Indexed) | on |
| 255 | DHCP/Kea Lease Usage | DHCP/Kea Lease Usage | on |
| 226 | AirOS-5.5 Signal | Get SNMP Data | on |
| 225 | Mikrotik - System - Uptime | Get SNMP Data | on |
| 229 | AirOS-5.5 TX MOD | Get SNMP Data | on |
| 230 | AirOS-5.5 RX MOD | Get SNMP Data | on |
| 235 | Cyan Z33 Envmon | Get SNMP Data (Indexed) | on |
| 236 | Cyan Z77 Envmon | Get SNMP Data (Indexed) | on |
| 295 | Raisecomm-3048-Temp | Get SNMP Data | on |
| 257 | Cisco Environmental Power - 7xxx | Get SNMP Data (Indexed) | on |
| 247 | Cisco 7200 PPPOE Sessions | Get SNMP Data (Indexed) | on |
| 254 | Eltek Rectifier Current | Get SNMP Data (Indexed) | on |
| 250 | Accedian Optical Power | Get SNMP Data (Indexed) | on |
| 258 | Cisco - EnvMon - Power | Get SNMP Data (Indexed) | on |
| 272 | BSD PPPOE Count | BSD PPPOE SNMP Counter Scripted | on |
| 271 | Arris C4c Temperature | Get SNMP Data (Indexed) | on |
| 259 | Accedian Temperature | Get SNMP Data (Indexed) | on |
| 260 | Accedian CPU Usage | Get SNMP Data (Indexed) | on |
| 263 | Accedian System uptime | Get SNMP Data (Indexed) | on |
| 264 | Cyan z33 Current | Get SNMP Data (Indexed) | on |
| 266 | Cyan z33 Voltages | Get SNMP Data (Indexed) | on |
| 274 | vc2900e-cabinet-internal-temp | vc2900e-cabinet | on |
| 275 | vc2900e-cabinet-ambienttemp | vc2900e-cabinet | on |
| 276 | vc2900e-cabinet-pressurepipetemp | vc2900e-cabinet | on |
| 277 | vc2900e-cabinet-setpointtemp | vc2900e-cabinet | on |
| 278 | vc2900e-cabinet-fantrayspeed | vc2900e-cabinet | on |
| 279 | vc2900e-cabinet-compressor | vc2900e-cabinet | on |
| 280 | vc2900e-cabinet-damper | vc2900e-cabinet | on |
| 285 | Corero Interfaces | Get SNMP Data (Indexed) | on |
| 281 | Corero Addresses | Get SNMP Data (Indexed) | on |
| 282 | Corero Flows | Get SNMP Data (Indexed) | on |
| 283 | Corero Setups | Get SNMP Data (Indexed) | on |
| 284 | Corero Rules | Get SNMP Data (Indexed) | on |
| 287 | Cyan 10G Port RxTx Power | Get SNMP Data (Indexed) | on |
| 302 | | NULL | NULL |
| 303 | | NULL | NULL |
| 297 | | NULL | NULL |
| 298 | | NULL | NULL |
| 299 | | NULL | NULL |
| 300 | | NULL | NULL |
| 301 | | NULL | NULL |
| 293 | Raisecomm-3048-CPU | Get SNMP Data | on |
| 294 | Raisecomm-3048-Memory | Get SNMP Data (Indexed) | on |
+-----+-----------------------------------------------------+---------------------------------------------------------------------+--------+
262 rows in set (0.00 sec)
mysql>
I think this has something to do with the blank entries. any suggestions as to how to fix this?
+-----+-----------------------------------------------------+---------------------------------------------------------------------+--------+
| id | name | data_input_method | active |
+-----+-----------------------------------------------------+---------------------------------------------------------------------+--------+
| 3 | ucd/net - Hard Drive Space | Get SNMP Data (Indexed) | on |
| 4 | ucd/net - CPU Usage - System | Get SNMP Data | on |
| 5 | ucd/net - CPU Usage - User | Get SNMP Data | on |
| 6 | ucd/net - CPU Usage - Nice | Get SNMP Data | on |
| 7 | Karlnet - Noise Level | Get SNMP Data (Indexed) | on |
| 8 | Karlnet - Signal Level | Get SNMP Data (Indexed) | on |
| 9 | Karlnet - Wireless Transmits | Get SNMP Data (Indexed) | on |
| 10 | Karlnet - Wireless Re-Transmits | Get SNMP Data (Indexed) | on |
| 11 | Unix - Load Average | Unix - Get Load Average | on |
| 13 | Linux - Memory - Free | Linux - Get Memory Usage | on |
| 15 | Linux - Memory - Free Swap | Linux - Get Memory Usage | on |
| 16 | Unix - Processes | Unix - Get System Processes | on |
| 17 | Unix - Logged in Users | Unix - Get Logged In Users | on |
| 18 | Unix - Ping Host | Unix - Ping Host | on |
| 19 | Netware - Total Users | Get SNMP Data | on |
| 20 | Netware - Total Logins | Get SNMP Data | on |
| 22 | Netware - File System Reads | Get SNMP Data | on |
| 23 | Netware - File System Writes | Get SNMP Data | on |
| 24 | Netware - Cache Checks | Get SNMP Data | on |
| 25 | Netware - Cache Hits | Get SNMP Data | on |
| 26 | Netware - Open Files | Get SNMP Data | on |
| 27 | Cisco Router - 5 Minute CPU | Get SNMP Data | on |
| 30 | ucd/net - Load Average - 1 Minute | Get SNMP Data | on |
| 31 | ucd/net - Load Average - 5 Minute | Get SNMP Data | on |
| 32 | ucd/net - Load Average - 15 Minute | Get SNMP Data | on |
| 33 | ucd/net - Memory - Buffers | Get SNMP Data | on |
| 34 | ucd/net - Memory - Free | Get SNMP Data | on |
| 35 | Netware - Volumes | Get SNMP Data (Indexed) | on |
| 36 | Netware - Directory Entries | Get SNMP Data (Indexed) | on |
| 37 | Unix - Hard Drive Space | Get Script Data (Indexed) | on |
| 38 | | Get SNMP Data (Indexed) | on |
| 39 | | Get SNMP Data (Indexed) | on |
| 40 | | Get SNMP Data (Indexed) | on |
| 41 | | Get SNMP Data (Indexed) | on |
| 42 | Netware - CPU Utilization | Get SNMP Data (Indexed) | on |
| 43 | Host MIB - Hard Drive Space | Get Script Server Data (Indexed) | on |
| 44 | Host MIB - CPU Utilization | Get Script Server Data (Indexed) | on |
| 45 | Host MIB - Processes | Get SNMP Data | on |
| 46 | Host MIB - Logged in Users | Get SNMP Data | on |
| 47 | ucd/net - Memory - Cache | Get SNMP Data | on |
| 48 | SNMP - Generic OID Template | Get SNMP Data | on |
| 246 | Cyan Gig Port RxTx Power | Get SNMP Data (Indexed) | on |
| 296 | Mimosa - System - Uptime | Get SNMP Data | on |
| 227 | AirOS_5.5 Channel | Get SNMP Data | on |
| 228 | AirOS-5.5 CPU | Get SNMP Data | on |
| 224 | Brocade - 1 Minute Average CPU Usage | Get SNMP Data (Indexed) | on |
| 248 | Cisco EnvMon Power | Get SNMP Data (Indexed) | on |
| 252 | Cisco UBR FEC Errors | Get SNMP Data (Indexed) | on |
| 291 | Raisecomm Memory | Get SNMP Data (Indexed) | on |
| 51 | User Counts from DB | Count Users From DB | on |
| 290 | Raisecomm Temerature | Get SNMP Data (Indexed) | on |
| 289 | Raisecomm CPU Usage | Get SNMP Data (Indexed) | on |
| 52 | MiraPoint - Storage Space | Get SNMP Data (Indexed) | on |
| 53 | MiraPoint - Users and Inboxes | Get SNMP Data (Indexed) | on |
| 54 | MiraPoint - Message Flow | Get SNMP Data (Indexed) | on |
| 55 | MiraPoint - Average Message Size | Get SNMP Data (Indexed) | on |
| 56 | MiraPoint - MTA Messages | Get SNMP Data (Indexed) | on |
| 57 | MiraPoint - MTA Recipients | Get SNMP Data (Indexed) | on |
| 58 | MiraPoint - RAID Storage | Get SNMP Data (Indexed) | on |
| 59 | MiraPoint - RAID Commands | Get SNMP Data (Indexed) | on |
| 60 | MiraPoint - RAID Throughput | Get SNMP Data (Indexed) | on |
| 61 | MiraPoint - RAID Latency | Get SNMP Data (Indexed) | on |
| 62 | MiraPoint - WebMail Sessions | Get SNMP Data (Indexed) | on |
| 63 | MiraPoint - WebMail Sort Operations | Get SNMP Data (Indexed) | on |
| 64 | MiraPoint - WebMail Times | Get SNMP Data (Indexed) | on |
| 65 | MiraPoint - WebMail Actions | Get SNMP Data (Indexed) | on |
| 66 | MiraPoint - WebMail Messages | Get SNMP Data (Indexed) | on |
| 67 | MiraPoint - CPU1 Usage | Get SNMP Data | on |
| 68 | MiraPoint - CPU2 Usage | Get SNMP Data | on |
| 69 | MiraPoint - IMAP Connections | Get SNMP Data | on |
| 70 | MiraPoint - SMTP Connections | Get SNMP Data | on |
| 71 | MiraPoint - SMTP Delivery Queue | Get SNMP Data | on |
| 72 | MiraPoint - SSL Connections | Get SNMP Data | on |
| 73 | APC - Output Amps | Get SNMP Data | on |
| 74 | APC - Battery Temperature | Get SNMP Data | on |
| 75 | APC - Input Frequency | Get SNMP Data | on |
| 76 | APC - Output Frequency | Get SNMP Data | on |
| 77 | APC - Output Load | Get SNMP Data | on |
| 78 | APC Smart UPS - Input Voltage | Get SNMP Data | on |
| 79 | APC Smart UPS - Output Voltage | Get SNMP Data | on |
| 80 | APC Smart UPS - Runtime | Get SNMP Data | on |
| 81 | APC Smart UPS - On Battery | Get SNMP Data | on |
| 82 | Cisco ASA - Current Connections | Get SNMP Data | on |
| 83 | Cisco ASA - IPsec Tunnels | Get SNMP Data | on |
| 84 | Cisco ASA - AnyConnect Tunnels | Get SNMP Data | on |
| 85 | Cisco ASA - WebVPN Tunnels | Get SNMP Data | on |
| 86 | Cisco ASA - IPsec L2L Tunnels | Get SNMP Data | on |
| 87 | Cisco ASA - IKE Dropped Packets - dropped_in | Get SNMP Data | on |
| 88 | Cisco ASA - IKE Dropped Packets - dropped_out | Get SNMP Data | on |
| 89 | Cisco ASA - IKE Traffic - traffic_out | Get SNMP Data | on |
| 90 | Cisco ASA - IKE Traffic - traffic_in | Get SNMP Data | on |
| 91 | Cisco ASA - Memory Free | Get SNMP Data | on |
| 92 | Cisco ASA - Memory Used | Get SNMP Data | on |
| 93 | Cisco ASA - 5 Minute CPU | Get SNMP Data | on |
| 94 | | Get SNMP Data (Indexed) | on |
| 116 | APC - Last Transfer | Get SNMP Data | on |
| 115 | APC - External Temp Threshold | Get SNMP Data | on |
| 114 | APC - External Temperature | Get SNMP Data | on |
| 112 | APC - Battery Runtime | Get SNMP Data | on |
| 113 | APC - Battery # Total Packs | Get SNMP Data | on |
| 110 | VMware ESX - VM NIC traffic | Get Script Server Data (Indexed) | on |
| 111 | APC - Battery Capacity | Get SNMP Data | on |
| 109 | VMware ESX - VM NIC packets | Get Script Server Data (Indexed) | on |
| 107 | VMware ESX - VM disk read/write (kB) | Get Script Server Data (Indexed) | on |
| 108 | VMware ESX - VM memory usage | Get Script Server Data (Indexed) | on |
| 106 | VMware ESX - VM disk read/write operations | Get Script Server Data (Indexed) | on |
| 104 | Cyan Chassis - FEC Errors | Get SNMP Data (Indexed) | on |
| 105 | VMware ESX - VM CPU usage | Get Script Server Data (Indexed) | on |
| 103 | APC - Battery # Bad Packs | Get SNMP Data | on |
| 95 | Interface - Upstream FEC | Get SNMP Data (Indexed) | on |
| 96 | Interface - Bandwidth Utilization | Get SNMP Data (Indexed) | on |
| 97 | Interface - Modems per Upstream | Get SNMP Data (Indexed) | on |
| 98 | Interface - UGS | Get SNMP Data (Indexed) | on |
| 99 | Interface - Upstream SNR | Get SNMP Data (Indexed) | on |
| 100 | Interface - Upstream Utilization | Get SNMP Data (Indexed) | on |
| 102 | IP Local Pool Summary | IP Local Pool Summary | on |
| 215 | C4 USx CMs | Get SNMP Data (Indexed) | on |
| 216 | C4 USx MER | Get SNMP Data (Indexed) | on |
| 101 | Cisco PPPoE Sessions | Get SNMP Data | on |
| 214 | C4 USx SNR | Get SNMP Data (Indexed) | on |
| 117 | APC - Output KvA Threshold | Get SNMP Data | on |
| 118 | APC - Output KvA | Get SNMP Data | on |
| 119 | APC PDU Phase 1 Load | Get SNMP Data | on |
| 120 | APC PDU Phase 2 Load | Get SNMP Data | on |
| 121 | APC PDU Phase 3 Load | Get SNMP Data | on |
| 122 | APC Rack PDU - Load Phase 1 | Get SNMP Data | on |
| 123 | APC Rack PDU - Load Phase 2 | Get SNMP Data | on |
| 124 | APC Rack PDU - Load Phase 3 | Get SNMP Data | on |
| 125 | APC Rack PDU - Low Threshold Level | Get SNMP Data | on |
| 126 | APC Rack PDU - Overload Level | Get SNMP Data | on |
| 127 | APC Rack PDU - Warning Level | Get SNMP Data | on |
| 128 | Cisco 65xx - SFP statistics | Get Script Data (Indexed) | on |
| 129 | Cisco Transceiver Current Data Template | Get SNMP Data | on |
| 130 | CNI Custom Cisco ENVMON Temp | Get SNMP Data | on |
| 131 | Dakus - Show Table Entries | Get SNMP Data (Indexed) | on |
| 132 | ESXi - CPU Load per VM | ESXi - stats | on |
| 133 | ESXi - CPU Load per VS | ESXi - stats | on |
| 134 | ESXi - IO Load per VM | ESXi - stats | on |
| 135 | ESXi - IO Load per VS | ESXi - stats | on |
| 136 | ESXi - MEM Load per VM | ESXi - stats | on |
| 137 | ESXi - MEM Load per VS | ESXi - stats | on |
| 138 | ESXi - NET Load per VM | ESXi - stats | on |
| 139 | ESXi - NET Load per VS | ESXi - stats | on |
| 140 | Foundry - CPU | Get SNMP Data | on |
| 141 | Foundry - Memory | Get SNMP Data | on |
| 142 | Foundry SI - Aged Sessions | Get SNMP Data | on |
| 143 | Foundry SI - Connections | Get SNMP Data | on |
| 144 | Foundry SI - Drops | Get SNMP Data | on |
| 145 | Foundry SI - FIN/RST Sessions | Get SNMP Data | on |
| 146 | Foundry SI - Sessions | Get SNMP Data | on |
| 147 | Individual Cable Modem | Individual CM Graphing | on |
| 148 | TrippLite EstimatedChargeRemaining | Get SNMP Data | on |
| 149 | TrippLite upsBatteryVoltage | Get SNMP Data | on |
| 150 | TrippLite upsInputVoltage | Get SNMP Data | on |
| 151 | TrippLite upsOutputVoltage | Get SNMP Data | on |
| 152 | TrippLite upsSecondsOnBattery | Get SNMP Data | on |
| 153 | VMware ESX - ESX Memory - Console | Get SNMP Data | on |
| 154 | VMware ESX - ESX Memory - Free | Get SNMP Data | on |
| 155 | VMware ESX - ESX Memory - Total | Get SNMP Data | on |
| 156 | VMware ESXi - CPU Load | ESXi - Get CPU Load | on |
| 157 | VMware ESXi - MEM Usage | ESXi - Get MEM Load | on |
| 158 | VMware ESXi - Network Usage | ESXi - Get NET Load | on |
| 159 | VMware ESX - VMFS Usage | ESX - VMFS check | on |
| 160 | DHCP Used Leases | Get DHCP Count | on |
| 161 | NetApp Cache Age | Get SNMP Data | on |
| 162 | NetApp CPU % Busy | Get SNMP Data | on |
| 163 | NetApp NFS Ops - 64-bit | Get SNMP Data | on |
| 164 | NetApp Cifs Ops - 64-bit | Get SNMP Data | on |
| 165 | NetApp Http Ops - 64-bit | Get SNMP Data | on |
| 166 | NetApp iSCSI Ops - 64-bit | Get SNMP Data | on |
| 167 | NetApp FCP Ops - 64-bit | Get SNMP Data | on |
| 168 | Percona MyISAM Indexes DT | Percona Get MySQL Stats/MyISAM Indexes IM | on |
| 169 | Percona MyISAM Key Cache DT | Percona Get MySQL Stats/MyISAM Key Cache IM | on |
| 170 | Percona InnoDB Buffer Pool DT | Percona Get MySQL Stats/InnoDB Buffer Pool IM | on |
| 171 | Percona InnoDB I/O DT | Percona Get MySQL Stats/InnoDB I/O IM | on |
| 172 | Percona InnoDB Insert Buffer DT | Percona Get MySQL Stats/InnoDB Insert Buffer IM | on |
| 173 | Percona InnoDB Insert Buffer Usage DT | Percona Get MySQL Stats/InnoDB Insert Buffer Usage IM | on |
| 174 | Percona InnoDB Semaphores DT | Percona Get MySQL Stats/InnoDB Semaphores IM | on |
| 175 | Percona InnoDB Row Operations DT | Percona Get MySQL Stats/InnoDB Row Operations IM | on |
| 176 | Percona MySQL Table Locks DT | Percona Get MySQL Stats/MySQL Table Locks IM | on |
| 177 | Percona MySQL Connections DT | Percona Get MySQL Stats/MySQL Connections IM | on |
| 178 | Percona MySQL Replication DT | Percona Get MySQL Stats/MySQL Replication IM | on |
| 179 | Percona MySQL Query Cache DT | Percona Get MySQL Stats/MySQL Query Cache IM | on |
| 180 | Percona MySQL Query Cache Memory DT | Percona Get MySQL Stats/MySQL Query Cache Memory IM | on |
| 181 | Percona MySQL Command Counters DT | Percona Get MySQL Stats/MySQL Command Counters IM | on |
| 182 | Percona MySQL Select Types DT | Percona Get MySQL Stats/MySQL Select Types IM | on |
| 183 | Percona MySQL Sorts DT | Percona Get MySQL Stats/MySQL Sorts IM | on |
| 184 | Percona MySQL Temporary Objects DT | Percona Get MySQL Stats/MySQL Temporary Objects IM | on |
| 185 | Percona MySQL Network Traffic DT | Percona Get MySQL Stats/MySQL Network Traffic IM | on |
| 186 | Percona InnoDB Buffer Pool Activity DT | Percona Get MySQL Stats/InnoDB Buffer Pool Activity IM | on |
| 187 | Percona InnoDB I/O Pending DT | Percona Get MySQL Stats/InnoDB I/O Pending IM | on |
| 188 | Percona InnoDB Log DT | Percona Get MySQL Stats/InnoDB Log IM | on |
| 189 | Percona MySQL Binary/Relay Logs DT | Percona Get MySQL Stats/MySQL Binary/Relay Logs IM | on |
| 190 | Percona InnoDB Transactions DT | Percona Get MySQL Stats/InnoDB Transactions IM | on |
| 191 | Percona InnoDB Transactions Active/Locked DT | Percona Get MySQL Stats/InnoDB Transactions Active/Locked IM | on |
| 192 | Percona MySQL Files and Tables DT | Percona Get MySQL Stats/MySQL Files and Tables IM | on |
| 193 | Percona MySQL Threads DT | Percona Get MySQL Stats/MySQL Threads IM | on |
| 194 | Percona InnoDB Memory Allocation DT | Percona Get MySQL Stats/InnoDB Memory Allocation IM | on |
| 195 | Percona InnoDB Adaptive Hash Index DT | Percona Get MySQL Stats/InnoDB Adaptive Hash Index IM | on |
| 196 | Percona InnoDB Internal Hash Memory Usage DT | Percona Get MySQL Stats/InnoDB Internal Hash Memory Usage IM | on |
| 197 | Percona InnoDB Tables In Use DT | Percona Get MySQL Stats/InnoDB Tables In Use IM | on |
| 198 | Percona InnoDB Current Lock Waits DT | Percona Get MySQL Stats/InnoDB Current Lock Waits IM | on |
| 199 | Percona InnoDB Lock Structures DT | Percona Get MySQL Stats/InnoDB Lock Structures IM | on |
| 200 | Percona InnoDB Checkpoint Age DT | Percona Get MySQL Stats/InnoDB Checkpoint Age IM | on |
| 201 | Percona InnoDB Row Lock Time DT | Percona Get MySQL Stats/InnoDB Row Lock Time IM | on |
| 202 | Percona InnoDB Row Lock Waits DT | Percona Get MySQL Stats/InnoDB Row Lock Waits IM | on |
| 203 | Percona InnoDB Semaphore Waits DT | Percona Get MySQL Stats/InnoDB Semaphore Waits IM | on |
| 204 | Percona InnoDB Semaphore Wait Time DT | Percona Get MySQL Stats/InnoDB Semaphore Wait Time IM | on |
| 205 | Percona MySQL Processlist DT | Percona Get MySQL Stats/MySQL Processlist IM | on |
| 206 | Percona MySQL Transaction Handler DT | Percona Get MySQL Stats/MySQL Transaction Handler IM | on |
| 207 | Percona MySQL Handlers DT | Percona Get MySQL Stats/MySQL Handlers IM | on |
| 208 | Percona MySQL Query Time Histogram (Count) DT | Percona Get MySQL Stats/MySQL Query Time Histogram (Count) IM | on |
| 209 | Percona MySQL Query Response Time (Microseconds) DT | Percona Get MySQL Stats/MySQL Query Response Time (Microseconds) IM | on |
| 210 | Interface - Traffic | Get SNMP Data (Indexed) | on |
| 213 | Z1- Docsis SNR | Get SNMP Data (Indexed) | on |
| 212 | DOCSIS - CMTS CM Counts | DOCSIS - CMTS CM Count | on |
| 217 | C4 USx FEC | Get SNMP Data (Indexed) | on |
| 231 | Air5_5 CPE Info | Get SNMP Data (Indexed) | on |
| 218 | Cisco EnvMon Temperature | Get SNMP Data (Indexed) | on |
| 223 | ASR 9k Temperature (SNMP INDEXED) | Get SNMP Data (Indexed) | on |
| 255 | DHCP/Kea Lease Usage | DHCP/Kea Lease Usage | on |
| 226 | AirOS-5.5 Signal | Get SNMP Data | on |
| 225 | Mikrotik - System - Uptime | Get SNMP Data | on |
| 229 | AirOS-5.5 TX MOD | Get SNMP Data | on |
| 230 | AirOS-5.5 RX MOD | Get SNMP Data | on |
| 235 | Cyan Z33 Envmon | Get SNMP Data (Indexed) | on |
| 236 | Cyan Z77 Envmon | Get SNMP Data (Indexed) | on |
| 295 | Raisecomm-3048-Temp | Get SNMP Data | on |
| 257 | Cisco Environmental Power - 7xxx | Get SNMP Data (Indexed) | on |
| 247 | Cisco 7200 PPPOE Sessions | Get SNMP Data (Indexed) | on |
| 254 | Eltek Rectifier Current | Get SNMP Data (Indexed) | on |
| 250 | Accedian Optical Power | Get SNMP Data (Indexed) | on |
| 258 | Cisco - EnvMon - Power | Get SNMP Data (Indexed) | on |
| 272 | BSD PPPOE Count | BSD PPPOE SNMP Counter Scripted | on |
| 271 | Arris C4c Temperature | Get SNMP Data (Indexed) | on |
| 259 | Accedian Temperature | Get SNMP Data (Indexed) | on |
| 260 | Accedian CPU Usage | Get SNMP Data (Indexed) | on |
| 263 | Accedian System uptime | Get SNMP Data (Indexed) | on |
| 264 | Cyan z33 Current | Get SNMP Data (Indexed) | on |
| 266 | Cyan z33 Voltages | Get SNMP Data (Indexed) | on |
| 274 | vc2900e-cabinet-internal-temp | vc2900e-cabinet | on |
| 275 | vc2900e-cabinet-ambienttemp | vc2900e-cabinet | on |
| 276 | vc2900e-cabinet-pressurepipetemp | vc2900e-cabinet | on |
| 277 | vc2900e-cabinet-setpointtemp | vc2900e-cabinet | on |
| 278 | vc2900e-cabinet-fantrayspeed | vc2900e-cabinet | on |
| 279 | vc2900e-cabinet-compressor | vc2900e-cabinet | on |
| 280 | vc2900e-cabinet-damper | vc2900e-cabinet | on |
| 285 | Corero Interfaces | Get SNMP Data (Indexed) | on |
| 281 | Corero Addresses | Get SNMP Data (Indexed) | on |
| 282 | Corero Flows | Get SNMP Data (Indexed) | on |
| 283 | Corero Setups | Get SNMP Data (Indexed) | on |
| 284 | Corero Rules | Get SNMP Data (Indexed) | on |
| 287 | Cyan 10G Port RxTx Power | Get SNMP Data (Indexed) | on |
| 302 | | NULL | NULL |
| 303 | | NULL | NULL |
| 297 | | NULL | NULL |
| 298 | | NULL | NULL |
| 299 | | NULL | NULL |
| 300 | | NULL | NULL |
| 301 | | NULL | NULL |
| 293 | Raisecomm-3048-CPU | Get SNMP Data | on |
| 294 | Raisecomm-3048-Memory | Get SNMP Data (Indexed) | on |
+-----+-----------------------------------------------------+---------------------------------------------------------------------+--------+
262 rows in set (0.00 sec)
mysql>
I think this has something to do with the blank entries. any suggestions as to how to fix this?
Re: A rather unique situation i desperately need help with
So there seems to be two problems here. One is that the name of the data templates appear to be null. The other is that links back to the data_input type are also not working.
Post the results of that and lets decide what to do once we know what the full data looks like.
Code: Select all
SELECT * FROM data_template LEFT JOIN data_template_data ON data_template.id = data_template_data.data_template_id WHERE data_template.name is nullCacti Developer & Release Manager
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
-
camerabob
- Cacti User
- Posts: 386
- Joined: Fri Feb 10, 2017 2:45 pm
- Location: Long Island, New York, USA
- Contact:
Re: A rather unique situation i desperately need help with
I don't think there is a coincidence that the number of null entries in the top image is the same as the number of posted entries in the list (297-302).
Prod: Cacti 1.2.15 @ CentOS Linux release 7.9.2009 (Core) & PHP 5.4.16-48.el7
Maint @ 1.2
Monitor @ 2.3.6
Thold @ 1.2.4
Temp: Cacti 1.2.3 @ CentOS Linux release 7.9.2009 (Core) & PHP 5.4.16-48.el7
Flowview @ 2.1
Mactrack @ 4.2
Maint @ 1.2
Monitor @ 2.3.6
Router Configs @ 1.3.4
Syslog Monitoring @ 2.1
Thold @ 1.2.4
Maint @ 1.2
Monitor @ 2.3.6
Thold @ 1.2.4
Temp: Cacti 1.2.3 @ CentOS Linux release 7.9.2009 (Core) & PHP 5.4.16-48.el7
Flowview @ 2.1
Mactrack @ 4.2
Maint @ 1.2
Monitor @ 2.3.6
Router Configs @ 1.3.4
Syslog Monitoring @ 2.1
Thold @ 1.2.4
Re: A rather unique situation i desperately need help with
Agreed, hence asking for the output, but what we do with the template, depends on what we see.
Cacti Developer & Release Manager
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
-
RustedKnight
- Posts: 39
- Joined: Fri Mar 18, 2016 8:49 am
Re: A rather unique situation i desperately need help with
no results for the last querry
mysql> SELECT * FROM data_template LEFT JOIN data_template_data ON data_template.id = data_template_data.data_template_id WHERE data_template.name is null;
Empty set (0.00 sec)
mysql>
mysql> SELECT * FROM data_template LEFT JOIN data_template_data ON data_template.id = data_template_data.data_template_id WHERE data_template.name is null;
Empty set (0.00 sec)
mysql>
-
camerabob
- Cacti User
- Posts: 386
- Joined: Fri Feb 10, 2017 2:45 pm
- Location: Long Island, New York, USA
- Contact:
Re: A rather unique situation i desperately need help with
Should 'null' be in caps to match the values?
Prod: Cacti 1.2.15 @ CentOS Linux release 7.9.2009 (Core) & PHP 5.4.16-48.el7
Maint @ 1.2
Monitor @ 2.3.6
Thold @ 1.2.4
Temp: Cacti 1.2.3 @ CentOS Linux release 7.9.2009 (Core) & PHP 5.4.16-48.el7
Flowview @ 2.1
Mactrack @ 4.2
Maint @ 1.2
Monitor @ 2.3.6
Router Configs @ 1.3.4
Syslog Monitoring @ 2.1
Thold @ 1.2.4
Maint @ 1.2
Monitor @ 2.3.6
Thold @ 1.2.4
Temp: Cacti 1.2.3 @ CentOS Linux release 7.9.2009 (Core) & PHP 5.4.16-48.el7
Flowview @ 2.1
Mactrack @ 4.2
Maint @ 1.2
Monitor @ 2.3.6
Router Configs @ 1.3.4
Syslog Monitoring @ 2.1
Thold @ 1.2.4
-
RustedKnight
- Posts: 39
- Joined: Fri Mar 18, 2016 8:49 am
Re: A rather unique situation i desperately need help with
Actually, looking at what is trying to be accomplished, there is no way to get what is being looked for based on what I know about SQL. Granted, I am no expert. But the field we are searching for does not contain the word null in any way shape or form. The select should be grabbing fields that have no content but I'm not sure how to write that up.
Who is online
Users browsing this forum: No registered users and 2 guests