cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

How to get list of users whose Preferred File Server is "xxxx"

ptc-3113212
1-Newbie

How to get list of users whose Preferred File Server is "xxxx"

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.

3 REPLIES 3

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!

Announcements

Top Tags