Differences

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

Link to this comparison view

Both sides previous revision Previous revision
packetfence_toemegesen_lejaro_regek [2020/01/02 10:46]
annargy [userek] 		packetfence_toemegesen_lejaro_regek [2020/01/02 10:49] (current)
annargy [node-ok]
Line 7: Line 7:
  
 ====== node-ok ====== ====== node-ok ======
-azok a regisztráltak, akik regisztrációja unregdate-kor jár le+azok a regisztráltak, akik regisztrációja `*unregdate*`-kor jár le
 <code> <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 `status`='reg' AND category_id>0 AND `unregdate`= '2021-01-01 00:00:00' ;
Line 18: Line 18:
  
 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; 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;
-SELECT COUNT(*) FROM node WHERE last_dhcp < '2019-01-01 00:00:00' AND STATUS='unreg' 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> </code>