MAS32 identification tables librenms - IlanRuiz/Cours-TechES GitHub Wiki
Identifications des tables librenms
Se connecter à l'instance local de mariadb
sudo mysql
Afficher les tables présentes
#Utiliser la db librenms
use librenms;
#afficher les tables
show tables;
output:
+--------------------------------+
| Tables_in_librenms |
+--------------------------------+
| abilities |
| access_points |
| alert_device_map |
| alert_group_map |
| alert_location_map |
| alert_log |
| alert_rules |
| alert_schedulables |
| alert_schedule |
| alert_template_map |
| alert_templates |
| alert_transport_groups |
| alert_transport_map |
| alert_transports |
| alerts |
| api_tokens |
| application_metrics |
| applications |
| assigned_roles |
| authlog |
| availability |
| bgpPeers |
| bgpPeers_cbgp |
| bill_data |
| bill_history |
| bill_perms |
| bill_port_counters |
| bill_ports |
| bills |
| cache |
| cache_locks |
| callback |
| cef_switching |
| ciscoASA |
| component |
| component_prefs |
| component_statuslog |
| config |
| custom_map_backgrounds |
| custom_map_edges |
| custom_map_nodes |
| custom_maps |
| customers |
| customoids |
| dashboards |
| device_graphs |
| device_group_device |
| device_groups |
| device_outages |
| device_perf |
| device_relationships |
| devices |
| devices_attribs |
| devices_group_perms |
| devices_perms |
| entPhysical |
| entPhysical_state |
| entityState |
| eventlog |
| graph_types |
| hrDevice |
| hrSystem |
| ipsec_tunnels |
| ipv4_addresses |
| ipv4_mac |
| ipv4_networks |
| ipv6_addresses |
| ipv6_networks |
| isis_adjacencies |
| juniAtmVp |
| links |
| loadbalancer_rservers |
| loadbalancer_vservers |
| locations |
| mac_accounting |
| mefinfo |
| mempools |
| migrations |
| mpls_lsp_paths |
| mpls_lsps |
| mpls_saps |
| mpls_sdp_binds |
| mpls_sdps |
| mpls_services |
| mpls_tunnel_ar_hops |
| mpls_tunnel_c_hops |
| munin_plugins |
| munin_plugins_ds |
| netscaler_vservers |
| notifications |
| notifications_attribs |
| ospf_areas |
| ospf_instances |
| ospf_nbrs |
| ospf_ports |
| packages |
| pdb_ix |
| pdb_ix_peers |
| permissions |
| plugins |
| poller_cluster |
| poller_cluster_stats |
| poller_groups |
| pollers |
| port_group_port |
| port_groups |
| ports |
| ports_adsl |
| ports_fdb |
| ports_nac |
| ports_perms |
| ports_stack |
| ports_statistics |
| ports_stp |
| ports_vdsl |
| ports_vlans |
| printer_supplies |
| processes |
| processors |
| proxmox |
| proxmox_ports |
| pseudowires |
| push_subscriptions |
| roles |
| route |
| sensors |
| sensors_to_state_indexes |
| service_templates |
| service_templates_device |
| service_templates_device_group |
| services |
| session |
| sessions |
| slas |
| state_indexes |
| state_translations |
| storage |
| stp |
| syslog |
| tnmsneinfo |
| transport_group_transport |
| ucd_diskio |
| users |
| users_prefs |
| users_widgets |
| vendor_ouis |
| vlans |
| vminfo |
| vrf_lite_cisco |
| vrfs |
| wireless_sensors |
+--------------------------------+
151 rows in set (0.003 sec)
Afficher la structure de la colonne "devices"
show columns from devices;
Lister les données shouaitées (Hôte)
select hostname from devices;
output
+--------------+
| hostname |
+--------------+
| 10.10.10.134 |
| 10.10.10.36 |
| localhost |
+--------------+
3 rows in set (0.002 sec)
Lister les alertes présentes
MariaDB [librenms]> show columns from alert_rules;
+------------+---------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| rule | text | NO | | NULL | |
| severity | enum('ok','warning','critical') | NO | | NULL | |
| extra | varchar(255) | NO | | NULL | |
| disabled | tinyint(1) | NO | | NULL | |
| name | varchar(255) | NO | UNI | NULL | |
| query | text | NO | | NULL | |
| builder | text | NO | | NULL | |
| proc | varchar(80) | YES | | NULL | |
| invert_map | tinyint(1) | NO | | 0 | |
+------------+---------------------------------+------+-----+---------+----------------+
10 rows in set (0.002 sec)
MariaDB [librenms]> select name from alert_rules;
+-------------------------------------+
| name |
+-------------------------------------+
| Services Debian |
| Services windows |
| Win Processor usage over 20% |
| Win Processor usage over 20% - Copy |
+-------------------------------------+
4 rows in set (0.001 sec)