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

DCRUM DMI creater

skung
Organizer

Is there a way to find out who created DMI report and when DMI report were created?

Sharyl

10 REPLIES 10

gregory_schullo
Newcomer

Yes, @Sharyl Kung!

If you go to the Actions drop down menu on a DMI report and select Save, the report creator and time of creation should be displayed in the bottom right hand corner of the 'Save Report' window that pops up (We are still on 12.3.8).

Hope this helps!

Is there a way to run a report instead of open DMI individually?

Sharyl

adam_piotrowicz
Dynatrace Pro
Dynatrace Pro

DO you mean a report that would tell you authors and dates of all DMI reprots?

adam_piotrowicz
Dynatrace Pro
Dynatrace Pro

Sharyl,

If you mean the list of all reports and their authors and created dates there is no such report you can run.

But you can get is from SQL query ran against CAS DB:

select name as 'Report Name', (select ulogin from delta.wslastused where row_id = creator) as 'Report Creator', delta.nd_getDateString(created,-4,0) as 'Date created' from delta.lsentry where creator > 0

where "-4" sets your time zone, in this example it's GMT-4.

Hope it helps.

can I use same SQL for ADS DMI?

Adam,

Are there other fields that can be queried as well? Like a Report Last Modified By and the date of the last modification?

So there's a both a LastModifier (user id) field and LastModified (date) field you can query.

ADS has the same table/fields so you can run the same query.

That's helpful. After review the outcome, is it possible to delete/remove DMI reports which no longer needed (instead of deleting one by one from dashboard)?

Also, how to distinguish the DMI reports are out of system (come with product)?

Just to add/share:

Remember to update [CAS_Database_Name] and [dbo] with your database values.

/****** Script for showing reports with actual creator and modifier usernames and dates ******/

USE [CAS_Database_Name]   /* Update with your CAS database name */
SELECT TOP 1000
row_id as "ID"
,name as "Report Name"
,[dbo].nd_getDateString([created],+1,0) as 'Date created' -- timezone GMT +1
,[dbo].nd_getDateString([lastmodified],+1,0) as 'Date Modified' -- timezone GMT +1
,CASE creator
WHEN '-1' THEN 'system'
ELSE COALESCE((select ulogin from [dbo].WSLastUsed where row_id = creator),CONCAT('(unknown: ',creator,')'))
END as 'Report Creator'
,CASE lastModifier
WHEN '-1' THEN 'system'
ELSE COALESCE((select ulogin from [dbo].WSLastUsed where row_id = lastModifier),CONCAT('(unknown: ',lastModifier,')'))
END as 'Report Modifier'
,reportServletPath
,version
,readOnly
,imported
,creator
,lastModifier
,params
FROM [dbo].[LSEntry]
-- WHERE lastModifier NOT IN ('-1','1') AND creator = '-1' /* when interested only in user modified system default reports */
-- WHERE lastModifier NOT IN ('-1','1') /* when interested only in user modified */
-- WHERE lastModifier > 1 /* when interested only in user modified */
-- WHERE creator > 1 /* when only interested in user created */