ServerConductor/Blade Server Manager Description and Reference

### 5.2.2 Environment settings (database management)

To perform database management, the following environment settings are required:

Settings for Windows (executed at the manager)
  - Creation of ODBC data source

Settings for the ServerConductor console service (executed at the management console)
  - Creation of the database
  - Setting of email addresses to be used by the auto-report function (if necessary)
  - Deletion of the database (as necessary)

The following subsections describe these procedures.

Organization of this subsection
  (1) Creating an ODBC data source
  (2) Creating a database
  (3) Setting email addresses (auto-report function)
  (4) Deleting a database

#### (1) Creating an ODBC data source

You must use the ODBC administrator on the Control Panel to create a system data source. This must be done in advance.

To create an ODBC data source in Windows Server 2003:

1. From Control Panel, choose Administrative Tools, and then Data Source (ODBC).
   The ODBC Data Source Administrator dialog box appears.
2. Choose the System DSN tab.

3. Click the Add button.
   The Create New Data Source dialog box appears:

4. Select Microsoft Access Driver (*.mdb), and then click the Finish button.
   The ODBC Microsoft Access Setup dialog box appears:

5. Enter a name and description for the data source, and then click the Create button.
   Example:
     Data source name: ServerConductor
     Description: ServerConductor DSN
   The New Database dialog box appears:

6. Enter a name for the database, and then click the OK button.
   The file can be stored at any location.
7. When the ODBC Microsoft Access Setup dialog box appears again, click the OK button.

#### (2) Creating a database

To create a database:

1. In the Host Management window, from the Setting menu, choose Manager Service Settings.
   The Manager Service setup dialog box appears.
2. Choose the Report Function tab.

3. Select the Using the host search function and auto-report function check box.
   The Select Database dialog box appears.

##### (a) Select Database dialog box

This dialog box displays the names of only those data sources that are currently available (that were created by the procedure in 5.2.2(1) Creating an ODBC data source).

1. Select the name of the data source to be used, and then click the OK button.
   The Report Function page is displayed again and the Settings for the database update schedule button is enabled.
2. Click the Settings for the database update schedule button.
   The Database Update and Schedule Settings dialog box appears.

##### (b) Database Update and Schedule Settings dialog box

1. Select a desired day of the week or a desired date as the basis for setting a schedule.
   - For a daily schedule: Click the Every day button under Specific day setting.
   - For a weekly schedule: Select the desired day(s) of the week.
   - For a monthly schedule: Select Every month in the Month drop-down under Specific day setting.
   - For an annual schedule: Enter -1 in Year under Specific day setting.
2. Set schedule information.
   Set the following information:

   Item | Setting
   --- | ---
   Time | Set the time of day at which the database update schedule is to be executed. You can specify the time in increments of 30 minutes.
   To update a database | Select this option to update the database at the specified time.
   To exclude from database updates | Select this option to not update the database at the specified time.

   Rules
   - When To update a database is selected, the Specific day setting settings take effect. When To update a database is selected in conjunction with both Specific day setting settings and Settings for days of the week settings, the Settings for days of the week settings are ignored regardless of the specified time.
     Example: If Specific day setting settings are 08/11/1999 9:00 (with To update a database selected) and Settings for days of the week settings are Wed 12:00 (with To update a database selected), then database updating on Wednesdays at 12:00 is ignored.
   - When To exclude from database updates is selected, there is no precedence between the Specific day setting settings and the Settings for days of the week settings. If To update a database is selected in conjunction with Specific day setting settings and To exclude from database updates is selected in conjunction with Settings for days of the week settings, and the update time and exclusion time are the same, the exclusion settings take precedence.
     Example: If Specific day setting settings are 08/11/1999 9:00 (with To update a database selected) and Settings for days of the week settings are Wed 9:00 (with To exclude from database updates selected), then exclusion is assumed.
   - Make sure that the database update schedule time will be before the report schedule time described in 5.2.3(2) Setting a report schedule (auto-report function). By setting the report schedule to be subsequent to database updating, the most recent information will always be reported. In such a case, you should provide an interval of at least one hour.
   - When you select To update a database, allow at least one day before the update time.
   - If fewer than 30 minutes will elapse between scheduled update times as a result of setting Every month in Month or of clicking the Every day button, the Every day setting will be ignored.
3. Click the Add to List button.
   The set daily schedule is added to the One-day schedule list. If there is an error in the added schedule, select that schedule and click the Delete button.
4. Click the Settings (R) -> button.
   The specified settings are added to List of setting-completed days of the week or List on set specific day. To set multiple update schedules, repeat this procedure. You can set a maximum of 10 daily update schedules, in any combination of up to seven days of the week and up to 10 specific dates.
5. Click the OK button.
   The update schedule is registered and the Report Function page is displayed again.
6. On the Report Function page, click the OK button.
   Database creation (collection of inventory information from managed hosts) begins.

#### (3) Setting email addresses (auto-report function)

To set the email addresses that are to be used for reporting by the auto-report function:

1. In the Host Management window, from the Setting menu, choose Manager Service Settings.
   The Manager Service setup dialog box appears.
2. Choose the Email Settings tab.
3. From the Select the function for email settings list, select Report Function.
   Setting items are displayed on the Email Settings page.

   In this dialog box, you can set the following information:

   Item | Setting
   --- | ---
   Destination | Set an email address to which inventory information is to be sent.
   Sender | Set the sender's email address.
   Subject | Set a subject line for the email (as a character string).
   Mail server | Set the host name or IP address of the sender's mail server.
   Attached file format | Set the format of the file attachment that is to be sent by the auto-report function. You can select CSV format or HTML format. The default is CSV format.
   Test email | Select if a test email is to be sent to all email addresses displayed in the Email report destination list. Test Mail is set as the subject line and as the message of the test email, and no file is attached.
   Maximum size of attached file | Specify a maximum size for an attached file (in megabytes). You cannot specify a value in excess of 32 megabytes. However, if you specify 0, this size limitation is eliminated and files larger than 32 megabytes can be sent as attachments. The default is 0.

4. Click the Add to List button.
   The destination specified in Email report destination list is added. You can set a maximum of four email destinations. To delete a destination that has been set, select it and click the Delete button.
5. Click the OK button.

For details about the email message to be sent and the format of attached files, see 5.2.3(2) Setting a report schedule (auto-report function).

#### (4) Deleting a database

If you wish to re-create a database for some reason, you must first delete it. To delete a database, from Setting, choose Manager Service Settings, then the Report Function tab, and then clear the Using the host search function and auto-report function check box. Clicking the OK button displays a message asking you to confirm deletion of the database. To delete the database, click the Yes button.

When a database is deleted, the host search and auto-report functions are no longer available. To use these functions, see 5.2.2(2) Creating a database, and then re-create the database.

All Rights Reserved. Copyright (C) 2006, Hitachi, Ltd.