There's more to experience when you log in!
We are trying to determine what the "notify Infogix Insight" is set to on each control point. The report should contain the control entity and control point names. Our original thought was we could run a query in the Admin Console but need to know what tables to search. If you could either provide the query or provide that table and columns we would need to look at.
The Control Points' definitions are stored as XML within the RULESEGMENT column of the RULEPART table.
The query below will display control names in a format where the entity and point names are concatenated with an underscore, along with the XML configuration of that control point:
SELECT c.DISPLAYNAME, r.* FROM RULEPART r INNER JOIN "RULE" c on RULEFK=RULEPKWHERE RULETYPEFK = 63ORDER BY DISPLAYNAME
Within the XML in the RULESEGMENT column will a parameter named notifyInsightOverride that contains the setting value. An example of the XML is below:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><ns3:controlPointRule xmlns="/generated/export/integrityrules/ocm" xmlns:ns2="/generated/export/val/actions" xmlns:ns3="/generated/export/integrityrules/ocm/cp"> <multiInstanceControlPoint name="samplecontrol" processDefinitionId="229051b0-4d3d-11ec-b5c7-048120524153" captureRule="_228a1020-4d3d-11ec-b5c7-048120524153_Capture" merge="_228fdc80-4d3d-11ec-b5c7-048120524153_Merge" storeHistory="false" instanceManagement="creates" cycleManagement="creates" executionActionLimit="100" executionProfile="default" dqplusControlDataPostProcessing="process" instancePreProcessing="none" notifyInsightOverride="bypass"> <description></description> <actions> <ns2:controlReportGeneration action="suppress"/> <ns2:controlInstanceLifeCycle action="store"/> <ns2:applyProcessMonitorControl action="apply"/> <ns2:setRetentionPolicy policy="standard"/> </actions> <concurrency> <fail/> </concurrency> </multiInstanceControlPoint></ns3:controlPointRule>
As a general disclaimer, the syntax and location of how controls are stored may change over time.