Welcome, Guest. Please login or register.

Author Topic: Scheduled Emailing of Reports  (Read 524 times)

Westy_87

  • Newbie
  • *
  • Posts: 13
    • View Profile
Scheduled Emailing of Reports
« on: July 10, 2023, 04:06:50 am »
Good Morning,

We recently implemented a script that moves inactive ports into a suspended vlan 999.

I am now manually checking each day to see if any have become active (i.e. someone plugged into them)

(https://<nediserver>/Devices-Interfaces.php?in[]=pvid&op[]=%3D&st[]=999&co[]=AND&in[]=ifstat&op[]=%3D&st[]=3&co[]=&in[]=ifname&op[]=~&st[]=&co[]=&in[]=ifname&op[]=~&st[]=&col[]=imBL&col[]=ifname&col[]=device&col[]=alias&col[]=lastchg&col[]=speed&col[]=duplex&col[]=pvid&lim=250&cmt=&lnt=&sis=&bcm=&bal=&tal=&maf=)
or
SELECT device,ifname,alias,speed,duplex,pvid FROM interfaces WHERE PVID = 999 AND IFSTAT = 3

How would I go about getting this sent as an email once per day at a specified time?

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2894
    • View Profile
    • NeDi
Re: Scheduled Emailing of Reports
« Reply #1 on: September 25, 2023, 11:02:56 am »
I'd do a bash script which emails the result as text. I never bothered with automated GUI reports...
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo