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

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

how to organize previous built DMI custom reports in 12.2 CAS

kevin_liu1
Guide

i'd like to delete a bunch of old custom DMI reports, rather than going to each one and delete, is there a central location where i can select a whole bunch and delete?

5 REPLIES 5

jean_louis_lorm
Dynatrace Pro
Dynatrace Pro

Use :

select * into lsentryBackup2015 from lsentry (for backup)
delete from lsentry where name = 'ReportName' (ReportName = name of your dmi section)

+ CAS restart

Regards,

JLL

Kevin,

It's not available in the GUI. Only the query from Jean-Louis can help.

Where and how do you apply this query ?

Use SQL Studio logged in as delta or on CAS: http://CAS/sqlreports.

jean_louis_lorm
Dynatrace Pro
Dynatrace Pro

the same with the screen shot 🙂

http: // CAS /sqlreports

1) Backup

select * into lsentryBackup2015 from lsentry

2) Delete

delete from lsentry where name = 'ReportName'

3) Restart the CAS

Regards,

JLL