Showing results for 
Show  only  | Search instead for 
Did you mean: 

This product reached the end of support date on March 31, 2021.

DCRUM- Any way to see list of reports in DMI by modified dates


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.


Dynatrace Pro
Dynatrace Pro

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], 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]
from LSEntry
inner join WSLastUsed AS tabcreator on LSEntry.creator = tabcreator.row_id
inner join WSLastUsed AS tabmodifier on LSEntry.lastModifier = tabmodifier.row_id
where LSEntry.readonly=0

This one will also give you the create date and the username of the last creator/modifier.