How to find the un-used schema’s in ALM
Question ID: 108766

Hello ALM Team,

we have many unused schema’s in ALM and wanted to find out the details of it for an internal audit, Please help me with this request if there is any query to find these details.
We are using ALM 12.60 on Oracle 12c.
Thanks in advance.

Marked as spam
Posted by (Questions: 4, Answers: 1)
Asked on December 17, 2018 6:59 am
Answers (1)
Private answer

Hello ,

The easiest way would be to go to the ''projects'' table in the site admin schema this table should list what schemas are in use for the projects along with the status of the project (active or inactive). Then you should be able to determine which ones are not in use

Marked as spam
Posted by (Questions: 0, Answers: 364)
Answered on January 30, 2019 9:59 pm

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top