Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision 		Previous revision
packetfence_toemegesen_lejaro_regek [2020/01/02 09:01]
annargy created 		packetfence_toemegesen_lejaro_regek [2020/01/02 10:49] (current)
annargy [node-ok]
Line 1: Line 1:
 ====== userek ====== ====== userek ======
 +ha a user maga regisztrálja magát, akkor ezt a dátumot kapja az eszköz
 <code> <code>
 SELECT * FROM `password` WHERE expiration = '2020-01-01 00:00:00'; 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' UPDATE `password` SET expiration = '2021-01-01 00:00:00' WHERE expiration = '2020-01-01 00:00:00'
 </code> </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>
 +