What is the assigned_to field on cmdb_sam_sw_install used for?

[Tuna]

Good day,

We are introducing SAM Pro and are using Discovery in order to populate the servers and another integration (not SCCM) for clients. What I can see is that the assigned_to field on [cmdb_sam_sw_install] is empty. So, the question arose if the assigned_to on [cmdb_sam_sw_install] is somehow relevant for SAM Pro and if we need to populate it? So, is SAM Pro using the assigned to on the CI or is it using the assigned_to on the CI? And what is the purpose of the assigned_to field in [cmdb_sam_sw_install] actually?

[Community Alums]

Hi @Tuna ,

Out of box there are two ACL on this table.  One requires the role sam_user, the other is a acl that if the logged in user is the same as the assigned_to value on the record and they are coming from mobile that they can read the record.  I would look to remove the restriction that the user is coming from mobile.

This is not advise on when you've entered the waters of requiring a license for that user.  Also it would be helpful if you define who needs to see the records (the end users who is associated to to those records or someone else).

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Tuna]

Sorry to say that, but this is not even close to what I am looking for. I am referring to the Software Asset Management Professional Reconciliation process and not the required ServiceNow licenses and roles.

Thanks anyways 😉

[Daniel Slocum · Accepted solution]

Hi Tuna.

At this link you can find an article I posted here in the Community that identifies every attribute in the Software Installation table.  In that article, I describe the Assigned to value with the following text:

Assigned to (assigned_to): A reference attribute to the sys_user table identifying the Assigned To value of the Installed On device. The value is leveraged for Per User and Per Named User license metrics and is updated during the reconciliation process from the Assigned to value found on the Installed On CI.

[Tuna]

Hi Daniel,

Thanks a lot for the link and that was exactly what I was looking for! That helps me really, right now!

Regards,

Tuna