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

[12.4.10+] List DCRUM Reports sorted by creation date

raffaele_talari
Inactive

Hi there,

the question is the following:

is there any way to list the reports sorted by creation date?

Thanks a lot for your help.

Ciao,

Raff

4 REPLIES 4

adam_piotrowicz
Dynatrace Pro
Dynatrace Pro

Not sure if there is anything in the GUI, but the following SQL could help:

select name, DATEADD(s, created/1000, '1970-01-01 00:00:00') as created from lsentry order by created DESC

Thanks Adam, would it be worth introducing it as a feature in the "All reports" view?

First time I personally hear such request especially when we introduced searching through DMI reports, but there nothing better to judge it by placind Product Idea ...

chris_v
Dynatrace Pro
Dynatrace Pro

@Adam P. I frequently do this.

At some customers, they generate large numbers of reports, and often like to see which ones are old and can be removed to clean up the reports list - which becomes far to large to navigate.

Here's another one, list the last accessed date for all reports (limited to last 32 days as it's pulled from the DMI web server logs)

select reportName [Report Name], 
userName as [User Name],
count(*) as [Total Runs],
dateadd(s, max(endTime)/1000,'1970-01-01') as [Last Run GMT],
avg(endTime-beginTime) as [Average Run Time]

from (
select reportName, userName, beginTime, endTime from DmiQueryPerformance0
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance1
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance2
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance3
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance4
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance5
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance6
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance7
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance8
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance9
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance10
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance11
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance12
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance13
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance14
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance15
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance16
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance17
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance18
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance19
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance20
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance21
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance22
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance23
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance24
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance25
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance26
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance27
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance28
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance29
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance30
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance31
union all
select reportName, userName, beginTime, endTime from DmiQueryPerformance32
) as data

group by reportName, userName
order by [Total Runs] DESC