Help needed - SAM - Bulk User Allocations

[Josh Thompson]

Hello,

I am working on adding User Allocations to a Software Entitlement. I am trying to find a functional way to take the data from my spreadsheet (user email address or user name) and target to the User Allocations table in that Software. I've created the data source using the excel doc and a transform map targeting User Allocation table and  mapping email > assigned to. I've tried using the Asset Tag or the Display name of the Software Entitlement to map to the Entitlement (which gets changed to licensed_by in the Field Maps). I've also added a Quantity to the data source xlsx just for sanity sake and filled those out with 1 across each entry.  I feel like I'm overlooking one simple step here and I cannot figure it out. 

Any tips/suggestions would be hugely appreciated. 

[Josh Thompson]

I think I may have found the issue.  Although I have some of the required permissions in ServiceNow, I was unable to make changes in the imported data when I changed the file that was attached to the data. This was keeping the old data in the table and not allowing me to further test. I collab'd with a user who had higher permissions and had them go step by step and the data imported correctly > mapped correctly > and then applied it to the User allocation table of the Software Entitlement mapped off of the display name.  I'm going to leave this open for now because we're still testing it out in dev for things like users who aren't active anymore and then some live testing.  

Thank you so far to Akash and Scott for helping me out and reaffirming to me that it should be working which put me on the track of "maybe it's me(my privs) and not servicenow". 

I'll update after further testing.

[Dimitrios2]

Hi, can this be done via a import template spreadsheet? alot of us arent knowledge and also dont have premissions to view the tables. This feature can be done in SNOW license manager via a spreadsheet import. thanks.