Where does Service Catalog pick up the info for things like _.user.id, _.user.email, _.user.last_name, etc. ? What / Where is it querying?
Are you working with CA Support on this via issue #00875055?
Good Morning Stephen. A way to see which (mdb)queries are being executed to retrieve the data as described is, to set the view.log in TRACE mode. Please consider the following details for the SC log4j.xml file on the SC-Server.The loglevel can be set from e.g INFO into TRACE for extra logging to be recorded in the view.log file.This setting is being controlled in the <usm_home>\view\conf/log4j.xml file. After changing the settings, there is no need to restart the 'Catalog' service.Save the file and after a short period of time, you'll see 'trace' and 'debug' records being recorded in error.log and view.log files. Next then is to 'reproduce' the '.user.id pick up' situation.And then check the view.log file(s) for the queries that have been executed. NOTE: Revert the changes after reproducing this. To avoid further overhead.With 'revert' I mean to say that what you changed from INFO into TRACE, should then be changed back from TRACE into INFO. Thanks in advance and kind regards, Louis.
Thanks! This was insightful, but since I can not change the query to only look at active accounts I can't fix my problem. I submitted a ticket with CA Support.
I am, yes.
Hi Stephen - most likely this will be deemed a bug and should be reproducible in-house. Hopefully its something that can be fixed easily!!
We will track the issue and hopefully be able to post the solution here as well.
Thanks for bringing this one up.
It's the same info that you get to Administration > Users
The main table to search data, the one you can enable/disable users is ca_contact
select * from ca_contact
But if you have to access that data from outsite, you should use the webservice provided, that can get you the same data
Go to Administration > Tools > Webserices API (usm/API/SOAP/index.html) getUser method
Retrieving data ...