Decrypt value in process task "PowerShellComponent - Execute Script"

Hi,

I'm trying to execute script from process task "PowerShellComponent - Execute Script" for executing command on Exchange server.

In parameter "StartScriptOrPath" I create remote PS session, so I need password from connector here, and I take it using: Connection.GetSingleProperty("DPRSystemVariable","Value", "Name = N'CP_Password'" )

It works when password in connector is not encrypted.

But after encrypting the database this process stopped working, However field "Partial Encrypted" was checked.

Default processes which use this encrypted password work fine, so I'm sure that JS can decrypt this password. For example Mailbox-Disable is working.

May be I should use encrypted value in special manner in my script ?

Top Replies

Parents

+1 Markus Weiss-Ehlers over 5 years ago

The thing is, that you cannot decrypt the sync variables directly in the PowerShell component. You need to let a script process step decrypt the password and then pass that password to your PowerShell process step.

You can decrypt the variable (only if it runs on the Job Service) with a script like the following:

Public Function CCC_Decrypt_DPRSystemVariable(ByVal EncryptedString As String, ByVal ReturnEncrypted As Boolean) As String

    Dim ReturnString As String
    Dim decrypter As VI.Projector.Security.DatabaseEncryption = New VI.Projector.Security.DatabaseEncryption(Connection.Session)

    ' decryption using the Projector method
    ReturnString = decrypter.Decrypt(EncryptedString)

    ' encryption using the object layer method - this value can be decrypted by the Jobserver
    If ReturnEncrypted Then
        ReturnString = Connection.Encryption.Encrypt(ReturnString)
    End If

    Return ReturnString

End Function

With the 2nd parameter, you can control if the script returns the decrypted value or if the script encrypts the value again using the Jobserver method and return this new encrypted string.

The 2nd one should be used if you need the value in further jobs in the same process.

In this case, call the mentioned script using a ScriptExec job, pass the DPR variable to the 1st parameter and "true" to the 2nd. And use the parameter "ParamOutName" to define the name of the OUT variable which contains the return value from the script - for example "DecryptedString".

This OUT variable can be used with the notation ""&OUT(DecryptedString)&"" in the next jobs.

Attached is an example process that was originally designed for 7.1.2.

<DbObjects>
  <DbObject Display="CCC_Decrypt_DPRSystemVariable" Version="2">
    <Key>
      <Table Name="JobChain" Display="CCC_Decrypt_DPRSystemVariable" Key="CCC-B5FA2D2571FE4D40AD739EBB7796CA4F">
        <Prop Name="UID_JobChain">
          <Value>CCC-B5FA2D2571FE4D40AD739EBB7796CA4F</Value>
        </Prop>
      </Table>
    </Key>
    <Columns>
      <Column Name="CustomRemarks">
        <Value>
        </Value>
      </Column>
      <Column Name="Description">
        <Value>
        </Value>
      </Column>
      <Column Name="GenCondition">
        <Value>
        </Value>
      </Column>
      <Column Name="LayoutPositions" Display="V1.1&#x7;JobChain_CCC_Decrypt_DPRSystemVariable&#x8;20&#x8;20&#x8;R600&#x7;Decrypt&#x8;20&#x8;120&#x8;S600&#x7;Write2log&#x8;20&#x8;230">
        <Value>V1.1&#x7;JobChain_CCC_Decrypt_DPRSystemVariable&#x8;20&#x8;20&#x8;R600&#x7;Decrypt&#x8;20&#x8;120&#x8;S600&#x7;Write2log&#x8;20&#x8;230</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_Decrypt_DPRSystemVariable">
        <Value>CCC_Decrypt_DPRSystemVariable</Value>
      </Column>
      <Column Name="NoGenerate" Display="False">
        <Value>False</Value>
      </Column>
      <Column Name="PreCode">
        <Value>
        </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="DPRSystemVariable">
        <Key>
          <Table Name="DialogTable" Display="DPRSystemVariable" Key="DPR-T-DPRSystemVariable">
            <Prop Name="UID_DialogTable">
              <Value>DPR-T-DPRSystemVariable</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_Job" Display="Decrypt">
        <Key>
          <Table Name="Job" Display="Decrypt" Key="CCC-628D1A5D38E7C64EAC895A982098E2AD">
            <Prop Name="UID_Job">
              <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobChain" Display="CCC-B5FA2D2571FE4D40AD739EBB7796CA4F">
        <Value>CCC-B5FA2D2571FE4D40AD739EBB7796CA4F</Value>
      </Column>
      <Column Name="XDateInserted" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.2600000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="2/6/2018 9:19:18 AM">
        <Value>2018-02-06T08:19:18.6930000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>JobChain</T><P>CCC-B5FA2D2571FE4D40AD739EBB7796CA4F</P></Key>">
        <Value><Key><T>JobChain</T><P>CCC-B5FA2D2571FE4D40AD739EBB7796CA4F</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="Decrypt" Version="2">
    <Key>
      <Table Name="Job" Display="Decrypt" Key="CCC-628D1A5D38E7C64EAC895A982098E2AD">
        <Prop Name="UID_Job">
          <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
        </Prop>
      </Table>
    </Key>
    <Columns>
      <Column Name="DeferOnError" Display="False">
        <Value>False</Value>
      </Column>
      <Column Name="Description">
        <Value>
        </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="False">
        <Value>False</Value>
      </Column>
      <Column Name="MinutesToDefer" Display="0">
        <Value>0</Value>
      </Column>
      <Column Name="Name" Display="Decrypt">
        <Value>Decrypt</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-628D1A5D38E7C64EAC895A982098E2AD">
        <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
      </Column>
      <Column Name="UID_JobChain" Display="CCC_Decrypt_DPRSystemVariable">
        <Key>
          <Table Name="JobChain" Display="CCC_Decrypt_DPRSystemVariable" Key="CCC-B5FA2D2571FE4D40AD739EBB7796CA4F">
            <Prop Name="UID_JobChain">
              <Value>CCC-B5FA2D2571FE4D40AD739EBB7796CA4F</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobTask" Display="ScriptExec">
        <Key>
          <Table Name="JobTask" Display="ScriptExec" Key="QBM-C5350C2B66F547FA801B323B165965CE">
            <Prop Name="UID_JobTask">
              <Value>QBM-C5350C2B66F547FA801B323B165965CE</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_QBMServerTag" Display="Master SQL server">
        <Key>
          <Table Name="QBMServerTag" Display="Master SQL server" Key="QBM-ST-Is07">
            <Prop Name="UID_QBMServerTag">
              <Value>QBM-ST-Is07</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_SuccessJob" Display="Write2log">
        <Key>
          <Table Name="Job" Display="Write2log" Key="CCC-5B9DB9CCF9344744841D0A91F039AE7D">
            <Prop Name="UID_Job">
              <Value>CCC-5B9DB9CCF9344744841D0A91F039AE7D</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="XDateInserted" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.5430000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.5430000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>Job</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P></Key>">
        <Value><Key><T>Job</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="CCC-177246F5C00D6F4DB9292DB7A6A7DB79" Version="2">
    <Key>
      <Table Name="JobEventGen" Display="CCC-177246F5C00D6F4DB9292DB7A6A7DB79" Key="CCC-B440217CFB46B742BF448429EF877A0B">
        <Prop Name="UID_JobEventGen">
          <Value>CCC-B440217CFB46B742BF448429EF877A0B</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-B5FA2D2571FE4D40AD739EBB7796CA4F">
        <Key>
          <Table Name="JobChain" Display="CCC_Decrypt_DPRSystemVariable" Key="CCC-B5FA2D2571FE4D40AD739EBB7796CA4F">
            <Prop Name="UID_JobChain">
              <Value>CCC-B5FA2D2571FE4D40AD739EBB7796CA4F</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobEventGen" Display="CCC-B440217CFB46B742BF448429EF877A0B">
        <Value>CCC-B440217CFB46B742BF448429EF877A0B</Value>
      </Column>
      <Column Name="UID_QBMEvent" Display="CCC-177246F5C00D6F4DB9292DB7A6A7DB79">
        <Key>
          <Table Name="QBMEvent" Display="Decrypt - DPRSystemVariable" Key="CCC-177246F5C00D6F4DB9292DB7A6A7DB79">
            <Prop Name="UID_QBMEvent">
              <Value>CCC-177246F5C00D6F4DB9292DB7A6A7DB79</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="XDateInserted" Display="2/6/2018 9:19:05 AM">
        <Value>2018-02-06T08:19:05.6250000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="2/6/2018 9:19:05 AM">
        <Value>2018-02-06T08:19:05.6250000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>JobEventGen</T><P>CCC-B440217CFB46B742BF448429EF877A0B</P></Key>">
        <Value><Key><T>JobEventGen</T><P>CCC-B440217CFB46B742BF448429EF877A0B</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="Write2log" Version="2">
    <Key>
      <Table Name="Job" Display="Write2log" Key="CCC-5B9DB9CCF9344744841D0A91F039AE7D">
        <Prop Name="UID_Job">
          <Value>CCC-5B9DB9CCF9344744841D0A91F039AE7D</Value>
        </Prop>
      </Table>
    </Key>
    <Columns>
      <Column Name="DeferOnError" Display="False">
        <Value>False</Value>
      </Column>
      <Column Name="Description">
        <Value>
        </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="False">
        <Value>False</Value>
      </Column>
      <Column Name="MinutesToDefer" Display="0">
        <Value>0</Value>
      </Column>
      <Column Name="Name" Display="Write2log">
        <Value>Write2log</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-5B9DB9CCF9344744841D0A91F039AE7D">
        <Value>CCC-5B9DB9CCF9344744841D0A91F039AE7D</Value>
      </Column>
      <Column Name="UID_JobChain" Display="CCC_Decrypt_DPRSystemVariable">
        <Key>
          <Table Name="JobChain" Display="CCC_Decrypt_DPRSystemVariable" Key="CCC-B5FA2D2571FE4D40AD739EBB7796CA4F">
            <Prop Name="UID_JobChain">
              <Value>CCC-B5FA2D2571FE4D40AD739EBB7796CA4F</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobTask" Display="ScriptExec">
        <Key>
          <Table Name="JobTask" Display="ScriptExec" Key="QBM-C5350C2B66F547FA801B323B165965CE">
            <Prop Name="UID_JobTask">
              <Value>QBM-C5350C2B66F547FA801B323B165965CE</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_QBMServerTag" Display="Master SQL server">
        <Key>
          <Table Name="QBMServerTag" Display="Master SQL server" Key="QBM-ST-Is07">
            <Prop Name="UID_QBMServerTag">
              <Value>QBM-ST-Is07</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_SuccessJob">
        <Value>
        </Value>
      </Column>
      <Column Name="XDateInserted" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.3930000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.3930000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>Job</T><P>CCC-5B9DB9CCF9344744841D0A91F039AE7D</P></Key>">
        <Value><Key><T>Job</T><P>CCC-5B9DB9CCF9344744841D0A91F039AE7D</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="AuthenticationString" Version="2">
    <Key>
      <Table Name="JobRunParameter" Display="AuthenticationString">
        <Prop Name="UID_Job">
          <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
        </Prop>
        <Prop Name="UID_JobParameter">
          <Value>QBM-E20AEE2CD2CB402F8F5F9092E35718BF</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-628D1A5D38E7C64EAC895A982098E2AD">
        <Key>
          <Table Name="Job" Display="Decrypt" Key="CCC-628D1A5D38E7C64EAC895A982098E2AD">
            <Prop Name="UID_Job">
              <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobParameter" Display="QBM-E20AEE2CD2CB402F8F5F9092E35718BF">
        <Key>
          <Table Name="JobParameter" Display="AuthenticationString" Key="QBM-E20AEE2CD2CB402F8F5F9092E35718BF">
            <Prop Name="UID_JobParameter">
              <Value>QBM-E20AEE2CD2CB402F8F5F9092E35718BF</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="ValueTemplate" Display="Value = ConnectionInfo.AuthString">
        <Value>Value = ConnectionInfo.AuthString</Value>
      </Column>
      <Column Name="XDateInserted" Display="8/24/2015 4:07:58 PM">
        <Value>2015-08-24T14:07:58.1930000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="8/24/2015 4:07:58 PM">
        <Value>2015-08-24T14:07:58.1930000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>JobRunParameter</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P><P>QBM-E20AEE2CD2CB402F8F5F9092E35718BF</P></Key>">
        <Value><Key><T>JobRunParameter</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P><P>QBM-E20AEE2CD2CB402F8F5F9092E35718BF</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="QBM_PBufferT_ProcessInsert">
        <Value>QBM_PBufferT_ProcessInsert</Value>
      </Column>
      <Column Name="XUserUpdated" Display="QBM_PBufferT_ProcessInsert">
        <Value>QBM_PBufferT_ProcessInsert</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="ConnectionProvider" Version="2">
    <Key>
      <Table Name="JobRunParameter" Display="ConnectionProvider">
        <Prop Name="UID_Job">
          <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
        </Prop>
        <Prop Name="UID_JobParameter">
          <Value>QBM-3F295A50E8DD4295BE96B25F0B76E498</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-628D1A5D38E7C64EAC895A982098E2AD">
        <Key>
          <Table Name="Job" Display="Decrypt" Key="CCC-628D1A5D38E7C64EAC895A982098E2AD">
            <Prop Name="UID_Job">
              <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobParameter" Display="QBM-3F295A50E8DD4295BE96B25F0B76E498">
        <Key>
          <Table Name="JobParameter" Display="ConnectionProvider" Key="QBM-3F295A50E8DD4295BE96B25F0B76E498">
            <Prop Name="UID_JobParameter">
              <Value>QBM-3F295A50E8DD4295BE96B25F0B76E498</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="ValueTemplate" Display="Value = ConnectionInfo.ConnectionProvider">
        <Value>Value = ConnectionInfo.ConnectionProvider</Value>
      </Column>
      <Column Name="XDateInserted" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.5870000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.5870000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>JobRunParameter</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P><P>QBM-3F295A50E8DD4295BE96B25F0B76E498</P></Key>">
        <Value><Key><T>JobRunParameter</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P><P>QBM-3F295A50E8DD4295BE96B25F0B76E498</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="ConnectionString" Version="2">
    <Key>
      <Table Name="JobRunParameter" Display="ConnectionString">
        <Prop Name="UID_Job">
          <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
        </Prop>
        <Prop Name="UID_JobParameter">
          <Value>QBM-2DA5BEF3C7684B7294A7146607D9C59B</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-628D1A5D38E7C64EAC895A982098E2AD">
        <Key>
          <Table Name="Job" Display="Decrypt" Key="CCC-628D1A5D38E7C64EAC895A982098E2AD">
            <Prop Name="UID_Job">
              <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobParameter" Display="QBM-2DA5BEF3C7684B7294A7146607D9C59B">
        <Key>
          <Table Name="JobParameter" Display="ConnectionString" Key="QBM-2DA5BEF3C7684B7294A7146607D9C59B">
            <Prop Name="UID_JobParameter">
              <Value>QBM-2DA5BEF3C7684B7294A7146607D9C59B</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="ValueTemplate" Display="Value = ConnectionInfo.ConnectionString">
        <Value>Value = ConnectionInfo.ConnectionString</Value>
      </Column>
      <Column Name="XDateInserted" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6170000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6170000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>JobRunParameter</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P><P>QBM-2DA5BEF3C7684B7294A7146607D9C59B</P></Key>">
        <Value><Key><T>JobRunParameter</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P><P>QBM-2DA5BEF3C7684B7294A7146607D9C59B</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="ParameterValue0" Version="2">
    <Key>
      <Table Name="JobRunParameter" Display="ParameterValue0">
        <Prop Name="UID_Job">
          <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
        </Prop>
        <Prop Name="UID_JobParameter">
          <Value>QBM-E7059CD113094CB59C7BEB897189843C</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="ParameterValue0">
        <Value>ParameterValue0</Value>
      </Column>
      <Column Name="UID_Job" Display="CCC-628D1A5D38E7C64EAC895A982098E2AD">
        <Key>
          <Table Name="Job" Display="Decrypt" Key="CCC-628D1A5D38E7C64EAC895A982098E2AD">
            <Prop Name="UID_Job">
              <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobParameter" Display="QBM-E7059CD113094CB59C7BEB897189843C">
        <Key>
          <Table Name="JobParameter" Display="ParameterValue0" Key="QBM-E7059CD113094CB59C7BEB897189843C">
            <Prop Name="UID_JobParameter">
              <Value>QBM-E7059CD113094CB59C7BEB897189843C</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="ValueTemplate" Display="Value = $Value:Text$">
        <Value>Value = $Value:Text$</Value>
      </Column>
      <Column Name="XDateInserted" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6200000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6200000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>JobRunParameter</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P><P>QBM-E7059CD113094CB59C7BEB897189843C</P></Key>">
        <Value><Key><T>JobRunParameter</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P><P>QBM-E7059CD113094CB59C7BEB897189843C</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="ParameterValue1" Version="2">
    <Key>
      <Table Name="JobRunParameter" Display="ParameterValue1">
        <Prop Name="UID_Job">
          <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
        </Prop>
        <Prop Name="UID_JobParameter">
          <Value>QBM-909C5A179DB8489F85EF1B8627866928</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="ParameterValue1">
        <Value>ParameterValue1</Value>
      </Column>
      <Column Name="UID_Job" Display="CCC-628D1A5D38E7C64EAC895A982098E2AD">
        <Key>
          <Table Name="Job" Display="Decrypt" Key="CCC-628D1A5D38E7C64EAC895A982098E2AD">
            <Prop Name="UID_Job">
              <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobParameter" Display="QBM-909C5A179DB8489F85EF1B8627866928">
        <Key>
          <Table Name="JobParameter" Display="ParameterValue1" Key="QBM-909C5A179DB8489F85EF1B8627866928">
            <Prop Name="UID_JobParameter">
              <Value>QBM-909C5A179DB8489F85EF1B8627866928</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="ValueTemplate" Display="Value = true">
        <Value>Value = true</Value>
      </Column>
      <Column Name="XDateInserted" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6230000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6230000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>JobRunParameter</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P><P>QBM-909C5A179DB8489F85EF1B8627866928</P></Key>">
        <Value><Key><T>JobRunParameter</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P><P>QBM-909C5A179DB8489F85EF1B8627866928</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="ParamOutName" Version="2">
    <Key>
      <Table Name="JobRunParameter" Display="ParamOutName">
        <Prop Name="UID_Job">
          <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
        </Prop>
        <Prop Name="UID_JobParameter">
          <Value>QBM-D1AC93F80E8A4E18A18D7EBCECF645F2</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="ParamOutName">
        <Value>ParamOutName</Value>
      </Column>
      <Column Name="UID_Job" Display="CCC-628D1A5D38E7C64EAC895A982098E2AD">
        <Key>
          <Table Name="Job" Display="Decrypt" Key="CCC-628D1A5D38E7C64EAC895A982098E2AD">
            <Prop Name="UID_Job">
              <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobParameter" Display="QBM-D1AC93F80E8A4E18A18D7EBCECF645F2">
        <Key>
          <Table Name="JobParameter" Display="ParamOutName" Key="QBM-D1AC93F80E8A4E18A18D7EBCECF645F2">
            <Prop Name="UID_JobParameter">
              <Value>QBM-D1AC93F80E8A4E18A18D7EBCECF645F2</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="ValueTemplate" Display="Value = "DecryptedString"">
        <Value>Value = "DecryptedString"</Value>
      </Column>
      <Column Name="XDateInserted" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6270000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6270000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>JobRunParameter</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P><P>QBM-D1AC93F80E8A4E18A18D7EBCECF645F2</P></Key>">
        <Value><Key><T>JobRunParameter</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P><P>QBM-D1AC93F80E8A4E18A18D7EBCECF645F2</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="ScriptName" Version="2">
    <Key>
      <Table Name="JobRunParameter" Display="ScriptName">
        <Prop Name="UID_Job">
          <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
        </Prop>
        <Prop Name="UID_JobParameter">
          <Value>QBM-8AC23451F7524207A8B8AF71224AE7FC</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="ScriptName">
        <Value>ScriptName</Value>
      </Column>
      <Column Name="UID_Job" Display="CCC-628D1A5D38E7C64EAC895A982098E2AD">
        <Key>
          <Table Name="Job" Display="Decrypt" Key="CCC-628D1A5D38E7C64EAC895A982098E2AD">
            <Prop Name="UID_Job">
              <Value>CCC-628D1A5D38E7C64EAC895A982098E2AD</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobParameter" Display="QBM-8AC23451F7524207A8B8AF71224AE7FC">
        <Key>
          <Table Name="JobParameter" Display="ScriptName" Key="QBM-8AC23451F7524207A8B8AF71224AE7FC">
            <Prop Name="UID_JobParameter">
              <Value>QBM-8AC23451F7524207A8B8AF71224AE7FC</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="ValueTemplate" Display="Value = "CCC_Decrypt_DPRSystemVariable"">
        <Value>Value = "CCC_Decrypt_DPRSystemVariable"</Value>
      </Column>
      <Column Name="XDateInserted" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6300000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6300000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>JobRunParameter</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P><P>QBM-8AC23451F7524207A8B8AF71224AE7FC</P></Key>">
        <Value><Key><T>JobRunParameter</T><P>CCC-628D1A5D38E7C64EAC895A982098E2AD</P><P>QBM-8AC23451F7524207A8B8AF71224AE7FC</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="Decrypt - DPRSystemVariable" Version="2">
    <Key>
      <Table Name="QBMEvent" Display="Decrypt - DPRSystemVariable" Key="CCC-177246F5C00D6F4DB9292DB7A6A7DB79">
        <Prop Name="UID_QBMEvent">
          <Value>CCC-177246F5C00D6F4DB9292DB7A6A7DB79</Value>
        </Prop>
      </Table>
    </Key>
    <Columns>
      <Column Name="DisplayName" Display="Decrypt - DPRSystemVariable">
        <Value>Decrypt - DPRSystemVariable</Value>
      </Column>
      <Column Name="EventName" Display="Decrypt">
        <Value>Decrypt</Value>
      </Column>
      <Column Name="UID_DialogTable" Display="DPRSystemVariable">
        <Key>
          <Table Name="DialogTable" Display="DPRSystemVariable" Key="DPR-T-DPRSystemVariable">
            <Prop Name="UID_DialogTable">
              <Value>DPR-T-DPRSystemVariable</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_QBMEvent" Display="CCC-177246F5C00D6F4DB9292DB7A6A7DB79">
        <Value>CCC-177246F5C00D6F4DB9292DB7A6A7DB79</Value>
      </Column>
      <Column Name="XDateInserted" Display="2/6/2018 9:19:04 AM">
        <Value>2018-02-06T08:19:04.6340000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="2/6/2018 9:19:04 AM">
        <Value>2018-02-06T08:19:04.6340000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>QBMEvent</T><P>CCC-177246F5C00D6F4DB9292DB7A6A7DB79</P></Key>">
        <Value><Key><T>QBMEvent</T><P>CCC-177246F5C00D6F4DB9292DB7A6A7DB79</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="AuthenticationString" Version="2">
    <Key>
      <Table Name="JobRunParameter" Display="AuthenticationString">
        <Prop Name="UID_Job">
          <Value>CCC-5B9DB9CCF9344744841D0A91F039AE7D</Value>
        </Prop>
        <Prop Name="UID_JobParameter">
          <Value>QBM-E20AEE2CD2CB402F8F5F9092E35718BF</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-5B9DB9CCF9344744841D0A91F039AE7D">
        <Key>
          <Table Name="Job" Display="Write2log" Key="CCC-5B9DB9CCF9344744841D0A91F039AE7D">
            <Prop Name="UID_Job">
              <Value>CCC-5B9DB9CCF9344744841D0A91F039AE7D</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobParameter" Display="QBM-E20AEE2CD2CB402F8F5F9092E35718BF">
        <Key>
          <Table Name="JobParameter" Display="AuthenticationString" Key="QBM-E20AEE2CD2CB402F8F5F9092E35718BF">
            <Prop Name="UID_JobParameter">
              <Value>QBM-E20AEE2CD2CB402F8F5F9092E35718BF</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="ValueTemplate" Display="Value = ConnectionInfo.AuthString">
        <Value>Value = ConnectionInfo.AuthString</Value>
      </Column>
      <Column Name="XDateInserted" Display="8/24/2015 4:07:58 PM">
        <Value>2015-08-24T14:07:58.1930000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="8/24/2015 4:07:58 PM">
        <Value>2015-08-24T14:07:58.1930000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>JobRunParameter</T><P>CCC-5B9DB9CCF9344744841D0A91F039AE7D</P><P>QBM-E20AEE2CD2CB402F8F5F9092E35718BF</P></Key>">
        <Value><Key><T>JobRunParameter</T><P>CCC-5B9DB9CCF9344744841D0A91F039AE7D</P><P>QBM-E20AEE2CD2CB402F8F5F9092E35718BF</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="QBM_PBufferT_ProcessInsert">
        <Value>QBM_PBufferT_ProcessInsert</Value>
      </Column>
      <Column Name="XUserUpdated" Display="QBM_PBufferT_ProcessInsert">
        <Value>QBM_PBufferT_ProcessInsert</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="ConnectionProvider" Version="2">
    <Key>
      <Table Name="JobRunParameter" Display="ConnectionProvider">
        <Prop Name="UID_Job">
          <Value>CCC-5B9DB9CCF9344744841D0A91F039AE7D</Value>
        </Prop>
        <Prop Name="UID_JobParameter">
          <Value>QBM-3F295A50E8DD4295BE96B25F0B76E498</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-5B9DB9CCF9344744841D0A91F039AE7D">
        <Key>
          <Table Name="Job" Display="Write2log" Key="CCC-5B9DB9CCF9344744841D0A91F039AE7D">
            <Prop Name="UID_Job">
              <Value>CCC-5B9DB9CCF9344744841D0A91F039AE7D</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobParameter" Display="QBM-3F295A50E8DD4295BE96B25F0B76E498">
        <Key>
          <Table Name="JobParameter" Display="ConnectionProvider" Key="QBM-3F295A50E8DD4295BE96B25F0B76E498">
            <Prop Name="UID_JobParameter">
              <Value>QBM-3F295A50E8DD4295BE96B25F0B76E498</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="ValueTemplate" Display="Value = ConnectionInfo.ConnectionProvider">
        <Value>Value = ConnectionInfo.ConnectionProvider</Value>
      </Column>
      <Column Name="XDateInserted" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6330000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6330000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>JobRunParameter</T><P>CCC-5B9DB9CCF9344744841D0A91F039AE7D</P><P>QBM-3F295A50E8DD4295BE96B25F0B76E498</P></Key>">
        <Value><Key><T>JobRunParameter</T><P>CCC-5B9DB9CCF9344744841D0A91F039AE7D</P><P>QBM-3F295A50E8DD4295BE96B25F0B76E498</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="ConnectionString" Version="2">
    <Key>
      <Table Name="JobRunParameter" Display="ConnectionString">
        <Prop Name="UID_Job">
          <Value>CCC-5B9DB9CCF9344744841D0A91F039AE7D</Value>
        </Prop>
        <Prop Name="UID_JobParameter">
          <Value>QBM-2DA5BEF3C7684B7294A7146607D9C59B</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-5B9DB9CCF9344744841D0A91F039AE7D">
        <Key>
          <Table Name="Job" Display="Write2log" Key="CCC-5B9DB9CCF9344744841D0A91F039AE7D">
            <Prop Name="UID_Job">
              <Value>CCC-5B9DB9CCF9344744841D0A91F039AE7D</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobParameter" Display="QBM-2DA5BEF3C7684B7294A7146607D9C59B">
        <Key>
          <Table Name="JobParameter" Display="ConnectionString" Key="QBM-2DA5BEF3C7684B7294A7146607D9C59B">
            <Prop Name="UID_JobParameter">
              <Value>QBM-2DA5BEF3C7684B7294A7146607D9C59B</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="ValueTemplate" Display="Value = ConnectionInfo.ConnectionString">
        <Value>Value = ConnectionInfo.ConnectionString</Value>
      </Column>
      <Column Name="XDateInserted" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6370000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6370000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>JobRunParameter</T><P>CCC-5B9DB9CCF9344744841D0A91F039AE7D</P><P>QBM-2DA5BEF3C7684B7294A7146607D9C59B</P></Key>">
        <Value><Key><T>JobRunParameter</T><P>CCC-5B9DB9CCF9344744841D0A91F039AE7D</P><P>QBM-2DA5BEF3C7684B7294A7146607D9C59B</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="ParameterValue0" Version="2">
    <Key>
      <Table Name="JobRunParameter" Display="ParameterValue0">
        <Prop Name="UID_Job">
          <Value>CCC-5B9DB9CCF9344744841D0A91F039AE7D</Value>
        </Prop>
        <Prop Name="UID_JobParameter">
          <Value>QBM-E7059CD113094CB59C7BEB897189843C</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="ParameterValue0">
        <Value>ParameterValue0</Value>
      </Column>
      <Column Name="UID_Job" Display="CCC-5B9DB9CCF9344744841D0A91F039AE7D">
        <Key>
          <Table Name="Job" Display="Write2log" Key="CCC-5B9DB9CCF9344744841D0A91F039AE7D">
            <Prop Name="UID_Job">
              <Value>CCC-5B9DB9CCF9344744841D0A91F039AE7D</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobParameter" Display="QBM-E7059CD113094CB59C7BEB897189843C">
        <Key>
          <Table Name="JobParameter" Display="ParameterValue0" Key="QBM-E7059CD113094CB59C7BEB897189843C">
            <Prop Name="UID_JobParameter">
              <Value>QBM-E7059CD113094CB59C7BEB897189843C</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="ValueTemplate" Display="Value = "c:\temp\log\DecryptionTest.log"">
        <Value>Value = "c:\temp\log\DecryptionTest.log"</Value>
      </Column>
      <Column Name="XDateInserted" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6400000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6400000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>JobRunParameter</T><P>CCC-5B9DB9CCF9344744841D0A91F039AE7D</P><P>QBM-E7059CD113094CB59C7BEB897189843C</P></Key>">
        <Value><Key><T>JobRunParameter</T><P>CCC-5B9DB9CCF9344744841D0A91F039AE7D</P><P>QBM-E7059CD113094CB59C7BEB897189843C</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="ParameterValue1" Version="2">
    <Key>
      <Table Name="JobRunParameter" Display="ParameterValue1">
        <Prop Name="UID_Job">
          <Value>CCC-5B9DB9CCF9344744841D0A91F039AE7D</Value>
        </Prop>
        <Prop Name="UID_JobParameter">
          <Value>QBM-909C5A179DB8489F85EF1B8627866928</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="ParameterValue1">
        <Value>ParameterValue1</Value>
      </Column>
      <Column Name="UID_Job" Display="CCC-5B9DB9CCF9344744841D0A91F039AE7D">
        <Key>
          <Table Name="Job" Display="Write2log" Key="CCC-5B9DB9CCF9344744841D0A91F039AE7D">
            <Prop Name="UID_Job">
              <Value>CCC-5B9DB9CCF9344744841D0A91F039AE7D</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobParameter" Display="QBM-909C5A179DB8489F85EF1B8627866928">
        <Key>
          <Table Name="JobParameter" Display="ParameterValue1" Key="QBM-909C5A179DB8489F85EF1B8627866928">
            <Prop Name="UID_JobParameter">
              <Value>QBM-909C5A179DB8489F85EF1B8627866928</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="ValueTemplate" Display="Value = "&OUT(DecryptedString)&"">
        <Value>Value = "&OUT(DecryptedString)&"</Value>
      </Column>
      <Column Name="XDateInserted" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6470000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6470000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>JobRunParameter</T><P>CCC-5B9DB9CCF9344744841D0A91F039AE7D</P><P>QBM-909C5A179DB8489F85EF1B8627866928</P></Key>">
        <Value><Key><T>JobRunParameter</T><P>CCC-5B9DB9CCF9344744841D0A91F039AE7D</P><P>QBM-909C5A179DB8489F85EF1B8627866928</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
  <DbObject Display="ScriptName" Version="2">
    <Key>
      <Table Name="JobRunParameter" Display="ScriptName">
        <Prop Name="UID_Job">
          <Value>CCC-5B9DB9CCF9344744841D0A91F039AE7D</Value>
        </Prop>
        <Prop Name="UID_JobParameter">
          <Value>QBM-8AC23451F7524207A8B8AF71224AE7FC</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="ScriptName">
        <Value>ScriptName</Value>
      </Column>
      <Column Name="UID_Job" Display="CCC-5B9DB9CCF9344744841D0A91F039AE7D">
        <Key>
          <Table Name="Job" Display="Write2log" Key="CCC-5B9DB9CCF9344744841D0A91F039AE7D">
            <Prop Name="UID_Job">
              <Value>CCC-5B9DB9CCF9344744841D0A91F039AE7D</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="UID_JobParameter" Display="QBM-8AC23451F7524207A8B8AF71224AE7FC">
        <Key>
          <Table Name="JobParameter" Display="ScriptName" Key="QBM-8AC23451F7524207A8B8AF71224AE7FC">
            <Prop Name="UID_JobParameter">
              <Value>QBM-8AC23451F7524207A8B8AF71224AE7FC</Value>
            </Prop>
          </Table>
        </Key>
      </Column>
      <Column Name="ValueTemplate" Display="Value = "vid_write2log"">
        <Value>Value = "vid_write2log"</Value>
      </Column>
      <Column Name="XDateInserted" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6500000Z</Value>
      </Column>
      <Column Name="XDateUpdated" Display="3/1/2017 10:39:55 AM">
        <Value>2017-03-01T09:39:55.6500000Z</Value>
      </Column>
      <Column Name="XMarkedForDeletion">
        <Value>0</Value>
      </Column>
      <Column Name="XObjectKey" Display="<Key><T>JobRunParameter</T><P>CCC-5B9DB9CCF9344744841D0A91F039AE7D</P><P>QBM-8AC23451F7524207A8B8AF71224AE7FC</P></Key>">
        <Value><Key><T>JobRunParameter</T><P>CCC-5B9DB9CCF9344744841D0A91F039AE7D</P><P>QBM-8AC23451F7524207A8B8AF71224AE7FC</P></Key></Value>
      </Column>
      <Column Name="XTouched">
        <Value>
        </Value>
      </Column>
      <Column Name="XUserInserted" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
      <Column Name="XUserUpdated" Display="viadmin">
        <Value>viadmin</Value>
      </Column>
    </Columns>
  </DbObject>
</DbObjects>

HtH

0 dezuykov over 4 years ago in reply to Markus Weiss-Ehlers

Markus, if I decrypt password using your script (out parameter: DecryptedPwd) and use it in parameter of the next step(Powershell script), I can see password as plain text in logs in case of error. However, I've checked "Hidden" property for parameter where I use password. Is it possible to hide password from logs?

Imports System
Imports System.Collections.Generic
Dim fullPath As String = "\\" & $FK(UID_HomeServer).Ident_Server$ & "\" & $HomeShare$ & "\" & $HomeDirPath$
Dim remote_user As String = Connection.GetConfigParm("Custom\ADS\Home_Folder\" & $FK(UID_ADSDomain).ADSDomainName$ & "\Remote_user")
Dim domain As String = $FK(UID_ADSDomain).ADSDomainName$
Dim script As New StringBuilder()
　
script.Append("$credential = New-Object System.Management.Automation.PsCredential -ArgumentList """)
script.Append( remote_user )
script.Append( """,(ConvertTo-SecureString """)
script.Append( "&Out(DecryptedPwd)&" )
script.Append(""" –AsPlainText -force)")
script.Append(Environment.NewLine)
script.AppendLine(String.Format("$$session = New-PSSession –ComputerName localhost -Credential {0} -Authentication Credssp", "$$credential"))
script.AppendLine(String.Format("invoke-command -session {0} {{ $$fullPath = '{1}' }}", "$$session", fullPath))
script.AppendLine(String.Format("invoke-command -session {0} {{ $$homeShare = New-Item -path $$fullPath -ItemType Directory -ea Stop }}", "$$session" ))
script.AppendLine(String.Format("invoke-command -session {0} {{ $$acl = Get-Acl $$homeShare }}", "$$session" ))
script.AppendLine(String.Format("invoke-command -session {0} {{ $$AccessRule = New-Object System.Security.AccessControl.FileSystemAccessRule (""{1}"", ""Modify"", ""ContainerInherit,ObjectInherit"", ""None"",""Allow"") }}", "$$session",$UserPrincipalName$ ))
script.AppendLine(String.Format("invoke-command -session {0} {{ $$acl.AddAccessRule($AccessRule) }}", "$$session" ))
script.AppendLine(String.Format("invoke-command -session {0} {{ Set-Acl -Path $homeShare -AclObject $$acl -ea Stop }}", "$$session" ))
　
script.AppendLine("Remove-PsSession $$session")
Value = script.ToString()

0 Markus Weiss-Ehlers over 4 years ago in reply to dezuykov

As the variable is part of your PowerShell code, the system is unable to hide it from the log. But may allow me to ask why you are doing home-share stuff with a PowerShell script instead of using the OneIM components for that?
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
+1 Markus Weiss-Ehlers over 4 years ago in reply to Markus Weiss-Ehlers

If it has to be PowerShell you could use your code and create a custom function from it like "Create-MyHomeShare". You could then use the ExecuteCommand task from the component and fill the variable you need in your custom function using the job parameters. One of them would be the password which is marked as encrypted.
Cancel
Up +1 Down

Reply

Reject Answer

Cancel
0 dezuykov over 4 years ago in reply to Markus Weiss-Ehlers

Our customer wants us to run Job Service only under "local system" user and in the same time Information Security department doesn't agree to give access to destination folder for server (system) account, because such account can't have responsible person.

Solution with dedicated JS also doesn't satisfy our customer.

So I have to do such a crazy things)
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Markus Weiss-Ehlers over 4 years ago in reply to dezuykov

You have an opportunity here, sell the customer Safeguard to protect your privileged credentials and checkout the current password from Safeguard in your Powershell script. The user to do that checkout could be based on a certificate.

In that case, you have protected the password and wouldn't have to work around those requirements. Or you go with my second proposal.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 dezuykov over 4 years ago in reply to Markus Weiss-Ehlers

I think I will choose option with custom function.

Also, I tried to use process task "PowershellComponentNet4 - ExecuteRemoteHostScript" where I need to enter password in predefined parameter.

Such process task works, however script is executed as user under who job service was executed, but not as user from "User" parameter of this step.

May be I do something wrong in Screenshot?
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Markus Weiss-Ehlers over 4 years ago in reply to dezuykov

The ExecuteRemoteHostScript opens a remote PowerShell session to the computer specified using user/password to create the remote connection.

If something is not working here as expected please contact support.

In addition, my workaround proposal was to use ExecuteCommand to be able to pass the password as a hidden & encrypted parameter.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Reply

0 Markus Weiss-Ehlers over 4 years ago in reply to dezuykov

The ExecuteRemoteHostScript opens a remote PowerShell session to the computer specified using user/password to create the remote connection.

If something is not working here as expected please contact support.

In addition, my workaround proposal was to use ExecuteCommand to be able to pass the password as a hidden & encrypted parameter.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Children

No Data

Endpoint Privilege Management

Decrypt value in process task "PowerShellComponent - Execute Script"

Top Replies