How can I find private content owned by active or deleted users?

David Registro shared this question ago

Answered

If I have users that created their own private content, and they've now been deleted how do I find these items?

Or I simply want a list of private content in my system.

The same question

Replies (3)

David Registro ●

This will ONLY apply to users who have created private content.

To find private content owned by these users, you can run the queries below.

To find all active private reports

SELECT * FROM ReportHeader
where ExternalAccessCode='PERSONAL' and ReportStatusCode='OPEN'

To find all active private dashboards.

This is a bit trickier, as dashboards are not so easily identified. You can simply find a dashboard which has security applied, and then work it out from here. This is the query will return secured content.

select * from ReportGroup
where AccessCode='ACCESSLEVEL'

To find private reports for deleted users only

Note this is ONLY in the interim, as personal content should be deleted when you delete the user

SELECT * FROM ReportHeader R
INNER JOIN IpClass I ON IpId=IpOwner
WHERE I.EndDate != '9999-12-31'
and R.ReportStatusCode='OPEN'
and R.ExternalAccessCode='PERSONAL'

Reply URL

Bradley Dixon ●

We are after something similar too. As an admin we would like to see all private reports

Reply URL

David Registro ●

Hey Brad,

An idea has been raised here for the ability to find all private content if you're some sort of special admin user.

Any updates on this will be posted there. Thanks for your feedback!

Regards,

David

Reply URL