SQL Queries - CAST Knowledge Base - Queries on objects - How to list CAST Generated Objects for analysis

Purpose of Query

This document provides a query to get objects generated by Cast for analysis purpose.

You may want to select them by object type, or by application

The table that contains this piece of information is CTT_OBJECT_APPLICATIONS (it is filled during Cast System Views computation).

Here we use a join with table CDT_OBJECTS to get human-readable details on the object.

Applicable CAST Version

Release	Yes/No
8.3.x	✅

Applicable RDBMS

RDBMS	Yes/No
Oracle Server	✅
Microsoft SQL Server	✅
CSS	✅

Query for CSS

Query to find all CAST-generated objects belonging to a certain application. To get CAST generated objects based on your application id, you have to find the application id first. For this refer SQL Queries - CAST Central Base - Queries on applications - How to get the ID of the application

For CAST 8.3.36 and below:

SELECT cdto.*
FROM   cdt_objects cdto
       JOIN ctt_object_applications coa
       ON     coa.object_id=cdto.object_id
WHERE  coa.properties     = 2
AND    application_id      =<APPLICATION_ID> -- here 275104

For CAST 8.3.37 and above:

SELECT cdto.*
FROM   cdt_objects cdto
       JOIN ctt_object_applications coa
       ON     coa.object_id=cdto.object_id
WHERE  coa.properties & 255     = 2
AND    application_id      =<APPLICATION_ID> -- here 275104

Query result example

286124;“WMUtils”;"net.att.opus.ws.utils.WMUtils.WMUtils";“Java Constructor”;“WMUtils()”;" public";“Java”;286124;275104;101;98;2
286196;“OneTwoThreeFeaturesComparator”;"net.att.opus.ws.utils.OneTwoThreeFeaturesComparator.OneTwoThreeFeaturesComparator";“Java Constructor”;“OneTwoThreeFeaturesComparator()”;" public";“Java”;286196;275104;101;98;2
286211;“ConversionUtils”;"net.att.opus.ws.utils.ConversionUtils.ConversionUtils";“Java Constructor”;“ConversionUtils()”;" public";“Java”;286211;275104;101;98;2
286356;“ReceiptPrinterConstants”;"net.att.opus.ws.receipt.print.ReceiptPrinterConstants.ReceiptPrinterConstants";“Java Constructor”;“ReceiptPrinterConstants()”;" public";“Java”;286356;275104;101;98;2
286821;“PrinterConnection”;"net.att.opus.ws.receipt.print.PrinterConnection.PrinterConnection";“Java Constructor”;“PrinterConnection()”;" public";“Java”;286821;275104;101;98;2
286827;“valueOf”;"net.att.opus.ws.receipt.print.PrinterConnection.PrinterStatus.valueOf";“Java Method”;“valueOf(java.lang.String) return net.att.opus.ws.receipt.print.PrinterConnection.PrinterStatus”;" public static";“Java”;286827;275104;102;98;2
286828;“values”;"net.att.opus.ws.receipt.print.PrinterConnection.PrinterStatus.values";“Java Method”;“values() return net.att.opus.ws.receipt.print.PrinterConnection.PrinterStatus[]”;" public static";“Java”;286828;275104;102;98;2
286835;“PrinterStatus”;"net.att.opus.ws.receipt.print.PrinterConnection.PrinterStatus.PrinterStatus";“Java Constructor”;“PrinterStatus()”;" public";“Java”;286835;275104;101;98;2
286854;“UpgradeOptionsConstants”;"net.att.opus.ws.UpgradeOptionsConstants.UpgradeOptionsConstants";“Java Constructor”;“UpgradeOptionsConstants()”;" public";“Java”;286854;275104;101;98;2
286977;“UpgradeEligibilityCTNServicesImpl”;"net.att.opus.ws.UpgradeEligibilityCTNServicesImpl.UpgradeEligibilityCTNServicesImpl";“Java Constructor”;“UpgradeEligibilityCTNServicesImpl()”;" public";“Java”;286977;275104;101;98;2
287564;“OPUSGenericHandler”;“net.att.opus.webservices.OPUSGenericHandler.OPUSGenericHandler”;“Java Constructor”;“OPUSGenericHandler()”;" public";“Java”;287564;275104;101;98;2
287593;“LoggingHandler”;“net.att.opus.webservices.LoggingHandler.LoggingHandler”;“Java Constructor”;“LoggingHandler()”;" public";“Java”;287593;275104;101;98;2
287603;“AuthenticationHandler”;“net.att.opus.webservices.AuthenticationHandler.AuthenticationHandler”;“Java Constructor”;“AuthenticationHandler()”;" public";“Java”;287603;275104;101;98;2
287635;“WSLog4jInit”;“net.att.opus.servlet.WSLog4jInit.WSLog4jInit”;“Java Constructor”;“WSLog4jInit()”;" public";“Java”;287635;275104;101;98;2
3683538;“valueOf”;“com.att.cscr.common.datamodel.order.OrderStatusValue.valueOf”;“Java Method”;“valueOf(java.lang.String) return com.att.cscr.common.datamodel.order.OrderStatusValue”;“publictatic”;“Java”;3683538;3682366;102;98;2
3802896;“ObjectNameFactory”;“com.cingular.jmx.log4j.ObjectNameFactory.ObjectNameFactory”;“Java Constructor”;“ObjectNameFactory()”;" public";“Java”;3802896;3791105;101;98;2

Query result interpretation

The application contains these CAST-generated objects

Query for Oracle

For CAST 8.3.36 and below:

SELECT cdto.*
FROM   cdt_objects cdto
       JOIN ctt_object_applications coa
       ON     coa.object_id=cdto.object_id
WHERE  coa.properties      = 2
AND    application_id      =<APPLICATION_ID>

For CAST 8.3.37 and above:

SELECT cdto.*
FROM   cdt_objects cdto
       JOIN ctt_object_applications coa
       ON     coa.object_id=cdto.object_id
WHERE  coa.properties & 255     = 2
AND    application_id      =<APPLICATION_ID>

Query result example

Query result interpretation

The application contains these CAST-generated objects

Query for SQL server

For CAST 8.3.36 and below:

SELECT cdto.*
FROM   cdt_objects cdto
       JOIN ctt_object_applications coa
       ON     coa.object_id=cdto.object_id
WHERE  coa.properties      = 2
AND    application_id      =<APPLICATION_ID>

For CAST 8.3.37 and above:

SELECT cdto.*
FROM   cdt_objects cdto
       JOIN ctt_object_applications coa
       ON     coa.object_id=cdto.object_id
WHERE  coa.properties & 255     = 2
AND    application_id      =<APPLICATION_ID>

Query result example

Query result interpretation

The application contains these CAST-generated objects

Query for CSS

Query to find all CAST-generated objects of a certain object type.

For CAST 8.3.36 and below:

SELECT DISTINCT cdto.*
FROM            cdt_objects cdto
                JOIN ctt_object_applications coa
                ON              coa.object_id=cdto.object_id
WHERE           coa.properties               = 2
AND             coa.object_type              =<OBJECT_TYPE_ID> -- here 101, Java constructor

For CAST 8.3.37 and above:

SELECT DISTINCT cdto.*
FROM            cdt_objects cdto
                JOIN ctt_object_applications coa
                ON              coa.object_id=cdto.object_id
WHERE           coa.properties & 255               = 2
AND             coa.object_type              =<OBJECT_TYPE_ID> -- here 101, Java constructor

Query result example

943455;“DigiLifePhysCountSerialListAction”;“poslite.inventoryControl.digiLife.actions.DigiLifePhysCountSerialListAction.DigiLifePhysCountSerialListAction”;“Java Constructor”;“DigiLifePhysCountSerialListAction()”;" public";“Java”
909145;“ChangeTLGFeaturesAction”;“poslite.customerService.actions.ChangeTLGFeaturesAction.ChangeTLGFeaturesAction”;“Java Constructor”;“ChangeTLGFeaturesAction()”;" public";“Java”
8756428;“DTVOMSLineItemInfo”;“net.att.opus.dtv.DTVOMSLineItemInfo.DTVOMSLineItemInfo”;“Java Constructor”;“DTVOMSLineItemInfo()”;" public";“Java”
3826255;“InstallDateTimeInfo”;“net.att.opus.dtv.InstallDateTimeInfo.InstallDateTimeInfo”;“Java Constructor”;“InstallDateTimeInfo()”;" public";“Java”
961923;“SharedDataProcessRequestInfo”;“POS2.Core.Activation.SharedDataProcessRequestInfo.SharedDataProcessRequestInfo”;“Java Constructor”;“SharedDataProcessRequestInfo()”;" public";“Java”
866355;“ReleaseInquiredTelephoneNumbersRequest”;“net.att.opus.titan.ReleaseInquiredTelephoneNumbersRequest.ReleaseInquiredTelephoneNumbersRequest”;“Java Constructor”;“ReleaseInquiredTelephoneNumbersRequest()”;" public";“Java”
16781096;“InvDiscrpMgmtForm”;“poslite.inventorymanagement.forms.InvDiscrpMgmtForm.InvDiscrpMgmtForm”;“Java Constructor”;“InvDiscrpMgmtForm()”;" public";“Java”
840447;“UsageMinutesAction”;“com.cingular.opus.customerservice.customersummary.UsageMinutesAction.UsageMinutesAction”;“Java Constructor”;“UsageMinutesAction()”;" public";“Java”
862484;“ExternalPeripheralTestForm”;“net.cingular.opus.administration.extperipheral.ExternalPeripheralTestForm.ExternalPeripheralTestForm”;“Java Constructor”;“ExternalPeripheralTestForm()”;" public";“Java”
852155;“TabletTag”;“net.att.opus.tags.opusmobile.device.TabletTag.TabletTag”;“Java Constructor”;“TabletTag()”;" public";“Java”
950324;“FindHomeForm”;“poslite.security.forms.FindHomeForm.FindHomeForm”;“Java Constructor”;“FindHomeForm()”;" public";“Java”

Query result interpretation

The KB contains these CAST-generated objects of this object_type –here Java Constructor

Query for Oracle

Query to find all CAST-generated objects of a certain object type.

For CAST 8.3.36 and below:

SELECT DISTINCT cdto.*
FROM            cdt_objects cdto
                JOIN ctt_object_applications coa
                ON              coa.object_id=cdto.object_id
WHERE           coa.properties               = 2
AND             coa.object_type              =<OBJECT_TYPE_ID> -- here 101, Java constructor

For CAST 8.3.37 and above:

SELECT DISTINCT cdto.*
FROM            cdt_objects cdto
                JOIN ctt_object_applications coa
                ON              coa.object_id=cdto.object_id
WHERE           coa.properties & 255              = 2
AND             coa.object_type              =<OBJECT_TYPE_ID> -- here 101, Java constructor

Query result example

Query result interpretation

The KB contains these CAST-generated objects of this object_type –here Java Constructor

Query for SQL server

Query to find all CAST-generated objects of a certain object type.

For CAST 8.3.36 and below:

SELECT DISTINCT cdto.*
FROM            cdt_objects cdto
                JOIN ctt_object_applications coa
                ON              coa.object_id=cdto.object_id
WHERE           coa.properties               = 2
AND             coa.object_type              =<OBJECT_TYPE_ID> -- here 101, Java constructor

For CAST 8.3.37 and above:

SELECT DISTINCT cdto.*
FROM            cdt_objects cdto
                JOIN ctt_object_applications coa
                ON              coa.object_id=cdto.object_id
WHERE           coa.properties & 255               = 2
AND             coa.object_type              =<OBJECT_TYPE_ID> -- here 101, Java constructor

Query result example

Query result interpretation

The KB contains these CAST-generated objects of this object_type –here Java Constructor

Notes/comments

Related Pages