HPSIM 5 integrate with HP Service Desk 4.5

[orven]

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

[David Claypool]

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]

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