Purpose of Query
To find out the list of objects belonging to an analysis unit (View analysis unit content).
The query used is different for versions prior to 8.2 and after 8.2.
Please note that this query uses both CAST Knowledge Base AND CAST Management Base
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
| 8.1.x | |
| 8.0.x | |
| 7.3.x | |
Observed on RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS2 | |
Query for CSS for 8.2 and higher
SELECT k.keynam AS "Object name",
k.idkey AS "Object id",
mau.object_id AS "Analysis Unit ID",
mau.object_name AS "Analysis Unit Name"
FROM <MNGT>.maint_analysisunits mau
JOIN <MNGT>.cms_dynamicfields cdf
ON cdf.object_id = mau.object_id
AND cdf.field_guid = 'entry'
JOIN <LOCAL>.pmc_subsets ps
ON ps.subset_name = 'CMS_AU_FULL__'
|| cast(cdf.field_value AS varchar)
JOIN <LOCAL>.pmc_subset_objects pso
ON pso.subset_id = ps.subset_id
JOIN <LOCAL>.keys k
ON k.idkey = pso.object_id
JOIN <LOCAL>.typ t
ON t.idtyp = k.objtyp
WHERE k.idkey = <ID of the Object>
Query result example
33739;"Bai.SystemAdministration.ServiceInterface";204557;"SaveDepartments";"OperationMethod"
Query result interpretation
All the listed objects belong to Analysis Unit "Server"
Query for CSS before 8.2
SELECT mau.object_id AS "Analysis Unit ID",
mau.object_name AS "Analysis Unit Name",
pso.object_id AS "Object ID",
k.keynam AS "Object name",
t.typnam AS "Type"
FROM <MNGT>.maint_analysisunits mau
JOIN <LOCAL>.pmc_subsets ps
ON ps.subset_name = 'CMS_AU_FULL__'
|| cast(mau.object_id AS varchar)
JOIN <LOCAL>.pmc_subset_objects pso
ON pso.subset_id = ps.subset_id
JOIN <LOCAL>.keys k
ON k.idkey = pso.object_id
JOIN <LOCAL>.typ t
ON t.idtyp = k.objtyp
WHERE k.idkey = <OBJECT ID>
Query result example
3464;"Technical-support";386453;"S:\SOURCES\XXXXXXXXXX";"COBOL_ROOTDIRECTORY"
Notes/comments
Related Pages
