SQL_LogScout/SQL LogScout/SQL_LogScout.cmd at main · microsoft/SQL_LogScout · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
@echo off
rem  Copyright (c) Microsoft Corporation.
rem  Licensed under the MIT license.

@echo off

set cwd=%~dp0

IF "%1"=="?" GOTO :Help
IF "%1"=="-?" GOTO :Help
IF "%1"=="/?" GOTO :Help
IF "%1"=="help" GOTO :Help
IF "%1"=="-help" GOTO :Help
IF "%1"=="--help" GOTO :Help

echo.
echo      ======================================================================================================
echo               #####   #####  #          #                      #####
echo              #     # #     # #          #        ####   ####  #     #  ####   ####  #    # #####
echo              #       #     # #          #       #    # #    # #       #    # #    # #    #   #
echo               #####  #     # #          #       #    # #       #####  #      #    # #    #   #
echo                    # #   # # #          #       #    # #  ###       # #      #    # #    #   #
echo              #     # #    #  #          #       #    # #    # #     # #    # #    # #    #   #
echo               #####   #### # #######    #######  ####   ####   #####   ####   ####   ####    #
echo      ======================================================================================================
echo.


rem if the min version of Powershell is less than 4.0, exit since we cannot execute futher

IF [%1] EQU [] (set p1="") ELSE (set p1=%1)
IF [%2] EQU [] (set p2="") ELSE (set p2=%2)
IF [%3] EQU [] (set p3="") ELSE (set p3=%3)
IF [%4] EQU [] (set p4="") ELSE (set p4=%4)
IF [%5] EQU [] (set p5="") ELSE (set p5=%5)
IF [%6] EQU [] (set p6="") ELSE (set p6=%6)
IF [%7] EQU [] (set p7="") ELSE (set p7=%7)
IF [%8] EQU [] (set p8="") ELSE (set p8=%8)

pushd "%cwd%"
powershell.exe -ExecutionPolicy RemoteSigned -File SQL_LogScout.ps1 -Scenario %p1% -ServerName %p2% -CustomOutputPath %p3% -DeleteExistingOrCreateNew %p4% -DiagStartTime %p5% -DiagStopTime %p6% -InteractivePrompts %p7% -RepeatCollections %p8% 2> .\##STDERR.LOG
popd

pushd "%cwd%\bin"
powershell.exe -ExecutionPolicy RemoteSigned -File StdErrorOutputHandling.ps1 .\##STDERR.LOG
popd

exit /b

:Help
pushd "%cwd%\bin"
powershell.exe -ExecutionPolicy RemoteSigned -File SQLLogScoutPs.ps1 -help
popd

:EOF