User not populated in Software Subscriptions table

MercBuilding
Giga Guru

Hi,

  We have Microsoft 365 integration and Adobe integration done in our instance. For Microsoft 365 integration iam noticing that even if user is present in Servicenow instance, the user field is blank and if i check the user principal name in users table it is present in the instance but not populated in Software subscription table becuase of which the child products are considered as unlicensed. Can anyone tell me how to fix this issue?

 

Thanks!

 

2 REPLIES 2

jonsan09
Giga Sage
Giga Sage

I had a similar issue with the Software Subscription table, I created a scheduled job to run after the update the software subscription record by looking up/matching the UPN against the sys_user table and then populating the user field on the software subscription record.

jose_quinonez
Giga Guru

Hi,

We also need to populate the software subscription user field by looking up User principal name in a another table.

We wanted to do that in the Auto-populate discovered user business rule and the getSysUser function on the SAMSaasIntegrationUtils script include, but we discovered that there is a condition on the business rule that prevents it to be executed from integrations (it works only in manual updates).

So we are thinking on a scheduled job as well, and have it run once a day.

Suggestions?

Thanks