This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to force AD attribute update when no change occured in OneIM?

 Hello,

 

I would like to provision some AD attributes based on the values I have in OneIM knowing that no changes occured in OneIM.

 

We are using OneIM 7.1.2 and Active Diretory 2012. We already had an almost "out-of-the-box" AD synchronization project set.

 

What would you recommend?

 

Regards,

Mustapha Gaies  

  • Hi Mustapha,

    You could perform something like this by creating a provisioning workflow with a specific filter set for the attributes you want to update. This can be triggered by a sync using that workflow.

    I'd suggest testing with a subset of users by configuring a scope.

    Trevor
  • Hello,

    Thank you very much for you answer, this sounds like a really good idea.

    Actually I decided to generate a process using a step of type ProjectorComponent - AdHocProjection. This includes a run parameter ("ForceSyncOf") which allows to specify the attributes I want to update.

    Be aware that the list of attributes should be a list of comma separated column names (even if run parameter description says "<table name>.<column name>").

     

    Please find attached an example of process.

    CCC_ADS_ADSAccount_ForceAttributeProvision.xml
    <DbObjects>
      <DbObject Display="CCC_ADS_ADSAccount_ForceAttributeProvision" Version="2">
        <Key>
          <Table Name="JobChain" Display="CCC_ADS_ADSAccount_ForceAttributeProvision" Key="CCC-81C013768F94834393234EDF1EAD8C08">
            <Prop Name="UID_JobChain">
              <Value>CCC-81C013768F94834393234EDF1EAD8C08</Value>
            </Prop>
          </Table>
        </Key>
        <Columns>
          <Column Name="CustomRemarks">
            <Value>
            </Value>
          </Column>
          <Column Name="Description" Display="Force update in AD for a specific list of attributes even if no change occured in OneIM.">
            <Value>Force update in AD for a specific list of attributes even if no change occured in OneIM.</Value>
          </Column>
          <Column Name="GenCondition">
            <Value>
            </Value>
          </Column>
          <Column Name="LayoutPositions" Display="V1.1&#x7;JobChain_CCC_ADS_ADSAccount_ForceAttributeProvision&#x8;20&#x8;20&#x8;R600&#x7;CCC_Start projection&#x8;20&#x8;120">
            <Value>V1.1&#x7;JobChain_CCC_ADS_ADSAccount_ForceAttributeProvision&#x8;20&#x8;20&#x8;R600&#x7;CCC_Start projection&#x8;20&#x8;120</Value>
          </Column>
          <Column Name="LimitationCount" Display="0">
            <Value>0</Value>
          </Column>
          <Column Name="LimitationWarning" Display="0">
            <Value>0</Value>
          </Column>
          <Column Name="Name" Display="CCC_ADS_ADSAccount_ForceAttributeProvision">
            <Value>CCC_ADS_ADSAccount_ForceAttributeProvision</Value>
          </Column>
          <Column Name="NoGenerate" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="PreCode" Display="If Provider.Contains(&quot;PC(ForceSyncOf)&quot;) Then&#xD;&#xA;	values(&quot;ForceSyncOf&quot;) = $PC(ForceSyncOf)$.ToString()&#xD;&#xA;Else&#xD;&#xA;	values(&quot;ForceSyncOf&quot;) = &quot;&quot;&#xD;&#xA;End if&#xD;&#xA;&#xD;&#xA;&#xD;&#xA;Imports System.Collections.Generic&#xD;&#xA;Dim data As IDictionary(Of String,string) = Nothing		&#xD;&#xA;&#xD;&#xA;' try to get AD data&#xD;&#xA;Try&#xD;&#xA;	data = DPR_GetAdHocData($FK(UID_ADSDomain).XObjectKey$,&quot;ADS&quot;,&quot;&quot;,&quot;Update&quot;)&#xD;&#xA;Catch ex As Exception&#xD;&#xA;	Throw new Exception(&quot;Couldn't found AdHocData...&quot;)&#xD;&#xA;End Try&#xD;&#xA;&#xD;&#xA;If Not data is Nothing&#xD;&#xA;	values(&quot;UID_DPRSystemVariableSet&quot;) = data(&quot;VariableSetUID&quot;)&#xD;&#xA;	values(&quot;UID_DPRProjectionConfiguration&quot;) = data(&quot;ProjectionConfigUID&quot;)&#xD;&#xA;End if">
            <Value>If Provider.Contains("PC(ForceSyncOf)") Then
    	values("ForceSyncOf") = $PC(ForceSyncOf)$.ToString()
    Else
    	values("ForceSyncOf") = ""
    End if
    
    
    Imports System.Collections.Generic
    Dim data As IDictionary(Of String,string) = Nothing		
    
    ' try to get AD data
    Try
    	data = DPR_GetAdHocData($FK(UID_ADSDomain).XObjectKey$,"ADS","","Update")
    Catch ex As Exception
    	Throw new Exception("Couldn't found AdHocData...")
    End Try
    
    If Not data is Nothing
    	values("UID_DPRSystemVariableSet") = data("VariableSetUID")
    	values("UID_DPRProjectionConfiguration") = data("ProjectionConfigUID")
    End if</Value>
          </Column>
          <Column Name="PreProcessorCondition">
            <Value>
            </Value>
          </Column>
          <Column Name="ProcessDisplay">
            <Value>
            </Value>
          </Column>
          <Column Name="ProcessTracking" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="UID_DialogTable" Display="ADSAccount">
            <Key>
              <Table Name="DialogTable" Display="ADSAccount" Key="ADS-T-ADSAccount">
                <Prop Name="UID_DialogTable">
                  <Value>ADS-T-ADSAccount</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="UID_Job" Display="CCC_Start projection">
            <Key>
              <Table Name="Job" Display="CCC_Start projection" Key="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
                <Prop Name="UID_Job">
                  <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="UID_JobChain" Display="CCC-81C013768F94834393234EDF1EAD8C08">
            <Value>CCC-81C013768F94834393234EDF1EAD8C08</Value>
          </Column>
          <Column Name="XDateInserted" Display="2/8/2018 11:28:17 AM">
            <Value>2018-02-08T10:28:17.5030000Z</Value>
          </Column>
          <Column Name="XDateUpdated" Display="2/8/2018 2:56:53 PM">
            <Value>2018-02-08T13:56:53.1810000Z</Value>
          </Column>
          <Column Name="XMarkedForDeletion">
            <Value>0</Value>
          </Column>
          <Column Name="XObjectKey" Display="&lt;Key&gt;&lt;T&gt;JobChain&lt;/T&gt;&lt;P&gt;CCC-81C013768F94834393234EDF1EAD8C08&lt;/P&gt;&lt;/Key&gt;">
            <Value>&lt;Key&gt;&lt;T&gt;JobChain&lt;/T&gt;&lt;P&gt;CCC-81C013768F94834393234EDF1EAD8C08&lt;/P&gt;&lt;/Key&gt;</Value>
          </Column>
          <Column Name="XTouched">
            <Value>
            </Value>
          </Column>
          <Column Name="XUserInserted" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
          <Column Name="XUserUpdated" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
        </Columns>
      </DbObject>
      <DbObject Display="CCC_Start projection" Version="2">
        <Key>
          <Table Name="Job" Display="CCC_Start projection" Key="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
            <Prop Name="UID_Job">
              <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
            </Prop>
          </Table>
        </Key>
        <Columns>
          <Column Name="DeferOnError" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="Description" Display="Update AD account.">
            <Value>Update AD account.</Value>
          </Column>
          <Column Name="ErrorNotify" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="GenCondition">
            <Value>
            </Value>
          </Column>
          <Column Name="IgnoreErrors" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="IsErrorLogToJournal" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="IsSplitOnly" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="IsToFreezeOnError" Display="True">
            <Value>True</Value>
          </Column>
          <Column Name="MinutesToDefer" Display="0">
            <Value>0</Value>
          </Column>
          <Column Name="Name" Display="CCC_Start projection">
            <Value>CCC_Start projection</Value>
          </Column>
          <Column Name="NotifyAddress">
            <Value>
            </Value>
          </Column>
          <Column Name="NotifyAddressSuccess">
            <Value>
            </Value>
          </Column>
          <Column Name="NotifyBody">
            <Value>
            </Value>
          </Column>
          <Column Name="NotifyBodySuccess">
            <Value>
            </Value>
          </Column>
          <Column Name="NotifySender">
            <Value>
            </Value>
          </Column>
          <Column Name="NotifySenderSuccess">
            <Value>
            </Value>
          </Column>
          <Column Name="NotifySubject">
            <Value>
            </Value>
          </Column>
          <Column Name="NotifySubjectSuccess">
            <Value>
            </Value>
          </Column>
          <Column Name="PreCode">
            <Value>
            </Value>
          </Column>
          <Column Name="PreProcessorCondition">
            <Value>
            </Value>
          </Column>
          <Column Name="Priority" Display="3">
            <Value>3</Value>
          </Column>
          <Column Name="ProcessDisplay">
            <Value>
            </Value>
          </Column>
          <Column Name="ProcessInfoLevel" Display="Basic information">
            <Value>0</Value>
          </Column>
          <Column Name="ProcessTracking" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="Retries" Display="0">
            <Value>0</Value>
          </Column>
          <Column Name="ServerDetectScript">
            <Value>
            </Value>
          </Column>
          <Column Name="SuccessNotify" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="UID_ErrorJob">
            <Value>
            </Value>
          </Column>
          <Column Name="UID_Job" Display="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
            <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
          </Column>
          <Column Name="UID_JobChain" Display="CCC_ADS_ADSAccount_ForceAttributeProvision">
            <Key>
              <Table Name="JobChain" Display="CCC_ADS_ADSAccount_ForceAttributeProvision" Key="CCC-81C013768F94834393234EDF1EAD8C08">
                <Prop Name="UID_JobChain">
                  <Value>CCC-81C013768F94834393234EDF1EAD8C08</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="UID_JobTask" Display="AdHocProjection">
            <Key>
              <Table Name="JobTask" Display="AdHocProjection" Key="DPR-18738A6234B58F459A0B335180298BB0">
                <Prop Name="UID_JobTask">
                  <Value>DPR-18738A6234B58F459A0B335180298BB0</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="UID_QBMServerTag" Display="One Identity Manager Service installed">
            <Key>
              <Table Name="QBMServerTag" Display="One Identity Manager Service installed" Key="QBM-ST-Is14">
                <Prop Name="UID_QBMServerTag">
                  <Value>QBM-ST-Is14</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="UID_SuccessJob">
            <Value>
            </Value>
          </Column>
          <Column Name="XDateInserted" Display="2/8/2018 11:28:17 AM">
            <Value>2018-02-08T10:28:17.9800000Z</Value>
          </Column>
          <Column Name="XDateUpdated" Display="2/8/2018 2:56:50 PM">
            <Value>2018-02-08T13:56:50.3530000Z</Value>
          </Column>
          <Column Name="XMarkedForDeletion">
            <Value>0</Value>
          </Column>
          <Column Name="XObjectKey" Display="&lt;Key&gt;&lt;T&gt;Job&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;/Key&gt;">
            <Value>&lt;Key&gt;&lt;T&gt;Job&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;/Key&gt;</Value>
          </Column>
          <Column Name="XTouched">
            <Value>
            </Value>
          </Column>
          <Column Name="XUserInserted" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
          <Column Name="XUserUpdated" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
        </Columns>
      </DbObject>
      <DbObject Display="CCC-0862BAE1F76F08418AA5AEE2B0D3D475" Version="2">
        <Key>
          <Table Name="JobEventGen" Display="CCC-0862BAE1F76F08418AA5AEE2B0D3D475" Key="CCC-2E4A94EB9BDB69469C0EF8630A247BAE">
            <Prop Name="UID_JobEventGen">
              <Value>CCC-2E4A94EB9BDB69469C0EF8630A247BAE</Value>
            </Prop>
          </Table>
        </Key>
        <Columns>
          <Column Name="OrderNr" Display="0">
            <Value>0</Value>
          </Column>
          <Column Name="ProcessDisplay">
            <Value>
            </Value>
          </Column>
          <Column Name="UID_JobChain" Display="CCC-81C013768F94834393234EDF1EAD8C08">
            <Key>
              <Table Name="JobChain" Display="CCC_ADS_ADSAccount_ForceAttributeProvision" Key="CCC-81C013768F94834393234EDF1EAD8C08">
                <Prop Name="UID_JobChain">
                  <Value>CCC-81C013768F94834393234EDF1EAD8C08</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="UID_JobEventGen" Display="CCC-2E4A94EB9BDB69469C0EF8630A247BAE">
            <Value>CCC-2E4A94EB9BDB69469C0EF8630A247BAE</Value>
          </Column>
          <Column Name="UID_QBMEvent" Display="CCC-0862BAE1F76F08418AA5AEE2B0D3D475">
            <Key>
              <Table Name="QBMEvent" Display="CCC_FORCE_ATTRIBUTE_SYNC - ADSAccount" Key="CCC-0862BAE1F76F08418AA5AEE2B0D3D475">
                <Prop Name="UID_QBMEvent">
                  <Value>CCC-0862BAE1F76F08418AA5AEE2B0D3D475</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="XDateInserted" Display="2/8/2018 11:38:43 AM">
            <Value>2018-02-08T10:38:43.8130000Z</Value>
          </Column>
          <Column Name="XDateUpdated" Display="2/8/2018 11:38:43 AM">
            <Value>2018-02-08T10:38:43.8130000Z</Value>
          </Column>
          <Column Name="XMarkedForDeletion">
            <Value>0</Value>
          </Column>
          <Column Name="XObjectKey" Display="&lt;Key&gt;&lt;T&gt;JobEventGen&lt;/T&gt;&lt;P&gt;CCC-2E4A94EB9BDB69469C0EF8630A247BAE&lt;/P&gt;&lt;/Key&gt;">
            <Value>&lt;Key&gt;&lt;T&gt;JobEventGen&lt;/T&gt;&lt;P&gt;CCC-2E4A94EB9BDB69469C0EF8630A247BAE&lt;/P&gt;&lt;/Key&gt;</Value>
          </Column>
          <Column Name="XTouched">
            <Value>
            </Value>
          </Column>
          <Column Name="XUserInserted" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
          <Column Name="XUserUpdated" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
        </Columns>
      </DbObject>
      <DbObject Display="AuthenticationString" Version="2">
        <Key>
          <Table Name="JobRunParameter" Display="AuthenticationString">
            <Prop Name="UID_Job">
              <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
            </Prop>
            <Prop Name="UID_JobParameter">
              <Value>DPR-DA9131661816794784404EF643AD23B8</Value>
            </Prop>
          </Table>
        </Key>
        <Columns>
          <Column Name="IsCrypted" Display="True">
            <Value>True</Value>
          </Column>
          <Column Name="IsHidden" Display="True">
            <Value>True</Value>
          </Column>
          <Column Name="IsPartialCrypted" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="Name" Display="AuthenticationString">
            <Value>AuthenticationString</Value>
          </Column>
          <Column Name="UID_Job" Display="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
            <Key>
              <Table Name="Job" Display="CCC_Start projection" Key="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
                <Prop Name="UID_Job">
                  <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="UID_JobParameter" Display="DPR-DA9131661816794784404EF643AD23B8">
            <Key>
              <Table Name="JobParameter" Display="AuthenticationString" Key="DPR-DA9131661816794784404EF643AD23B8">
                <Prop Name="UID_JobParameter">
                  <Value>DPR-DA9131661816794784404EF643AD23B8</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="ValueTemplate" Display="Value = ConnectionInfo.AuthString">
            <Value>Value = ConnectionInfo.AuthString</Value>
          </Column>
          <Column Name="XDateInserted" Display="2/8/2018 11:28:19 AM">
            <Value>2018-02-08T10:28:19.1030000Z</Value>
          </Column>
          <Column Name="XDateUpdated" Display="2/8/2018 11:28:19 AM">
            <Value>2018-02-08T10:28:19.1030000Z</Value>
          </Column>
          <Column Name="XMarkedForDeletion">
            <Value>0</Value>
          </Column>
          <Column Name="XObjectKey" Display="&lt;Key&gt;&lt;T&gt;JobRunParameter&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;P&gt;DPR-DA9131661816794784404EF643AD23B8&lt;/P&gt;&lt;/Key&gt;">
            <Value>&lt;Key&gt;&lt;T&gt;JobRunParameter&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;P&gt;DPR-DA9131661816794784404EF643AD23B8&lt;/P&gt;&lt;/Key&gt;</Value>
          </Column>
          <Column Name="XTouched">
            <Value>
            </Value>
          </Column>
          <Column Name="XUserInserted" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
          <Column Name="XUserUpdated" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
        </Columns>
      </DbObject>
      <DbObject Display="CausingEntityPatch" Version="2">
        <Key>
          <Table Name="JobRunParameter" Display="CausingEntityPatch">
            <Prop Name="UID_Job">
              <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
            </Prop>
            <Prop Name="UID_JobParameter">
              <Value>DPR-B59831A8FEDC1247BE80239A8B9E5A22</Value>
            </Prop>
          </Table>
        </Key>
        <Columns>
          <Column Name="IsCrypted" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="IsHidden" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="IsPartialCrypted" Display="True">
            <Value>True</Value>
          </Column>
          <Column Name="Name" Display="CausingEntityPatch">
            <Value>CausingEntityPatch</Value>
          </Column>
          <Column Name="UID_Job" Display="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
            <Key>
              <Table Name="Job" Display="CCC_Start projection" Key="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
                <Prop Name="UID_Job">
                  <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="UID_JobParameter" Display="DPR-B59831A8FEDC1247BE80239A8B9E5A22">
            <Key>
              <Table Name="JobParameter" Display="CausingEntityPatch" Key="DPR-B59831A8FEDC1247BE80239A8B9E5A22">
                <Prop Name="UID_JobParameter">
                  <Value>DPR-B59831A8FEDC1247BE80239A8B9E5A22</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="ValueTemplate" Display="Dim myForceProperty as String() =  {values(&quot;ForceSyncOf&quot;).ToString()}&#xD;&#xA;Value = DPR_WrapObjectForProjection(Entity,myForceProperty)">
            <Value>Dim myForceProperty as String() =  {values("ForceSyncOf").ToString()}
    Value = DPR_WrapObjectForProjection(Entity,myForceProperty)</Value>
          </Column>
          <Column Name="XDateInserted" Display="2/8/2018 11:28:19 AM">
            <Value>2018-02-08T10:28:19.1170000Z</Value>
          </Column>
          <Column Name="XDateUpdated" Display="2/8/2018 11:28:19 AM">
            <Value>2018-02-08T10:28:19.2300000Z</Value>
          </Column>
          <Column Name="XMarkedForDeletion">
            <Value>0</Value>
          </Column>
          <Column Name="XObjectKey" Display="&lt;Key&gt;&lt;T&gt;JobRunParameter&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;P&gt;DPR-B59831A8FEDC1247BE80239A8B9E5A22&lt;/P&gt;&lt;/Key&gt;">
            <Value>&lt;Key&gt;&lt;T&gt;JobRunParameter&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;P&gt;DPR-B59831A8FEDC1247BE80239A8B9E5A22&lt;/P&gt;&lt;/Key&gt;</Value>
          </Column>
          <Column Name="XTouched">
            <Value>
            </Value>
          </Column>
          <Column Name="XUserInserted" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
          <Column Name="XUserUpdated" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
        </Columns>
      </DbObject>
      <DbObject Display="ConnectionProvider" Version="2">
        <Key>
          <Table Name="JobRunParameter" Display="ConnectionProvider">
            <Prop Name="UID_Job">
              <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
            </Prop>
            <Prop Name="UID_JobParameter">
              <Value>DPR-A1D8CDAF1E811F4F9175C3C811C51D5B</Value>
            </Prop>
          </Table>
        </Key>
        <Columns>
          <Column Name="IsCrypted" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="IsHidden" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="IsPartialCrypted" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="Name" Display="ConnectionProvider">
            <Value>ConnectionProvider</Value>
          </Column>
          <Column Name="UID_Job" Display="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
            <Key>
              <Table Name="Job" Display="CCC_Start projection" Key="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
                <Prop Name="UID_Job">
                  <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="UID_JobParameter" Display="DPR-A1D8CDAF1E811F4F9175C3C811C51D5B">
            <Key>
              <Table Name="JobParameter" Display="ConnectionProvider" Key="DPR-A1D8CDAF1E811F4F9175C3C811C51D5B">
                <Prop Name="UID_JobParameter">
                  <Value>DPR-A1D8CDAF1E811F4F9175C3C811C51D5B</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="ValueTemplate" Display="Value = ConnectionInfo.ConnectionProvider">
            <Value>Value = ConnectionInfo.ConnectionProvider</Value>
          </Column>
          <Column Name="XDateInserted" Display="2/8/2018 11:28:19 AM">
            <Value>2018-02-08T10:28:19.1200000Z</Value>
          </Column>
          <Column Name="XDateUpdated" Display="2/8/2018 11:28:19 AM">
            <Value>2018-02-08T10:28:19.1200000Z</Value>
          </Column>
          <Column Name="XMarkedForDeletion">
            <Value>0</Value>
          </Column>
          <Column Name="XObjectKey" Display="&lt;Key&gt;&lt;T&gt;JobRunParameter&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;P&gt;DPR-A1D8CDAF1E811F4F9175C3C811C51D5B&lt;/P&gt;&lt;/Key&gt;">
            <Value>&lt;Key&gt;&lt;T&gt;JobRunParameter&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;P&gt;DPR-A1D8CDAF1E811F4F9175C3C811C51D5B&lt;/P&gt;&lt;/Key&gt;</Value>
          </Column>
          <Column Name="XTouched">
            <Value>
            </Value>
          </Column>
          <Column Name="XUserInserted" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
          <Column Name="XUserUpdated" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
        </Columns>
      </DbObject>
      <DbObject Display="ConnectionString" Version="2">
        <Key>
          <Table Name="JobRunParameter" Display="ConnectionString">
            <Prop Name="UID_Job">
              <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
            </Prop>
            <Prop Name="UID_JobParameter">
              <Value>DPR-8913E25E395F664CB095C199BD0CF12C</Value>
            </Prop>
          </Table>
        </Key>
        <Columns>
          <Column Name="IsCrypted" Display="True">
            <Value>True</Value>
          </Column>
          <Column Name="IsHidden" Display="True">
            <Value>True</Value>
          </Column>
          <Column Name="IsPartialCrypted" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="Name" Display="ConnectionString">
            <Value>ConnectionString</Value>
          </Column>
          <Column Name="UID_Job" Display="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
            <Key>
              <Table Name="Job" Display="CCC_Start projection" Key="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
                <Prop Name="UID_Job">
                  <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="UID_JobParameter" Display="DPR-8913E25E395F664CB095C199BD0CF12C">
            <Key>
              <Table Name="JobParameter" Display="ConnectionString" Key="DPR-8913E25E395F664CB095C199BD0CF12C">
                <Prop Name="UID_JobParameter">
                  <Value>DPR-8913E25E395F664CB095C199BD0CF12C</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="ValueTemplate" Display="Value = ConnectionInfo.ConnectionString">
            <Value>Value = ConnectionInfo.ConnectionString</Value>
          </Column>
          <Column Name="XDateInserted" Display="2/8/2018 11:28:19 AM">
            <Value>2018-02-08T10:28:19.1200000Z</Value>
          </Column>
          <Column Name="XDateUpdated" Display="2/8/2018 11:28:19 AM">
            <Value>2018-02-08T10:28:19.1200000Z</Value>
          </Column>
          <Column Name="XMarkedForDeletion">
            <Value>0</Value>
          </Column>
          <Column Name="XObjectKey" Display="&lt;Key&gt;&lt;T&gt;JobRunParameter&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;P&gt;DPR-8913E25E395F664CB095C199BD0CF12C&lt;/P&gt;&lt;/Key&gt;">
            <Value>&lt;Key&gt;&lt;T&gt;JobRunParameter&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;P&gt;DPR-8913E25E395F664CB095C199BD0CF12C&lt;/P&gt;&lt;/Key&gt;</Value>
          </Column>
          <Column Name="XTouched">
            <Value>
            </Value>
          </Column>
          <Column Name="XUserInserted" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
          <Column Name="XUserUpdated" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
        </Columns>
      </DbObject>
      <DbObject Display="ForceSyncOf" Version="2">
        <Key>
          <Table Name="JobRunParameter" Display="ForceSyncOf">
            <Prop Name="UID_Job">
              <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
            </Prop>
            <Prop Name="UID_JobParameter">
              <Value>DPR-C0F7A5DC70BAA341989FB4C75EEDF05C</Value>
            </Prop>
          </Table>
        </Key>
        <Columns>
          <Column Name="IsCrypted" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="IsHidden" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="IsPartialCrypted" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="Name" Display="ForceSyncOf">
            <Value>ForceSyncOf</Value>
          </Column>
          <Column Name="UID_Job" Display="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
            <Key>
              <Table Name="Job" Display="CCC_Start projection" Key="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
                <Prop Name="UID_Job">
                  <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="UID_JobParameter" Display="DPR-C0F7A5DC70BAA341989FB4C75EEDF05C">
            <Key>
              <Table Name="JobParameter" Display="ForceSyncOf" Key="DPR-C0F7A5DC70BAA341989FB4C75EEDF05C">
                <Prop Name="UID_JobParameter">
                  <Value>DPR-C0F7A5DC70BAA341989FB4C75EEDF05C</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="ValueTemplate" Display="Value = values(&quot;ForceSyncOf&quot;).ToString()">
            <Value>Value = values("ForceSyncOf").ToString()</Value>
          </Column>
          <Column Name="XDateInserted" Display="2/8/2018 11:28:19 AM">
            <Value>2018-02-08T10:28:19.1270000Z</Value>
          </Column>
          <Column Name="XDateUpdated" Display="2/8/2018 11:28:19 AM">
            <Value>2018-02-08T10:28:19.3770000Z</Value>
          </Column>
          <Column Name="XMarkedForDeletion">
            <Value>0</Value>
          </Column>
          <Column Name="XObjectKey" Display="&lt;Key&gt;&lt;T&gt;JobRunParameter&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;P&gt;DPR-C0F7A5DC70BAA341989FB4C75EEDF05C&lt;/P&gt;&lt;/Key&gt;">
            <Value>&lt;Key&gt;&lt;T&gt;JobRunParameter&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;P&gt;DPR-C0F7A5DC70BAA341989FB4C75EEDF05C&lt;/P&gt;&lt;/Key&gt;</Value>
          </Column>
          <Column Name="XTouched">
            <Value>
            </Value>
          </Column>
          <Column Name="XUserInserted" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
          <Column Name="XUserUpdated" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
        </Columns>
      </DbObject>
      <DbObject Display="UID_DPRProjectionConfiguration" Version="2">
        <Key>
          <Table Name="JobRunParameter" Display="UID_DPRProjectionConfiguration">
            <Prop Name="UID_Job">
              <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
            </Prop>
            <Prop Name="UID_JobParameter">
              <Value>DPR-CDF64ED65FFF494DBC29D795A2A91DBC</Value>
            </Prop>
          </Table>
        </Key>
        <Columns>
          <Column Name="IsCrypted" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="IsHidden" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="IsPartialCrypted" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="Name" Display="UID_DPRProjectionConfiguration">
            <Value>UID_DPRProjectionConfiguration</Value>
          </Column>
          <Column Name="UID_Job" Display="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
            <Key>
              <Table Name="Job" Display="CCC_Start projection" Key="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
                <Prop Name="UID_Job">
                  <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="UID_JobParameter" Display="DPR-CDF64ED65FFF494DBC29D795A2A91DBC">
            <Key>
              <Table Name="JobParameter" Display="UID_DPRProjectionConfiguration" Key="DPR-CDF64ED65FFF494DBC29D795A2A91DBC">
                <Prop Name="UID_JobParameter">
                  <Value>DPR-CDF64ED65FFF494DBC29D795A2A91DBC</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="ValueTemplate" Display="Value = values(&quot;UID_DPRProjectionConfiguration&quot;).ToString()">
            <Value>Value = values("UID_DPRProjectionConfiguration").ToString()</Value>
          </Column>
          <Column Name="XDateInserted" Display="2/8/2018 11:28:19 AM">
            <Value>2018-02-08T10:28:19.1230000Z</Value>
          </Column>
          <Column Name="XDateUpdated" Display="2/8/2018 11:28:19 AM">
            <Value>2018-02-08T10:28:19.1230000Z</Value>
          </Column>
          <Column Name="XMarkedForDeletion">
            <Value>0</Value>
          </Column>
          <Column Name="XObjectKey" Display="&lt;Key&gt;&lt;T&gt;JobRunParameter&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;P&gt;DPR-CDF64ED65FFF494DBC29D795A2A91DBC&lt;/P&gt;&lt;/Key&gt;">
            <Value>&lt;Key&gt;&lt;T&gt;JobRunParameter&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;P&gt;DPR-CDF64ED65FFF494DBC29D795A2A91DBC&lt;/P&gt;&lt;/Key&gt;</Value>
          </Column>
          <Column Name="XTouched">
            <Value>
            </Value>
          </Column>
          <Column Name="XUserInserted" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
          <Column Name="XUserUpdated" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
        </Columns>
      </DbObject>
      <DbObject Display="UID_DPRSystemVariableSet" Version="2">
        <Key>
          <Table Name="JobRunParameter" Display="UID_DPRSystemVariableSet">
            <Prop Name="UID_Job">
              <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
            </Prop>
            <Prop Name="UID_JobParameter">
              <Value>DPR-E6976B615B8634408D7372F3CE4F18D3</Value>
            </Prop>
          </Table>
        </Key>
        <Columns>
          <Column Name="IsCrypted" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="IsHidden" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="IsPartialCrypted" Display="False">
            <Value>False</Value>
          </Column>
          <Column Name="Name" Display="UID_DPRSystemVariableSet">
            <Value>UID_DPRSystemVariableSet</Value>
          </Column>
          <Column Name="UID_Job" Display="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
            <Key>
              <Table Name="Job" Display="CCC_Start projection" Key="CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC">
                <Prop Name="UID_Job">
                  <Value>CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="UID_JobParameter" Display="DPR-E6976B615B8634408D7372F3CE4F18D3">
            <Key>
              <Table Name="JobParameter" Display="UID_DPRSystemVariableSet" Key="DPR-E6976B615B8634408D7372F3CE4F18D3">
                <Prop Name="UID_JobParameter">
                  <Value>DPR-E6976B615B8634408D7372F3CE4F18D3</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="ValueTemplate" Display="Value = values(&quot;UID_DPRSystemVariableSet&quot;).ToString()">
            <Value>Value = values("UID_DPRSystemVariableSet").ToString()</Value>
          </Column>
          <Column Name="XDateInserted" Display="2/8/2018 11:28:19 AM">
            <Value>2018-02-08T10:28:19.1230000Z</Value>
          </Column>
          <Column Name="XDateUpdated" Display="2/8/2018 11:28:19 AM">
            <Value>2018-02-08T10:28:19.1230000Z</Value>
          </Column>
          <Column Name="XMarkedForDeletion">
            <Value>0</Value>
          </Column>
          <Column Name="XObjectKey" Display="&lt;Key&gt;&lt;T&gt;JobRunParameter&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;P&gt;DPR-E6976B615B8634408D7372F3CE4F18D3&lt;/P&gt;&lt;/Key&gt;">
            <Value>&lt;Key&gt;&lt;T&gt;JobRunParameter&lt;/T&gt;&lt;P&gt;CCC-1B3BFFDDDF540949A23EBAEFFB3A1EDC&lt;/P&gt;&lt;P&gt;DPR-E6976B615B8634408D7372F3CE4F18D3&lt;/P&gt;&lt;/Key&gt;</Value>
          </Column>
          <Column Name="XTouched">
            <Value>
            </Value>
          </Column>
          <Column Name="XUserInserted" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
          <Column Name="XUserUpdated" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
        </Columns>
      </DbObject>
      <DbObject Display="CCC_FORCE_ATTRIBUTE_SYNC - ADSAccount" Version="2">
        <Key>
          <Table Name="QBMEvent" Display="CCC_FORCE_ATTRIBUTE_SYNC - ADSAccount" Key="CCC-0862BAE1F76F08418AA5AEE2B0D3D475">
            <Prop Name="UID_QBMEvent">
              <Value>CCC-0862BAE1F76F08418AA5AEE2B0D3D475</Value>
            </Prop>
          </Table>
        </Key>
        <Columns>
          <Column Name="DisplayName" Display="CCC_FORCE_ATTRIBUTE_SYNC - ADSAccount">
            <Value>CCC_FORCE_ATTRIBUTE_SYNC - ADSAccount</Value>
          </Column>
          <Column Name="EventName" Display="CCC_FORCE_ATTRIBUTE_SYNC">
            <Value>CCC_FORCE_ATTRIBUTE_SYNC</Value>
          </Column>
          <Column Name="UID_DialogTable" Display="ADSAccount">
            <Key>
              <Table Name="DialogTable" Display="ADSAccount" Key="ADS-T-ADSAccount">
                <Prop Name="UID_DialogTable">
                  <Value>ADS-T-ADSAccount</Value>
                </Prop>
              </Table>
            </Key>
          </Column>
          <Column Name="UID_QBMEvent" Display="CCC-0862BAE1F76F08418AA5AEE2B0D3D475">
            <Value>CCC-0862BAE1F76F08418AA5AEE2B0D3D475</Value>
          </Column>
          <Column Name="XDateInserted" Display="2/8/2018 11:38:43 AM">
            <Value>2018-02-08T10:38:43.7700000Z</Value>
          </Column>
          <Column Name="XDateUpdated" Display="2/8/2018 11:38:43 AM">
            <Value>2018-02-08T10:38:43.7700000Z</Value>
          </Column>
          <Column Name="XMarkedForDeletion">
            <Value>0</Value>
          </Column>
          <Column Name="XObjectKey" Display="&lt;Key&gt;&lt;T&gt;QBMEvent&lt;/T&gt;&lt;P&gt;CCC-0862BAE1F76F08418AA5AEE2B0D3D475&lt;/P&gt;&lt;/Key&gt;">
            <Value>&lt;Key&gt;&lt;T&gt;QBMEvent&lt;/T&gt;&lt;P&gt;CCC-0862BAE1F76F08418AA5AEE2B0D3D475&lt;/P&gt;&lt;/Key&gt;</Value>
          </Column>
          <Column Name="XTouched">
            <Value>
            </Value>
          </Column>
          <Column Name="XUserInserted" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
          <Column Name="XUserUpdated" Display="WFTEST\ext00308">
            <Value>WFTEST\ext00308</Value>
          </Column>
        </Columns>
      </DbObject>
    </DbObjects>

     

    Regards.