Auditing Usage of staff report

Paul Langham

Hi, Can anyone help with the following sql.I am trying to report on staff usage ie login, delete, modify, open documents/emails already in Livelink.I would like to search by "User LastName" and between a certain date....also would be good to search "AuditID"SELECT distinct a.AuditID, a.AuditStr, a.AuditDate, c.Dname, livelink.KUAF.FirstName, livelink.KUAF.LastName FROM livelink.DAuditNew a INNER Join livelink.DAudit c ON c.DataID = a.DataID Left Join livelink.KUAF ON livelink.KUAF.ID = c.UserIDWHERE (a.AuditDate > CONVERT(DATETIME, '14/8/2009', 103)) AND (a.AuditDate < CONVERT(DATETIME, '22/9/2009', 103))AND(livelink.KUAF.LastName = 'blog') Order By a.AuditStr, a.AuditDate, livelink.KUAF.LastName--(a.AuditID = '')--ReName = 5--Fetch = 14--Create = 1--AttChange = 10--AddVersion = 11--Move = 3--Delete = 2--Login = 23--View --Reserve = 6--Unreserve = 7--Permission Changed 9

Tim_Hunter

Paul, not sure what you want to get out of the report, but you want to remove the reference to DAudit as it is unused in current versions of Livelink and will not join to DAuditNew