ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

PowerShell Desired State Configuration (DSC) ืกื™ืžืคึผืœืึทืคื™ื™ื– ื–ื™ื™ืขืจ ื“ื™ ืึทืจื‘ืขื˜ ืคื•ืŸ ื“ื™ืคึผืœื•ื™ื™ื ื’ ืื•ืŸ ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ ื“ื™ ืึธืคึผืขืจื™ื™ื˜ื™ื ื’ ืกื™ืกื˜ืขื, ืกืขืจื•ื•ืขืจ ืจืึธืœืขืก ืื•ืŸ ืึทืคึผืœืึทืงื™ื™ืฉืึทื ื– ื•ื•ืขืŸ ืื™ืจ ื”ืึธื‘ืŸ ื”ื•ื ื“ืขืจื˜ืขืจ ืคื•ืŸ ืกืขืจื•ื•ืขืจืก.

ืื‘ืขืจ ื•ื•ืขืŸ ื ื™ืฆืŸ DSC ืื•ื™ืฃ-ืœืึธืงืึทืœ, ื“.ื”. ื ื™ืฉื˜ ืื™ืŸ MS Azure, ืขืก ื–ืขื ืขืŸ ืึท ืคึผืึธืจ ืคื•ืŸ ื ื•ืึทื ืกื™ื–. ื–ื™ื™ ื–ืขื ืขืŸ ืกืคึผืขืฆื™ืขืœ ื‘ืืžืขืจืงื˜ ืื•ื™ื‘ ื“ื™ ืึธืจื’ืึทื ื™ื–ืึทืฆื™ืข ืื™ื– ื’ืจื•ื™ืก (ืคื•ืŸ 300 ื•ื•ืขืจืงืกื˜ื™ื™ืฉืึทื ื– ืื•ืŸ ืกืขืจื•ื•ืขืจืก) ืื•ืŸ ื”ืื˜ ื ื™ืฉื˜ ื ืึธืš ื“ื™ืกืงืึทื•ื•ืขืจื“ ื“ื™ ื•ื•ืขืœื˜ ืคื•ืŸ ืงืึทื ื˜ื™ื™ื ืขืจื–:

  • ืขืก ื–ืขื ืขืŸ ืงื™ื™ืŸ ืคื•ืœ ืจื™ืคึผืึธืจืฅ ืื•ื™ืฃ ื“ื™ ืกื˜ืึทื˜ื•ืก ืคื•ืŸ ืกื™ืกื˜ืขืžืขืŸ. ืื•ื™ื‘ ื“ื™ ืคืืจืœืื ื’ื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื™ื– ื ื™ืฉื˜ ื’ืขื•ื•ืขื ื“ื˜ ืื•ื™ืฃ ืขื˜ืœืขื›ืข ืกืขืจื•ื•ืขืจืก, ืึธืŸ ื“ื™ ืจื™ืคึผืึธืจืฅ ืžื™ืจ ื•ื•ืขืœืŸ ื ื™ืฉื˜ ื•ื•ื™ืกืŸ ื•ื•ืขื’ืŸ ืื™ื. ืขืก ืื™ื– ื’ืึทื ืฅ ืฉื•ื•ืขืจ ืฆื• ื‘ืึทืงื•ืžืขืŸ ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข ืคื•ืŸ โ€‹โ€‹ื“ื™ ื’ืขื‘ื•ื™ื˜-ืื™ืŸ ืจื™ืคึผืึธืจื˜ื™ื ื’ ืกืขืจื•ื•ืขืจ, ืื•ืŸ ืคึฟืึทืจ ืึท ื’ืจื•ื™ืก ื ื•ืžืขืจ ืคื•ืŸ ืžื—ื ื•ืช ืขืก ืงืขืŸ ืื•ื™ืš ื ืขืžืขืŸ ืึท ืœืึทื ื’ ืฆื™ื™ึทื˜.
  • ืœืึทืงืก ืกืงืึทืœืึทื‘ื™ืœื™ื˜ื™ ืื•ืŸ ืฉื•ืœื“ ื˜ืึธืœืขืจืึทื ืฅ. ืขืก ืื™ื– ืื•ืžืžืขื’ืœืขืš ืฆื• ื‘ื•ื™ืขืŸ ืึท ืคืึทืจื ืคื•ืŸ DSC ืคึผื•ืœ ื•ื•ืขื‘ ืกืขืจื•ื•ืขืจืก ื•ื•ืึธืก ื•ื•ืึธืœื˜ ื”ืึธื‘ืŸ ืึท ืื™ื™ืŸ ืฉื•ืœื“-ื˜ืึธืœืขืจืึทื ื˜ ื“ืึทื˜ืึทื‘ื™ื™ืก ืื•ืŸ ืึท ืคึผืจืึธืกื˜ ืกื˜ืึธืจื™ื“ื–ืฉ ืคื•ืŸ ืžืึธืค ื˜ืขืงืขืก ืคึฟืึทืจ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทื ื–, ืžืึทื“ื–ืฉื•ืœื– ืื•ืŸ ืจืขื’ื™ืกื˜ืจืึทืฆื™ืข ืฉืœื™ืกืœืขืŸ.

ื”ื™ื™ึทื ื˜ ืื™ืš ื•ื•ืขื˜ ื–ืึธื’ืŸ ืื™ืจ ื•ื•ื™ ืื™ืจ ืงืขื ืขืŸ ืกืึธืœื•ื•ืข ื“ืขืจ ืขืจืฉื˜ืขืจ ืคึผืจืึธื‘ืœืขื ืื•ืŸ ื‘ืึทืงื•ืžืขืŸ ื“ืึทื˜ืŸ ืคึฟืึทืจ ืจื™ืคึผืึธืจื˜ื™ื ื’. ืึทืœืฅ ื•ื•ืึธืœื˜ ื–ื™ื™ืŸ ืกื™ืžืคึผืœืขืจ ืื•ื™ื‘ SQL ืงืขืŸ ื–ื™ื™ืŸ ื’ืขื•ื•ื™ื™ื ื˜ ื•ื•ื™ ืึท ื“ืึทื˜ืึทื‘ื™ื™ืก. ืžื™ืก ื”ื‘ื˜ื—ื•ืช ื’ืขื‘ื•ื™ื˜-ืื™ืŸ ืฉื˜ื™ืฆืŸ ื‘ืœื•ื™ื– ืื™ืŸ Windows Server 2019 ืึธื“ืขืจ ืื™ืŸ ื‘ื•ื™ืขืŸ Windows ืกืขืจื•ื•ืขืจ 1803. ื‘ืจืขื ื’ืขืŸ ื“ืึทื˜ืŸ ืžื™ื˜ ืึธืœืขื“ื‘ ืฉืคึผื™ื™ึทื–ืขืจ ืื•ื™ืš ื•ื•ืขื˜ ืคืึทืจืœืึธื–ืŸื•ื•ื™ื™ึทืœ DSC ืกืขืจื•ื•ื™ืจืขืจ ื ื™ืฆื˜ ืึท ื’ืขื”ื™ื™ืกืŸ ืคึผืึทืจืึทืžืขื˜ืขืจ ื•ื•ืึธืก ืื™ื– ื ื™ืฉื˜ ื’ืึธืจ ื’ืขืฉื˜ื™ืฆื˜ ื“ื•ืจืš OleDbCommand.

ืื™ืš ื’ืขืคึฟื•ื ืขืŸ ื“ืขื ืื•ืคึฟืŸ: ืคึฟืึทืจ ื™ืขื ืข ื•ื•ืึธืก ื ื•ืฆืŸ Windows Server 2012 ืื•ืŸ 2016, ืื™ืจ ืงืขื ืขืŸ ื ื™ื’ืŸ ื ื™ืฆืŸ ืึท SQL ื“ืึทื˜ืึทื‘ื™ื™ืก ื•ื•ื™ ืึท ื‘ืึทืงืขื ื“ ืคึฟืึทืจ ื“ื™ DSC ืึธื ืคึฟืจืขื’ ืกืขืจื•ื•ืขืจ. ืฆื• ื˜ืึธืŸ ื“ืึธืก, ืžื™ืจ ื•ื•ืขืœืŸ ืžืึทื›ืŸ ืึท "ืคึผืจืึธืงืกื™" ืื™ืŸ ื“ื™ ืคืึธืจืขื ืคื•ืŸ ืึท .mdb ื˜ืขืงืข ืžื™ื˜ ืคึฟืึทืจื‘ื•ื ื“ืŸ ื˜ื™ืฉืŸ, ื•ื•ืึธืก ื•ื•ืขื˜ ืจื™ื“ืขืจืขืงื˜ ื“ื™ ื“ืึทื˜ืŸ ื‘ืืงื•ืžืขืŸ ืคื•ืŸ ืงืœื™ืขื ื˜ ืจื™ืคึผืึธืจืฅ ืฆื• ื“ื™ ืกืงืœ ืกืขืจื•ื•ืขืจ ื“ืึทื˜ืึทื‘ื™ื™ืก.

ื‘ืึทืžืขืจืงื•ื ื’: ืคึฟืึทืจ Windows Server 2016 ืื™ืจ ืžื•ื–ืŸ ื ื•ืฆืŸ ืึทืงืกืขืก ื“ืึทื˜ืึทื‘ืึทืกืข ืžืึธื˜ืึธืจ 2016 ืงืก 86ื•ื•ื™ื™ึทืœ Microsoft.Jet.OLEDB.4.0 ืื™ื– ื ื™ื˜ ืžืขืจ ื’ืขืฉื˜ื™ืฆื˜.

ืื™ืš ื•ื•ืขืœ ื ื™ืฉื˜ ื’ื™ื™ืŸ ืื™ืŸ ื“ืขื˜ืึทืœ ื•ื•ืขื’ืŸ ื“ืขื ืคึผืจืึธืฆืขืก ืคื•ืŸ ื“ื™ืคึผืœื•ื™ื™ื ื’ ืึท DSC ืฆื™ืขืŸ ืกืขืจื•ื•ืขืจ, ืขืก ืื™ื– ื–ื™ื™ืขืจ ื’ื•ื˜ ื“ื™ืกืงืจื™ื™ื‘ื“ ื“ืึธ. ืื™ืš ื•ื•ืขืœ ื ืึธืจ ื‘ืึทืžืขืจืงืŸ ืึท ืคึผืึธืจ ืคื•ืŸ ื ืงื•ื“ื•ืช. ืื•ื™ื‘ ืžื™ืจ ืฆืขื•ื•ื™ืงืœืขืŸ ื“ื™ DSC ืคึผื•ืœืขืจ ืื•ื™ืฃ ื“ืขืจ ื–ืขืœื‘ื™ืงืขืจ ื•ื•ืขื‘ ืกืขืจื•ื•ืขืจ ืžื™ื˜ WSUS ืึธื“ืขืจ Kaspersky Security Center, ืžื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ื˜ื•ื™ืฉืŸ ื“ื™ ืคืืœื’ืขื ื“ืข ืคึผืึทืจืึทืžืขื˜ืขืจืก ืื™ืŸ ื“ื™ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืฉืึทืคื•ื ื’:

  1. UseSecurityBestPractices     = $false

    ืึทื ื“ืขืจืฉ, TLS 1.0 ื•ื•ืขื˜ ื–ื™ื™ืŸ ืคืึทืจืงืจื™ืคึผืœื˜ ืื•ืŸ ืื™ืจ ื•ื•ืขื˜ ื ื™ืฉื˜ ืงืขื ืขืŸ ืฆื• ืคืึทืจื‘ื™ื ื“ืŸ ืฆื• ื“ื™ SQL ื“ืึทื˜ืึทื‘ื™ื™ืก. Kaspersky Security Center ื•ื•ืขื˜ ืื•ื™ืš ื ื™ืฉื˜ ืึทืจื‘ืขื˜ืŸ (ื“ื™ ืคึผืจืึธื‘ืœืขื ื–ืึธืœ ื–ื™ื™ืŸ ืกืึทืœื•ื•ื“ ืื™ืŸ Kaspersky Security Center v11).

  2. Enable32BitAppOnWin64   = $true

    ืื•ื™ื‘ ืื™ืจ ื˜ืึธืŸ ื ื™ื˜ ืžืึทื›ืŸ ื“ืขื ืขื ื“ืขืจื•ื ื’, ืื™ืจ ื•ื•ืขื˜ ื ื™ืฉื˜ ืงืขื ืขืŸ ืฆื• ืœื•ื™ืคืŸ ื“ื™ AppPool DSC ืกืขืจื•ื•ืขืจ ืื•ื™ืฃ IIS ืžื™ื˜ WSUS.

  3. ื•ื•ืขืŸ ืื™ืจ ื™ื ืกื˜ืึทืœื™ืจืŸ DSC Server ืžื™ื˜ WSUS, ื“ื™ืกื™ื™ื‘ืึทืœ ืกื˜ืึทื˜ื™ืง ืื•ืŸ ื“ื™ื ืึทืžื™ืฉ ืงืึทื˜ืฉื™ื ื’ ืคึฟืึทืจ ื“ื™ DSC ืคึผืœืึทืฅ.

ื–ืืœ ืก ืžืึทืš ืื•ื™ืฃ ืฆื• ื‘ืึทืฉื˜ืขื˜ื™ืงืŸ ื“ื™ DSC ืกืขืจื•ื•ืขืจ ืฆื• ื ื•ืฆืŸ ื“ื™ SQL ื“ืึทื˜ืึทื‘ื™ื™ืก.

ืงืจื™ื™ื™ื˜ื™ื ื’ ืึท SQL ื“ืึทื˜ืึทื‘ื™ื™ืก

  1. ืœืึธืžื™ืจ ืฉืึทืคึฟืŸ ืึท ืœื™ื™ื“ื™ืง ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก ืžื™ื˜ ื“ื™ ื ืึธืžืขืŸ DSC.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  2. ืœืึธืžื™ืจ ืฉืึทืคึฟืŸ ืึท ื—ืฉื‘ื•ืŸ ืฆื• ืคืึทืจื‘ื™ื ื“ืŸ ืฆื• ื“ืขื ื“ืึทื˜ืึทื‘ื™ื™ืก. ืขืจืฉื˜ืขืจ, ืงืึธื ื˜ืจืึธืœื™ืจืŸ ืึทื– ื“ื™ SQL ืกืขืจื•ื•ืขืจ ืึทืœืึทื•ื– ืึธื˜ืขื ื˜ืึทืงื™ื™ืฉืึทืŸ ืคื•ืŸ ื‘ื™ื™ื“ืข Windows ืื•ืŸ SQL ืึทืงืึทื•ื ืฅ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  3. ื’ื™ื™ืŸ ืฆื• ื“ื™ ื‘ืึทื ื™ืฆืขืจ ืžืึทืคึผื™ื ื’ ืึธืคึผื˜ื™ื™ืœื•ื ื’. ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก, ืื™ืŸ ื“ืขื ืคืึทืœ DSC. ืžื™ืจ ื’ืขื‘ืŸ ื“ื™ ืจืขื›ื˜ ืคื•ืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ื‘ืึทื–ื™ืฆืขืจ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  4. ื’ืขื˜ืืŸ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

ืฉืึทืคึฟืŸ ืึท ืกื›ืขืžืข ืคึฟืึทืจ ื“ื™ DSC ื“ืึทื˜ืึทื‘ืึทืกืข

ืขืก ื–ืขื ืขืŸ ืฆื•ื•ื™ื™ ื•ื•ืขื’ืŸ ืฆื• ืฉืึทืคึฟืŸ ืึท ืกื›ืขืžืข ืคึฟืึทืจ ืึท DSC ื“ืึทื˜ืึทื‘ื™ื™ืก:

  • ื™ื ื“ื™ืคึผืขื ื“ืึทื ื˜ืœื™, ื“ื•ืจืš ืึท TSQL ืฉืจื™ืคื˜
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[Devices](
    [TargetName] [nvarchar](255) NOT NULL,
    [ConfigurationID] [nvarchar](255) NOT NULL,
    [ServerCheckSum] [nvarchar](255) NOT NULL,
    [TargetCheckSum] [nvarchar](255) NOT NULL,
    [NodeCompliant] [bit] NOT NULL,
    [LastComplianceTime] [datetime] NULL,
    [LastHeartbeatTime] [datetime] NULL,
    [Dirty] [bit] NOT NULL,
    [StatusCode] [int] NULL
    ) ON [PRIMARY]
    GO
     
    CREATE TABLE [dbo].[RegistrationData](
    [AgentId] [nvarchar](255) NOT NULL,
    [LCMVersion] [nvarchar](255) NULL,
    [NodeName] [nvarchar](255) NULL,
    [IPAddress] [nvarchar](255) NULL,
    [ConfigurationNames] [nvarchar](max) NULL
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    GO
     
    CREATE TABLE [dbo].[StatusReport](
    [JobId] [nvarchar](50) NOT NULL,
    [Id] [nvarchar](50) NOT NULL,
    [OperationType] [nvarchar](255) NULL,
    [RefreshMode] [nvarchar](255) NULL,
    [Status] [nvarchar](255) NULL,
    [LCMVersion] [nvarchar](50) NULL,
    [ReportFormatVersion] [nvarchar](255) NULL,
    [ConfigurationVersion] [nvarchar](255) NULL,
    [NodeName] [nvarchar](255) NULL,
    [IPAddress] [nvarchar](255) NULL,
    [StartTime] [datetime] NULL,
    [EndTime] [datetime] NULL,
    [Errors] [nvarchar](max) NULL,
    [StatusData] [nvarchar](max) NULL,
    [RebootRequested] [nvarchar](255) NULL
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    GO
  • ืึทืจื™ื™ึทื ืคื™ืจ ื“ืึทื˜ืŸ ืคื•ืŸ ืœื™ื™ื“ื™ืง devices.mdb ื•ื•ื™ ืึท ื˜ื™ื™ืœ ืคื•ืŸ ื“ื™ ืคึผืก ืžืึธื“ื•ืœืข PSDesiredStateConfiguration ื“ื•ืจืš ื“ื™ SQL Data Import Wizard.

    ื“ื™ Devices.mdb ืžื™ื˜ ื•ื•ืึธืก ืžื™ืจ ื•ื•ืขืœืŸ ืึทืจื‘ืขื˜ืŸ ืื™ื– ืœื™ื’ืŸ ืื™ืŸ C: WindowsSysWOW64WindowsPowerShellv1.0ModulesPSDesiredStateConfigurationPullServer.

  1. ืฆื• ืึทืจื™ื™ึทื ืคื™ืจ ื“ืึทื˜ืŸ, ืœื•ื™ืคืŸ ื“ื™ SQL Server Import and Export Wizard.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  2. ืžื™ืจ ืงืœื™ื™ึทื‘ืŸ ื•ื•ื• ืžื™ืจ ื•ื•ืขืœืŸ ื‘ืึทืงื•ืžืขืŸ ื“ื™ ื“ืึทื˜ืŸ - ืื™ืŸ ืื•ื ื“ื–ืขืจ ืคืึทืœ ืขืก ืื™ื– ืึท ืžื™ืงืจืึธืกืึธืคื˜ ืึทืงืกืขืก ื“ืึทื˜ืึทื‘ื™ื™ืก. ื“ืจื™ืงื˜ ื•ื•ื™ื™ึทื˜ืขืจ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  3. ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ ื“ื™ ื˜ืขืงืข ืคื•ืŸ โ€‹โ€‹ื•ื•ืึธืก ืžื™ืจ ืึทืจื™ื™ึทื ืคื™ืจ ื“ื™ ื“ื™ืึทื’ืจืึทืžืข.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  4. ืžื™ืจ ืึธื ื•ื•ื™ื™ึทื–ืŸ ื•ื•ื• ืฆื• ืึทืจื™ื™ึทื ืคื™ืจ - ืคึฟืึทืจ ืื•ื ื“ื– ืขืก ืื™ื– ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  5. ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ ื“ื™ ืกืงืœ ืกืขืจื•ื•ืขืจ (ืกืขืจื•ื•ืขืจ ื ืึธืžืขืŸ) ืื•ืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ืื™ืŸ ื•ื•ืึธืก ืžื™ืจ ื•ื•ืขืœืŸ ืึทืจื™ื™ึทื ืคื™ืจ ื“ืึทื˜ืŸ (ื“ืึทื˜ืึทื‘ืึทืกืข).

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  6. ืกืขืœืขืงื˜ื™ืจืŸ ื“ืขื ืึธืคึผืฆื™ืข ื ืึธื›ืžืึทื›ืŸ ื“ืึทื˜ืŸ ืคื•ืŸ ืื™ื™ืŸ ืึธื“ืขืจ ืžืขืจ ื˜ื™ืฉืŸ ืึธื“ืขืจ ืงื•ืงืŸ (ืงืึธืคึผื™ืข ื“ืึทื˜ืŸ ืคื•ืŸ ื˜ื™ืฉืŸ ืึธื“ืขืจ ืงื•ืงืŸ).

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  7. ืžื™ืจ ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ ื“ื™ ื˜ื™ืฉืŸ ืคื•ืŸ ื•ื•ืึธืก ืžื™ืจ ื•ื•ืขืœืŸ ืึทืจื™ื™ึทื ืคื™ืจ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ืกื˜ืฉืขืžืึท.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  8. ืงื•ืง ื“ื™ ืœื•ื™ืคืŸ ืžื™ื“ ื˜ืฉืขืงืงื‘ืึธืงืก ืื•ืŸ ื’ื™ื˜ ืขื ื“ื™ืงืŸ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  9. ื’ืขื˜ืืŸ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  10. ื•ื•ื™ ืึท ืจืขื–ื•ืœื˜ืึทื˜, ื˜ื™ืฉืŸ ื–ืึธืœ ื“ืขืจืฉื™ื™ึทื ืขืŸ ืื™ืŸ ื“ื™ DSC ื“ืึทื˜ืึทื‘ื™ื™ืก.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

ื‘ืึทืฉื˜ืขื˜ื™ืงืŸ ืึท .mdb "ืคึผืจืึธืงืกื™" ื˜ืขืงืข

ืฉืึทืคึฟืŸ ืึทืŸ ODBC ืคึฟืึทืจื‘ื™ื ื“ื•ื ื’ ืฆื• ืึท ืกืงืœ ืกืขืจื•ื•ืขืจ. ืขืก ืื™ื– ืื ื’ืขื ื•ืžืขืŸ ืึทื– ืžื™ื– ืึทืงืกืขืก ืื™ื– ื ื™ืฉื˜ ืื™ื ืกื˜ืึทืœื™ืจืŸ ืื•ื™ืฃ ื“ื™ ืกืขืจื•ื•ืขืจ ืคืœื™ืกื ื“ื™ืง ื“ืกืง, ืึทื–ื•ื™ ื‘ืึทืฉื˜ืขื˜ื™ืงืŸ ืึทืจื•ื™ืฃ databases.mdb ืื™ื– ื’ืขื˜ืืŸ ืื•ื™ืฃ ืึท ื™ื ื˜ืขืจืžื™ื“ื™ื™ื˜ ื‘ืึทืœืขื‘ืึธืก ืžื™ื˜ ืžื™ื– ืึทืงืกืขืก ืื™ื ืกื˜ืึทืœื™ืจืŸ.

ืœืึธืžื™ืจ ืžืึทื›ืŸ ืึท ืกื™ืกื˜ืขื ODBC ืคึฟืึทืจื‘ื™ื ื“ื•ื ื’ ืฆื• ื“ื™ ืกืงืœ ืกืขืจื•ื•ืขืจ (ื“ื™ ืงืึทื ืขืงืฉืึทืŸ ื‘ื™ื˜ื˜ื ืขืกืก ืžื•ื–ืŸ ื’ืœื™ื™ึทื›ืŸ ื“ื™ MS Access bitness - 64 ืึธื“ืขืจ 32). ืขืก ืงืขื ืขืŸ ื–ื™ื™ืŸ ื‘ืืฉืืคืŸ ืžื™ื˜:
- Powershell cmdlet:

Add-OdbcDsn โ€“Name DSC โ€“DriverName 'SQL Server' โ€“Platform '<64-bit or 32-bit>' โ€“DsnType System โ€“SetPropertyValue @('Description=DSC Pull Server',"Server=<Name of your SQL Server>",'Trusted_Connection=yes','Database=DSC') โ€“PassThru

- ืึธื“ืขืจ ืžืึทื ื™ื•ืึทืœื™, ื ื™ืฆืŸ ื“ื™ ืงืฉืจ ืžืึทื–ืขืง:

  1. ืขืคืขื ืขืŸ ืึทื“ืžื™ื ื™ืกื˜ืจืึทื˜ื™ื•ื•ืข ืžื›ืฉื™ืจื™ื. ืžื™ืจ ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ ODBC ื“ืึทื˜ืŸ ืงื•ื•ืืœืŸ ื“ื™ืคึผืขื ื“ื™ื ื’ ืื•ื™ืฃ ื“ื™ ื•ื•ืขืจืกื™ืข ืคื•ืŸ โ€‹โ€‹ืื™ื ืกื˜ืึทืœื™ืจืŸ MS Access. ื’ื™ื™ืŸ ืฆื• ื“ื™ ืกื™ืกื˜ืขื DSN ืงื•ื•ื™ื˜ืœ ืื•ืŸ ืฉืึทืคึฟืŸ ืึท ืกื™ืกื˜ืขื ืงืฉืจ (ืœื™ื™ื’).

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  2. ืžื™ืจ ืึธื ื•ื•ื™ื™ึทื–ืŸ ืึทื– ืžื™ืจ ื•ื•ืขืœืŸ ืคืึทืจื‘ื™ื ื“ืŸ ืฆื• ื“ื™ SQL ืกืขืจื•ื•ืขืจ. ื“ืจื™ืงื˜ ืขื ื“ื™ืงืŸ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  3. ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ื“ื™ ื ืึธืžืขืŸ ืื•ืŸ ืกืขืจื•ื•ืขืจ ืฆื• ืคืึทืจื‘ื™ื ื“ืŸ. ื“ืขืจื ืึธืš ืึท ืงืฉืจ ืžื™ื˜ ื“ื™ ื–ืขืœื‘ืข ืคึผืึทืจืึทืžืขื˜ืขืจืก ื•ื•ืขื˜ ื–ื™ื™ืŸ ื‘ืืฉืืคืŸ ืื•ื™ืฃ ื“ื™ DSC ืกืขืจื•ื•ืขืจ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  4. ืžื™ืจ ืึธื ื•ื•ื™ื™ึทื–ืŸ ืึทื– ืฆื• ืคืึทืจื‘ื™ื ื“ืŸ ืฆื• ื“ื™ SQL ืกืขืจื•ื•ืขืจ, ืžื™ืจ ื ื•ืฆืŸ ืึท ืคืจื™ืขืจ ื‘ืืฉืืคืŸ ืœืึธื’ื™ืŸ ืžื™ื˜ ื“ื™ ื ืึธืžืขืŸ DSC.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  5. ืžื™ืจ ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ืื™ืŸ ื“ื™ DSC ืงืึทื ืขืงืฉืึทืŸ ืกืขื˜ื˜ื™ื ื’ืก.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  6. ื“ืจื™ืงื˜ ืขื ื“ื™ืงืŸ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  7. ืื™ื™ื“ืขืจ ืงืึทืžืคึผืœื™ื˜ื™ื ื’ ื“ื™ ืกืขื˜ืึทืคึผ, ืžื™ืจ ืงืึธื ื˜ืจืึธืœื™ืจืŸ ืึทื– ื“ื™ ืงืฉืจ ืื™ื– ืืจื‘ืขื˜ืŸ (ื˜ืขืกื˜ ื“ืึทื˜ืึท ืžืงื•ืจ).

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  8. ื’ืขื˜ืืŸ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

ืงืจื™ื™ื™ื˜ื™ื ื’ ืึท ื“ื™ื•ื•ื™ื™ืกืึทื–.ืžื“ื‘ ื“ืึทื˜ืึทื‘ื™ื™ืก ืื™ืŸ ืžื™ื– ืึทืงืกืขืก. ืงืึทื˜ืขืจ ืžื™ื– ืึทืงืกืขืก ืื•ืŸ ืฉืึทืคึฟืŸ ืึท ืœื™ื™ื“ื™ืง ื“ืึทื˜ืึทื‘ื™ื™ืก ื’ืขืจื•ืคืŸ devices.mdb.

ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  1. ื’ื™ื™ืŸ ืฆื• ื“ื™ ืคื•ื ื“ืจื•ื™ืกื ื“ื™ืง ื“ืึทื˜ืึท ืงื•ื•ื™ื˜ืœ ืื•ืŸ ื’ื™ื˜ ืื•ื™ืฃ ODBC ื“ืึทื˜ืึทื‘ืึทืกืข. ืื™ืŸ ื“ื™ ืคึฟืขื ืฆื˜ืขืจ ื•ื•ืึธืก ืื™ื– ืืจื•ื™ืก, ืกืขืœืขืงื˜ื™ืจืŸ ืฉืึทืคึฟืŸ ืึท ืœื™ื ื’ืงื˜ ื˜ื™ืฉ ืฆื• ืคืึทืจื‘ื™ื ื“ืŸ ืฆื• ื“ื™ ื“ืึทื˜ืŸ ืžืงื•ืจ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  2. ืื™ืŸ ื“ื™ ื ื™ื™ึท ืคึฟืขื ืฆื˜ืขืจ, ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ ื“ื™ ืžืึทืฉื™ืŸ ื“ืึทื˜ืึท ืžืงื•ืจ ืงื•ื•ื™ื˜ืœ ืื•ืŸ ื’ื™ื˜ OK. ืื™ืŸ ื“ื™ ื ื™ื™ึทืข ืคึฟืขื ืฆื˜ืขืจ, ืึทืจื™ื™ึทืŸ ื“ื™ ืงืจืึทื“ืขื ื˜ืฉืึทืœื– ืฆื• ืคืึทืจื‘ื™ื ื“ืŸ ืฆื• ื“ื™ SQL ืกืขืจื•ื•ืขืจ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  3. ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ ื“ื™ ื˜ื™ืฉืŸ ื•ื•ืึธืก ื“ืึทืจืคึฟืŸ ืฆื• ื–ื™ื™ืŸ ืœื™ื ื’ืงื˜. ืงื•ืง ื“ื™ ื”ื™ื˜ ืคึผืึทืจืึธืœ ืงืขืกื˜ืœ ืื•ืŸ ื’ื™ื˜ OK. ื”ื™ื˜ ื“ื™ ืคึผืึทืจืึธืœ ื™ืขื“ืขืจ ืžืึธืœ ืคึฟืึทืจ ืึทืœืข ื“ืจื™ื™ ื˜ื™ืฉืŸ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  4. ืื™ืŸ ื“ื™ ื™ื ื“ืขืงืกื™ื– ืื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ ื“ื™ ืคืืœื’ืขื ื“ืข:
    - TargetName ืคึฟืึทืจ ื“ื™ dbo_Devices ื˜ื™ืฉ;

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

    - NodeName ืึธื“ืขืจ IPAddress ืคึฟืึทืจ dbo_RegistrationData;

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

    - NodeName ืึธื“ืขืจ IPAddress ืคึฟืึทืจ dbo_StatusReport.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  5. ืœืึธืžื™ืจ ืจืขื ืึทืžืข ื“ื™ ื˜ื™ืฉืŸ ืื™ืŸ MS Access, ื ื™ื™ืžืœื™: ืึทืจืึธืคึผื ืขืžืขืŸ ื“ื™ dbo_ ืคึผืจืขืคื™ืงืก ืึทื–ื•ื™ ืึทื– DSC ืงืขื ืขืŸ ื ื•ืฆืŸ ื–ื™ื™.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  6. ื’ืขื˜ืืŸ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  7. ื”ื™ื˜ ื“ื™ ื˜ืขืงืข ืื•ืŸ ื ืึธืขื ื˜ MS Access. ืื™ืฆื˜ ืžื™ืจ ื ืึธื›ืžืึทื›ืŸ ื“ื™ ืจื™ื–ืึทืœื˜ื™ื ื’ devices.mdb ืฆื• ื“ื™ DSC ืกืขืจื•ื•ืขืจ (ื“ื•ืจืš ืคืขืœื™ืงื™ื™ึทื˜ ืื™ืŸ C: ืคึผืจืึธื’ืจืึทื ืคื™ืœืขืกWindowsPowershellDSCService) ืื•ืŸ ืคืึทืจื‘ื™ื™ึทื˜ืŸ ื“ื™ ื™ื’ื–ื™ืกื˜ื™ื ื’ ืื™ื™ื ืขืจ ืžื™ื˜ ืื™ื (ืื•ื™ื‘ ืขืก ื™ื’ื–ื™ืกืฅ).

ืงืึทื ืคื™ื’ื™ืขืจ DSC ืกืขืจื•ื•ื™ืจืขืจ ืฆื• ื ื•ืฆืŸ SQL

  1. ืžื™ืจ ืฆื•ืจื™ืงืงื•ืžืขืŸ ืฆื• ื“ื™ DSC ืกืขืจื•ื•ืขืจ. ืฆื• ืคืึทืจื‘ื™ื ื“ืŸ ืฆื• ื“ื™ SQL ืกืขืจื•ื•ืขืจ ืžื™ื˜ ืื•ื ื“ื–ืขืจ ืคืจืืงืกื™ ื˜ืขืงืข, ืœืึธื–ืŸ ืื•ื ื“ื– ืฉืึทืคึฟืŸ ืึท ื ื™ื™ึทืข ODBC ืคึฟืึทืจื‘ื™ื ื“ื•ื ื’ ืื•ื™ืฃ ื“ื™ DSC ืกืขืจื•ื•ืขืจ. ื“ื™ ื ืึธืžืขืŸ, ื‘ื™ืกืœ ื˜ื™ืคืงื™ื™ึทื˜ ืื•ืŸ ืงืฉืจ ืกืขื˜ื˜ื™ื ื’ืก ืžื•ื–ืŸ ื–ื™ื™ืŸ ื“ื™ ื–ืขืœื‘ืข ื•ื•ื™ ื•ื•ืขืŸ ืงืจื™ื™ื™ื˜ื™ื ื’ ื“ื™ MDB ื˜ืขืงืข. ืื™ืจ ืงืขื ืขืŸ ื ืึธื›ืžืึทื›ืŸ ื“ื™ ืฉื•ื™ืŸ ืงืึทื ืคื™ื’ื™ืขืจื“ ืœื™ื™ื“ื™ืง devices.mdb ืคึฟื•ืŸ ื“ืึธ.
  2. ืฆื• ื ื•ืฆืŸ devices.mdb, ืื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ืžืึทื›ืŸ ืขื ื“ืขืจื•ื ื’ืขืŸ ืฆื• ื“ื™ web.config ืคื•ืŸ ื“ื™ DSC ืฆื™ืขืŸ ืกืขืจื•ื•ืขืจ (ืคืขืœื™ืงื™ื™ึทื˜ ืื™ื– C:inetpubPSDSCPullServerweb.config):

- ืคึฟืึทืจ Windows Server 2012

<add key="dbprovider" value="System.Data.OleDb">
<add key="dbconnectionstr" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Program FilesWindowsPowerShellDscServiceDevices.mdb;">

- ืคึฟืึทืจ Windows Server 2016

<add key="dbprovider" value="System.Data.OleDb">
<add key="dbconnectionstr" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:Program FilesWindowsPowerShellDscServiceDevices.mdb;">

ื“ืึธืก ืงืึทืžืคึผืœื™ืฅ ื“ื™ DSC ืกืขืจื•ื•ืขืจ ืกืขื˜ืึทืคึผ.

ืงืึธื ื˜ืจืึธืœื™ืจืŸ ื“ื™ ืคืึทื ื’ืงืฉืึทื ืึทืœื™ื˜ื™ ืคื•ืŸ ื“ื™ DSC ืกืขืจื•ื•ืขืจ

  1. ืœืึธืžื™ืจ ืงืึธื ื˜ืจืึธืœื™ืจืŸ ืึทื– ื“ื™ DSC ืกืขืจื•ื•ืขืจ ืื™ื– ืฆื•ื˜ืจื™ื˜ืœืขืš ื“ื•ืจืš ืึท ื•ื•ืขื‘ ื‘ืœืขื˜ืขืจืขืจ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  2. ืื™ืฆื˜ ืœืึธื–ืŸ ืก ื˜ืฉืขืง ืื•ื™ื‘ ื“ื™ DSC ืฆื™ืขืŸ ืกืขืจื•ื•ืขืจ ืึทืจื‘ืขื˜ ืจื™ื›ื˜ื™ืง. ืฆื• ื˜ืึธืŸ ื“ืึธืก, ื“ื™ xPSDesiredStateConfiguration ืžืึธื“ื•ืœืข ื›ื•ืœืœ ื“ื™ pullserversetuptests.ps1 ืฉืจื™ืคื˜. ืื™ื™ื“ืขืจ ืื™ืจ ืœื•ื™ืคืŸ ื“ืขื ืฉืจื™ืคื˜, ืื™ืจ ืžื•ื–ืŸ ื™ื ืกื˜ืึทืœื™ืจืŸ ืึท Powershell ืžืึธื“ื•ืœืข ืžื™ื˜ืŸ ื ืึธืžืขืŸ Pester. ื™ื ืกื˜ืึทืœื™ืจืŸ ืขืก ื™ื ืกื˜ืึทืœื™ืจืŸ-ืžืึธื“ื•ืœ - ื ืึธืžืขืŸ ืคึผืขืกื˜ืขืจ.
  3. ืขืคึฟืขื ืขืŸ C: ืคึผืจืึธื’ืจืึทื ืคื™ืœืขืก ืคึฟืขื ืฆื˜ืขืจ ืคึผืึธื•ื•ืขืจืฉืขืœืœืžืึธื“ื•ืœืขืกืงืกืคึผืกื“ืขืกื™ืจืขื“ ืฉื˜ืึทื˜ ืงืึธื ืคื™ื’ื•ืจืึทื˜ื™ืึธืŸ<ืžืึธื“ื•ืœืข ื•ื•ืขืจืกื™ืข>DSCPullServerSetupPullServerDeploymentVerificationTest (ืื™ืŸ ื“ืขื ื‘ื™ื™ึทืฉืคึผื™ืœ ื•ื•ืขืจืกื™ืข 8.0.0.0.0).

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  4. ืขืคึฟืขื ืขืŸ PullServerSetupTests.ps1 ืื•ืŸ ืงืึธื ื˜ืจืึธืœื™ืจืŸ ื“ืขื ื“ืจืš ืฆื• ื“ื™ web.config ืคื•ืŸ ื“ื™ DSC ืกืขืจื•ื•ืขืจ. ื“ืขืจ ื“ืจืš ืฆื• web.config, ื•ื•ืึธืก ื•ื•ืขื˜ ืงืึธื ื˜ืจืึธืœื™ืจืŸ ื“ืขื ืฉืจื™ืคื˜, ืื™ื– ื›ื™ื™ืœื™ื™ื˜ื™ื“ ืื™ืŸ ืจื•ื™ื˜. ืื•ื™ื‘ ื ื™ื™ื˜ื™ืง, ืžื™ืจ ื˜ื•ื™ืฉืŸ ื“ืขื ื•ื•ืขื’.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  5. ืœื•ื™ืคืŸ pullserversetuptests.ps1
    Invoke-Pester.PullServerSetupTests.ps1
    ื›ืœ ื”ื–ื›ื•ื™ื•ืช ืฉืžื•ืจื•ืช.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

  6. ืื™ืŸ SQL ืžืึทื ืึทื’ืขืžืขื ื˜ ืกื˜ื•ื“ื™ืึธ ืžื™ืจ ื–ืขืŸ ืึทื– ืึทื“ืžื™ื ืึทืกื˜ืขืจื“ ืžื—ื ื•ืช ืฉื™ืงืŸ ืจื™ืคึผืึธืจืฅ ืฆื• ื“ื™ DSC ืจื™ืคึผืึธืจื˜ื™ื ื’ ืกืขืจื•ื•ืขืจ ืื•ืŸ ื“ื™ ื“ืึทื˜ืŸ ืขื ื“ืก ืื™ืŸ ื“ื™ DSC ื“ืึทื˜ืึทื‘ื™ื™ืก ืื•ื™ืฃ ื“ื™ SQL ืกืขืจื•ื•ืขืจ.

    ืคึผืึธื•ื•ืขืจืฉืขืœืœ ื“ื™ื–ื™ื™ืขืจื“ ืฉื˜ืึทื˜ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืื•ืŸ ื˜ืขืงืข: ื˜ื™ื™ืœ 1. ืงืึทื ืคื™ื’ื™ืขืจื™ื ื’ DSC Pull Server ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ ืึท ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก

ืึทื– ืก ืึทืœืข. ืื™ืŸ ื“ื™ ืคืืœื’ืขื ื“ืข ืึทืจื˜ื™ืงืœืขืŸ ืื™ืš ืคึผืœืึทืŸ ืฆื• ื–ืึธื’ืŸ ืื™ืจ ื•ื•ื™ ืฆื• ื‘ื•ื™ืขืŸ ืจื™ืคึผืึธืจืฅ ืื•ื™ืฃ ื“ื™ ื‘ืืงื•ืžืขืŸ ื“ืึทื˜ืŸ, ืื•ืŸ ืื™ืš ื•ื•ืขืœ ืึธื ืจื™ืจืŸ ื™ืฉื•ื– ื•ื•ืขื’ืŸ ืฉื•ืœื“ ื˜ืึธืœืขืจืึทื ืฅ ืื•ืŸ ืกืงืึทืœืึทื‘ื™ืœื™ื˜ื™.

ืžืงื•ืจ: www.habr.com

ืœื™ื™ื’ืŸ ืึท ื‘ืึทืžืขืจืงื•ื ื’