I checked CSS auditing, Application XML through the manage reports. I could not find an easy way may be I was not looking at the right options for this. It will be a great help if some one can point out the option or the table name that I can look up to find the created/updated reports in DMI sorted by date time.
Solved! Go to Solution.
Can't do it through the UI unfortunately.
The following SQL script can be run from the SQL debug console (from http://casip/atscon)
LSEntry.row_id as [Report ID],
LSEntry.name as [Report Name],
tabcreator.ulogin as [Creator],
dateadd(S, LSEntry.created/1000, '1970-01-01') as [Created UTC],
tabmodifier.ulogin as [Modifier],
dateadd(S, LSEntry.LastModified/1000, '1970-01-01') as [Modified UTC]
inner join WSLastUsed AS tabcreator on LSEntry.creator = tabcreator.row_id
inner join WSLastUsed AS tabmodifier on LSEntry.lastModifier = tabmodifier.row_id
This one will also give you the create date and the username of the last creator/modifier.