Connect your Asset Management tool to your JIRA Help Desk with nFeed


Posted by
Jérémie MARTINEZ

February 3, 2015

Asset Management software has now become key to organisations of all sizes. Despite their performance however it is common that these applications do not always fully integrate to a company’s Information System. For this reason, when one of your internal stakeholders is calling you through Help Desk, you often have to manually look for information in your Asset Management tool. Plus, you may require further information from your stakeholder such as Machine Number, Machine ID etc., which is, let’s face it, quite tedious and can increase your chance of mistakes.

To reduce the occurrence of the above example and increase efficiency thus saving everyone’s time, I’m pleased to suggest a method where you connect your Asset Management tool (GLPI in our example) to your JIRA Help Desk thanks to nFeed.

Connect GLPI and JIRA in 4 steps

In the following example, the goal is to get the end-user machine number and regenerate the URL which will enable you to directly access the GLPI page.

We will use two fields for this: “Machine Number” which will display the end-user machine’s ID and “Machine Information” which will display a link to the related machine page in GLPI.

Prerequisite: your asset management system should have its database accessible by JIRA.

Step 1: Declare your external database

Declare your external base in the .xml server file located in the conf Tomcat directory hosting your JIRA.

In the “context” tag, add:

<Resource name="jdbc/GLPI" auth="Container" type="javax.sql.DataSource"

username="XXX"

password="XXX"

driverClassName="

<Driver BDD>" url="jdbc:<TypdeBDD>:<URLdeBDD>"/>

Once this is done, restart your JIRA.

You will then need to add this external base in your nFeed configuration.

To do so, reach “Datasources connectors” tab and click on “Add Datasource Connector”.

Blog-01

Step 2: Create a custom field

From your JIRA admin console:

  • Create “Machine Number” custom field as an nFeed type field so that the machine number can be displayed
  • Create “Machine Information” custom field as an nFeed type so that the machine URL can be displayed in GLPI

Step 3: Configure fields in nFeed

In the nFeed configuration panel, click “Configuration” tab and then “Create a configuration” button for you to access nFeed fields that haven’t been configured as yet.

“Machine Number” field configuration

You would first select GLPI data source in the first tab and then choose the display mode in the second tab (read only in this example).

Blog-02

Type the following request in the “query” field: we want to get the GLPI machine number linking to the stakeholder reporting the query (or the one of the current machine user if the previous field is blank).

 #if ($issue.reporter and $issue.reporter != '')

SELECT c.name

FROM glpi.glpi_computers as c, glpi.glpi_users as u

WHERE u.id = c.users_id AND u.name like '$issue.reporter'

#else

SELECT c.name

FROM glpi.glpi_computers as c, glpi.glpi_users as u

WHERE u.id = c.users_id

AND u.name like '$currentUser'

#end

The column 0 will be stored as a key and will be displayed in the related page.

“Machine Information” field configuration

You will first select GLPI data source in the first tab and then choose the display mode in the second tab (read only in this example).

Blog-03

Type the following request in the “query” field: we want to get the GLPI machine ID for the user reporting the query.

#if ($issue.reporter and $issue.reporter != '')

SELECT c.id

FROM glpi.glpi_computers as c, glpi.glpi_users as u

WHERE u.id = c.users_id

AND u.name like '$issue.reporter'

#else

SELECT c.id

FROM glpi.glpi_computers as c, glpi.glpi_users as u

WHERE u.id = c.users_id

AND u.name like '$currentUser'

#end

The column 0 will be stored as a key and will be displayed in the related page.

For you to display the ID as a link to GLPI, you need to configure the display mode.

To do so, click “Configure”:

Blog-04

Then type the start of the GLPI URL, the end of the URL will be suggested thanks to the ID of the end-user machine:

Example:

<a href="https://glpi-test/{0}">https://glpi-test/{0}</a>

Do this operation again for the “Field Display” tab:

Blog-05

Step 4: Display your field

The field should then be seen on your screen. Once the field is displayed, you will have the GLPI data which will be displayed dynamically in your JIRA Help Desk.

Creation mode:

Blog-06

Visualisation mode:

Blog-07

The user will be redirected to GLPI when clicking the link, how amazing!

Blog-08

Your JIRA and GLPI are now fully integrated!

Now you know how powerful nFeed is by integrating your Help Desk with your Asset Management tool. It will create ease and efficiency for your stakeholders to report queries whilst ensuring a better data integration between your two systems.

Is this what you have been looking for?