About this integration
You can integrate third-party systems with Service Manager in many ways. The method you select will depend on business requirements, architectural and security constraints as well as the characteristics specific to each third-party application or service.
This document describes an integration process that has already been implemented in a customer context.
To find out more about this integration (e.g. scripts to be used), please do not hesitate to contact your EasyVista contact, or your service provider and integrator.
Integration summary
This integration is used to integrate the GLPI Equipment/Software/Attribute tables in the Service Manager equipment/software catalogs.
- The gateway is automatically managed through the creation and update of catalog entries that indicate the GLPI data to be extracted and normalized, if required.
- GLPI and Service Manager tables are mapped using two unique IDs:
- Manufacturer/Model for equipment
- Software for software
GLPI gateway processes are used to synchronize Service Manager catalogs with third-party inventory tools using only the desired references based on the corporate strategy adopted. The catalogs must then be updated daily to integrate new GLPI references.
Supported Versions
GLPI V0.80 |
GLPI V0.83 |
GLPI V0.84 |
GLPI V0.85 |
GLPI V0.90 |
GLPI V9.1 |
 |
 |
 |
 |
 |
 |
Operating principle

The process is made up of 3 phases:
- Enter the equipment/software catalog entries for GLPI references to be monitored in Service Manager.
- Run a preimport task using the smoBackOfficeClient tool to:
- Extract and store information from GLPI tables in Service Manager work tables by using a filter to retrieve only the data corresponding to the catalog entries to be monitored in Service Manager.
- Normalize data by grouping GLPI names together.
- Run various processing to normalize and standardize data.
- Store all data in the final Service Manager tables.
- Integrate data in the final Service Manager tables using Equipment/Software/Attribute integration models.
Example
- GLPI software table:
The third-party inventory tool detects three versions of FastStone, resulting in three records in the GLPI table: FastStone 5.1, FastStone 5.5, FastStone 6.1.
- Service Manager software catalog: different options are possible:
- You can create a single catalog entry that groups together the three GLPI names, FastStone.
- You can create one catalog entry for each major version, FastStone 5, FastStone 6.
- You can create one catalog entry for each version, FastStone 5.1, FastStone 5.5, FastStone 6.1.
Notes
- The following data is not automatically processed by the GLPI gateway:
- Allocation of users to workstations: third-party data is loaded to user-defined fields containing information in Service Manager Equipment forms.
- Allocation of locations and departments to workstations: not loaded by the GLPI gateway.
- Management of software licenses: not performed by the GLPI gateway.
- Management of the status of Equipment/Software forms: not performed by the GLPI gateway.
- Service Manager Equipment/Software/Attribute integration models are shipped with the GLPI gateway. Only those that are enabled at integration are taken into account.
- For SaaS customers, GLPI tables are read using a VPN connection to ensure restricted and encrypted access to data.
- Depending on the type of third-party database, GLPI data may be case-sensitive.
See How to choose the best tool for automating integration.
Best Practice
- To ensure optimal performance of the Service Manager platform, you should integrate only data that is new or modified since the previous processing.
GLPI gateway rules
- The GLPI Reference field of each equipment/software catalog entry is used to indicate the GLPI data to be extracted and filtered, and if required, to group GLPI names together. It must comply with certain rules:
- GLPI references must be separated using the sequence of characters /+-+/
- The joker % can replace any string of characters
- Rules for equipment: GLPI and Service Manager are mapped using the Manufacturer/Model unique ID.
- Rules for software: GLPI and Service Manager are mapped using the Software unique ID.
- Rules for attributes: The GLPI table is integrated as it is in Service Manager, without normalization.
Procedure: How to monitor GLPI references in catalogs
1. In Service Manager, create or modify the equipment/software catalog entries you want to monitor.
- Enter the unique ID of the catalog entry:
- For equipment, enter the fields outlined in red, Model and Manufacturer.

- For software, enter the field outlined in red, Software.

- In the field outlined in blue, GLPI Reference, indicate the GLPI names to be monitored via the catalog entry.
See normalization examples.- Separate each reference using the sequence of characters /+-+/
- Use the joker % to replace any string of characters
2. In the menu, select Integration > Integration Models. Enable and schedule the Equipment/Software/Attribute integration models for the data you want to integrate in Service Manager.
Caneco references in the {third-party} table |
Caneco BT 4.1 (EN)
Caneco BT 4.1.4 (FR)
Caneco BT 4.1.6 (FR)
Caneco BT 4.2 (FR)
Caneco BT 4.3 (EN)
Caneco BT 4.3 (FR)
Caneco BT 5.1 (EN)
Caneco BT 5.1 (FR)
Caneco BT 5.5 (EN)
Caneco BT 5.5 (FR)
|
|
How to monitor Caneco software in Service Manager |
|
To monitor... |
In the catalog, create... |
In the Software field, enter... |
In the {third-party} Reference field, enter... |
Grouping performed |
For all versions and languages |
A single entry |
Caneco BT |
Caneco BT |
Caneco BT |
|
By major version |
One entry for each major version |
Caneco BT 4 |
Caneco BT 4% |
All versions 4* =
4.1 (EN), 4.1.4 (FR), 4.1.6 (FR), 4.2 (FR), 4.3 (EN), 4.3 (FR)
|
Caneco BT 5 |
Caneco BT 5% |
All versions 5* =
5.1 (EN), 5.1 (FR), 5.5 (EN), 5.5 (FR)
|
|
By language |
One entry for each language |
Caneco BT (EN) |
Caneco BT%(EN) |
All EN versions =
4.1 (EN), 4.3 (EN), 5.1 (EN), 5.5 (EN)
|
Caneco BT (FR) |
Caneco BT%(FR) |
All FR versions =
4.1.4 (FR), 4.1.6 (FR), 4.2 (FR), 4.3 (FR), 5.1 (FR), 5.5 (FR)
|
|
Caneco references in the {third-party} table |
Caneco Design 2013
Caneco Design 4.4
Caneco HT 1.2
Caneco HT 2.0
Caneco HT 2.5
Caneco HT 2013
Caneco Implantation 2.3
Caneco Implantation 2010
Caneco Implantation
Caneco Implantation 2011
Caneco Implantation 2013
Caneco Implantation V2.4.0
Caneco Implantation V2.5.1
Caneco Implantation V2.5.2 Beta
Caneco EP 3.2
Caneco EP 3.3
Caneco EP 2013
|
|
How to monitor Caneco software in Service Manager |
|
To monitor... |
In the catalog, create... |
In the Software field, enter... |
In the {third-party} Reference field, enter... |
Grouping performed |
For all versions and languages |
A single entry |
Caneco |
Caneco%Design%/+-+/Caneco%Implantation%/+-+/Caneco%HT%/+-+/Caneco%EP% |
All Caneco Design, Caneco Implantation, Caneco HT, Caneco EP products |
|
By product |
One entry for each product |
Caneco Design |
Caneco%Design% |
All Caneco Design products, regardless of year or version |
Caneco Implantation |
Caneco%Implantation% |
All Caneco Implantation products, regardless of year or version |
Caneco HT |
Caneco%HT% |
All Caneco HT products, regardless of year or version |
Caneco EP |
Caneco%EP% |
All Caneco EP products, regardless of year or version |
|
By year |
One entry for each year |
Caneco 2010 |
Caneco%2010 |
Year 2010 =
Caneco Implantation 2010
|
Caneco 2011 |
Caneco%2011 |
Year 2011 =
Caneco Implantation 2011
|
Caneco 2013 |
Caneco%2013 |
Year 2013 =
Caneco Design 2013, Caneco HT 2013, Caneco Implantation 2013, Caneco EP 2013
Warning: In this case, {third-party} references by version will be ignored in Service Manager: Caneco Design 4.4, V2.4.1 - Caneco HT 1.2, 2.0, 2.5 - Caneco Implantation 2.3, V2.4.0, V2.5.1, V2.5.2 Beta - CanecoEP 3.2, 3.3
|
|
Caneco references in the {third-party} table |
Caneco Design
Caneco Design Module
CanecoDesign
Caneco Des
Caneco EP
Caneco HT
Caneco Module Design
Design Caneco
Adobe Module Design
Design Adobe Creative
|
|
How to monitor Caneco software in Service Manager |
|
To monitor... |
In the catalog, create... |
In the Software field, enter... |
In the {third-party} Reference field, enter... |
Grouping performed |
All names |
A single entry |
Caneco Design |
Caneco%Des%/+-+/Design Caneco |
All Caneco Design products |
Warning |
%Design% |
All Caneco Design products
But also: Adobe Module Design - Design Adobe Creative
|
Caneco Design |
All Caneco Design products
But not: Caneco Design Module - CanecoDesign - Caneco Module Design - Design Caneco
|
Caneco Design% |
All Caneco Design products
But not: CanecoDesign - Caneco Module Design - Design Caneco
|
|
Mapping GLPI tables and catalogs
Equipment
GLPI |
|
Service Manager |
Equipment table |
|
EZV_ASSET table |
|
Views: Column |
glpi_computers.Name |
|
ID |
|
ID |
glpi_computers.Serial |
|
SerialNumber |
|
SerialNumber |
glpi_computers.date_mod |
|
LastScanDate |
|
LastScanDate |
glpi_computertypes.name |
|
Category |
|
LanCatalog |
glpi_manufacturers.name |
|
Manufacturer |
|
Manufacturer |
glpi_computermodels.name |
|
Model |
|
Model |
glpi_users.name |
|
LoginName |
|
LoginName |
glpi_locations.name |
|
ComputerLocation |
|
ComputerLocation |
Software
GLPI |
|
Service Manager |
Software table |
|
EZV_SOFTWARE table |
|
Views: Column |
glpi_computers.Name |
|
ID |
|
ID |
glpi_softwares.Name |
|
SuiteName |
|
SuiteName |
glpi_softwareversions.Name |
|
Version |
|
Version |
glpi_manufacturers.Name |
|
Publisher |
|
Publisher |
Attribute tables
GLPI |
|
Service Manager |
Attribute tables |
|
EZV_CHARACTERISTIC table |
|
Views: Column / Name |
glpi_computermodels.Name |
|
ID |
|
ID / |
glpi_computerdisks.Count(*) |
|
Characteristic |
|
Characteristic / Disk Qty |
LogicalDrives.StorageTotal |
|
Characteristic |
|
Characteristic / Disk Size |
glpi_computers.glpi_computers*100 |
|
Characteristic |
|
Characteristic / Espace Disk Available |
glpi_deviceprocessors.designation |
|
Characteristic |
|
Characteristic / CPU Type |
glpi_deviceprocessors.specificity |
|
Characteristic |
|
Characteristic / CPU Frequency |
glpi_computers_devicememories.specificity |
|
Characteristic |
|
Characteristic / Total Memory |
glpi_computers.Serial |
|
Characteristic |
|
Characteristic / Machine Serial Number |
glpi_computertypes.name |
|
Characteristic |
|
Characteristic / Hardware Type |
glpi_manufacturers.name |
|
Characteristic |
|
Characteristic / Hardware Brand |
glpi_computermodels.name |
|
Characteristic |
|
Characteristic / Hardware Model |
|
|
Unit |
|
Unit / Go,Mhz, -, |