How to enable more than one working copy in Identity Audit - Rules (ComplianceRule table)

Question

I am doing compliance rule creation in bulk using the Data Import tool for One Identity Manager version 8.1.5. 
 However, facing challenges in enabling working copies of these compliance rules. 
 There is a method called "Enable working copy," which can enable only one working copy at a time. It is not allowing you to select multiple working copies at a time to enable them. 
 Please suggest some workarounds to enable more than one working copy (which belongs to the ComplianceRule table) at a time.

Markus Weiss-Ehlers · Answer

You can create a custom DialogMethod and assign the MethodBehavior to Execute on multiple objects. The code would look like the following if you want to enable the production rule (the second method call parameter is set to True). This is a stripped-down version of the original method. 
 Try
	If Not Base.IsLoaded Then
 MsgBox (#LD("Not possible in insert mode.")#, MsgBoxStyle.OKOnly Or MsgBoxStyle.Information, "Information")
 Else
 Base.Custom.CallMethod("ActivateWorkingCopy", True)
	End If
Catch ex As Exception
	Throw New ViException(#LD("Error occured enabling working copy")#, ex)
End Try

Klaus Müller · Answer

You can insert a one-time job into jobQueue that enables all the relevant CompliancePolicy working methods using SQL (needs to be done after every new import/change). Adjust the whereClause/Code as necesary: declare @XObjectKeys QBM_YParameterList declare @ProcID varchar(38) = Convert(varchar (38),newID()) declare @aokeff QBM_YParameterList Insert Into @XObjectKeys(Parameter1) select XObjectKey from ComplianceRule where IsWorkingCopy=1 and UID_ComplianceRule in (select w.UID_ComplianceRule from ComplianceRule w left join ComplianceRule o on w.UID_ComplianceRule=o.UID_ComplianceRuleWork and w.IsWorkingCopy=1 where (w.IsSimpleMode=0 and isnull(w.WhereClause, '')<>isnull(o.WhereClause, '') ) or (w.IsSimpleMode=1 and (isnull(w.WhereClausePerson, '')<>isnull(o.WhereClausePerson, '') or exists (select top 1 1 from ComplianceSubRule so full outer join ComplianceSubRule sw on so.WhereClauseAddOn=sw.WhereClauseAddOn and so.UID_ComplianceRule=o.UID_ComplianceRule and sw.UID_ComplianceRule=w.UID_ComplianceRule where (so.UID_ComplianceRule=o.UID_ComplianceRule and sw.UID_ComplianceSubRule is null or sw.UID_ComplianceRule=w.UID_ComplianceRule and so.UID_ComplianceSubRule is null ) ) ) ) ) exec QBM_PJobCreate_HOCallMethod_L 'ComplianceRule', @XObjectKeys, 1, @MethodName='ActivateWorkingCopy', @GenprocID=@ProcID, @AdditionalObjectKeysAffected=@aokeff, @param1= 'True'

Endpoint Privilege Management

How to enable more than one working copy in Identity Audit - Rules (ComplianceRule table)

Top Replies