UDT: Search User Logon information by First Name, Last Name or Email

Version 1

    The default UDT search allows you to find a user by its AD credential (domain\username).

    This document introduces a way to use a custom SWQL view to list some important user information in one table and allow you to search a user by its logon user name, AD first/last name, or email address.

    Note: User information should already be available in UDT.

     

    Go to a page you want this to be displayed and add a 'Custom Query' resource via customize page-> add-> custom query.

    Click Edit, change the Title and Subtitle as you need,

    then copy and past the queries (see them at the end of the doc) into the two boxes,

    and select the number of records you want to see per page, then submit.

    It may be too narrow for it to display all information, so drag the column to fit it in.

    Use the search pool to search against account name, first name, last name or email.

     

     

     

    You can also refine the query (add more information, customize the column name etc.) as you need.

     

    ====== copy below query into Custom SWQL Query box =====

     

    select u.accountname, u.FirstName, u.LastName, u.EmailAddressList, c.ipaddress, d.DNSName, c.logondatetime from Orion.udt.user as u

    left outer join Orion.UDT.UserToIPAddressCurrent c

    on u.userid=c.userid

    left outer join Orion.UDT.DNSNameCurrent d

    on c.IPAddress=d.IPAddress

    order by c.logondatetime desc

     

     

     

    ====== copy below query into Search SWQL Query box =====

     

    select u.accountname, u.FirstName, u.LastName, u.EmailAddressList, c.ipaddress, d.DNSName, c.logondatetime from Orion.udt.user as u

    left outer join Orion.UDT.UserToIPAddressCurrent c

    on u.userid=c.userid

    left outer join Orion.UDT.DNSNameCurrent d

    on c.IPAddress=d.IPAddress

    where u.accountname like '%${SEARCH_STRING}%' or u.FirstName like '%${SEARCH_STRING}%' or u.LastName like '%${SEARCH_STRING}%'  or u.EmailAddressList like '%${SEARCH_STRING}%'

    order by c.logondatetime desc