packetfence_toemegesen_lejaro_regek [GEO Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== userek ======
ha a user maga regisztrálja magát, akkor ezt a dátumot kapja az eszköz
<code>
SELECT * FROM `password` WHERE expiration = '2020-01-01 00:00:00';
UPDATE `password` SET expiration = '2021-01-01 00:00:00' WHERE expiration = '2020-01-01 00:00:00'
</code>

====== node-ok ======
azok a regisztráltak, akik regisztrációja `*unregdate*`-kor jár le
<code>
SELECT `mac`,`pid`,`category_id`,`regdate`,`unregdate`,`status`,`computername` FROM `node` WHERE `status`='reg' AND category_id>0 AND `unregdate`= '2021-01-01 00:00:00' ;

SELECT `mac`,`pid`,`category_id`,`regdate`,`unregdate`,`status`,`computername` FROM `node` WHERE `unregdate` > '2020-01-01 00:00:00' AND category_id <> 2 AND pid='default' ORDER BY `unregdate`;
</code>
mikor kapott dhcp-t utoljára
<code>
SELECT mac,pid,category_id,unregdate,`status`,computername,last_dhcp FROM node WHERE last_dhcp > '2020-01-01 00:00:00' ORDER BY last_dhcp;

SELECT mac,pid,category_id,regdate,unregdate,`status`,computername,last_dhcp FROM node WHERE last_dhcp < '2019-01-01 00:00:00' AND STATUS='reg' ORDER BY last_dhcp DESC;
</code>
azok az eszközök, amik `*dátum*` előtt kaptak dhcp-től utoljára IP-t
<code>
SELECT COUNT(*) FROM node WHERE last_dhcp < '2019-01-01 00:00:00' AND STATUS='reg' ORDER BY last_dhcp DESC;
</code>