syssesprof connected column

AIX 6 11.50.FC7W3 I am trying to obtain a list of who has been on (ie... has a session) for less than one hour using the sysmaster:syssesprof connected column. I can use dbinfo to see the actual datetimes but want to somehow only select the ones connected within the last hour. This is obviously dumbed down but this is what is standing in my way. Any suggestions? Thanx, Dan

You should be using syssessions. The connected column is a unix time stamp ( seconds from epoch ) so current time in UTC ( available through dbinfo use utc_current ) select * form syssessions where connected > dbinfo("utc_current") - 3600 Numbers is numbers 3600 seconds in an hour. This help ? George. From: "DAN MUELLER" <ddmueller@intercall.com> To: ids@iiug.org Date: 03/20/2013 09:08 AM Subject: syssesprof connected column [29805] Sent by: ids-bounces@iiug.org AIX 6 11.50.FC7W3 I am trying to obtain a list of who has been on (ie... has a session) for less than one hour using the sysmaster:syssesprof connected column. I can use dbinfo to see the actual datetimes but want to somehow only select the ones connected within the last hour. This is obviously dumbed down but this is what is standing in my way. Any suggestions? Thanx, Dan ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

select (sh_curtime - connected) units second::interval hour to second from syssessions, sysshmvals; Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Mar 20, 2013 at 9:39 AM, DAN MUELLER <ddmueller@intercall.com>wrote: > AIX 6 > 11.50.FC7W3 > > I am trying to obtain a list of who has been on (ie... has a session) for > less > than one hour using the sysmaster:syssesprof connected column. I can use > dbinfo to see the actual datetimes but want to somehow only select the ones > connected within the last hour. This is obviously dumbed down but this is > what > is standing in my way. > > Any suggestions? > > Thanx, > Dan > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f234659d0a72104d85c577a