15 lines
1.3 KiB
SQL
Executable File
15 lines
1.3 KiB
SQL
Executable File
|
|
update ports set `ignore`='0';
|
|
update ports set `ignore`='1' where `ifOperStatus`='down' and `ifAdminStatus`='up' and TIMESTAMPDIFF(SECOND, `ifLastChange`, NOW())>'2419200';
|
|
update ports inner join devices on ports.device_id=devices.device_id set ports.ignore='0' where hostname like 'switch-sp-%';
|
|
update ports inner join devices on ports.device_id=devices.device_id set ports.ignore='0' where hostname like 'switch-catalyst-%';
|
|
update ports inner join devices on ports.device_id=devices.device_id set ports.ignore='0' where hostname like 'switch-nexus-%';
|
|
update ports inner join devices on ports.device_id=devices.device_id set ports.ignore='0' where hostname like 'router-%';
|
|
update ports inner join devices on ports.device_id=devices.device_id set ports.ignore='0' where hostname like 'asa-%';
|
|
update ports inner join devices on ports.device_id=devices.device_id set ports.ignore='0' where hostname like 'switch-vwd-%';
|
|
update ports inner join devices on ports.device_id=devices.device_id set ports.ignore='1' where hostname like 'switch-fibre-%';
|
|
update ports inner join devices on ports.device_id=devices.device_id set ports.ignore='1' where hostname like '%.conadm.de';
|
|
update ports set `ignore`='1' where `ifAdminStatus`='down';
|
|
update ports set `ignore`='1' where `ifSpeed`<100000;
|
|
update ports set `ignore`='0' where `ifAlias` like '%!!!%';
|