Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X
Hi,
How to get list of users who all had set their Preferred File Server (in their preferences) as "xxxx".
Appreciate your help.
Thanks,
Prabhakaran V.
SELECT A2.name FROM PreferenceDefinition A0,PreferenceInstance A1,WTUser A2 WHERE (((A0.name = '/wt/content/contentCacheSite') AND (A1.value = 'File_Server_Name'))) AND ((A1.idA3A4 = A0.idA2A2) AND (A1.idA3B4 = A2.idA2A2));
That query works!!
Thanks a lot Lakshman.
Regards,
Prabhakaran V.
Thanks for the qml!