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 on that we will ask for log files and other information to start our analysis.

    For that reason this little program was created to make the extraction of all needed log files, system settings and other data more easily to extract. In future it is planed to integrate this in our software.

     

    Step-by-step guide:

     

    Activation of the DicentisDatabaseBackup_0.99.bat

     

    1. Please copy this DicentisDatabaseBackup_0.99.bat (attached) to your DICENTIS Server were the DICENTIS software is installed on and "Run it as administrator".

    It is also possible to run it on a client PC to get some limited client specified log files with and reduced data set for example without the important server log files.

    If the system is off it will only capture then it was the last time switched on and had created log files.

    Central_Support_0-1708935801029.png

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

    Central_Support_1-1708935838674.png

    Program will run on it's own and collect all relevant data.

    Central_Support_2-1708935869474.png

    But it could take some minutes (2-3) to collect all data.

    Central_Support_3-1708935897273.png

    Central_Support_4-1708935914941.png

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

    Please copy this zipp file and send it to the Technical support at best with data share link since the program logs will have more than 10MB up to 100MB and E-mail is no longer suitable for this data size.

    Central_Support_5-1708935952995.png

     

    Troubleshoot

     

    The zip file is missing

     

    The .zip file may be missing within Windows Server 2012 

    Sometimes it is stored in: C:\InstTemp 

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

    Central_Support_6-1708935996894.png

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

    Central_Support_7-1708936018578.png

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

    Central_Support_8-1708936050661.png

     

    // copy this in the text file

    cls
    @echo off

    rem The destination path can be defined here:
    set copypath=C:\DicentisDiagData

    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.99

    rem update 0.95(Date 01-02-2024): -added Logdump.exe to generate a logfile i.s.o. creating a backup with the SQL commandline. 
    rem                             : -added WMIC PRODUCT, to generate a list of installed software + version + install date
    rem update 0.96(Date 21-02-2024): -added backup of MediaGateway Config 
    rem                                  -added backup of %programdata%/Bosch/DICENTIS/*.*
    rem update 0.97(Date 08-03-2024): -added CPU detail logging
    rem
    rem update 0.98(Date 16-04-2024): -added GPU detail logging
    rem        
    rem update 0.99(Date 28-08-2024): -added Hotfix installation logging
    rem                         
    c:
    cd\
    IF exist C:\DicentisDiagData ( echo. ) ELSE ( mkdir %copypath% )
    color F0

    ClS
    ECHO.
    ECHO. 
    ECHO        This tool will generate a zip archive in 
    ECHO           which we include system information
    ECHO           extracted from your DICENTIS server
    ECHO              for trouble shouting purposes
    ECHO.         
    ECHO.      
    ECHO.
    ECHO.
    ECHO        Run the script with Administrator rights!
    echo.
    echo.
    echo.
    echo.
    ECHO                     Version %FileVersion%
    ECHO.
    ECHO.
    echo.
    echo Do you want to continue? Y/N
    echo.
    SET INPUT=
    SET /P INPUT=(Y/N):
    ClS
    IF /I '%INPUT%'=='Y' GOTO DiagData1
    IF /I '%INPUT%'=='N' exit

     

    :PrepareZipData
    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
    del /q %copypath%\*.json*
    rd /s /q %copypath%\ProgramData
    goto zip

    :zip
    rem This part archives the harvested data in a zip-file
    cls
    powershell Compress-Archive -path %TEMPDIR%\* %copypath%\%DateTime%.zip
    rmdir /s /q %TEMPDIR%
    goto quit

    :DiagData1
    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%
    copy "C:\Program Files (x86)\Bosch\DICENTIS Hybrid\MediaGateway\MediaGatewaySettings.jsonc" %copypath%
    CLS
    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
    xcopy /S /E /Q %ProgramData%\Bosch\DICENTIS %copypath%\ProgramData\
    del %copypath%\ProgramData\*.x*
    del %copypath%\ProgramData\*.txt
    CLS
    ECHO.
    ECHO.
    ECHO Generating a software list, this takes time. 
    ECHO.
    ECHO Please be patient, the tool did not stop.
    wmic /output:"%copypath%\InstalledSW_%Computername%.txt" product get name,version,installdate
    powershell "Get-WmiObject -Class Win32_Processor -ComputerName. | Select-Object -Property [a-z]*" > "%copypath%\InstalledCPU_%Computername%.txt"
    powershell "Get-WmiObject -Class Win32_VideoController -ComputerName. | Select-Object -Property [a-z]*" > "%copypath%\InstalledGPU_%Computername%.txt"
    powershell "Get-Hotfix" > "%copypath%\InstalledHotfix_%Computername%.txt"
    CLS
    if exist "C:\Program Files\BOSCH\DICENTIS\Logdump.exe" (goto Logdump)
    else (goto SQL2014)


    :SQL2014
    rem For DICENTIS versions <3.60
    SqlCmd -E -S .\SQLDICENTIS2014 -Q "BACKUP DATABASE [DcnmloggingDatabase] TO DISK='%copypath%\LoggingDbBackup_%DateTime%.bak'"
    goto PrepareZipData

    :Logdump
    "C:\Program Files\BOSCH\DICENTIS\Logdump.exe" %copypath%\Logdump_%Computername%.txt
    goto PrepareZipData 

    :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
    Last update:
    Friday
    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