manage=> SELECT radacctid, acctuniqueid, username, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctterminatecause FROM radacct WHERE username LIKE 'xxx000%'; radacctid | acctuniqueid | username | nasipaddress | nasportid | nasporttype | acctstarttime | acctstoptime | acctsessiontime | acctterminatecause -----------+------------------+-----------------------+----------------+-----------+-------------+-------------------------------+-------------------------------+-----------------+-------------------- 49 | f5c3662a11cb9c96 | xxx000@xxx.xxx.xxx | xxx.xxx.xxx.xx | 50027 | Ethernet | 2005-07-13 16:37:56.991037+02 | | | 86 | ba7c66fe30d2e933 | xxx000@xxx.xxx.xxx | xxx.xxx.xxx.xx | 50027 | Ethernet | 2005-07-13 16:52:57.142572+02 | | 27011 | 432 | 328b5aa3cb9c9783 | xxx000@xxx.xxx.xxx | xxx.xxx.xxx.xx | 50027 | Ethernet | 2005-07-14 00:38:08.639255+02 | 2005-07-14 00:58:12.651435+02 | 47121 | Port-Error 608 | f4cde8a7ab4087f4 | xxx000@xxx.xxx.xxx | xxx.xxx.xxx.xx | 50027 | Ethernet | 2005-07-14 09:16:23.006713+02 | | 1 | 627 | f6166e0e52ee5625 | xxx000@xxx.xxx.xxx | xxx.xxx.xxx.xx | 50027 | Ethernet | 2005-07-14 09:31:23.935167+02 | | | manage=> SELECT radacctid, acctuniqueid, username, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctterminatecause FROM radacct WHERE username LIKE 'yyy022%'; radacctid | acctuniqueid | username | nasipaddress | nasportid | nasporttype | acctstarttime | acctstoptime | acctsessiontime | acctterminatecause -----------+------------------+-------------------------+-----------------+-----------+-------------+-------------------------------+-------------------------------+-----------------+-------------------- 248 | 4b137cbd9d0edc37 | yyy022@yyy.yyy.yyy | yyy.yyy.yyy.yy | 50002 | Ethernet | 2005-07-13 20:35:45.720945+02 | 2005-07-13 20:47:16.888227+02 | 691 | Port-Error 247 | 4b137cbd9d0edc37 | yyy022@yyy.yyy.yyy | yyy.yyy.yyy.yy | 50002 | Ethernet | 2005-07-13 20:35:45.7404+02 | 2005-07-13 20:47:16.888227+02 | 691 | Port-Error