Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. 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!