How to rebuild Data Analytics database tables and rules

Version 4

    Verified Product Versions

    Endpoint Manager 2016.xEndpoint Manager 2017.xEndpoint Manager 2018.x

    Overview

     

    In some situations, resetting DA information may be necessary. The following steps will rebuild all DA related database tables and DTS rules.

     

    1. Head to %LDMS_HOME%
    2. Run DBSetup.exe "As Administrator"
    3. Click "Install

     

    You should then see the process below:

     

    Screenshot_163.png

     

    DBSetup.exe runs other processes as well, such as CoreDBUtil. If an error is encountered, checking logs for those processes may be beneficial. DBSetup will show when it's running another process.