We have recently starting implementing SAM Pro and have deployed ACC with OSQuery to provide advanced software metering and usage. We have found that, despite seeing the raw usage data retrieved by ACC in the ECC queue, the staging table is not getting populated.
We have been advised by our consultants that this is possible because users log on to their devicves (laptops, desktops etc) using their legacy user ID, but we record their user ID as their UPN on their user record. ServiceNow is therefore unable to find the matching user record. As a solution we have been pointed in the direction of a script include EnhancedDiscoveryHandler, where changes to the getUserSysId() function could be modified along with the system property
sn_acc_vis_content.column_name_for_user_mapping to allow matching users on either attribute (we have a legacy user ID field on the sys_user table).
Is this the best way to achieve our aims or is there a better way to get software metering to work?
