Providing User Assignment Data to ServiceNow from ITAM

[a_cutler2]

I'm looking for a little assistance with the task of getting user/computer assignment data into ServiceNow for an App Broker implementation from ITAM. I know that this data doesn't come directly from App Broker in any way and the customer is responsible for populating those data into ServiceNow, however a customer would like to utilize ITAM as the source of those data. Is there an API that can be utilized to pull directly from ITAM? Or would we need to do a more manual approach utilizing exports/reports/business adapters or something similar?

The concept of doing this is referenced here, but this was also for FNMS rather than the cloud based ITAM. https://community.flexera.com/t5/App-Broker-Forum/User-Computer-Relationship-in-ServiceNow/td-p/183350

[jdempsey]

As far as I know, you would need to create a custom report in ITAM that has the "asset to assigned and/or calculated user" relationship and could then use the reportsExecute API to pull that report out of ITAM (as CSV data) and then import it to ServiceNow.

[a_cutler2]

Thanks Jim, can you please confirm if the report data would be a csv file that's exported, or would it be a real time API connection that wouldn't require a file export?

[jdempsey]

By default, the output of the reportsExecute API will be JSON, which can be easily converted/saved as CSV if calling the API from PowerShell.  Alternatively, if you specify an Accept header on the API call with text/csv as the value, it will return the results formatted as CSV, which you would then save to a file.  If you are calling the API directly from ServiceNow (I couldn't tell you how to do that), then you could avoid the middle step of saving to a CSV file.

[jdempsey]

By the way, if your assigned/calculated user column is marked as "Include in search" within your custom report, then you can pass a user as "searchText" to the reportsExecute API, and it will then only return rows that match the specified user.

e.g.  https://api.flexera.com/fnms/v1/orgs/{orgId}/reports/{id}/execute?searchText={user}