#acl LanGroup:read,write,revert,delete,admin All:read
[[HTML()]]
[[HTML()]]
[[HTML(
)]]
https://www.lan.kth.se/staff/kthopen/2010/os.png
https://www.lan.kth.se/staff/kthopen-stats.png
https://www.lan.kth.se/staff/ssid-stats.png
https://www.lan.kth.se/staff/kthopen/2010/users.png
Unika macadresser per månad:
[[kl_moin_dbsel(substring_index(day,'-',2) as month,count(distinct eaddr) as count from nm_arp_hist where ip like '130.229.%' group by month order by month desc)]]
Unika macadresser per vecka:
[[kl_moin_dbsel(week(day,3) as week,count(distinct eaddr) as count from nm_arp_hist where ip like '130.229.%' group by week order by week desc)]]
Unika macadresser per dag den senaste månaden:
[[kl_moin_dbsel(day,count(distinct eaddr) as count from nm_arp_hist where ip like '130.229.%' group by day order by day desc limit 30)]]
https://www.lan.kth.se/staff/kthopen-stats-rolling12.png