15-How to copy whole/entire database from one SQL Server instance to ano...

Выход из режима single-user в MS sql-server + 1С

1. Останавливаем сервер приложений 1С
2. Смотрим кто использует базу T-sql sp_who2
3. Убиваем всех пользователей использующих БД 1С KILL { session ID } 
4. Переводим базу в режим Multi_user

-- Start in master
USE MASTER;

-- Add users
ALTER DATABASE [my_db] SET MULTI_USER
GO

https://stackoverflow.com/questions/18965980/exit-single-user-mode

Outlook Web Access (OWA) and ActiveSync reporting using IIS logs

I was asked to report on how many people were still accessing a legacy Exchange server via Outlook Web Access for the purposes of retiring it permanently.  Here is a step by step walk through. Pasted commands may not work.  Please type directly into the cmd window!

1. Locate your IIS logs on your exchange server.  Mine were stored in C:\inetpub\logs\LogFiles\W3SVC1.  For more help refer to this article.
2. For this example we will be copying the logs we need locally to the C:\log directory.  This method could easily be adapted to use UNC paths but was not needed for my purposes.  IIS should create one log per day so copy the number of days you would like to report on to c:\log on your local machine.
3. Download Log Parser 2.2 from the Microsoft website and install it to the default directory.
4. Next we will use log parser to combine all of these logs into a single file.  Create a subdirectory under c:\log called mergedlog.  From the command line navigate to the log parser directory “C:\Program Files (x86)\Log Parser 2.2” and run the following command “logparser.exe -i:iisw3c “select * into c:\log\mergedlog\merge.log from c:\log\*” -o:csv”  This will create a single log file named merge.log and convert the data from iisw3c to csv format.
5. Next we will need to run a command that will pull the information we are looking for out of the log.  Here are three examples that list User Name, Date, Time, IP, page accessed, and user agent. Each will output the results into a file named output.csv in the c:\log directory.

The first command looks for OWA access

LogParser -i:csv “SELECT cs-username, date, time, c-ip, cs-uri-stem, cs(User-Agent) FROM C:\log\mergedlog\merge.log TO C:\log\Output.csv WHERE cs-method LIKE ‘%get%’ and cs-uri-stem LIKE ‘%owa%’

This next command lists ActiveSync users

LogParser -i:csv “SELECT cs-username, date, time, c-ip, cs-uri-stem, cs(User-Agent) FROM C:\log\mergedlog\merge.log TO C:\log\Output.csv WHERE cs-method LIKE ‘%post%’ and cs-uri-stem LIKE ‘%Microsoft-Server-ActiveSync%’

Finally as a Bonus This one looks for Mac Office Users

LogParser -i:csv “SELECT cs-username, date, time, c-ip, cs-uri-stem, cs(User-Agent) FROM C:\log\mergedlog\merge.log TO C:\log\Output.csv WHERE cs-method LIKE ‘%post%’ and cs(user-agent) LIKE ’%Macoutlook%’

http://manjubluemoon.blogspot.com/2014/11/outlook-web-access-owa-and-activesync.html

Прошивки Kyocera /Kyocera firmware

Все лежит тут:

https://yadi.sk/d/AOVDZTXM3YFjDA
https://drive.google.com/open?id=1AD2fVr-AdKAv6bUHOyXn2hSVfkwg5pD8


FS-1020-1120-1025-1125MFP\
FS-1028-1128MFP\
FS-1030MFP-1035MFP-1130-1135\
FS-1040-1060DN\
FS-1120-1320-1370\
FS-2020-3920-4020\
FS-2100-4100-4200-4300\
FS-3040-3140MFP\
FS-3040P_3140P\
FS-3540_3640MFP\
FS-6025-6030MFP\
FS-6525-6530MFP\
FS-6970\

и вот тут
https://yadi.sk/d/GQRRZmUD3YMmje

FS-C1020MFP\
FS-C1020MFP+\
FS-C2026-2126MFP\
FS-C2026P-2126P\
FS-C2526-2626\
FS-C5100-5200-5300-5400\
FS-C5150-5250\
FS-C5350\
FS-C8020MFP-8025MFP\
FS-C8500DN\
FS-C8520-8525MFP\
FS-C8600DN_C8650DN\
TASKalfa 250-300-400-500ci\
TASKalfa 2550ci\
TASKalfa 552ci\

How do I shrink all files quickly for all databases?

SELECT 
      'USE [' + d.name + N']' + CHAR(13) + CHAR(10) 
    + 'DBCC SHRINKFILE (N''' + mf.name + N''' , 0, TRUNCATEONLY)' 
    + CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10) 
FROM 
         sys.master_files mf 
    JOIN sys.databases d 
        ON mf.database_id = d.database_id 
WHERE d.database_id > 4;

https://dba.stackexchange.com/questions/358/how-do-i-shrink-all-files-quickly-for-all-databases

Черный экран в Windows 10 1803.

Признаки:
Система не выходит на логин пароль.
Бесконечно крутится "колесо" курсора.

Решение:
1.Удаление драйвера видеокарты intel.
2.Удаление KB4103721
3.Удаление Антивируса Касперского.

Для того, чтобы попасть в безопасный режим нажимайте кнопку выключения ПК на вот этом шаге загрузки. Эту операцию нужно повторить два раза, после этого система переходим в режим восстановления.

 Необходимо выбрать Диагностику

 После перезагрузки  откроется  меню, в котором с помощью функциональных клавиш F1-F9 можно выбрать необходимый режим загрузки, например безопасный режим. F4

Настройка внутренних номеров (Extensions) FreePBX 13

How to Enable SNMP on CISCO Router or Switch

#conf t

#snmp-server  community public ro

#exit

Изменение Auto growth значения в Sql Server