Delete Content Folder via DB
We have a customer who mistakenly imported a report with its dependencies, including the data source. This caused a license breach and caused SR to be inaccessible. We were able to login as the default system admin, but as soon as we got to the Admin Console page, the user got kicked out and was brought back to the login page. Instead, we performed the following steps to add the the default system admin as part of the client org:
Insert into IpRltshp (IpParent, IpChild, RltshpTypeCode, StartDate, EndDate, EndReasonCode, InternalReferenceId, PrivacyLevelCode, RltshpLevelCode, DefReHireCode) values ( 12101, 5, 'STAFFMEMBER', '2001-01-01 00:00:00.000', '9999-12-31 00:00:00.000', NULL, NULL, NULL, NULL, NULL)
Post this, the user was able to login to SR and delete the extra data source; but now, the content folders that were imported did not get deleted.
When we try to delete them, it says that it is being used by 2 views. As the data source was deleted, it shouldn't have any associated views or reports.
Are you able to provide the queries needed to get rid of them? See attached.
We have renamed the content folders by appending 'zz' in front.