Can some one guide me with Service-Now integration with Landesk to populate cmdb.

bipin207 · ‎02-02-2018

I have to integrate Service-Now with Landesk and need to populate cmdb via integration.

Please guide me through step by step procedure to accomplish this.

toneyvecchio1 · ‎02-03-2018

Hi Bipin,

I might say walking you step by step on an Ivanti Landesk integration might be a bit much, but I'll give you the general gist of what I've done prior.

The last Landesk integration I did, there was a SQL table that stored all of the Landesk results and we would query from that. I don't know if thats normal for Landesk or just to that client.

1. Get a service account setup that has SQL access to the Landesk Data.

2. Setup Midserver and have process on server run as the Service Account (So when Midserver reaches out to hit SQL, it has auth). Note that I setup a separate midserver instance, on same server as original midserver, for this purpose.

3. Setup Data Source in ServiceNow, Type = JDBC, Format = SQLServer, Use Integrated Authentication.

4. In Data Source, use SQL Statement to build a query to computer data. I dont know if this is standard or specific to client, but a simplified version of our SQL statement looked like

SELECT

Computer.*,

CompSystem.*,

Operating_System.*

FROM Computer

LEFT OUTER JOIN CompSystem ON Computer.Computer_Idn = CompSystem.Computer_Idn

LEFT OUTER JOIN Operating_System ON Computer.Computer_Idn = Operating_System.Computer_Idn

5. Create a Transform Map that maps your Landesk data to the CMDB. You'll need find your best unique identifier to coalesce on, maybe serial_number.

6. Test it out. Adjust.

Step X and beyond ideas: Build process around what to do if device stops reporting into Landesk after X days. Find ways to populate asset table and create a CI stub to update form purchasing so you can have finance data involved. Use catalog forms and sourcing to tie back original request, source purchasing, PO, arrive on docks, stockroom and then have Landesk data populate the specs and tie in full circle asset management. Use Cabrilo on mobile to introduce barcode scanning. Come to forums and help describe process to others starting.

View solution in original post

bipin207 · ‎02-03-2018

Thanks Toney.your response really gave me some idea to start with this .

jagarnathn · ‎02-03-2018

Bipin, if you do not prefer to do it via JDBC, you can do this integration using SOAP or REST API.

Landesk authentication mechanism differs compared to other tools. First we have to call an API for your authentication to be validated to get dynamic user id and password.Once it is done, you can make an actual API calls to get some data from Landesk by using the credentials received earlier.

If you do not have a middleware like(Froumsentry, Biztalk, Apigee) to whitelist your end point and bypass the firewall,Mid server will come into picture.

bipin207 · ‎02-04-2018

This is helpful.

Thanks

bipin207 · ‎02-04-2018

This is really helpful.

Thanks