Database performance is slow in when displaying patch content in Management Suite Console

Version 4

    Verified Product Versions

    Endpoint Manager 9.5

    Create the following indexes in your database to decrease load time on the scanned and detected vulnerabilities within the patch tool in the Management Suite Console:

     

    --Microsoft SQL

     

    CREATE NONCLUSTERED INDEX IDXVULNPATCH ON VULNERABILITY

    (VULNERABILITY_IDN ASC,

    VUL_ID ASC,

    LANG ASC)

     

    CREATE NONCLUSTERED INDEX IDXCOMPVULNPATCH ON COMPUTERVULNERABILITY

    (VUL_ID ASC,

    LANG ASC,

    COMPUTER_IDN ASC,

    DETECTED ASC,

    PATCHINSTALLSUCCEEDED ASC)

     


    --Oracle

    --Note: change USER to the actual Schema user.

     


    CREATE INDEX USER.IDXVULNPATCH on USER.VULNERABILITY VUL

     

    (VUL.VULNERABILITY_IDN ASC, VUL.VUL_ID ASC, VUL.LANG ASC)

     

     

    CREATE INDEX USER.IDXCOMPVULNP on USER.COMPUTERVULNERABILITY CVUL

     

    (CVUL.VUL_ID ASC, CVUL.LANG ASC, CVUL.COMPUTER_IDN ASC, CVUL.DETECTED ASC, CVUL.PATCHINSTALLSUCCEEDED ASC)