Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.
select SESSION,cast(NODENAME as char(15)) as modename,cast(min(DATE_TIME)
as char(19)) as start,cast(max(DATE_TIME) as char(19)) as end from actlog where
not nodename='' group by session,nodename order by start
SESSION MODENAME START END
------------ ---------------- -------------------- --------------------
149399 AAAAAAAAAAAA 2013-06-04-00.01.01 2013-06-04-00.01.01
149461 AAAAAAAAAAA 2013-06-04-00.02.59 2013-06-04-00.02.59
149146 BBBBBBBB 2013-06-04-00.18.58 2013-06-04-00.19.47