SQL Queries - CAST Knowledge Base - Queries on objects - What is the Analysis Unit of an object or list of objects

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

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x✅
8.0.x✅
7.3.x✅

Observed on RDBMS

RDBMSYes/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