HP OpenView Service Desk and HP Systems Insight Manager Integration User Guide Reference number: 449791-001 First edition: March 2007
Legal notices © Copyright 2005-2007 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license. The information contained herein is subject to change without notice.
Contents Contents Introduction Supported Configurations ....................................................................................................................... 6 ACES XML Import Importing items as Service Desk configuration items from the HP SIM database Creating a new template......................................................................................................................... 9 Installing the Insight Manager Configuration File ..........................................
Contents Adding OpenView Web Console Tools Menu ......................................................................................... 46 Launching to the HP Systems Management Homepage.............................................................................. 47 Troubleshooting Task Results error ................................................................................................................................. 49 ACES_InsightManager XML import error ....................................
Introduction Introduction Enterprise IT managers are responsible for delivering and maintaining the infrastructure and services that enable businesses to compete effectively and respond quickly to changing market conditions. Keeping business services operating smoothly requires in-depth knowledge of the environment from end-to-end, an understanding of how IT affects the availability and operations of business processes, and an effective set of well-integrated management tools.
Introduction • ovwebconsole.xml – tool definition file to add a launch to the HP OpenView Service Desk Web Console from Systems Insight Manager • hpsimsde.exe – program to automatically create incidents from events received by Systems Insight Manager • hpsimsde_test.bat – file to test sd_event configuration from the HP SIM server on Microsoft® Windows® • insightmanager.
ACES XML Import ACES XML Import A predefined XML file provided in association with this guide automatically defines several default values for Systems Insight Manager in the Service Desk database. Importing this file simplifies the configuration process, and removes the need to manually define a default template and import mapping for objects related with the Systems Insight Manager database. The following items are defined in the ACES_InsightManager.
ACES XML Import Figure 1 ACES Import Selection Window The items automatically imported by the ACES_InsightManager.xml file can also be created manually, if preferred. The steps to perform a manual configuration are described in the following sections of this guide.
Importing items as Service Desk configuration items from the HP SIM database Importing items as Service Desk configuration items from the HP SIM database Creating a new template Create a new Insight Manager template based on the default template. This process allows for the definition of default values for certain fields (like Location), that will be applied to the imported objects.
Importing items as Service Desk configuration items from the HP SIM database Table 2 Default Insight Manager Template Values Property Value Brand Hewlett Packard Category Server Location USA Maximum Installations 100,000 Search Code HPSIM Status Installed Installing the Insight Manager Configuration File Copy the configuration file (hpsim-sql.ini, hpsim-pgsql.ini, or hpsim-oracle.ini) to the Service Desk\data_exchange\config directory.
Importing items as Service Desk configuration items from the HP SIM database Creating a Data Source for Systems Insight Manager using an SQL Database Create a System Data Source Name (DSN) on an OpenView Service Desk system that can connect to the HP Systems Insight Manager database. 6. Select Start>Settings>Control Panel>Administrative Tools>Data Sources(ODBC). 7. Click the System DSN tab. 8. Click Add. 9. Select SQL Server from the list, and then click Finish. 10.
Importing items as Service Desk configuration items from the HP SIM database Before performing these steps, the PostgreSQL ODBC driver should already be installed on the client that will be used to run the data exchange tasks. Also, the HP Systems Insight Manager database should already be configured for remote access. 1. Select Start>Settings>Control Panel>Administrative Tools>Data Sources(ODBC). 2. Click the System DSN tab. 3. Click Add. 4. Select the PostgreSQL Unicode driver, and then click Finish. 5.
Importing items as Service Desk configuration items from the HP SIM database Figure 4 PostgreSQL ODBC Advanced Options window. Creating the Import Mapping for the HP SIM database NOTE: This procedure is not necessary if the user imported the ACES_InsightManager.xml file. 1. Open the Service Desk Administrator Console. 2. Navigate to hp OpenView service desk>Data>Data Exchange>Import Mapping. 3. To create a new mapping, click the New button. 4. Enter a name in the Name field, for example, Insight Manager.
Importing items as Service Desk configuration items from the HP SIM database Figure 5 Import Mapping Window Table 3 Import Mapping Property Field Used As DEVICES_MXGUID Source ID Unique Key DEVICES_NAME Search Code DEVICES_FULLDNSNAME ID IM_CATEGORY Category IM_PARENT Parent CI’s; CI Parent DB_DEVICEINFOEX_SERIALNUMBER Serial Number M_NAME1 Name 1 IM_NAME2 Name 2 DEVICEPROTOCOLINFO_PRIMARYADD RESS IP Address 14
Importing items as Service Desk configuration items from the HP SIM database Figure 6 Default Insight Manager Import Mapping Creating and Importing the Insight Manager XML file from the HP SIM database This action will export items from the HP Systems Insight Manager database into an XML file that can be parsed by Service Desk. The items exported to the XML file are defined by the filters in the configuration file.
Importing items as Service Desk configuration items from the HP SIM database 9. Enter the account password. 10. Select Insight Manager as the import mapping. 11. Click the Start button to begin the export and import process (click OK if prompted that the XML file will be overwritten by the export process). 12. When asked if you want to exchange data now, click OK. 13. To close the Data Exchange Task Window when the process is complete, click OK.
Importing items as Service Desk configuration items from the HP SIM database warning: Attribute not defined: DB_DEVICEINFOEX_ASSETTAG on entity InsightManager (id = 1) warning: Attribute not defined: DB_DEVICEINFOEX_TOTALMEMORY on entity InsightManager (id = 1) warning: Attribute not defined: DB_DEVICEINFOEX_ROMVERSION on entity InsightManager (id = 1) Importing Different Types of Devices from Systems Insight Manager By default, the provided Insight Manager configuration file imports the data objects defin
Importing items as Service Desk configuration items from the HP SIM database By default, the configuration file imports all devices with the “Storage” product sub-type into the overall Storage CI Category. After the devices are imported, they can be moved into more descriptive categories, such as “Storage Array” and “Storage Switch.
Automatic incident creation from HP SIM events Automatic incident creation from HP SIM events The program hpsimsde.exe automatically parses the environment variables from HP Systems Insight Manager (HP SIM) events. Using these environment variables, the program creates the appropriate command string and launches sd_event.exe to pass the HP SIM event information to Service Desk. NOTE: The sd_event.exe program must be installed on the HP SIM server.
Automatic incident creation from HP SIM events Figure 10 Executing the hpsimsde_test script to verify communication between SIM and Service Desk 20
Automatic incident creation from HP SIM events Figure 11 Test Incident created by running the hpsimsde_test script. Creating a custom command in HP SIM 5.0 The first step for automatic incident creation is configuring a custom command within Systems Insight Manager. This custom command (hpsimsde.exe) is the program that will be executed when an event is received. This program takes the trap environment variables set by Systems Insight Manager, formats the values, and launches sd_event.
Automatic incident creation from HP SIM events 5. In the Command field, enter the full path to the hpsimsde executable, for example: c:\progra~1\hewlet~1\openview\servic~1.5\event\bin\hpsimsde.exe” on Microsoft® Windows® and “/opt/OV/sd/event/bin/hpsimsde” on HP-UX. 6. In the Parameter field, enter -i to specify a new incident creation. NOTE: This field must first be added to the external_event import mapping. 7. Add the IM_WORKGROUP environment variable if preferred. 8. To save the new command, click OK.
Automatic incident creation from HP SIM events Figure 13 Service Desk Event files installed on the HP SIM server running on HP-UX Figure 14 Creating a custom command in HP SIM running on HP-UX 23
Automatic incident creation from HP SIM events Creating a custom tool in HP SIM 5.1 In HP SIM version 5.1, the custom commands menu has been replaced by the “Custom Tools” menu. Use the following steps to create a custom tool: 1. Select Tools>Custom Tools>New Custom Tool. 2. Select CMS Tool, and then click Next. 3. Enter a name for the new custom tool. 4. Fill in the description, help information, and menu placement fields (optional). 5. Specify the user account that will be used to run the custom tool. 6.
Automatic incident creation from HP SIM events The new custom tool displays at the defined menu location. Additionally, the custom tool definition can display in HP SIM 5.1. Figure 16 Custom Tools menu Creating an “Action on Event” in HP SIM The user configures what HP SIM events should be created as Service Desk Incidents when the “action on event” is created. This step enables system filters and event filters to be applied so that only specified events are created as incidents. 1.
Automatic incident creation from HP SIM events Figure 17 Task Results for event forwarded to Service Desk 26
Automatic incident creation from HP SIM events Figure 18 Incident Received from Systems Insight Manager Adding other fields to the External Event Import Mapping The external_event import mapping defines several fields for use with the sd_event executable. For other fields to be utilized during automatic incident creation, the import mapping must be updated to include the new fields.
Automatic incident creation from HP SIM events Creating Incidents from Storage Essentials Events Incidents in Service Desk can be generated automatically for Storage Essentials events using the procedures described in the previous sections. A custom command is created, and then an action on event is created that forwards the selected storage events. See “Creating a custom command in HP SIM 5.0” on page 21.
Automatic incident creation from HP SIM events Figure 20 Storage Essentials Incident Details 29
Automatic incident closing from HP SIM Automatic incident closing from HP SIM The program hpsimsde.exe automatically parses the environment variables from HP Systems Insight Manager (HP SIM) events. Using these environment variables, the program creates the appropriate command string and launches the sd_event executable to pass the HP SIM event information to Service Desk.
Automatic incident closing from HP SIM 7. Specify the user account that will be used to run the custom tool. 8. Set the number of targets field to Unlimited. 9. Enter the command in the command field, including any parameters. For example: c:\progra~1\hewlet~1\openview\servic~1.5\event\bin\hpsimsde.exe –u. 10. Add the SD_EVENTHOME environment variable, for example: C:\Program Files\HewlettPackard\OpenView\service desk 4.5\event\.
Automatic incident closing from HP SIM Creating an “Action on Event” in HP SIM The user configures what HP SIM events should be closed in Service Desk when the “action on event” is created. This step is where system filters and event filters can be applied so that only the selected events are closed. 1. Click Options>Events>Automatic Event Handling>New Task. 2. Enter the name for the new task, for example, Close Service Desk Incident, and then click Next. 3.
Launching HP SIM and other Management Applications from Service Desk Launching HP SIM and other Management Applications from Service Desk Shortcuts can be created on the Service Desk shortcut bar to access various applications. To create a shortcut to HP Systems Insight Manager: 1. Right-click on the appropriate category in the shortcut bar, and select Add Group. 2. Enter a name for the new group, for example, Management Tools. 3. Select the new group. 4.
Creating Smart Actions for HP SIM and the Insight Management Agents in Service Desk Creating Smart Actions for HP SIM and the Insight Management Agents in Service Desk Smart actions can be defined to provide direct launches to specific systems. These Smart Actions will be available in the Configuration Item window for a specified device. Clicking the Actions>HP System Management Homepage, Actions>HP Systems Insight Manager, or Actions>HP Insight Lights Out menu items will launch the newly defined actions.
Creating Smart Actions for HP SIM and the Insight Management Agents in Service Desk Defining a Smart Action for the in-context launch of HP Systems Insight Manager 1. In the HP OpenView Service Desk main window, select the Tools menu, and then click System. 2. Under HP OpenView service desk, click Business Logic>Actions>Smart Actions. 3. Under Smart Actions, select Configuration Items. 4. To create a new Smart Action, click New. 5.
Creating Smart Actions for HP SIM and the Insight Management Agents in Service Desk Defining a Smart Action for the HP Integrated LightsOut 1. In the HP OpenView Service Desk main window, select the Tools menu, and then click on the System entry. 2. Under HP OpenView service desk, click Business Logic>Actions>Smart Actions. 3. Under Smart Actions, select Configuration Items. 4. To create a new Smart Action, click New. 5. In the Text field, enter a name for the entry, for example, HP Insight Lights Out. 6.
Creating Smart Actions for HP SIM and the Insight Management Agents in Service Desk Figure 26 Smart Actions defined for the Incident view.
Service Desk Service Pages Service Desk Service Pages Updating Systems Insight Manager to Discover the Service Desk Web Interface Through the Links tab on the System Page, the Systems Insight Manager server can be modified to show whether the Service Pages web interface is running on a server. Open the additionalWsDisc.props file in the Systems Insight Manager\config\identification directory. Add the following line to the file: 8080=OpenView Service Desk - Service Pages,sdsp45/index.html,true,false, ,http.
Service Desk Service Pages Adding Service Pages Tools Menu Entry Adding this tool definition will allow the user to launch to the OpenView Service Desk Service Pages from within Systems Insight Manager. 1. Copy the servicedesk.xml file to the Systems Insight Manager\tools directory. 2. Open the servicedesk.xml file and replace SERVICEDESK:8080 with the name and port number of the Service Pages server. Save the file. 3. Open a command prompt and change to the Systems Insight Manager\tools directory. 4.
Service Desk Service Pages Viewing Incidents in Service Pages Modifying the Services Pages settings may be necessary to display the Incidents created automatically by Systems Insight Manager. 1. Open the Administrator Console. 2. Navigate to Service Pages>Presentation>Incident. 3. Select Workgroup All Incidents and modify the Filter settings. 4. Select Workgroup Open Incidents and modify the Filter settings.
Service Desk Service Pages 41
Service Desk Service Pages Figure 30 Service Pages Specific Incident created by Systems Insight Manager 42
Scheduling the HP SIM Data Exchange Scheduling the HP SIM Data Exchange OpenView Service Desk provides command line utilities for various data exchange tasks. One of these tools (sd_exchange.bat) can be used to import data from the HP SIM database. A sample script is included (hpsimexchange.bat) that executes the sd_exchange command to export data from the HP SIM database and then import that data into service.
Scheduling the HP SIM Data Exchange The user must copy hpsimexchange.bat to the same location as sd_exchange.bat, and then edit the file to include the correct configuration file, username, password, and ServiceDesk server name. 1. Open the Microsoft® Windows® Control Panel, and then select Scheduled Tasks. 2. Click Add Scheduled Task, and then click Next. 3. Click Browse, and then select the hpsimexchange.bat file located in the \service desk 4.5\client\bin directory.
Scheduling the HP SIM Data Exchange 5. Enter a time for the task to execute, and then click Next. Figure 34 Scheduled Task Wizard time and day window 6. Enter the login credentials to execute the task, click Next, and then click Finished.
HP OpenView Web Console HP OpenView Web Console Updating Systems Insight Manager to Discover the OpenView Web Console Through the Links tab on the System Page, the Systems Insight Manager server can be modified to show whether the OpenView Web Console is running on a server. Open the additionalWsDisc.props file in the Systems Insight Manager\config\identification directory. Add the following line to the file: 80=HP OpenView Web Console,ovportal,true,false, ,http.
HP OpenView Web Console Figure 36 OpenView Web Console Displaying Configuration Items Launching to the HP Systems Management Homepage If Smart Actions that launch to the management agents are defined for Configuration Items and Incidents, these Smart Actions will be available in the OpenView Web Console.
HP OpenView Web Console Figure 37 OpenView Web Console Incident Pop-up Actions 48
Troubleshooting Troubleshooting Task Results error Description: When viewing the task results, the following message is displayed in the HP SIM Stdout window: No operation specified (insert or update) Action: • • Verify that the hpsimsde.exe option is specified correctly (-i or –u). Verify that there is not a space after the option (-i or –u) in the custom tool definition in HP SIM. ACES_InsightManager XML import error Description: The ACES_InsightManager XML file does not import successfully.
Appendix A Appendix A This appendix lists the contents of the Insight Manager SQL Data Exchange file. The configuration file is provided to export data from the Systems Insight Manager database running on Microsoft® SQL Server into an XML file that can be imported into Service Desk. Insight Manager SQL Data Exchange File SQL database configuration file. Entries beginning with "--" are comments.
Appendix A [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [DB_DeviceInfoEx_ROMVersion], \ [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_PrimaryAddress], \ [IM_NAME1], \ [IM_NAME2], \ [IM_CATEGORY] COLUMNS=[devices].[Name] AS [devices_Name], \ CAST ([deviceProtocolInfo].
Appendix A CAST ([DB_DeviceInfoEx].[OSDescription] AS VARCHAR) + ' - ' + \ CAST ([DB_DeviceInfo].[Description] AS VARCHAR) + ' - ' + \ CAST ([DB_DeviceInfo].[Location] AS VARCHAR) + ' - ' + \ CAST ([DB_DeviceInfo].[Contact] AS VARCHAR) AS [IM_NAME2], \ 'Server' AS [IM_CATEGORY] CONDITION=[devices].[DeviceKey] = [DB_DeviceInfo].[DeviceKey] AND \ [devices].[DeviceKey] = [DB_DeviceInfoEx].[DeviceKey] AND \ [DB_DeviceInfo].[DeviceKey] = [DB_DeviceInfoEx].[DeviceKey] AND \ [deviceProtocolInfo].
Appendix A [IM_CATEGORY] COLUMNS=[devices].[Name] AS [devices_Name], \ CAST ([deviceProtocolInfo].[PrimaryAddress] AS VARCHAR) AS [deviceProtocolInfo_PrimaryAddress], \ [devices].[ProductTypeStr] AS [devices_ProductTypeStr], \ CAST ([devices].[ProductName] AS VARCHAR) AS [IM_NAME1], \ [devices].[fullDNSName] AS [devices_fullDNSName], \ [devices].[OverallStatus] AS [devices_OverallStatus], \ [devices].[MxGUID] AS [devices_MxGUID], \ CAST ([DB_DeviceInfo].
Appendix A [devices].[ProductTypeStr]='Desktop' ORDERBY=[devices].
Appendix A CAST ([DB_DeviceInfo].[Contact] AS VARCHAR) AS [DB_DeviceInfo_Contact], \ CAST ([DB_DeviceInfoEx].[SerialNumber] AS VARCHAR) AS [DB_DeviceInfoEx_SerialNumber], \ CAST ([DB_DeviceInfoEx].[AssetTag] AS VARCHAR) AS [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx].[TotalMemory] AS [DB_DeviceInfoEx_TotalMemory], \ CAST ([DB_DeviceInfoEx].[ROMVersion] AS VARCHAR) AS [DB_DeviceInfoEx_ROMVersion], \ CAST ([DB_DeviceInfoEx].[OSName] AS VARCHAR) AS [DB_DeviceInfoEx_OSName], \ CAST ([DB_DeviceInfoEx].
Appendix A [devices_MxGUID], \ [DB_DeviceInfo_Location], \ [DB_DeviceInfo_Description], \ [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [DB_DeviceInfoEx_ROMVersion], \ [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_PrimaryAddress], \ [IM_NAME1], \ [IM_NAME2], \ [IM_CATEGORY] COLUMNS=[devices].
Appendix A CAST ([DB_DeviceInfoEx].[OSVendor] AS VARCHAR) AS [DB_DeviceInfoEx_OSVendor], \ CAST ([DB_DeviceInfoEx].[OSDescription] AS VARCHAR) AS [DB_DeviceInfoEx_OSDescription], \ CAST ([DB_DeviceInfoEx].[OSName] AS VARCHAR) + ' - ' + \ CAST ([DB_DeviceInfoEx].[OSDescription] AS VARCHAR) + ' - ' + \ CAST ([DB_DeviceInfo].[Description] AS VARCHAR) + ' - ' + \ CAST ([DB_DeviceInfo].[Location] AS VARCHAR) + ' - ' + \ CAST ([DB_DeviceInfo].
Appendix A [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_PrimaryAddress], \ [IM_NAME1], \ [IM_NAME2], \ [IM_CATEGORY] COLUMNS=[devices].[Name] AS [devices_Name], \ CAST ([deviceProtocolInfo].[PrimaryAddress] AS VARCHAR) AS [deviceProtocolInfo_PrimaryAddress], \ [devices].[ProductTypeStr] AS [devices_ProductTypeStr], \ CAST ([devices].[ProductName] AS VARCHAR) AS [IM_NAME1], \ [devices].[fullDNSName] AS [devices_fullDNSName], \ [devices].
Appendix A [devices].[DeviceKey] = [DB_DeviceInfoEx].[DeviceKey] AND \ [DB_DeviceInfo].[DeviceKey] = [DB_DeviceInfoEx].[DeviceKey] AND \ [deviceProtocolInfo].[DeviceKey] = [devices].[DeviceKey] AND \ [deviceProtocolInfo].[DeviceKey] = [DB_DeviceInfo].[DeviceKey] AND \ [deviceProtocolInfo].[DeviceKey] = [DB_DeviceInfoEx].[DeviceKey] AND \ [devices].[ProductTypeStr]='MgmtProc' LOADTABLE=FALSE ORDERBY=[devices].
Appendix A CAST ([devices].[ProductName] AS VARCHAR) AS [IM_NAME1], \ [devices].[fullDNSName] AS [devices_fullDNSName], \ [devices].[OverallStatus] AS [devices_OverallStatus], \ [devices].[MxGUID] AS [devices_MxGUID], \ CAST ([DB_DeviceInfo].[Location] AS VARCHAR) AS [DB_DeviceInfo_Location], \ CAST ([DB_DeviceInfo].[Description] AS VARCHAR) AS [DB_DeviceInfo_Description], \ CAST ([DB_DeviceInfo].[Contact] AS VARCHAR) AS [DB_DeviceInfo_Contact], \ CAST ([DB_DeviceInfoEx].
Appendix A [IM_SWITCH] SOURCE=[DB_DeviceInfo], [DB_DeviceInfoEx], [devices], [deviceProtocolInfo] ATT=[devices_Name], \ [devices_ProductTypeStr], \ [devices_FullDNSName], \ [devices_OverallStatus], \ [devices_MxGUID], \ [DB_DeviceInfo_Location], \ [DB_DeviceInfo_Description], \ [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [DB_DeviceInfoEx_ROMVersion], \ [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSV
Appendix A CAST ([DB_DeviceInfoEx].[AssetTag] AS VARCHAR) AS [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx].[TotalMemory] AS [DB_DeviceInfoEx_TotalMemory], \ CAST ([DB_DeviceInfoEx].[ROMVersion] AS VARCHAR) AS [DB_DeviceInfoEx_ROMVersion], \ CAST ([DB_DeviceInfoEx].[OSName] AS VARCHAR) AS [DB_DeviceInfoEx_OSName], \ CAST ([DB_DeviceInfoEx].[OSType] AS VARCHAR) AS [DB_DeviceInfoEx_OSType], \ CAST ([DB_DeviceInfoEx].[OSVersion] AS VARCHAR) AS [DB_DeviceInfoEx_OSVersion], \ CAST ([DB_DeviceInfoEx].
Appendix A [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [DB_DeviceInfoEx_ROMVersion], \ [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_PrimaryAddress], \ [IM_NAME1], \ [IM_NAME2], \ [IM_CATEGORY] COLUMNS=[devices].[Name] AS [devices_Name], \ CAST ([deviceProtocolInfo].
Appendix A CAST ([DB_DeviceInfoEx].[OSName] AS VARCHAR) + ' - ' + \ CAST ([DB_DeviceInfoEx].[OSDescription] AS VARCHAR) + ' - ' + \ CAST ([DB_DeviceInfo].[Description] AS VARCHAR) + ' - ' + \ CAST ([DB_DeviceInfo].[Location] AS VARCHAR) + ' - ' + \ CAST ([DB_DeviceInfo].[Contact] AS VARCHAR) AS [IM_NAME2], \ 'Rack' AS [IM_CATEGORY] CONDITION=[devices].[DeviceKey] = [DB_DeviceInfo].[DeviceKey] AND \ [devices].[DeviceKey] = [DB_DeviceInfoEx].[DeviceKey] AND \ [DB_DeviceInfo].[DeviceKey] = [DB_DeviceInfoEx].
Appendix A [IM_NAME1], \ [IM_NAME2], \ [IM_CATEGORY] COLUMNS=[devices].[Name] AS [devices_Name], \ CAST ([deviceProtocolInfo].[PrimaryAddress] AS VARCHAR) AS [deviceProtocolInfo_PrimaryAddress], \ [devices].[ProductTypeStr] AS [devices_ProductTypeStr], \ CAST ([devices].[ProductName] AS VARCHAR) AS [IM_NAME1], \ [devices].[fullDNSName] AS [devices_fullDNSName], \ [devices].[OverallStatus] AS [devices_OverallStatus], \ [devices].[MxGUID] AS [devices_MxGUID], \ CAST ([DB_DeviceInfo].
Appendix A [deviceProtocolInfo].[DeviceKey] = [DB_DeviceInfo].[DeviceKey] AND \ [deviceProtocolInfo].[DeviceKey] = [DB_DeviceInfoEx].[DeviceKey] AND \ [devices].[ProductTypeStr]='Enclosure' LOADTABLE=FALSE ORDERBY=[devices].
Appendix A [devices].[MxGUID] AS [devices_MxGUID], \ CAST ([DB_DeviceInfo].[Location] AS VARCHAR) AS [DB_DeviceInfo_Location], \ CAST ([DB_DeviceInfo].[Description] AS VARCHAR) AS [DB_DeviceInfo_Description], \ CAST ([DB_DeviceInfo].[Contact] AS VARCHAR) AS [DB_DeviceInfo_Contact], \ CAST ([DB_DeviceInfoEx].[SerialNumber] AS VARCHAR) AS [DB_DeviceInfoEx_SerialNumber], \ CAST ([DB_DeviceInfoEx].[AssetTag] AS VARCHAR) AS [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx].
Appendix A ATT=[devices_Name], \ [devices_ProductTypeStr], \ [devices_FullDNSName], \ [devices_OverallStatus], \ [devices_MxGUID], \ [DB_DeviceInfo_Location], \ [DB_DeviceInfo_Description], \ [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [DB_DeviceInfoEx_ROMVersion], \ [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProto
Appendix A CAST ([DB_DeviceInfoEx].[OSName] AS VARCHAR) AS [DB_DeviceInfoEx_OSName], \ CAST ([DB_DeviceInfoEx].[OSType] AS VARCHAR) AS [DB_DeviceInfoEx_OSType], \ CAST ([DB_DeviceInfoEx].[OSVersion] AS VARCHAR) AS [DB_DeviceInfoEx_OSVersion], \ CAST ([DB_DeviceInfoEx].[OSVendor] AS VARCHAR) AS [DB_DeviceInfoEx_OSVendor], \ CAST ([DB_DeviceInfoEx].[OSDescription] AS VARCHAR) AS [DB_DeviceInfoEx_OSDescription], \ CAST ([DB_DeviceInfoEx].[OSName] AS VARCHAR) + ' - ' + \ CAST ([DB_DeviceInfoEx].
Appendix B Appendix B This appendix lists the contents of the Insight Manager Oracle Data Exchange file. The configuration file is provided to export data from the Systems Insight Manager database running on Oracle into an XML file that can be imported into Service Desk. Insight Manager Oracle Data Exchange File Oracle database configuration file. Entries beginning with "--" are comments.
Appendix B [devices_MxGUID], \ [DB_DeviceInfo_Location], \ [DB_DeviceInfo_Description], \ [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [DB_DeviceInfoEx_ROMVersion], \ [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_ip], \ [IM_NAME1], \ [IM_NAME2], \ [IM_PARENT], \ [IM_CATEGORY] COLUMNS=SIM_MANAGER.DEVICES.
Appendix B SIM_MANAGER.DB_DEVICEINFOEX.OSVENDOR AS [DB_DeviceInfoEx_OSVendor], \ SIM_MANAGER.DB_DEVICEINFOEX.OSDESCRIPTION AS [DB_DeviceInfoEx_OSDescription], \ SIM_MANAGER.DB_DEVICEINFO.DESCRIPTION AS [IM_NAME2], \ 'Server' AS [IM_CATEGORY] LOADTABLE=FALSE CONDITION=SIM_MANAGER.DEVICES.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY AND \ SIM_MANAGER.DEVICES.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFOEX.DEVICEKEY AND \ SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFOEX.
Appendix B [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_ip], \ [IM_NAME1], \ [IM_NAME2], \ [IM_PARENT], \ [IM_CATEGORY] COLUMNS=SIM_MANAGER.DEVICES.NAME AS [devices_Name], \ SIM_MANAGER.DEVICEPROTOCOLINFO.PRIMARYADDRESS AS [deviceProtocolInfo_ip] ,\ SIM_MANAGER.DEVICES.PRODUCTTYPESTR AS [devices_ProductTypeStr], \ SIM_MANAGER.DEVICES.PRODUCTSUBTYPE AS [devices_ProductSubType], \ SIM_MANAGER.DEVICES.SUBTYPE2 AS [devices_SubType2], \ SIM_MANAGER.DEVICES.PRODUCTNAME AS [IM_NAME1], \ SIM_MANAGER.
Appendix B SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY AND \ SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFOEX.DEVICEKEY AND \ SIM_MANAGER.DEVICES.PRODUCTTYPESTR='Desktop' [IM_WORKSTATION] SOURCE=SIM_MANAGER.DEVICES, SIM_MANAGER.DB_DEVICEINFOEX, SIM_MANAGER.DB_DEVICEINFO, SIM_MANAGER.
Appendix B SIM_MANAGER.DEVICES.FULLDNSNAME AS [devices_fullDNSName], \ SIM_MANAGER.DEVICES.OVERALLSTATUS AS [devices_OverallStatus], \ SIM_MANAGER.DEVICES.MXGUID AS [devices_MxGUID], \ SIM_MANAGER.DB_DEVICEINFO.LOCATION AS [DB_DeviceInfo_Location], \ SIM_MANAGER.DB_DEVICEINFO.DESCRIPTION AS [DB_DeviceInfo_Description], \ SIM_MANAGER.DB_DEVICEINFO.CONTACT AS [DB_DeviceInfo_Contact], \ SIM_MANAGER.DB_DEVICEINFOEX.SERIALNUMBER AS [DB_DeviceInfoEx_SerialNumber], \ SIM_MANAGER.DB_DEVICEINFOEX.
Appendix B [devices_OverallStatus], \ [devices_MxGUID], \ [DB_DeviceInfo_Location], \ [DB_DeviceInfo_Description], \ [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [DB_DeviceInfoEx_ROMVersion], \ [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_ip], \ [IM_NAME1], \ [IM_NAME2], \ [IM_PARENT], \ [IM_CATEGORY] CO
Appendix B SIM_MANAGER.DB_DEVICEINFOEX.OSVERSION AS [DB_DeviceInfoEx_OSVersion], \ SIM_MANAGER.DB_DEVICEINFOEX.OSVENDOR AS [DB_DeviceInfoEx_OSVendor], \ SIM_MANAGER.DB_DEVICEINFOEX.OSDESCRIPTION AS [DB_DeviceInfoEx_OSDescription], \ SIM_MANAGER.DB_DEVICEINFO.DESCRIPTION AS [IM_NAME2], \ 'MgmtProc' AS [IM_CATEGORY] LOADTABLE=FALSE CONDITION=SIM_MANAGER.DEVICES.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY AND \ SIM_MANAGER.DEVICES.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFOEX.DEVICEKEY AND \ SIM_MANAGER.
Appendix B [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_ip], \ [IM_NAME1], \ [IM_NAME2], \ [IM_PARENT], \ [IM_CATEGORY] COLUMNS=SIM_MANAGER.DEVICES.NAME AS [devices_Name], \ SIM_MANAGER.DEVICEPROTOCOLINFO.PRIMARYADDRESS AS [deviceProtocolInfo_ip] ,\ SIM_MANAGER.DEVICES.PRODUCTTYPESTR AS [devices_ProductTypeStr], \ SIM_MANAGER.DEVICES.PRODUCTSUBTYPE AS [devices_ProductSubType], \ SIM_MANAGER.DEVICES.SUBTYPE2 AS [devices_SubType2], \ SIM_MANAGER.DEVICES.
Appendix B SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SIM_MANAGER.DEVICES.DEVICEKEY AND \ SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY AND \ SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFOEX.DEVICEKEY AND \ SIM_MANAGER.DEVICES.PRODUCTTYPESTR='Printer' [IM_STORAGE] SOURCE=SIM_MANAGER.DEVICES, SIM_MANAGER.DB_DEVICEINFOEX, SIM_MANAGER.DB_DEVICEINFO, SIM_MANAGER.
Appendix B SIM_MANAGER.DEVICES.SUBTYPE2 AS [devices_SubType2], \ SIM_MANAGER.DEVICES.PRODUCTNAME AS [IM_NAME1], \ SIM_MANAGER.DEVICES.FULLDNSNAME AS [devices_fullDNSName], \ SIM_MANAGER.DEVICES.OVERALLSTATUS AS [devices_OverallStatus], \ SIM_MANAGER.DEVICES.MXGUID AS [devices_MxGUID], \ SIM_MANAGER.DB_DEVICEINFO.LOCATION AS [DB_DeviceInfo_Location], \ SIM_MANAGER.DB_DEVICEINFO.DESCRIPTION AS [DB_DeviceInfo_Description], \ SIM_MANAGER.DB_DEVICEINFO.CONTACT AS [DB_DeviceInfo_Contact], \ SIM_MANAGER.
Appendix B [devices_SubType2], \ [devices_fullDNSName], \ [devices_OverallStatus], \ [devices_MxGUID], \ [DB_DeviceInfo_Location], \ [DB_DeviceInfo_Description], \ [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [DB_DeviceInfoEx_ROMVersion], \ [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_ip], \ [IM_NAME1], \
Appendix B SIM_MANAGER.DB_DEVICEINFOEX.OSNAME AS [DB_DeviceInfoEx_OSName], \ SIM_MANAGER.DB_DEVICEINFOEX.OSTYPE AS [DB_DeviceInfoEx_OSType], \ SIM_MANAGER.DB_DEVICEINFOEX.OSVERSION AS [DB_DeviceInfoEx_OSVersion], \ SIM_MANAGER.DB_DEVICEINFOEX.OSVENDOR AS [DB_DeviceInfoEx_OSVendor], \ SIM_MANAGER.DB_DEVICEINFOEX.OSDESCRIPTION AS [DB_DeviceInfoEx_OSDescription], \ SIM_MANAGER.DB_DEVICEINFO.DESCRIPTION AS [IM_NAME2], \ 'Switch' AS [IM_CATEGORY] LOADTABLE=FALSE CONDITION=SIM_MANAGER.DEVICES.
Appendix B [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_ip], \ [IM_NAME1], \ [IM_NAME2], \ [IM_PARENT], \ [IM_CATEGORY] COLUMNS=SIM_MANAGER.DEVICES.NAME AS [devices_Name], \ SIM_MANAGER.DEVICEPROTOCOLINFO.PRIMARYADDRESS AS [deviceProtocolInfo_ip] ,\ SIM_MANAGER.DEVICES.PRODUCTTYPESTR AS [devices_ProductTypeStr], \ SIM_MANAGER.DEVICES.PRODUCTSUBTYPE AS [devices_ProductSubType], \ SIM_MANAGER.DEVICES.
Appendix B SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFOEX.DEVICEKEY AND \ SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SIM_MANAGER.DEVICES.DEVICEKEY AND \ SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY AND \ SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFOEX.DEVICEKEY AND \ SIM_MANAGER.DEVICES.PRODUCTTYPESTR='Rack' [IM_ENCLOSURE] SOURCE=SIM_MANAGER.DEVICES, SIM_MANAGER.DB_DEVICEINFOEX, SIM_MANAGER.DB_DEVICEINFO, SIM_MANAGER.
Appendix B SIM_MANAGER.DEVICES.PRODUCTSUBTYPE AS [devices_ProductSubType], \ SIM_MANAGER.DEVICES.SUBTYPE2 AS [devices_SubType2], \ SIM_MANAGER.DEVICES.PRODUCTNAME AS [IM_NAME1], \ SIM_MANAGER.DEVICES.FULLDNSNAME AS [devices_fullDNSName], \ SIM_MANAGER.DEVICES.OVERALLSTATUS AS [devices_OverallStatus], \ SIM_MANAGER.DEVICES.MXGUID AS [devices_MxGUID], \ SIM_MANAGER.DB_DEVICEINFO.LOCATION AS [DB_DeviceInfo_Location], \ SIM_MANAGER.DB_DEVICEINFO.DESCRIPTION AS [DB_DeviceInfo_Description], \ SIM_MANAGER.
Appendix B [devices_ProductSubType], \ [devices_SubType2], \ [devices_fullDNSName], \ [devices_OverallStatus], \ [devices_MxGUID], \ [DB_DeviceInfo_Location], \ [DB_DeviceInfo_Description], \ [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [DB_DeviceInfoEx_ROMVersion], \ [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProto
Appendix B SIM_MANAGER.DB_DEVICEINFOEX.ROMVERSION AS [DB_DeviceInfoEx_ROMVersion], \ SIM_MANAGER.DB_DEVICEINFOEX.OSNAME AS [DB_DeviceInfoEx_OSName], \ SIM_MANAGER.DB_DEVICEINFOEX.OSTYPE AS [DB_DeviceInfoEx_OSType], \ SIM_MANAGER.DB_DEVICEINFOEX.OSVERSION AS [DB_DeviceInfoEx_OSVersion], \ SIM_MANAGER.DB_DEVICEINFOEX.OSVENDOR AS [DB_DeviceInfoEx_OSVendor], \ SIM_MANAGER.DB_DEVICEINFOEX.OSDESCRIPTION AS [DB_DeviceInfoEx_OSDescription], \ SIM_MANAGER.DB_DEVICEINFO.
Appendix B [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_ip], \ [IM_NAME1], \ [IM_NAME2], \ [IM_PARENT], \ [IM_CATEGORY] COLUMNS=SIM_MANAGER.DEVICES.NAME AS [devices_Name], \ SIM_MANAGER.DEVICEPROTOCOLINFO.PRIMARYADDRESS AS [deviceProtocolInfo_ip] ,\ SIM_MANAGER.DEVICES.PRODUCTTYPESTR AS [devices_ProductTypeStr], \ SIM_MANAGER.DEVICES.
Appendix B SIM_MANAGER.DEVICES.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFOEX.DEVICEKEY AND \ SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFOEX.DEVICEKEY AND \ SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SIM_MANAGER.DEVICES.DEVICEKEY AND \ SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY AND \ SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFOEX.DEVICEKEY AND \ SIM_MANAGER.DEVICES.PRODUCTTYPESTR='UPS' --SIM_MANAGER.DEVICES.
Appendix C Appendix C This appendix lists the contents of the Insight Manager Data PostgreSQL Exchange file. The configuration file is provided to export data from the Systems Insight Manager database running on PostgreSQL into an XML file that can be imported into Service Desk. Insight Manager Data PostgreSQL Exchange File PostgreSQL database configuration file. Entries beginning with "--" are comments.
Appendix C [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [DB_DeviceInfoEx_ROMVersion], \ [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_PrimaryAddress], \ [IM_NAME1], \ [IM_NAME2], \ [IM_CATEGORY] COLUMNS=public.devices.name AS [devices_Name], \ public.DEVICEPROTOCOLINFO.
Appendix C LOADTABLE=FALSE CONDITION=public.devices.DeviceKey = public.DB_DeviceInfo.DeviceKey AND \ public.devices.DeviceKey = public.DB_DeviceInfoEx.DeviceKey AND \ public.DB_DeviceInfo.DeviceKey = public.DB_DeviceInfoEx.DeviceKey AND \ public.deviceProtocolInfo.DeviceKey = public.devices.DeviceKey AND \ public.deviceProtocolInfo.DeviceKey = public.DB_DeviceInfo.DeviceKey AND \ public.deviceProtocolInfo.DeviceKey = public.DB_DeviceInfoEx.DeviceKey AND \ public.devices.
Appendix C public.DEVICES.PRODUCTTYPESTR AS [devices_ProductTypeStr], \ public.DEVICES.PRODUCTSUBTYPE AS [devices_ProductSubType], \ public.DEVICES.SUBTYPE2 AS [devices_SubType2], \ public.devices.productname AS [IM_NAME1], \ public.DEVICES.FULLDNSNAME AS [devices_fullDNSName], \ public.DEVICES.OVERALLSTATUS AS [devices_OverallStatus], \ public.DEVICES.MXGUID AS [devices_MxGUID], \ public.DB_DEVICEINFO.LOCATION AS [DB_DeviceInfo_Location], \ public.DB_DEVICEINFO.
Appendix C [devices_OverallStatus], \ [devices_MxGUID], \ [DB_DeviceInfo_Location], \ [DB_DeviceInfo_Description], \ [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [DB_DeviceInfoEx_ROMVersion], \ [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_PrimaryAddress], \ [IM_NAME1], \ [IM_NAME2], \ [IM_CATEGORY] COLUM
Appendix C public.DB_DEVICEINFOEX.OSVENDOR AS [DB_DeviceInfoEx_OSVendor], \ public.DB_DEVICEINFOEX.OSDESCRIPTION AS [DB_DeviceInfoEx_OSDescription], \ public.DB_DEVICEINFO.DESCRIPTION AS [IM_NAME2], \ 'Workstation' AS [IM_CATEGORY] LOADTABLE=FALSE CONDITION=public.devices.DeviceKey = public.DB_DeviceInfo.DeviceKey AND \ public.devices.DeviceKey = public.DB_DeviceInfoEx.DeviceKey AND \ public.DB_DeviceInfo.DeviceKey = public.DB_DeviceInfoEx.DeviceKey AND \ public.deviceProtocolInfo.DeviceKey = public.
Appendix C [IM_CATEGORY] COLUMNS=public.devices.name AS [devices_Name], \ public.DEVICEPROTOCOLINFO.PRIMARYADDRESS AS [deviceProtocolInfo_PrimaryAddress], \ public.DEVICES.PRODUCTTYPESTR AS [devices_ProductTypeStr], \ public.DEVICES.PRODUCTSUBTYPE AS [devices_ProductSubType], \ public.DEVICES.SUBTYPE2 AS [devices_SubType2], \ public.devices.productname AS [IM_NAME1], \ public.DEVICES.FULLDNSNAME AS [devices_fullDNSName], \ public.DEVICES.OVERALLSTATUS AS [devices_OverallStatus], \ public.DEVICES.
Appendix C SOURCE=public.db_deviceinfo, public.db_deviceinfoex, public.devices, public.
Appendix C public.DB_DEVICEINFOEX.ROMVERSION AS [DB_DeviceInfoEx_ROMVersion], \ public.DB_DEVICEINFOEX.OSNAME AS [DB_DeviceInfoEx_OSName], \ public.DB_DEVICEINFOEX.OSTYPE AS [DB_DeviceInfoEx_OSType], \ public.DB_DEVICEINFOEX.OSVERSION AS [DB_DeviceInfoEx_OSVersion], \ public.DB_DEVICEINFOEX.OSVENDOR AS [DB_DeviceInfoEx_OSVendor], \ public.DB_DEVICEINFOEX.OSDESCRIPTION AS [DB_DeviceInfoEx_OSDescription], \ public.DB_DEVICEINFO.
Appendix C [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_PrimaryAddress], \ [IM_NAME1], \ [IM_NAME2], \ [IM_CATEGORY] COLUMNS=public.devices.name AS [devices_Name], \ public.DEVICEPROTOCOLINFO.PRIMARYADDRESS AS [deviceProtocolInfo_PrimaryAddress], \ public.DEVICES.PRODUCTTYPESTR AS [devices_ProductTypeStr], \ public.DEVICES.PRODUCTSUBTYPE AS [devices_ProductSubType], \ public.DEVICES.SUBTYPE2 AS [devices_SubType2], \ public.devices.productname AS [IM_NAME1], \ public.
Appendix C public.devices.ProductSubType='Storage' ORDERBY=public.devices.Name ASC [IM_SWITCH] SOURCE=public.db_deviceinfo, public.db_deviceinfoex, public.devices, public.
Appendix C public.DB_DEVICEINFO.DESCRIPTION AS [DB_DeviceInfo_Description], \ public.DB_DEVICEINFO.CONTACT AS [DB_DeviceInfo_Contact], \ public.DB_DEVICEINFOEX.SERIALNUMBER AS [DB_DeviceInfoEx_SerialNumber], \ public.DB_DEVICEINFOEX.ASSETTAG AS [DB_DeviceInfoEx_AssetTag], \ public.DB_DEVICEINFOEX.TOTALMEMORY AS [DB_DeviceInfoEx_TotalMemory], \ public.DB_DEVICEINFOEX.ROMVERSION AS [DB_DeviceInfoEx_ROMVersion], \ public.DB_DEVICEINFOEX.OSNAME AS [DB_DeviceInfoEx_OSName], \ public.DB_DEVICEINFOEX.
Appendix C [DB_DeviceInfoEx_ROMVersion], \ [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_PrimaryAddress], \ [IM_NAME1], \ [IM_NAME2], \ [IM_CATEGORY] COLUMNS=public.devices.name AS [devices_Name], \ public.DEVICEPROTOCOLINFO.PRIMARYADDRESS AS [deviceProtocolInfo_PrimaryAddress], \ public.DEVICES.PRODUCTTYPESTR AS [devices_ProductTypeStr], \ public.DEVICES.
Appendix C public.DB_DeviceInfo.DeviceKey = public.DB_DeviceInfoEx.DeviceKey AND \ public.deviceProtocolInfo.DeviceKey = public.devices.DeviceKey AND \ public.deviceProtocolInfo.DeviceKey = public.DB_DeviceInfo.DeviceKey AND \ public.deviceProtocolInfo.DeviceKey = public.DB_DeviceInfoEx.DeviceKey AND \ public.devices.ProductTypeStr='Rack' ORDERBY=public.devices.Name ASC [IM_ENCLOSURE] SOURCE=public.db_deviceinfo, public.db_deviceinfoex, public.devices, public.
Appendix C public.DEVICES.FULLDNSNAME AS [devices_fullDNSName], \ public.DEVICES.OVERALLSTATUS AS [devices_OverallStatus], \ public.DEVICES.MXGUID AS [devices_MxGUID], \ public.DB_DEVICEINFO.LOCATION AS [DB_DeviceInfo_Location], \ public.DB_DEVICEINFO.DESCRIPTION AS [DB_DeviceInfo_Description], \ public.DB_DEVICEINFO.CONTACT AS [DB_DeviceInfo_Contact], \ public.DB_DEVICEINFOEX.SERIALNUMBER AS [DB_DeviceInfoEx_SerialNumber], \ public.DB_DEVICEINFOEX.ASSETTAG AS [DB_DeviceInfoEx_AssetTag], \ public.
Appendix C [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [DB_DeviceInfoEx_ROMVersion], \ [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_PrimaryAddress], \ [IM_NAME1], \ [IM_NAME2], \ [IM_CATEGORY] COLUMNS=public.devices.name AS [devices_Name], \ public.DEVICEPROTOCOLINFO.
Appendix C LOADTABLE=FALSE CONDITION=public.devices.DeviceKey = public.DB_DeviceInfo.DeviceKey AND \ public.devices.DeviceKey = public.DB_DeviceInfoEx.DeviceKey AND \ public.DB_DeviceInfo.DeviceKey = public.DB_DeviceInfoEx.DeviceKey AND \ public.deviceProtocolInfo.DeviceKey = public.devices.DeviceKey AND \ public.deviceProtocolInfo.DeviceKey = public.DB_DeviceInfo.DeviceKey AND \ public.deviceProtocolInfo.DeviceKey = public.DB_DeviceInfoEx.DeviceKey AND \ public.devices.
Appendix C public.DEVICES.PRODUCTTYPESTR AS [devices_ProductTypeStr], \ public.DEVICES.PRODUCTSUBTYPE AS [devices_ProductSubType], \ public.DEVICES.SUBTYPE2 AS [devices_SubType2], \ public.devices.productname AS [IM_NAME1], \ public.DEVICES.FULLDNSNAME AS [devices_fullDNSName], \ public.DEVICES.OVERALLSTATUS AS [devices_OverallStatus], \ public.DEVICES.MXGUID AS [devices_MxGUID], \ public.DB_DEVICEINFO.LOCATION AS [DB_DeviceInfo_Location], \ public.DB_DEVICEINFO.
Appendix D Appendix D Servicedesk.xml File --> --> Monitoring Tool Display the Service Desk web page.
Appendix E Appendix E Ovwebconsole.xml File --> --> --> Monitoring Tool Display the Service Desk web page.
Appendix F Appendix F Additional Information HP ProLiant Essentials Management Software website: http://www.hp.com/servers/manage HP Management Integration Solutions website: http://www.hp.com/servers/integration HP Enterprise Management Software website: http://managementsoftware.hp.com HP Management Software Technical Support: http://support.openview.hp.
Index Index A ACES_InsightManager.xml, 5, 7; troubleshooting, 49 Action on Event, 32; creating, 25 C CI. See Configuration Item category cleared events query, 31 configuration, 5, 10 Configuration Item category, 17; creating, 18 configurations, 6 creating: Action on Event, 25, 32; custom command, 21; custom command in HP SIM 5.0, 30; custom tool, 24; custom tool in HP SIM 5.