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

[ptc-3113212]

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.

[LakshmanEaswara]

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));

[ptc-3113212]

That query works!!

Thanks a lot Lakshman.

Regards,

Prabhakaran V.

[MorganBelais]

Thanks for the qml!