Изменения
Нет описания правки
= Найти свободные диапазоны UID , выполнять в DBeaver =
AND gap_end >= 10000; -- if you need a specific range
</pre>
= Найти свободные диапазоны в номерах вланов, выполнять в DBeaver =
<pre>
-- Select gaps in Vlan number ranges
SELECT gaps.*, gaps.gap_end - gaps.gap_start + 1 AS gap_size
FROM (
SELECT z.expected AS gap_start, IF(z.got - 1 > z.expected, z.got - 1, z.expected) AS gap_end
FROM (
SELECT @rownum := CONVERT(@rownum + 1, SIGNED INTEGER) AS expected, IF(@rownum = number, 0, @rownum := number) AS got
FROM (SELECT @rownum := 0) AS a
JOIN Vlan
ORDER BY number
) AS z
WHERE z.got != 0
UNION
SELECT MAX(number) + 1 AS gap_start, 4096 AS gap_end FROM Vlan
) AS gaps
WHERE gap_start <= gap_end
AND gap_end >= 1 -- if you need a specific range
ORDER BY gap_size DESC;
</pre>
= Выбор юзеров вместе в полными адресами в файл=
