diff options
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, |