From 709c78569b26677624e60588fa1166dc659ac93c Mon Sep 17 00:00:00 2001 From: Ole Mathias Heggem Date: Sat, 21 Jan 2023 19:07:38 +0100 Subject: chore: cleanup repo --- web/nms-public.gathering.org/api/public/dhcp | 20 -------------------- 1 file changed, 20 deletions(-) delete mode 100755 web/nms-public.gathering.org/api/public/dhcp (limited to 'web/nms-public.gathering.org/api/public/dhcp') diff --git a/web/nms-public.gathering.org/api/public/dhcp b/web/nms-public.gathering.org/api/public/dhcp deleted file mode 100755 index 91d52af..0000000 --- a/web/nms-public.gathering.org/api/public/dhcp +++ /dev/null @@ -1,20 +0,0 @@ -#! /usr/bin/perl -# vim:ts=8:sw=8 - -use lib '../../../../include'; -use nms::web qw (%json finalize_output); -use strict; -use warnings; -use Data::Dumper; - -nms::web::setwhen('60m'); -my $q = $nms::web::dbh->prepare('select distinct on (sysname) extract(epoch from date_trunc(\'second\',time)) as time,sysname from dhcp join switches on dhcp.switch = switches.switch where ' . $nms::web::when . ' order by sysname,time desc;'); -$q->execute(); -while ( my $ref = $q->fetchrow_hashref() ) { - my $sysname = $ref->{'sysname'}; - $json{'dhcp'}{$ref->{'sysname'}} = $ref->{'time'}; -} - -$nms::web::cc{'max-age'} = "5"; -$nms::web::cc{'stale-while-revalidate'} = "30"; -finalize_output(); -- cgit v1.2.3