Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

HPSIM 5 integrate with HP Service Desk 4.5

orven
Frequent Advisor

HPSIM 5 integrate with HP Service Desk 4.5

Is there a way to integrate this two Systems?

Like we have 200 Servers and we want those Servers detected by HPSIM to create corresping Configuration Item in HPService Desk.
Just need an idea here
thanks
2 REPLIES
David Claypool
Honored Contributor

Re: HPSIM 5 integrate with HP Service Desk 4.5

There's no direct link between the two. If you are using OpenView Operations, you can use it as the go-between.
Abd El Moniem Darwish
Occasional Visitor

Re: HPSIM 5 integrate with HP Service Desk 4.5

Dear orven,
you can make data exchange between SD and SIM.
I am attaching the sample ini file from Hp sim integration documentation

Regards,
Abd El Moniem Darwish

-- SQL database configuration file.
--
-- Entries beginning with "--" are comments.
-- Several device types are included in this file, but only one
-- can be active at a time. To import different types of devices,
-- comment out the current device type and uncomment the device
-- type you wish to import.
--
[DSN]
NAME=HPSIM-APPIQ
USR=system
PWD=manager
[SYSTEM]
LOG=TRUE
XML=TRUE
DUMP=TRUE
TXT=FALSE
LOG_FILE=C:\Program Files\Hewlett-Packard\OpenView\service desk
4.5\client\data_exchange\log\insightmanager.log
XML_OUTPUT_FILE=C:\Program Files\Hewlett-Packard\OpenView\service desk
4.5\client\data_exchange\xml\insightmanager.xml
APPLICATION_NAME=INSIGHTMANAGER
[CLASSES]
NAME=INSIGHTMANAGER
[INSIGHTMANAGER]
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_OSVersion], \
[DB_DeviceInfoEx_OSVendor], \
[DB_DeviceInfoEx_OSDescription], \
[deviceProtocolInfo_PrimaryAddress], \
[IM_NAME1], \
[IM_NAME2], \
32
[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].[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].[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].[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].[Contact] AS VARCHAR) AS [IM_NAME2], \
'Server' AS [IM_CATEGORY]
--'Switch' AS [IM_CATEGORY]
--'Storage' AS [IM_CATEGORY]
--'Workstation' AS [IM_CATEGORY]
--'MgmtProc' AS [IM_CATEGORY]
--'Desktop' AS [IM_CATEGORY]
--'Printer' AS [IM_CATEGORY]
--'Storage' AS [IM_CATEGORY]
LOADTABLE=FALSE
CONDITION=[devices].[DeviceKey] = [DB_DeviceInfo].[DeviceKey] AND \
[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]='Server'
--[devices].[ProductTypeStr]='Switch'
--[devices].[ProductSubType]='Storage'
--[devices].[ProductTypeStr]='Workstation'
--[devices].[ProductTypeStr]='MgmtProc'
--[devices].[ProductTypeStr]='Desktop'
--[devices].[ProductTypeStr]='Printer'
--[devices].[ProductSubType]='StorageEssentials'
ORDERBY=[devices].[Name] ASC