PerformerID in dauditnew table

Frank_Early

Is PerformerID in dauditnew table is a unique id for a user?The reason I'm ask is we'd like to pull out the date information of a user when they last login.select performerid, max(auditdate) from dauditnew where auditid='23' and performerid in ('13616409') group by performeridMuch appreciate any inputs.Michael C

Greg_Griffiths_(ggriffiths_-_(deleted))

If you get a copy of the Database Schema from OpenText, via an NDA you will see that the column is a foreign key to KUAF so should do what you want from your sample query, although the GROUP BY and the IN components seem a little useless if you are only looking for one user.