This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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

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.

pastedImage_0.pngpastedImage_2.png pastedImage_1.png

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

pastedImage_3.png

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

pastedImage_4.png

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.

pastedImage_5.png

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

pastedImage_6.png

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