Aller au contenu

Vue Equipements par VLAN

Equipements filtres par VLAN sur le site Vonnas

Tous les equipements avec leurs VLANs

TABLE
  vlans AS "VLANs",
  ips AS "IPs",
  type_equipement AS "Type",
  criticite AS "Crit."
FROM "vonnas/equipements"
WHERE type_equipement != null
SORT vlans ASC

VLAN 230 — LAN_SERVEUR (10.1.230.0/24)

TABLE
  ips AS "IPs",
  type_equipement AS "Type",
  criticite AS "Crit."
FROM "vonnas/equipements"
WHERE contains(vlans, "V230")
SORT equipement ASC

VLAN 250 — LAN_MGMT (10.1.250.0/24)

TABLE
  ips AS "IPs",
  type_equipement AS "Type",
  criticite AS "Crit."
FROM "vonnas/equipements"
WHERE contains(vlans, "V250")
SORT equipement ASC

VLAN 110 — LAN_INDUS_GEST (10.1.1.0/24)

TABLE
  ips AS "IPs",
  type_equipement AS "Type",
  criticite AS "Crit."
FROM "vonnas/equipements"
WHERE contains(vlans, "V110")
SORT equipement ASC

VLAN 1 — LAN_ADMIN (128.55.55.0/24)

TABLE
  ips AS "IPs",
  type_equipement AS "Type",
  criticite AS "Crit."
FROM "vonnas/equipements"
WHERE contains(vlans, "V1")
SORT equipement ASC

Voir aussi