SQL Queries - CAST Central Base - SQL Queries on Transactions - How to get the list of modified transactions for unchanged objects

Purpose of Query

The purpose of this query is to provide the list of modified transactions on unchanged objects.

Applicable CAST Version

Release	Yes/No
8.3.x
8.2.x
8.1.x
8.0.x

Applicable RDBMS

RDBMS	Yes/No
Oracle Server
Microsoft SQL Server
CSS2

Query for CSS

To get the list of modified transaction on unchanged objects, install the attached stored procedure XXX_TR_REPORT_UNCHANGED_V2.Sql on CB and run the following:

select XXX_TR_REPORT_UNCHANGED(SNAPSHOTID ) ;

Query result example

"(4956225,30002,EditGeographyPanel,com.att.edge.admin.client.eventrules.defineeventrules.panel.EditGeographyPanel)"
"(4959774,30002,execute,com.att.edge.backend.eventruleengine.EventManagerThreadInvoker.execute)"
"(4959752,30002,run,com.att.edge.backend.messagerouterinterface.MessageRouterSQData.run)"
"(4959775,30002,run,com.att.edge.backend.eventruleengine.EventManagerTestRunNow.run)"
"(4959776,30002,run,com.att.edge.backend.eventruleengine.EventManagerScheduler.run)"
"(4959777,30002,run,com.att.edge.backend.eventruleengine.EventManagerScheduleEditor.run)"
"(4959789,30002,run,com.att.edge.backend.datarouterpublisher.DataRouterDistributorStart.run)"
"(4959862,30002,run,com.att.edge.backend.workorderengine.WorkOrderBanHistory.run)"
"(4959863,30002,run,com.att.edge.backend.workorderengine.RetryWorkRequest.run)"
"(4959865,30002,run,com.att.edge.backend.workorderengine.HandleWorkOrder.run)"
"(4959866,30002,run,com.att.edge.backend.workorderengine.ForceSynchronizationStart.run)"
"(4959867,30002,run,com.att.edge.backend.workorderengine.Event.run)"
"(4959892,30002,run,com.att.edge.backend.rwgdaemonapplication.RWGRoutineWOStatusTracker.run)"
"(4959905,30002,run,com.att.edge.backend.pollingondemand.JobPolling.run)"
"(5681431,30002,run,com.att.edge.backend.handledispatchtimers.ManageDispatchTimers.run)"
"(5858747,30002,run,com.att.edge.backend.eamjobprocessor.EamConfirmReservationsWorkerStart.run)"
"(5990725,30002,run,com.att.edge.backend.messagerouterinterface.MessageRouterSQDataW6Tasks.run)"
"(6072161,30002,run,com.att.edge.backend.kafkarouter.KafkaWorkOrder.run)"
"(6086692,30002,run,com.att.edge.backend.concordrouter.WorkOrderClickTechsPocessor.run)"
"(6031682,30002,scenario/pushPlan/,""S:\\Sources\\EDGE\\Analyzed\\javabackend\\CPScenarioService\\src\\main\\java\\com\\att\\cp\\scenario\\controllers
ScenarioDetailsController.java/scenario/PORT/POST/scenario/pushPlan/"")"

Query result interpretation

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Query for SQL server

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Ticket #27533

Related Pages