How To: See User List Connections To Application Server

marlinlineInternet and Web Development

Oct 31, 2013 (4 years and 10 days ago)

76 views

How To:
See User List Connections To Application Server


run script psa (or psadmin)

Select Option:

(1
-
2, q): 1



1) Application Server

Select Option:
(1
-
4, q) : 1



1) Administer a domain

Select
D
omain number to administer: 1

1) CRMPROD

Select Opti
on:
(1
-
8, q) : 3



3) Domain status menu

Select Option:
(1
-
3, q) [q]: 2



2) Client status







ALSO…….

Something like this will show you the last signin date and time.


SELECT DISTINCT A.ROLEUSER, B.ACCTLOCK, B.OPRDEFNDESC, B.LASTSIGNONDTTM


FROM PSRO
LEUSER A,


PSOPRDEFN B


WHERE B.OPRID = A.ROLEUSER


AND B.ACCTLOCK = 0


ORDER BY 4