Notifications
Clear all
Topic starter
Does anyone have a suggestion on a way to see complete list of user preferences? I'm trying to clean up some of the custom lists that were made but I can't remove because still listed on users. All the current employees do not have it listed so it has to be an old employee/user that is inactive. Thanks
Kristen
Posted : October 3, 2017 11:29 am
Run this in SQL Server Management Studio
SELECT prefname,qpicks.DESCRIPTION,df.loginUser FROM pref
JOIN qpicks on pref.PREFVALUE = qpicks.qpid
JOIN doctorfacility df on pref.DoctorFacilityId = df.DoctorFacilityId
WHERE PREFNAME like '%customList'
Posted : October 4, 2017 12:00 am
