What users are on the system:
How do I tell what users are on my informix system. Thanks, Jeffery
In article <37455797.94470F0A@gilligan.nws.noaa.gov>,
Heather Friedeman <heather@gilligan.nws.noaa.gov> wrote:
> How do I tell what users are on my informix system.
>
> Thanks, Jeffery
>
>
Try this script if you have "nawk" on your system:
###---cut here---###
#!/bin/ksh
#Script: sessions.sh
#Date: 11/24/98
#By: J. Andersland
#Display the sql sessions currently running
onstat -g ses | nawk '
NR > 5 && $3 >= 0 && $3 <=1000 {
print "--------------------------------------------------------------"
print " " print "LOGINNAME TERMINAL LOGGED IN MACHINE "
print "--------- -------- ------------ ----------"
u = sprintf("who | grep pts/%s", $3)
system(u)
s = sprintf("onstat -g sql %s | grep -v INFORMIX ", $1)
system(s)
}' -
###---cut here---###
--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---
If you're using 7.0x, you could try:
select unique username from sysmaster:syssessions
John Carlson
Informix DBA
WHSmith USA
Heather Friedeman wrote:
>
> How do I tell what users are on my informix system.
>
> Thanks, Jeffery