Running CoreDbUtil to reset, rebuild, or update a
database
The CoreDbUtil.exe utility, in the core server's \Program
Files\LANDesk\ManagementSuite folder, creates all the tables,
indexes, and constraints needed to use the core database. Before
running CoreDbUtil.exe, you must install your database correctly or
the table creation may fail. CoreDbUtil.exe looks for registry keys
on the core server to determine the core database connection
information. CoreDbUtil doesn't work on core rollup databases.
Use CoreDbUtil to:
Reset database: Drops all tables, and rebuilds
the database from scratch using DATAMART.XML. Rebuilds
Vulnerability scanning database tables. Warning: all
existing data will be lost.
Build components: Updates the schema
(specifically to include column additions) in an existing core
database from metadata.xml. This isn't destructive to existing
data.
Publish app list: Publishes the software
configuration list using defaults.xml and ldappl3.template to
generate ldappl3.ini, ldappl3.bak, ldappl3.ldz, ldappl3.pat,
ldappl3.paz, and ldappl3.reset.
Update Display Names: Updates the Display Name
field in an existing core database for all devices in that
database. This isn't destructive to other existing data.
To run CoreDbUtil
On the core server, run CoreDbUtil.exe
After CoreDbUtil connects to the database, select the
option you want.
Wait until the Status is finished. Depending
on the database size and the task you chose, this could take a few
minutes or several hours.
If you reset the database, some patch management and LANDesk NAC
features won't work correctly until you do the following.
To update patch management database components after resetting
a database