cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Providing User Assignment Data to ServiceNow from ITAM

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

(4) Replies

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.

Anything expressed here is my own view and not necessarily that of my employer, Flexera. If my reply answers a question you have raised, please click "ACCEPT AS SOLUTION".

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?

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.

Anything expressed here is my own view and not necessarily that of my employer, Flexera. If my reply answers a question you have raised, please click "ACCEPT AS SOLUTION".

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}

Anything expressed here is my own view and not necessarily that of my employer, Flexera. If my reply answers a question you have raised, please click "ACCEPT AS SOLUTION".