Back to Contents Page

Back to Utilities and Command-Line Operation

Database Management Utility

Dell OpenManage™ IT Assistant User's Guide

	Overview		dconfig.ini File Requirements
	Using the GUI Database Management Utility		DLL Requirements
	Using the Command-Line Database Management Utility		Registry Key Requirements

Overview

The Dell OpenManage IT Assistant Database Management Utility has two implementations: a graphical user interface (GUI) and a command-line interface. Both versions of the utility allow users to perform operations on databases and tables that reside in the IT Assistant data repository.

You must start the GUI version of the Database Management Utility separately from IT Assistant. When you start the utility, a window opens that contains database and table management functions. See the Dell OpenManage IT Assistant Database Manager User's Guide for information on using the GUI utility. The command-line application performs the functions of the GUI utility along with a few others.

Using the GUI Database Management Utility

See the Dell OpenManage IT Assistant Database Manager User's Guide for information on using this utility.

Using the Command-Line Database Management Utility

1. At a command prompt, change directory to \Program Files\Dell\OpenManage\IT Assistant\bin.
   
   
2. Type dcdbmng followed by a switch that specifies the command you want. To see a list of valid switches, type:

dcdbmng /h

OR

dcdbmng /H

OR

dcdbmng /?

NOTE: Type a space between the dcdbmng command and the / (forward slash).

This command displays a dialog box that lists commands that you can use to do the following:

• Install the Microsoft® Data Engine (MSDE).
  
  
• Start and stop the database engine, MSDE, or Microsoft SQL Server.
  
  
• Attach and detach database files to and from the database engine.
  
  
• Import and export tables and databases.
  
  
• Clear tables.
  
  
• Restore data for the global IT Assistant configuration or the event management system configuration only.

Help

• Command: dcdbmng /h or dcdbmng /H or dcdbmng /?

• Description: Displays the command line options.

Attach Database

• Command: dcdbmng /A path or dcdbmng /a path
  
  
• Description: Attaches the single database file specified by path to the MSDE or Microsoft SQL Server.

NOTE: Related registry keys must be set up correctly, and the dconfig.ini file must be placed in the correct location.

Clear Table

• Command: dcdbmng /Z tablename or dcdbmng /z tablename

• Description: Removes all the rows from the specified table, but does not delete the table.

Detach Database

• Command: dcdbmng /R or dcdbmng /r
  
  
• Description: Detaches the attached database file from the MSDE or Microsoft SQL Server.

NOTE: The detached database file remains in the location from where it was attached to the MSDE or Microsoft SQL Server.

Export Table

• Command: dcdbmng /E tablename filenameor dcdbmng /e tablename filename

• Description: Exports the data in the table specified by tablename to the flat text file specified by filename. If the flat text file does not exist, the utility creates it. If filename does not include path information, the utility creates the file in the local directory.

Export Database

• Command: dcdbmng /X path or dcdbmng /x path

• Description: Exports data from all tables in the database to flat text files in the location specified by path.

NOTE: The utility creates the files in the location specified by path in the format of tablename.txt.

Import Table

• Command: dcdbmng /I tablename path [migrate] or dcdbmng /i tablename path [migrate]

• Description: Imports data to the table specified by tablename from the flat text file specified in path.

NOTE: If the flat text file was exported from IT Assistant 5.x, specify the optional variable [migrate] to be MIGRATE_5.x_TO_6.4. Do not use this optional variable if the flat file was exported from IT Assistant 6.1.

Import Database

• Command: dcdbmng /M pathor dcdbmng /m path

• Description: Imports data to all tables in the database from flat text files in the location specified by path.

NOTE: Do not use flat files exported from IT Assistant 5.x to import data into this version of IT Assistant. Flat text files must be named tablename.txt.

Install MSDE

• Command: dcdbmng /N or dcdbmng /n
  
  
• Description: Silently installs MSDE.

NOTE: Related registry keys must be set up correctly.

NOTE: The MSDEx85.exe and iss files must be placed in the correct location.

Start Server

• Command: dcdbmng /T or dcdbmng /t
  
  
• Description: Starts the MSSQLServer service.

Stop Server

• Command: dcdbmng /P or dcdbmng /p
  
  
• Description: Stops the MSSQLServer service.

Suppress Messages

When you run the Database Management Utility as a command-line application, you receive messages when commands succeed or fail. The command to suppress messages halts these notifications.

• Command: dcdbmng /S

• Description: Runs without displaying any messages (whether the action was successful or unsuccessful). This command is useful if you are running the utility from a batch file.

NOTE: Using /S with no other option causes the command to be ignored.

dconfig.ini File Requirements

The IT Assistant installation program installs the dconfig.ini file in the \configuration directory of the IT Assistant installation directory. The content of the dconfig.ini file is correct at installation and requires no modification; the following section is provided for reference only. This section is required for proper operation of the Database Management Utility.

;**********************************

;BEGIN Database Section

;**********************************

[DATABASE]

name=ITAssist

ODBC_SECTION=ITASSIST_ODBC

[ITASSIST_ODBC]

DSN_name=ITAssist

DRIVER=SQL Server

ATTRIBUTE_SECTION=ITAssist_Odbc_Attributes

[ITAssist_Odbc_Attributes]

NUMBER_OF_ATTRIBUTES=5

; Key Name - Name of the key

; Key Value - Value of the key

ATTRIBUTE0=DSN,ITAssist

ATTRIBUTE1=DESCRIPTION,ITAssistant Database

ATTRIBUTE2=DATABASE,ITAssist

ATTRIBUTE3=SERVER,(local)

ATTRIBUTE4=TRUSTED_CONNECTION,yes

[MASTER_DATABASE]

name=master

ODBC_SECTION=MASTER_ODBC

[MASTER_ODBC]

DSN_name=master

DRIVER=SQL Server

ATTRIBUTE_SECTION=Master_Odbc_Attributes

[Master_Odbc_Attributes]

NUMBER_OF_ATTRIBUTES=5

; Key Name - Name of the key

; Key Value - Value of the key

ATTRIBUTE0=DSN,master

ATTRIBUTE1=DESCRIPTION,master database

ATTRIBUTE2=DATABASE,master

ATTRIBUTE3=SERVER,(local)

ATTRIBUTE4=TRUSTED_CONNECTION,yes

[MIGRATE_5.X_TO_6.4]

; TableName.ColumnName in 5.x database

; ColumnName in 6.4 database

DiscoveryConfiguration.SubnetAddress=Address

[RESTORE_6.4_DATABASE]

GLOBAL_CONFIGURATION=GlobalConfiguration

EVENT_MGMT_SYSTEM=EventCategory,EventType,SNMPEventSource,DMIEventSource,SNMPEventSeverityConfiguration,EventManager,StoredAction

;**********************************

;END Database Section

;**********************************

DLL Requirements

The IT Assistant installation program installs the following dynamic link library (DLL) files in the \bin directory of the IT Assistant installation directory. No additional installation of these files is necessary; this list is for reference only. These files are required for proper operation of the Database Management Utility:

Registry Key Requirements

The IT Assistant installation program enters the following keys into the Windows registry under the \HKEY_LOCAL_MACHINE\SOFTWARE\Dell Computer\Dell OpenManage IT Assistant\Connection Service key. No additional registry modification is necessary; this list is provided for reference only. These registry keys are required for proper operation of the Database Management Utility.

Back to Contents Page

Back to Utilities and Command-Line Operation