DX Unified Infrastructure Management

What are the default tables created in UIM with MSSQL DB.

C:\Program Files (x86)\Nimsoft\probes\slm\data_engine\scripts\sqlserver_slm_create.sql

Does this help?

So I should run in CA_UIM database for creating all tables ?

If you have a good reason to do it, if you run the script manually it would create all tables

I hope some probes like ace,maintenance mode,discovery table creates  its own tables automatically when it connects to DB. Can you please confirm whether  these tables can also be created manual ?

Automatic creation of tables doesn't happening ..so i am checking whether it can be done manual.

hi,

please kindly check the following KB,

CA UIM (Nimsoft) Database Best Practices for MS SQL Server

Document ID: TEC000003224

CA UIM (Nimsoft) Database Best Practices for MS SQL Server 

https://search.ca.com/assets/SiteAssets/TEC000003224_External/NISDatabaseBestPracticesGuidev11.pdf 

Hope this help!

Hi

Default db scripts are saved under<uim>/nis/sql/<db> folder

you can run scripts:

<db>_nis_base_create.sql

<db>_slm_create.sql

<db>_dataengine_create.sql

<db>_nis_installer_create.sql

<db>_nis_account_create.sql

<db>_discovery_server_create.sql

<db>_nis_server_create.sql

<db>_ace_create.sql

<db>_webservice_create.sql

run script

<db>-nis-create.sql

under folder <uim>/probes/service/nas.

You can also extract schema from working UIM database and remove ddl statements for RN/HN/DN/BN_* tables.

Hope this helps