Find and Audit Active Service Operations

By Chris Malek | Thu, Sep 5, 2013

It is a good idea to periodically monitor what service operations are active in your production database.

Here is a base query that should return active Service operations that are routed to an active local node.

  • Make sure the values returned here are only service operations that you are actually using.
  • You should inactivate routings and service operations that you are not using.
  • This will ensure you do not have data being posted to the integration broker and updating or extracting data.
  • This should be checked after applying bundles and patches
-- Find All Active Service Operations and routings 
select O.IB_OPERATIONNAME, 
RD.SENDERNODENAME,RD.RECEIVERNODENAME, o.descr
from PSOPERATION o, PSOPRVERDFN OV, PSIBRTNGDEFN RD, PSMSGNODEDEFN MN
where O.IB_OPERATIONNAME = OV.IB_OPERATIONNAME
AND OV.ACTIVE_FLAG = 'A'
AND RD.IB_OPERATIONNAME = OV.IB_OPERATIONNAME
AND RD.VERSIONNAME = OV.VERSIONNAME
AND RD.EFF_STATUS = 'A' -- ROUTING IS ACTIVE
AND RD.RECEIVERNODENAME = mn.msgnodename  
AND mn.active_node = 1 
AND mn.localnode = 1
ORder by O.ib_operationname, RD.SENDERNODENAME;
Author Info
Chris Malek

Chris Malek is a PeopleTools® Technical Consultant with two decades of experience working on PeopleSoft enterprise software projects. He is available for consulting engagements.

About Chris Work with Chris
Product
PeopleSoft Simple Web Services (SWS)
Do you need a quick way to create web services?

Introducing a small but powerful PeopleSoft bolt-on that makes web services very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes.

Book
Integration Broker - The Missing Manual

I am in the process of writing a book called "Integration Broker - The Missing Manual" that you can read online.