diff options
| author | Kristian Lyngstol <kristian@bohemians.org> | 2015-04-02 19:24:45 +0200 |
|---|---|---|
| committer | Kristian Lyngstol <kristian@bohemians.org> | 2015-04-02 19:24:45 +0200 |
| commit | 0d8bba263dc195147d6fdb09662e7926f0a58b3e (patch) | |
| tree | 4c570b4376c323e585120e7695b8715be7aa8881 /clients/build-linknets.pl | |
| parent | e4354b47bd8891c5b1ee591fdf74b3ca67eee461 (diff) | |
Bump lots of changes
Diffstat (limited to 'clients/build-linknets.pl')
| -rwxr-xr-x | clients/build-linknets.pl | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/clients/build-linknets.pl b/clients/build-linknets.pl index 0b116dd..015e006 100755 --- a/clients/build-linknets.pl +++ b/clients/build-linknets.pl @@ -10,7 +10,7 @@ use Net::CIDR; my $dbh = nms::db_connect(); -my $coregws = $dbh->prepare("SELECT switch, ip, community, sysname FROM switches WHERE switchtype <> 'ex2200'") +my $coregws = $dbh->prepare("SELECT switch, ip, community, sysname FROM switches WHERE sysname NOT LIKE 'e%' and sysname NOT LIKE 'sw%creativia%' AND sysname NOT LIKE 'sw%crew'") or die "Can't prepare query: $!"; $coregws->execute; |