diff options
| author | David M. Syzdek <syzdek@bindlebinaries.com> | 2019-05-13 16:47:20 -0800 |
|---|---|---|
| committer | David M. Syzdek <syzdek@bindlebinaries.com> | 2019-05-13 16:47:20 -0800 |
| commit | d0ba9b3d336559e29116ed84083ce70f7145dfab (patch) | |
| tree | b5da227d1166b03be93e3b8103e15dc32ed7965f /notes/projects/radius/sql/ippool-queries.sql | |
| parent | b8d308885a9d52bfc068bce3fed63e89d8d18222 (diff) | |
| download | scratchpad-d0ba9b3d336559e29116ed84083ce70f7145dfab.tar.gz scratchpad-d0ba9b3d336559e29116ed84083ce70f7145dfab.tar.bz2 scratchpad-d0ba9b3d336559e29116ed84083ce70f7145dfab.tar.xz scratchpad-d0ba9b3d336559e29116ed84083ce70f7145dfab.zip | |
Updating how IP addresses are assigned
Diffstat (limited to 'notes/projects/radius/sql/ippool-queries.sql')
| -rw-r--r-- | notes/projects/radius/sql/ippool-queries.sql | 4 |
1 files changed, 0 insertions, 4 deletions
diff --git a/notes/projects/radius/sql/ippool-queries.sql b/notes/projects/radius/sql/ippool-queries.sql index 1009d53..f2daa21 100644 --- a/notes/projects/radius/sql/ippool-queries.sql +++ b/notes/projects/radius/sql/ippool-queries.sql | |||
| @@ -36,8 +36,6 @@ SELECT DISTINCT pool.name AS poolName, | |||
| 36 | ) AS active, | 36 | ) AS active, |
| 37 | ( | 37 | ( |
| 38 | nasId IS NOT NULL | 38 | nasId IS NOT NULL |
| 39 | OR | ||
| 40 | acctSession IS NOT NULL | ||
| 41 | ) AS assigned, | 39 | ) AS assigned, |
| 42 | ip.modified AS modified, | 40 | ip.modified AS modified, |
| 43 | nas.name AS nasName, | 41 | nas.name AS nasName, |
| @@ -67,8 +65,6 @@ SELECT DISTINCT pool.name AS poolName, | |||
| 67 | ) AS active, | 65 | ) AS active, |
| 68 | ( | 66 | ( |
| 69 | nasId IS NOT NULL | 67 | nasId IS NOT NULL |
| 70 | OR | ||
| 71 | acctSession IS NOT NULL | ||
| 72 | ) AS assigned, | 68 | ) AS assigned, |
| 73 | ip.modified AS modified, | 69 | ip.modified AS modified, |
| 74 | nas.name AS nasName, | 70 | nas.name AS nasName, |