cancel
Showing results for 
Search instead for 
Did you mean: 

reoprt with owner name

Former Member
0 Kudos

How to find reoprt (webi and deski)with owner name?

Accepted Solutions (1)

Accepted Solutions (1)

CdnConnection
Active Contributor
0 Kudos

Anutosh,

    If the user is deleted the schedule DO NOT always move to Administrator account.   You need to run REPOSCAN utility to make sure all Objects owned by deleted users are assigned to Administrator account.

If you run REPOSCAN in SCAN mode you will get XML output that tells you list of all objects without proper owners.

You need to REPOSCAN  in REPAIR mode to fix this issue and have them assigned to Administrator account.

Regards,

Ajay

Former Member
0 Kudos

Thank you Ajay

Answers (2)

Answers (2)

Former Member
0 Kudos

Based on Mayur's response, if in case the deleted user did have associated reports you can simply query for reports owned by the "Administrator" account.

"...where si_owner='Administrator'"

CdnConnection
Active Contributor
0 Kudos

Anutosh,

    The best way to get this information is to use Query Builder.  See link to blog showing the basics and samples on how to use it.

Steps to follow:

  1. Validate that proper UserID exist within CMS
  2. Then run Query Builder where owner = <Desired userID>

Regards,

Ajay

Former Member
0 Kudos

Thanks for your reply.

User has been removed from the server but we need information if any reports associated with his name.

Former Member
0 Kudos

If the user is removed/deleted from the system DB, ownership of the reports and recurring schedules will be transferred to Administrator.

Thanks,

Mayur