BusinessObjects Board

Can we get who last(user) modify crystal report information?

building reports crystal reports
#1

Hi, All

Is it possible to get user details who last modified crystal reports(or webi reports) from BI launchpad or CMC?.

We are on BI 4.2 SP6.

Thank you for the help!.

MIUSA (BOB member since 2011-05-01)

#2

I don’t think so. The only way to get that information that I know of is from the Audit data.

#3

And in the case of Crystal Reports, it would be the last person to upload the report since you cannot directly edit the report from BI (unless you are using Crystal Reports for Enterprise).

kevlray :us: (BOB member since 2010-06-23)

#4

Yes,agree.

How to find out last person information who uploaded crystal report?

In CMC–>Crystal report–>Right click database configuration–>User id/password are database credentials which crystal report is using to connect to database.

If we use individual user id(who have access to database to develop reports against it) under database configuration then we know who modify the report.

We can also get user who last updated report information from Query Builder tool. But checking to see if we can able to get it from CMC or BILaunchpad.

SELECT SI_NAME, SI_ID, SI_OWNER, SI_CREATION_TIME, SI_UPDATE_TS from CI_INFOOBJECTS WHERE SI_KIND=‘CrystalReport’ AND SI_OWNER=‘USERNAME’ ORDER BY SI_SIZE DESC

Thank you for the help!.

MIUSA (BOB member since 2011-05-01)