Sysmaster tables for "onstat -g ntt" info

What tables or views (in sysmaster) do I use to get the equivalent information provided by "onstat -g ntt". I had been parsing the onstat command output to determine idel time for a session. But now I find that my requirements have changed and additional information is required (stuff from syssessions). Thanks.

As if by coincidence I find myself needing very similar information. In my case I am trying to produce a status report on IDS systems showing things such as total number of users, number of local (shm/str), and number of remote (tcp). I can get this information from onstat -g ntu with suitable filters but am looking for ways to get this information using the sysmaster database. regards Malcolm fprose@hotmail.com wrote in message news:<1107812019.211752.288700@o13g2000cwo.googlegroups.com>... > What tables or views (in sysmaster) do I use to get the equivalent > information provided by "onstat -g ntt". I had been parsing the onstat > command output to determine idel time for a session. But now I find > that my requirements have changed and additional information is > required (stuff from syssessions). > > Thanks.