Dashboard/report to produce list of all modules I transacted in in the past 2 weeks

[Jackie Mondora]

Just looking for some "secret sauce" similar to " 'assigned_to' is (Dynamic) Me" filter in a report but for somehow getting the user's clicks (transactions) and a list of either all tables with a record that was changed (they did work...) or modules or Case IDs where they did the work for the last 2 weeks. 

Background: we have a lot of customized modules and a broad range of users (persona- wise) and we want to give these users a sort of cheat sheet for their timesheet by week. (In chunks of 2 weeks time frame.) So ideally at the landing on the dashboard they see a listing of the modules/tables/case IDs they touched over the past 2 weeks. Then they can either just view that or download the list. I'd add the voucher codes. 

[The Machine]

I don't know if there is any good way to do this since the transactions are on the syslog_transaction table as well as on table rotation due to how big it is.

One idea is to build a metric that gets populated, and then you can run your report based on that metric instance.

[Mark Manders · Accepted solution]

If they aren't assigned, it will be impossible. Reporting on audit table is something you should never do (and also that will only work if everything is audited). And still: that will only give all transactions and not how much time was spent. 

Why not just put the time worked field on all forms and have automation in place to copy it to the time sheets, so they only have to correct it?

Next to that: a person can open a record at 8AM, get a call, be busy all day with other things and close the tab when shutting down his system, causing an entire day on that ticket, without any work done. You are trying to solve a behavioral issue (register time when you spend it) by trying to have a technical solution. That will never work. Just teach them to write time on tasks when they perform it. ServiceNow has no 'I touched this' registration.