Hp Systems Insight Manager User Manual

HP OpenView Service Desk and HP Systems Insight Manager Integration User Guide Reference number: 449791-001 First edition: March 2007

Importing items as Service Desk configuration items from the HP SIM database 10 Table 2 Default Insight Manager Template Values Property Valu

Appendix C 100 public.devices.ProductSubType='Storage' ORDERBY=public.devices.Name ASC [IM_SWITCH] SOURCE=public.db_deviceinfo, p

Appendix C 101 public.DB_DEVICEINFO.DESCRIPTION AS [DB_DeviceInfo_Description], \ public.DB_DEVICEINFO.CONTACT AS [DB_DeviceInfo_Contact], \

Appendix C 102 [DB_DeviceInfoEx_ROMVersion], \ [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_Dev

Appendix C 103 public.DB_DeviceInfo.DeviceKey = public.DB_DeviceInfoEx.DeviceKey AND \ public.deviceProtocolInfo.DeviceKey = public.devices.D

Appendix C 104 public.DEVICES.FULLDNSNAME AS [devices_fullDNSName], \ public.DEVICES.OVERALLSTATUS AS [devices_OverallStatus], \ public.DEVIC

Appendix C 105 [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [D

Appendix C 106 LOADTABLE=FALSE CONDITION=public.devices.DeviceKey = public.DB_DeviceInfo.DeviceKey AND \ public.devices.DeviceKey = public.D

Appendix C 107 public.DEVICES.PRODUCTTYPESTR AS [devices_ProductTypeStr], \ public.DEVICES.PRODUCTSUBTYPE AS [devices_ProductSubType], \ publ

Appendix D 108 Appendix D Servicedesk.xml File <?xml version="1.0" encoding="UTF-8"?> <!--

Appendix E 109 Appendix E Ovwebconsole.xml File <?xml version="1.0" encoding="UTF-8"?> <!--

Importing items as Service Desk configuration items from the HP SIM database 11 Creating a Data Source for Systems Insight Manager using an S

Appendix F 110 Appendix F Additional Information HP ProLiant Essentials Management Software website: http://www.hp.com/servers/manage HP Man

Index 111 Index A ACES_InsightManager.xml, 5, 7; troubleshooting, 49 Action on Event, 32; creating, 25 C CI. See Configuration Item category

Importing items as Service Desk configuration items from the HP SIM database 12 Before performing these steps, the PostgreSQL ODBC driver sho

Importing items as Service Desk configuration items from the HP SIM database 13 Figure 4 PostgreSQL ODBC Advanced Options window. Creating

Importing items as Service Desk configuration items from the HP SIM database 14 Figure 5 Import Mapping Window Table 3 Import Mapping Prope

Importing items as Service Desk configuration items from the HP SIM database 15 Figure 6 Default Insight Manager Import Mapping Creating an

Importing items as Service Desk configuration items from the HP SIM database 16 9. Enter the account password. 10. Select Insight Manager a

Importing items as Service Desk configuration items from the HP SIM database 17 warning: Attribute not defined: DB_DEVICEINFOEX_ASSETTAG on e

Importing items as Service Desk configuration items from the HP SIM database 18 By default, the configuration file imports all devices with t

Automatic incident creation from HP SIM events 19 Automatic incident creation from HP SIM events The program hpsimsde.exe automatically parse

Legal notices © Copyright 2005-2007 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP required

Automatic incident creation from HP SIM events 20 Figure 10 Executing the hpsimsde_test script to verify communication between SIM and Servic

Automatic incident creation from HP SIM events 21 Figure 11 Test Incident created by running the hpsimsde_test script. Creating a custom com

Automatic incident creation from HP SIM events 22 5. In the Command field, enter the full path to the hpsimsde executable, for example: c:\p

Automatic incident creation from HP SIM events 23 Figure 13 Service Desk Event files installed on the HP SIM server running on HP-UX Figure

Automatic incident creation from HP SIM events 24 Creating a custom tool in HP SIM 5.1 In HP SIM version 5.1, the custom commands menu has be

Automatic incident creation from HP SIM events 25 The new custom tool displays at the defined menu location. Additionally, the custom tool de

Automatic incident creation from HP SIM events 26 Figure 17 Task Results for event forwarded to Service Desk

Automatic incident creation from HP SIM events 27 Figure 18 Incident Received from Systems Insight Manager Adding other fields to the Exter

Automatic incident creation from HP SIM events 28 Creating Incidents from Storage Essentials Events Incidents in Service Desk can be generate

Automatic incident creation from HP SIM events 29 Figure 20 Storage Essentials Incident Details

Contents 3 Contents Introduction Supported Configurations ...

Automatic incident closing from HP SIM 30 Automatic incident closing from HP SIM The program hpsimsde.exe automatically parses the environmen

Automatic incident closing from HP SIM 31 7. Specify the user account that will be used to run the custom tool. 8. Set the number of target

Automatic incident closing from HP SIM 32 Creating an “Action on Event” in HP SIM The user configures what HP SIM events should be closed in

Launching HP SIM and other Management Applications from Service Desk 33 Launching HP SIM and other Management Applications from Service Desk

Creating Smart Actions for HP SIM and the Insight Management Agents in Service Desk 34 Creating Smart Actions for HP SIM and the Insight Mana

Creating Smart Actions for HP SIM and the Insight Management Agents in Service Desk 35 Defining a Smart Action for the in-context launch of

Creating Smart Actions for HP SIM and the Insight Management Agents in Service Desk 36 Defining a Smart Action for the HP Integrated Lights

Creating Smart Actions for HP SIM and the Insight Management Agents in Service Desk 37 Figure 26 Smart Actions defined for the Incident view.

Service Desk Service Pages 38 Service Desk Service Pages Updating Systems Insight Manager to Discover the Service Desk Web Interface Through

Service Desk Service Pages 39 Adding Service Pages Tools Menu Entry Adding this tool definition will allow the user to launch to the OpenVi

Contents 4 Adding OpenView Web Console Tools Menu ... 46

Service Desk Service Pages 40 Viewing Incidents in Service Pages Modifying the Services Pages settings may be necessary to display the Inci

Service Desk Service Pages 41

Service Desk Service Pages 42 Figure 30 Service Pages Specific Incident created by Systems Insight Manager

Scheduling the HP SIM Data Exchange 43 Scheduling the HP SIM Data Exchange OpenView Service Desk provides command line utilities for various

Scheduling the HP SIM Data Exchange 44 The user must copy hpsimexchange.bat to the same location as sd_exchange.bat, and then edit the file

Scheduling the HP SIM Data Exchange 45 5. Enter a time for the task to execute, and then click Next. Figure 34 Scheduled Task Wizard time an

HP OpenView Web Console 46 HP OpenView Web Console Updating Systems Insight Manager to Discover the OpenView Web Console Through the Links ta

HP OpenView Web Console 47 Figure 36 OpenView Web Console Displaying Configuration Items Launching to the HP Systems Management Homepage If

HP OpenView Web Console 48 Figure 37 OpenView Web Console Incident Pop-up Actions

Troubleshooting 49 Troubleshooting Task Results error Description: When viewing the task results, the following message is displayed in the H

Introduction 5 Introduction Enterprise IT managers are responsible for delivering and maintaining the infrastructure and services that enable

Appendix A 50 Appendix A This appendix lists the contents of the Insight Manager SQL Data Exchange file. The configuration file is provided t

Appendix A 51 [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [DB_DeviceInfoEx_ROMVersion],

Appendix A 52 CAST ([DB_DeviceInfoEx].[OSDescription] AS VARCHAR) + ' - ' + \ CAST ([DB_DeviceInfo].[Description] AS VARCHAR) + &ap

Appendix A 53 [IM_CATEGORY] COLUMNS=[devices].[Name] AS [devices_Name], \ CAST ([deviceProtocolInfo].[PrimaryAddress] AS VARCHAR) AS [device

Appendix A 54 [devices].[ProductTypeStr]='Desktop' ORDERBY=[devices].[Name] ASC LOADTABLE=FALSE [IM_WORKSTATION] SOURCE=[DB_Devi

Appendix A 55 CAST ([DB_DeviceInfo].[Contact] AS VARCHAR) AS [DB_DeviceInfo_Contact], \ CAST ([DB_DeviceInfoEx].[SerialNumber] AS VARCHAR) AS

Appendix A 56 [devices_MxGUID], \ [DB_DeviceInfo_Location], \ [DB_DeviceInfo_Description], \ [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_Seri

Appendix A 57 CAST ([DB_DeviceInfoEx].[OSVendor] AS VARCHAR) AS [DB_DeviceInfoEx_OSVendor], \ CAST ([DB_DeviceInfoEx].[OSDescription] AS VARC

Appendix A 58 [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_PrimaryAddress], \ [IM_NAME1], \ [IM_NAME2

Appendix A 59 [devices].[DeviceKey] = [DB_DeviceInfoEx].[DeviceKey] AND \ [DB_DeviceInfo].[DeviceKey] = [DB_DeviceInfoEx].[DeviceKey] AND \ [

Introduction 6 • ovwebconsole.xml – tool definition file to add a launch to the HP OpenView Service Desk Web Console from Systems Insight Ma

Appendix A 60 CAST ([devices].[ProductName] AS VARCHAR) AS [IM_NAME1], \ [devices].[fullDNSName] AS [devices_fullDNSName], \ [devices].[Overa

Appendix A 61 [IM_SWITCH] SOURCE=[DB_DeviceInfo], [DB_DeviceInfoEx], [devices], [deviceProtocolInfo] ATT=[devices_Name], \ [devices_ProductT

Appendix A 62 CAST ([DB_DeviceInfoEx].[AssetTag] AS VARCHAR) AS [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx].[TotalMemory] AS [DB_DeviceIn

Appendix A 63 [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [DB

Appendix A 64 CAST ([DB_DeviceInfoEx].[OSName] AS VARCHAR) + ' - ' + \ CAST ([DB_DeviceInfoEx].[OSDescription] AS VARCHAR) + '

Appendix A 65 [IM_NAME1], \ [IM_NAME2], \ [IM_CATEGORY] COLUMNS=[devices].[Name] AS [devices_Name], \ CAST ([deviceProtocolInfo].[PrimaryAdd

Appendix A 66 [deviceProtocolInfo].[DeviceKey] = [DB_DeviceInfo].[DeviceKey] AND \ [deviceProtocolInfo].[DeviceKey] = [DB_DeviceInfoEx].[Devi

Appendix A 67 [devices].[MxGUID] AS [devices_MxGUID], \ CAST ([DB_DeviceInfo].[Location] AS VARCHAR) AS [DB_DeviceInfo_Location], \ CAST ([DB

Appendix A 68 ATT=[devices_Name], \ [devices_ProductTypeStr], \ [devices_FullDNSName], \ [devices_OverallStatus], \ [devices_MxGUID], \ [DB_D

Appendix A 69 CAST ([DB_DeviceInfoEx].[OSName] AS VARCHAR) AS [DB_DeviceInfoEx_OSName], \ CAST ([DB_DeviceInfoEx].[OSType] AS VARCHAR) AS [DB

ACES XML Import 7 ACES XML Import A predefined XML file provided in association with this guide automatically defines several default values

Appendix B 70 Appendix B This appendix lists the contents of the Insight Manager Oracle Data Exchange file. The configuration file is provide

Appendix B 71 [devices_MxGUID], \ [DB_DeviceInfo_Location], \ [DB_DeviceInfo_Description], \ [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_Seri

Appendix B 72 SIM_MANAGER.DB_DEVICEINFOEX.OSVENDOR AS [DB_DeviceInfoEx_OSVendor], \ SIM_MANAGER.DB_DEVICEINFOEX.OSDESCRIPTION AS [DB_DeviceIn

Appendix B 73 [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_ip], \ [IM_NAME1], \ [IM_NAME2], \ [IM_PARENT], \ [IM_CATEGORY] COLUMNS

Appendix B 74 SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY AND \ SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY =

Appendix B 75 SIM_MANAGER.DEVICES.FULLDNSNAME AS [devices_fullDNSName], \ SIM_MANAGER.DEVICES.OVERALLSTATUS AS [devices_OverallStatus], \ SIM

Appendix B 76 [devices_OverallStatus], \ [devices_MxGUID], \ [DB_DeviceInfo_Location], \ [DB_DeviceInfo_Description], \ [DB_DeviceInfo_Contac

Appendix B 77 SIM_MANAGER.DB_DEVICEINFOEX.OSVERSION AS [DB_DeviceInfoEx_OSVersion], \ SIM_MANAGER.DB_DEVICEINFOEX.OSVENDOR AS [DB_DeviceInfoE

Appendix B 78 [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_ip], \ [IM_NAME1], \ [IM_NAME2], \ [IM_PAR

Appendix B 79 SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SIM_MANAGER.DEVICES.DEVICEKEY AND \ SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SIM_M

ACES XML Import 8 Figure 1 ACES Import Selection Window The items automatically imported by the ACES_InsightManager.xml file can also be cr

Appendix B 80 SIM_MANAGER.DEVICES.SUBTYPE2 AS [devices_SubType2], \ SIM_MANAGER.DEVICES.PRODUCTNAME AS [IM_NAME1], \ SIM_MANAGER.DEVICES.FULL

Appendix B 81 [devices_SubType2], \ [devices_fullDNSName], \ [devices_OverallStatus], \ [devices_MxGUID], \ [DB_DeviceInfo_Location], \ [DB_D

Appendix B 82 SIM_MANAGER.DB_DEVICEINFOEX.OSNAME AS [DB_DeviceInfoEx_OSName], \ SIM_MANAGER.DB_DEVICEINFOEX.OSTYPE AS [DB_DeviceInfoEx_OSType

Appendix B 83 [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [de

Appendix B 84 SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFOEX.DEVICEKEY AND \ SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SI

Appendix B 85 SIM_MANAGER.DEVICES.PRODUCTSUBTYPE AS [devices_ProductSubType], \ SIM_MANAGER.DEVICES.SUBTYPE2 AS [devices_SubType2], \ SIM_MAN

Appendix B 86 [devices_ProductSubType], \ [devices_SubType2], \ [devices_fullDNSName], \ [devices_OverallStatus], \ [devices_MxGUID], \ [DB_D

Appendix B 87 SIM_MANAGER.DB_DEVICEINFOEX.ROMVERSION AS [DB_DeviceInfoEx_ROMVersion], \ SIM_MANAGER.DB_DEVICEINFOEX.OSNAME AS [DB_DeviceInfoE

Appendix B 88 [DB_DeviceInfoEx_OSName], \ [DB_DeviceInfoEx_OSType], \ [DB_DeviceInfoEx_OSVersion], \ [DB_DeviceInfoEx_OSVendor], \ [DB_Device

Appendix B 89 SIM_MANAGER.DEVICES.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFOEX.DEVICEKEY AND \ SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY = SIM_MANAGER.D

Importing items as Service Desk configuration items from the HP SIM database 9 Importing items as Service Desk configuration items from the H

Appendix C 90 Appendix C This appendix lists the contents of the Insight Manager Data PostgreSQL Exchange file. The configuration file is pro

Appendix C 91 [DB_DeviceInfo_Contact], \ [DB_DeviceInfoEx_SerialNumber], \ [DB_DeviceInfoEx_AssetTag], \ [DB_DeviceInfoEx_TotalMemory], \ [DB

Appendix C 92 LOADTABLE=FALSE CONDITION=public.devices.DeviceKey = public.DB_DeviceInfo.DeviceKey AND \ public.devices.DeviceKey = public.DB

Appendix C 93 public.DEVICES.PRODUCTTYPESTR AS [devices_ProductTypeStr], \ public.DEVICES.PRODUCTSUBTYPE AS [devices_ProductSubType], \ publi

Appendix C 94 [devices_OverallStatus], \ [devices_MxGUID], \ [DB_DeviceInfo_Location], \ [DB_DeviceInfo_Description], \ [DB_DeviceInfo_Contac

Appendix C 95 public.DB_DEVICEINFOEX.OSVENDOR AS [DB_DeviceInfoEx_OSVendor], \ public.DB_DEVICEINFOEX.OSDESCRIPTION AS [DB_DeviceInfoEx_OSDes

Appendix C 96 [IM_CATEGORY] COLUMNS=public.devices.name AS [devices_Name], \ public.DEVICEPROTOCOLINFO.PRIMARYADDRESS AS [deviceProtocolInfo

Appendix C 97 SOURCE=public.db_deviceinfo, public.db_deviceinfoex, public.devices, public.deviceprotocolinfo ATT=[devices_Name], \ [devices_P

Appendix C 98 public.DB_DEVICEINFOEX.ROMVERSION AS [DB_DeviceInfoEx_ROMVersion], \ public.DB_DEVICEINFOEX.OSNAME AS [DB_DeviceInfoEx_OSName],

Appendix C 99 [DB_DeviceInfoEx_OSVendor], \ [DB_DeviceInfoEx_OSDescription], \ [deviceProtocolInfo_PrimaryAddress], \ [IM_NAME1], \ [IM_NAME2