Bosch Building Technologies

    cancel
    Showing results for 
    Search instead for 
    Did you mean: 

    How to extract DICENTIS wired system log files for deeper analysis using DicentisDatabaseBackup.bat?

    If you are facing unknown problems with your DICENTIS wired system and you need advice from the technical support they will ask for a lot of different information.

    For that reason this little program was created to make the extraction of all needed log files, system settings and other data more easily.

     

    Step-by-step guide:

     

    Activation of the DicentisDatabaseBackup.bat

     

    1. Please copy this DicentisDatabaseBackup.bat (file attached) to your Server or Client were the DICENTIS software is installed and "Run it as administrator".

    1 How to extract DICENTIS wired system log files for deeper analysis using DicentisDatabaseBackup.bat.png

    2 How to extract DICENTIS wired system log files for deeper analysis using DicentisDatabaseBackup.bat.png

     

    2. Please press "Y" so that all information will be collected.

    3 How to extract DICENTIS wired system log files for deeper analysis using DicentisDatabaseBackup.bat.png4 How to extract DICENTIS wired system log files for deeper analysis using DicentisDatabaseBackup.bat.png5 How to extract DICENTIS wired system log files for deeper analysis using DicentisDatabaseBackup.bat.png

     

    3. You can find this files in: C:\DicentisBackup

    Please copy this and send it to the Technical support.

    6 How to extract DICENTIS wired system log files for deeper analysis using DicentisDatabaseBackup.bat.png

     

    The zip file is missing

     

    The .zip file may be missing within Windows Server 2012 

    Sometimes it is stored in: C:\InstTemp 

    Also a newer version is in process since not all data were collected by Windows Server 2019.

     

    If you have problems to send this via Mail you can as well send it as text and copy it later in text file to create a .bat out of it.

    7 How to extract DICENTIS wired system log files for deeper analysis using DicentisDatabaseBackup.bat.png

     

    Name it .bat at the end like "DicentisDatabaseBackup.bat"

    8 How to extract DICENTIS wired system log files for deeper analysis using DicentisDatabaseBackup.bat.png

     

    If you use WordPad you have to save it as MS-DOS Format.

    9 How to extract DICENTIS wired system log files for deeper analysis using DicentisDatabaseBackup.bat.png

     

    // copy this in the text file:

    cls

    @echo off

    rem The destination path can be defined here:

    set copypath=C:\DicentisBackup

    rem This is the location of a temporary folder, this will be automatically deleted:

    set TEMPDIR=C:\DICENTIStemp

    FOR /f %%a IN ('WMIC OS GET LocalDateTime ^| find "."') do set DTS=%%a

    set DateTime=%DTS:~0,4%%DTS:~4,2%%DTS:~6,2%_%DTS:~8,2%%DTS:~10,2%%DTS:~12,2%

    set FileVersion=0.94

    c:

    cd\

    IF exist C:\DicentisBackup ( echo. ) ELSE ( mkdir %copypath% )

    color 1a

     

    rem ClS

    ECHO.

    ECHO.

    ECHO         This tool will make a backup of the current

    ECHO.                     

    ECHO                       DICENTIS Database

    ECHO.                             

    echo                              and

    echo.

    ECHO                        Synoptic Layout

    ECHO.

    ECHO.

    ECHO         Optionally it can copy information from the

    ECHO            system for technical support purposes

    ECHO.

    ECHO.     

    ECHO.

    ECHO.

    ECHO               Run the script as Administrator!

    echo.

    echo.

    echo.

    echo.

    ECHO       Version %FileVersion%, press any key to continue

    ECHO.

    pause>nul

    echo off

    cls

    ECHO.

    echo Optional:

    echo.

    echo Do you want to make a backup of the logging database and installation log files for

    echo diagnostics?

    echo.

    SET INPUT=

    SET /P INPUT=(Y/N):

    CLS

    IF /I '%INPUT%'=='Y' GOTO DiagData

    IF /I '%INPUT%'=='N' GOTO BackupDB

     

     

     

    :BackupDB

    c:

    cd\

    cd data\tools

    @echo off

    rmdir %TEMPDIR% /s /q

    mkdir %TEMPDIR%

    cd "C:\Program Files\Bosch\DICENTIS"

    cls

    echo backup database serverconsole

    DcnmDatabaseConsole.exe -b "%copypath%\DbBackup_%DateTime%.bak"

    mkdir %TEMPDIR%\Data

    xcopy C:\inetpub\wwwroot\DcnmSynopticControl\Data %TEMPDIR%\Data /S /E

    echo .zip > %TEMPDIR%\zip.txt

    echo off

    xcopy /s %copypath% %TEMPDIR% /exclude:%TEMPDIR%\zip.txt

    xcopy /s %copypath%/Data %TEMPDIR%/Data

    echo Version_%FileVersion% > %TEMPDIR%\Tool_Version_%FileVersion%.txt

    del /q %TEMPDIR%\zip.txt

    del /q %copypath%\*.log

    del /q %copypath%\*.bak

    del /q %copypath%\*.txt

    del /q %copypath%\*.htm

    del /q %copypath%\*.html

    del /q %copypath%\*.evtx

    goto zip

     

    :zip

    cls

    powershell Compress-Archive -path %TEMPDIR%\* %copypath%\%DateTime%.zip

    rmdir /s /q %TEMPDIR%

    goto quit

     

    :DiagData

    CLS

    echo off

    cd /D %Temp%

    set lastChar=%TEMP:~-4%

    if not %lastChar% == Temp cd..

    copy Bosch_DICENTIS* %copypath%

    copy OMNEO* %copypath%

    copy Dante* %copypath%

    copy Network* %copypath%

    SqlCmd -E -S .\SQLDICENTIS2014 -Q "BACKUP DATABASE [DcnmloggingDatabase] TO DISK='%copypath%\LoggingDbBackup_%DateTime%.bak'"

    systeminfo > %copypath%\SystemInfo_%Computername%.txt

    ipconfig /all > %copypath%\IpConfig_%Computername%.txt

    route print > %copypath%\RoutePrint_%Computername%.txt

    set > %copypath%\EnvironmentVariables_%Computername%.txt

    wevtutil epl Application %copypath%\Application_log_%Computername%.evtx

    wevtutil epl System %copypath%\System_log_%Computername%.evtx

    goto BackupDB

     

    :quit

    cls

    ECHO.

    ECHO.

    ECHO.

    ECHO.

    ECHO.

    ECHO.

    ECHO.

    ECHO.

    ECHO ===============================Finished===================================

    ECHO.

    ECHO             The backup(s) can be found in %copypath%

    ECHO.

    ECHO =========================PRESS ANY KEY TO CONTINUE========================

    PAUSE>NUL

    exit

    Version history
    Revision #:
    3 of 3
    Last update:
    ‎07-02-2021 10:08 PM
    Updated by:
     
    Attachments
    Contributors
    Icon--AD-black-48x48Icon--address-consumer-data-black-48x48Icon--appointment-black-48x48Icon--back-left-black-48x48Icon--calendar-black-48x48Icon--center-alignedIcon--Checkbox-checkIcon--clock-black-48x48Icon--close-black-48x48Icon--compare-black-48x48Icon--confirmation-black-48x48Icon--dealer-details-black-48x48Icon--delete-black-48x48Icon--delivery-black-48x48Icon--down-black-48x48Icon--download-black-48x48Ic-OverlayAlertIcon--externallink-black-48x48Icon-Filledforward-right_adjustedIcon--grid-view-black-48x48IC_gd_Check-Circle170821_Icons_Community170823_Bosch_Icons170823_Bosch_Icons170821_Icons_CommunityIC-logout170821_Icons_Community170825_Bosch_Icons170821_Icons_CommunityIC-shopping-cart2170821_Icons_CommunityIC-upIC_UserIcon--imageIcon--info-i-black-48x48Icon--left-alignedIcon--Less-minimize-black-48x48Icon-FilledIcon--List-Check-grennIcon--List-Check-blackIcon--List-Cross-blackIcon--list-view-mobile-black-48x48Icon--list-view-black-48x48Icon--More-Maximize-black-48x48Icon--my-product-black-48x48Icon--newsletter-black-48x48Icon--payment-black-48x48Icon--print-black-48x48Icon--promotion-black-48x48Icon--registration-black-48x48Icon--Reset-black-48x48Icon--right-alignedshare-circle1Icon--share-black-48x48Icon--shopping-bag-black-48x48Icon-shopping-cartIcon--start-play-black-48x48Icon--store-locator-black-48x48Ic-OverlayAlertIcon--summary-black-48x48tumblrIcon-FilledvineIc-OverlayAlertwhishlist