zv0r

SELECT
  CAST('INSERT INTO fund (isn_fund, isn_archive, isn_doc_type, isn_period, fund_num_2, fund_name_short, fund_name_full, annotate, movement_note, fund_history, doc_start_year, doc_end_year, doc_receipt_year, last_checked_year) VALUES (' + CONVERT(nvarchar(max), (aff.ISN_FUND - 10000000000)) + ', ' + CONVERT(nvarchar(max), (aff.ISN_ARCHIVE - 10000000000)) + ', ' + CONVERT(nvarchar(max), ISNULL(aff.ISN_DOC_TYPE, 1)) + ', ' + CONVERT(nvarchar(max), CAST (CASE WHEN ISNULL(aff.FUND_NUM_1, '') LIKE '' THEN 1 ELSE 2 END as int)) + ', ' + CONVERT(nvarchar(max), ISNULL(aff.FUND_NUM_2, 0)) + ', ''' + CONVERT(nvarchar(max), REPLACE(REPLACE(ISNULL(aff.FUND_NAME_SHORT, ''), '\', '\\'), '''', '\''')) + ''', ''' + CONVERT(nvarchar(max), REPLACE(REPLACE(ISNULL(aff.FUND_NAME_FULL, ''), '\', '\\'), '''', '\''')) + ''', ''' + CONVERT(nvarchar(max), REPLACE(REPLACE(ISNULL(aff.ANNOTATE, ''), '\', '\\'), '''', '\''')) + ''', ''' + CONVERT(nvarchar(max), REPLACE(REPLACE(ISNULL(aff.MOVEMENT_NOTE, ''), '\', '\\'), '''', '\'''))

zv0r

SET IDENTITY_INSERT [AISArchive].[dbo].[tblArchiveFiles] ON

/*
 *
 * ID архивного учреждения, в БД которого заливаются данные
 *
 */
DECLARE @ArchId INT
SET @ArchId = 4

zv0r

INFO 2019-05-08 09:54:33,910 pid:27290 /usr/local/samba/lib/python3.5/site-packages/samba/provision/__init__.py #2079: Looking up IPv4 addresses
INFO 2019-05-08 09:54:33,910 pid:27290 /usr/local/samba/lib/python3.5/site-packages/samba/provision/__init__.py #2096: Looking up IPv6 addresses
WARNING 2019-05-08 09:54:33,911 pid:27290 /usr/local/samba/lib/python3.5/site-packages/samba/provision/__init__.py #2103: No IPv6 address will be assigned
INFO 2019-05-08 09:54:34,618 pid:27290 /usr/local/samba/lib/python3.5/site-packages/samba/provision/__init__.py #2269: Setting up share.ldb
INFO 2019-05-08 09:54:34,633 pid:27290 /usr/local/samba/lib/python3.5/site-packages/samba/provision/__init__.py #2273: Setting up secrets.ldb
INFO 2019-05-08 09:54:34,646 pid:27290 /usr/local/samba/lib/python3.5/site-packages/samba/provision/__init__.py #2279: Setting up the registry
INFO 2019-05-08 09:54:34,693 pid:27290 /usr/local/samba/lib/python3.5/site-packages/samba/provision/__init__.py #2282: Setting up the privileges database

zv0r

● ntp.service - LSB: Start NTP daemon
   Loaded: loaded (/etc/init.d/ntp; generated; vendor preset: enabled)
   Active: active (running) since Wed 2019-05-08 10:37:44 MSK; 4s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 663 ExecStop=/etc/init.d/ntp stop (code=exited, status=0/SUCCESS)
  Process: 673 ExecStart=/etc/init.d/ntp start (code=exited, status=0/SUCCESS)
    Tasks: 2 (limit: 36864)
   CGroup: /system.slice/ntp.service
           └─684 /usr/sbin/ntpd -p /var/run/ntpd.pid -g -u 108:112

zv0r

INFO 2019-05-08 11:28:02,916 pid:583 /usr/local/samba/lib/python3.5/site-packages/samba/join.py #103: Finding a writeable DC for domain 'corp.company.ru'
INFO 2019-05-08 11:28:02,939 pid:583 /usr/local/samba/lib/python3.5/site-packages/samba/join.py #105: Found DC mskdc.corp.company.ru
Password for [CORP\administrator]:
INFO 2019-05-08 11:28:06,489 pid:583 /usr/local/samba/lib/python3.5/site-packages/samba/join.py #1519: workgroup is CORP
INFO 2019-05-08 11:28:06,490 pid:583 /usr/local/samba/lib/python3.5/site-packages/samba/join.py #1522: realm is corp.company.ru
Adding CN=SPBDC,OU=Domain Controllers,DC=corp,DC=company,DC=ru
Adding CN=SPBDC,CN=Servers,CN=Default-First-Site-Name,CN=Sites,CN=Configuration,DC=corp,DC=company,DC=ru
Adding CN=NTDS Settings,CN=SPBDC,CN=Servers,CN=Default-First-Site-Name,CN=Sites,CN=Configuration,DC=corp,DC=company,DC=ru
Adding SPNs to CN=SPBDC,OU=Domain Controllers,DC=corp,DC=company,DC=ru
Setting account password for SPBDC$