Below is the query sent per user when sqlTrust is set to False


2011-11-01 08:44:47,415 DEBUG [http-8443-2] axl.AXLRouter - Router: com.cisco.ccm.axl.AXLRouter@1a2cda9
2011-11-01 08:44:47,415 INFO  [http-8443-2] axl.AXLRouter - VERSION : "CUCM:DB ver=7.1"
2011-11-01 08:44:47,416 INFO  [http-8443-2] axl.AXLRouter - sVERSION : 71
2011-11-01 08:44:47,416 INFO  [http-8443-2] axl.AXLRouter - Received request 1320101085412 from admin at IP 10.5.1.72
2011-11-01 08:44:47,416 INFO  [http-8443-2] axl.AXLRouter - <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><SOAP-ENV:Body><axl:getUser xmlns:axl="http://www.cisco.com/AXL/API/7.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><userid>agent1000</userid></axl:getUser></SOAP-ENV:Body></SOAP-ENV:Envelope>
2011-11-01 08:44:47,418 DEBUG [http-8443-2] axl.AXLRouter - Request is not a write request
2011-11-01 08:44:47,418 DEBUG [http-8443-2] axl.AXLRouter - Successfully set the value of counter: 4 value: 0
2011-11-01 08:44:47,418 INFO  [http-8443-2] axl.Handler - Handler initializing
2011-11-01 08:44:47,420 DEBUG [http-8443-2] axl.UserHandler - select enduser.pkid, enduser.firstname, enduser.middlename, enduser.lastname, enduser.userid, enduser.telephoneNumber,enduser.mailid,  enduser.department, enduser.manager, enduser.tkUserLocale, enduser.assocpc, enduser.allowcticontrolflag,  enduser.passwordreverse, enduser.enablemobility, enduser.enablemobilevoice, enduser.maxDeskPickupWaitTime,  enduser.remoteDestinationLimit, enduser.status, UL.name as userLocaleName from enduser, outer TypeUserLocale UL   where my_lower(userid)=my_lower('agent1000') and UL.enum=enduser.tkuserlocale
2011-11-01 08:44:47,423 DEBUG [http-8443-2] axl.UserHandler - select fkdevice from enduserdevicemap where fkenduser='430b36b4-684c-3665-b815-d9df3d0b8c37' and tkUserAssociation = '1'
2011-11-01 08:44:47,427 DEBUG [http-8443-2] axl.UserHandler - select endusernumplanmap.*, NP.dnorpattern as dnorpattern, RP.name as routePartitionName from endusernumplanmap left outer join numplan NP on NP.pkid = endusernumplanmap.fkNumplan left outer join routepartition RP on RP.pkid = NP.fkroutepartition where endusernumplanmap.fkenduser = '430b36b4-684c-3665-b815-d9df3d0b8c37' and tkDnUsage ='1'
2011-11-01 08:44:47,444 DEBUG [http-8443-2] axl.UserHandler - select endusernumplanmap.*, NP.dnorpattern as dnorpattern, RP.name as routePartitionName from endusernumplanmap left outer join numplan NP on NP.pkid = endusernumplanmap.fkNumplan left outer join routepartition RP on RP.pkid = NP.fkroutepartition where endusernumplanmap.fkenduser = '430b36b4-684c-3665-b815-d9df3d0b8c37' and tkDnUsage ='2'
2011-11-01 08:44:47,447 DEBUG [http-8443-2] axl.UserHandler - select dg.* from enduserdirgroupmap eudgm ,outer dirgroup dg  where eudgm.fkenduser = '430b36b4-684c-3665-b815-d9df3d0b8c37' and (dg.pkid=eudgm.fkdirgroup) 
2011-11-01 08:44:47,449 DEBUG [http-8443-2] axl.UserHandler -  select fr.* from functionroledirgroupmap frdgm ,outer  functionrole fr  where frdgm.fkdirgroup = 'f17f95a6-c185-41a8-872e-70bfac7e634d' and (fr.pkid=frdgm.fkfunctionrole) 
2011-11-01 08:44:47,451 DEBUG [http-8443-2] axl.UserHandler - select fkdevice from enduserdevicemap where fkenduser='430b36b4-684c-3665-b815-d9df3d0b8c37' and tkUserAssociation = '5'
2011-11-01 08:44:47,452 DEBUG [http-8443-2] axl.UserHandler - select name from device where fkenduser_mobility='430b36b4-684c-3665-b815-d9df3d0b8c37'
2011-11-01 08:44:47,453 DEBUG [http-8443-2] axl.UserHandler - select credential.*, CP.displayname as credentialPolicyName from credential, outer credentialpolicy CP where credential.fkenduser = '430b36b4-684c-3665-b815-d9df3d0b8c37' and CP.pkid = credential.fkcredentialpolicy order by tkCredential
2011-11-01 08:44:47,456 DEBUG [http-8443-2] axl.UserHandler - select name from todAccess where fkenduser='430b36b4-684c-3665-b815-d9df3d0b8c37'
2011-11-01 08:44:47,457 DEBUG [http-8443-2] axl.UserHandler - select name from device where pkid = (select  fkdevice from enduserdevicemap where fkenduser='430b36b4-684c-3665-b815-d9df3d0b8c37' and tkUserAssociation = '6')
2011-11-01 08:44:47,469 INFO  [http-8443-2] axl.AXLRouter - <SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header/><SOAP-ENV:Body><axl:getUserResponse xmlns:axl="http://www.cisco.com/AXL/API/7.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><return><user><firstname>agent1000</firstname><middlename/><lastname>test</lastname><userid>agent1000</userid><password/><pin/><telephoneNumber/><mailid/><department/><manager/><associatedDevices><device>SEP001FCAEA0108</device></associatedDevices><primaryExtension><pattern>1000</pattern><routePartitionName/></primaryExtension><ipccExtension><pattern>1000</pattern><routePartitionName/></ipccExtension><associatedPC/><associatedGroups><userGroup uuid="{F17F95A6-C185-41A8-872E-70BFAC7E634D}"><name>Standard CCM End Users</name><userRoles><userRole uuid="{CA97DD09-5DC4-4DB3-9893-2F5D35764BAD}">Standard CCM End Users</userRole><userRole uuid="{9CA7294A-9559-4BA2-A7CC-212B7C605625}">Standard CCMUSER Administration</userRole></userRoles></userGroup></associatedGroups><enableCTI>true</enableCTI><digestCredentials/><enableMobility>false</enableMobility><enableMobileVoiceAccess>false</enableMobileVoiceAccess><maxDeskPickupWaitTime>10000</maxDeskPickupWaitTime><remoteDestinationLimit>4</remoteDestinationLimit><passwordCredentials><pwdCredPolicyName>Default Credential Policy</pwdCredPolicyName><pwdCredUserCantChange>false</pwdCredUserCantChange><pwdCredUserMustChange>false</pwdCredUserMustChange><pwdCredDoesNotExpire>false</pwdCredDoesNotExpire><pwdCredTimeChanged>March 03, 1993 17:47:45 EST</pwdCredTimeChanged><pwdCredTimeAdminLockout/><pwdCredLockedByAdministrator>false</pwdCredLockedByAdministrator></passwordCredentials><pinCredentials><pinCredPolicyName>Default Credential Policy</pinCredPolicyName><pinCredUserCantChange>false</pinCredUserCantChange><pinCredUserMustChange>false</pinCredUserMustChange><pinCredDoesNotExpire>false</pinCredDoesNotExpire><pinCredTimeChanged>March 03, 1993 17:47:45 EST</pinCredTimeChanged><pinCredTimeAdminLockout/><pinCredLockedByAdministrator>false</pinCredLockedByAdministrator></pinCredentials><status>2</status></user></return></axl:getUserResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>
2011-11-01 08:44:47,470 INFO  [http-8443-2] axl.AXLRouter - Request 1320101085412 was process in 54ms