Flexera One’s SaaS Management now offers Microsoft Power BI extensible reporting for ServiceNow. The following new insights for analyzing ServiceNow subscriptions and allocations help identify license reclamation or downgrading opportunities.
- Executive Summary Report
- License Overview
- Use Verification Report (ServiceNow Audit Report)
- Subscriptions
- ServiceNow User Activity Tracking
The report, which uses the SaaS Management APIs, has been developed in partnership with our customers and product team to ensure that it provides the insights that enable improved governance and license management processes for complex ServiceNow environments.
In addition, the Microsoft Power BI report offers a mechanism to provide ServiceNow insights to those within your organization who do not use Flexera One's SaaS Management.
Power BI Report Setup
The report, which is attached to this article as a Power BI Template (PBIT), can be easily configured by providing:
- A refresh token obtained from your Flexera One org. Details on how to generate a refresh token to work with the Flexera One API can be found in the Flexera One Help topic Generating a Refresh Token.
- The location of your Flexera One org using the following options: North America (NA), Europe (EU), or APAC (AU).
- Your Flexera One Org ID, which is a numeric identifier contained within the URL of your org.
- The managed application ID for the ServiceNow managed application you wish to report on. This ID is also contained within the URL when you are viewing your ServiceNow managed application within SaaS Management. As an example, when you are viewing the Overview tab of a ServiceNow managed application in SaaS Management, your URL will be in the following format:
- SaaS Management URL Information Needed for Power BI Reporting—from the example https://app.flexera.com/orgs/99999/saas/managed-products/987654?tab=overview
|
SaaS Management URL Information Needed for Power BI Reporting |
Format |
|---|---|
|
Flexera One Org ID |
99999 |
|
Managed Application ID |
987654 |
When opening the PBIT file, you will be prompted for these values. For further details, see the following screenshot. After entering these values, your Power BI report will retrieve the data relating to the ServiceNow managed application you have supplied.
Test Mode
This has been added to allow you to be able to quickly load the report into the desktop designer. Setting this option to "Yes" will only import the first ten thousand users. When you publish the report to the Power BI service, you can change this parameter to "No" and all users within your ServiceNow instance will be imported.
When running this report in the APAC instance of Flexera One I am seeing a 400 Bad Request error when the sn_refresh_token function is being executed. This appears to be because the Content Type in the header of the AU specific URL is set to "x-www-form-urlencoded" and not "json".
After updating the content type, the sn_refresh_token correctly returns a valid bearer token.
regards,
Murray
After entering values into the parameters (refresh token, etc.) I get presented with another credentials screen and do not know what to select/enter. I tried various things but nothing seems to work and there are not any instructions on what should be entered.
@aswindells, it does not prompt right away. It runs through the query evaluation first. Maybe timeout is the issue, though I did have it in TEST mode initially so the data set should have been limited. It did error out eventually due to a duplicate value found in 'sn_licenses_details.displayName'.
'.
