Notifications
Clear all
Topic starter
Does anyone know of a way to see which users have certain Custom Lists set as their default. I would like to delete old custom lists and I'm trying to find out who is still using them. Thanks!
Posted : November 18, 2015 4:16 am
I have one that shows me everyone that doesn't have the smart search as their default custom problem list that might be a starting point if you want that. I can send it to you and probably tweak it for you if needed. Thanks. Jen
Posted : November 18, 2015 5:03 am
Topic starter
That would be great. A starting point is more than I have so far 🙂
Can you email it to me? [email protected]
Thanks!
Posted : November 18, 2015 5:08 am
I have a series of SQL queries that you can start with. I haven't created a Crystal Report, but given the interest will do so. Contact me a [email protected].
Posted : November 18, 2015 7:08 am
I too am looking for something to aide in identifying users who don't have the smart list as their default. May I get my hands on that report as well, please and thank you!
Posted : November 18, 2015 10:01 am
Here is an Oracle query to show all users' Problem Custom List preference:
select u.firstname, u.lastname,u.status, p.prefname, p.prefvalue, q.description, l.abbrevname from ml.pref p, ml.usrinfo u, ml.locreg l, ml.qpicks q
where p.groupid = u.pvid and u.homelocation = l.locid and p.prefvalue = q.qpid
and p.prefname = 'ProbCustomList'
Posted : December 15, 2015 9:41 am
