Skip to main content
P
ptc-31132121-Visitor
1-Visitor
May 13, 2011
Question

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

  • May 13, 2011
  • 1 reply
  • 2377 views

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.

1 reply

L
LakshmanEaswara1-Visitor
1-Visitor
May 13, 2011

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

    P
    ptc-31132121-VisitorAuthor
    1-Visitor
    May 13, 2011

    That query works!!

    Thanks a lot Lakshman.

    Regards,

    Prabhakaran V.

    Terms & ConditionsAccessibility statement