Report on items moved byt a specific user

Gillian_Hughes

Hi,Can anyone help me with a report that shows items moved on a specific date by a specific user?Thanks,Gill

Steve_McDonough

Hello Gill,Here's a simple report that will allow you to select the user and the date range and display the item detail from the DAUDITNEW table:SELECT D.EVENTID "ID", D.AUDITDATE "Date Logged In", K.NAME "Login Name", K.LASTNAME+', '+K.FIRSTNAME "User Name", D.Value1 "Description" FROM KUAF K, DAUDITNEW D WHERE K.ID = %1 AND D.AUDITID = 3 AND K.ID = D.PERFORMERID AND K.DELETED = 0 AND D.AUDITDATE >= %2 AND D.AUDITDATE <= %3 ORDER BY D.AUDITDATE DESCInputs to the report would be User (user type), Beginning Date (date type) and Ending Date (date type). Params 1 - 3 will be User Inputs 1 - 3. The report format is Auto LiveReport. Attached is a .rpt file that can be imported into your LiveReports folder. We are running LES 9.7.0 on an MS SQL database.I hope that it helps you.