Not all SQL you see in the logs is the direct result of workflow. Some of it, logging in for example, is generated by the server code and cannot be modified.
Mark Walters The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or support representative for BMC Software, Inc. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Mike Sent: 13 February 2009 08:59 To: [email protected] Subject: "Login SQL" where is it? i try to find a filter or active link or what ever is responsible for firing login SQL (user and password authentication), does anybody know what and where it is? It is SQL that looks up the User name when logging in. Thats the SQL log: <SQL > <TID: 0000000023> <RPC ID: 0000168668> <Queue: Fast> <Client- RPC: 390620 > <USER: qwerty > /* Tue Feb 10 2009 15:47:06.1552 */ SELECT userName,password,authUserName,shortAuthString,longAuthString,badPwd,badPwdTotal,notifyMech,licType,licTypeFText,licTypeReserv1,licTypeApp,email,shortGroup,longGroup,shortCompGroup,longCompGroup,timestamp,validateKey FROM user_cache WHERE userName = 'qwerty' Mike my setup: ITSM 7.1 patch 003,Solaris 10, Oracle 10g, OAS for Mid-Tier _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
