Automated creation of Software Usage from group memberships – standard approach?

[FranckM]

Hi SN SAM community,

Is anyone here familiar with the automated creation of Software Usage entries from the sys_user_grmember (group memberships) table?

We’re importing user data into ServiceNow via a connector, which includes:

• Users (sys_user)

• User Groups (sys_user_group)

• Group Memberships (sys_user_grmember)

  My goal:
  When a user is a member of a specific group – for example, the “Taskforce” group – that should be interpreted as software usage and reflected in the Software Usage table (cmdb_sam_sw_usage), since each member consumes a taskforce license.

  Question:
  Is there a standard or recommended way in SAM to achieve this mapping from group membership to software usage?

  Thx

  Regards

[dreinhardt]

Hi @FranckM ,

I would recommend to use the user allocation instead of software usage table.

please check the following post about the upcoming Zurich feature which fulfills your request to use groups to create allocation to be used as consumption.

https://www.servicenow.com/community/sam-forum/sampro-group-allocations-where/td-p/3343109

Best, Dennis

[FranckM]

Thank you for your response. i am still in the release Yokahoma and dont plan to upgrade soon. 

also, could we somehow automate the consumption creation? i willnt be able to create a group allocation for arount 1000 groups.

Regards

Franck

[FranckM]

@dreinhardt do you have a best practice for me, how i can do it (even with a work around) in the Yokahoma release on an automated way?

Regards

Franck