How can I import Allocation data into and Entitlement?

[ladrake]

The training book mentions importing Allocations on page 213, but does not show how to do this.  Pages 214 and 215 show the fields of data that are required but do not mention how to import the data.  Does anyone know how to do this?

[mikewhalley]

You'll have to create an import set/transform map to bulk load device/user allocations. Note that you will need to extract the entitlement record first and add a ref value such as asset tag or sys ID as data to the template, so that the allocations are linked to the correct entitlement.

[iamkurt]

@mikewhalley- I am in a similar situation with a similar post which can be found here. Will you please help me out?

[Daniel Slocum]

Good day,

Mike Whalley has this correct.  Here's a bit more color to help you.

You will indeed need to create an import set.  For user allocations, you'll need to import into the alm_entitlement_user table and for device allocations, the table is alm_entitlement_asset.  Mike's assertion that you require a method to map the linked entitlement in the transform map is correct.  You should be sure to have system-generated asset tags or user-created asset tags on all of your entitlement records for this purpose.  Similarly, within the transform map, you'll need to map the "assigned to" attribute to an active record in the sys_user table or the "allocated to" attribute from the CMDB.  You will also need to specify a group of attributes as the coalesce value.  I'd make this a two-attribute coalesce on the Entitlement and either the Device or the User depending on which table you are loading data into. 

Information on how to create and use Import Sets in New York, the current ServiceNow release, can be located here.

Daniel

[iamkurt]

@Daniel Slocum- I am in a similar situation with this post. Will you please help me out?