Beispiele für SQL-Reports

alle VLANs mit Subnets

MS SQL-Server

SELECT 
  tbltag.strVlanId ID,
  tbltag.strName VLAN,
  tbltag.strDescription Beschreibung,
  CONCAT(tbltaggroup.strName, "/", tbltaggroup.intCIDR) Subnet
FROM
  tbltag
LEFT JOIN tbltaggroup
ON
  tbltag.intId_pk = tbltaggroup.intVlanId_fk
WHERE
  tbltag.strClassName = "TBoNisTagVLAN"
ORDER BY ID ASC

SQLite

SELECT 
  tbltag.strVlanId ID,
  tbltag.strName VLAN,
  tbltag.strDescription Beschreibung,
  tbltaggroup.strName || '/' || tbltaggroup.intCIDR Subnet
FROM
  tbltag
LEFT JOIN tbltaggroup
ON
  tbltag.intId_pk = tbltaggroup.intVlanId_fk
WHERE
  tbltag.strClassName = "TBoNisTagVLAN"
ORDER BY ID ASC