Skip to content

Instantly share code, notes, and snippets.

View ekoyle's full-sized avatar

Eldon Koyle ekoyle

5 followers · 1 following
View GitHub Profile
@ekoyle
ekoyle / keybase.md
Created July 22, 2019 19:34

Keybase proof

I hereby claim:

  • I am ekoyle on github.
  • I am esk (https://keybase.io/esk) on keybase.
  • I have a public key ASAd_TbH-4uM3X7J9OrUsrRvnAe7b1UiAGCxYoKoefrphwo

To claim this, I am signing this object:

@ekoyle
ekoyle / librenms_cleanup_ports.sql
Last active September 30, 2016 22:16
librenms cleanup after port deletion
DELETE FROM adjacencies WHERE port_id NOT IN (SELECT DISTINCT port_id FROM ports);
DELETE FROM ipaddr WHERE port_id NOT IN (SELECT DISTINCT port_id FROM ports);
DELETE FROM ip6adjacencies WHERE port_id NOT IN (SELECT DISTINCT port_id FROM ports);
DELETE FROM ip6addr WHERE port_id NOT IN (SELECT DISTINCT port_id FROM ports);
DELETE FROM mac_accounting WHERE port_id NOT IN (SELECT DISTINCT port_id FROM ports);
DELETE FROM bill_ports WHERE port_id NOT IN (SELECT DISTINCT port_id FROM ports);
DELETE FROM pseudowires WHERE port_id NOT IN (SELECT DISTINCT port_id FROM ports);