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

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

pkiran
Inactive

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.

1 REPLY 1

chris_v
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)

select 
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]
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.