How to rebuild Data Analytics database tables and rules

Version 4

    Verified Product Versions

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



    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:




    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.