BAC - Live Reports

Dan_Duffy

Within LiveReports, does anyone know to show a list of users who haven not logged on, added,updated a document, since April 1,2001, for a particular group

eLink User

Message from Bryan Grega via eLinkWe run this report which shows us the users that have not logged in by group.SELECT k1.LastName, k1.FirstName, k1.Name, k2.Name "GROUP", k1.Contact FROM KUAF k1, KUAF k2 WHERE NOT EXISTS (SELECT UserID FROM DAUDIT WHERE (UserID = k1.ID) AND (EVENT = 'LOGIN')) AND k1.Deleted = 0 AND k1.Type = 0 AND k1.GroupID = k2.ID ORDER BY k1.GroupID, k1.LastName, k1.FirstName, k1.NameOr we have this one that is setup for the past 30 days.SELECT k1.LastName, k1.FirstName, k1.Name, k2.Name "GROUP", k1.Contact FROM KUAF k1, KUAF k2 WHERE NOT EXISTS (SELECT UserID FROM DAUDIT WHERE (UserID = k1.ID) AND (EVENT = 'LOGIN') AND (AuditDate < SYSDATE-30)) AND k1.Deleted = 0 AND k1.Type = 0 AND k1.GroupID = k2.ID ORDER BY k1.LastName, k1.FirstName, k1.NameAt 12:19 PM 01/16/2002 -0500, you wrote:>BAC - Live Reports>Posted by NationsUser1 on 01/16/2002 12:16 PM>>Within LiveReports, does anyone know to show a list of users who haven not >logged on, added,updated a document, since April 1,2001, for a particular group>>[To reply to this thread, use your normal e-mail reply function.]>>============================================================>>Discussion: Livelink LiveReports Discussion>https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=view>>Livelink Server:>https://knowledge.opentext.com/knowledge/livelink.exeBryan A. GregaSr. Consultant, Tech. SpecialistRS Information SystemsNASA, Glenn Research Center21000 Brookpark RoadMailStop 142-4Cleveland, OH 44135216-433-2724