Статистика использования сетей организации
Зомби, всего
(> $zombi_days дней)"; print ""; ?> \n"; $cl="data"; print "\n"; $all_ips = $row['ip_int_stop']-$row['ip_int_start']-3; print "\n"; #used $used_all = get_count_records($db_link,'User_auth','deleted=0 and ip_int>='.$row['ip_int_start'].' and ip_int<='.$row['ip_int_stop']); print "\n"; $free_all = $all_ips - $used_all; print "\n"; $dhcp_pool = $row['dhcp_stop']-$row['dhcp_start']+1; print "\n"; #used pool $used_dhcp = get_count_records($db_link,'User_auth','deleted=0 and ip_int>='.$row['dhcp_start'].' and ip_int<='.$row['dhcp_stop']); print "\n"; $free_dhcp = $dhcp_pool - $used_dhcp; print "\n"; $free_static = $free_all - $free_dhcp; print "\n"; $zombi = get_count_records($db_link,'User_auth','deleted=0 and ip_int>='.$row['ip_int_start'].' and ip_int<='.$row['ip_int_stop'].' and last_found<=(NOW() - INTERVAL '.$zombi_days.' DAY)'); print "\n"; $zombi = get_count_records($db_link,'User_auth','deleted=0 and ip_int>='.$row['dhcp_start'].' and ip_int<='.$row['dhcp_stop'].' and last_found<=(NOW() - INTERVAL '.$zombi_days.' DAY)'); print "\n"; print "\n"; } } ?>

Сеть	Всего адресов	Занято	Свободно (всего)	Размер dhcp пула	Занято в пуле	Свободно в пуле	Свободно (static)	Зомби dhcp (> $zombi_days дней)
".$row['subnet']."	".$all_ips."	".$used_all."	".$free_all."	".$dhcp_pool."	".$used_dhcp."	".$free_dhcp."	".$free_static."	".$zombi."	".$zombi."