How to use the ServiceNow tile

About ServiceNow tiles

The ServiceNow tile allows you to query incidents and change requests from ServiceNow and display this data in Dashboard Server.

Should you use the Web API tile or the dedicated ServiceNow tile?

The ServiceNow tile is available in Dashboard Server v4.4, which offers easier configuration than the Web API tile. You can display incidents and change request with the ServiceNow tile. If you want to use any other data from ServiceNow, you need to use the Web API tile.

The Web API tile can display other data in addition to incidents and change requests, it gives you more flexibility and advanced configurations.

For more information about using the Web API tile with ServiceNow see How to use the Web API tile with ServiceNow.

How to configure a ServiceNow tile

If you don't already have a ServiceNow provider, you need to create one before you can configure a ServiceNow tile (How to add a ServiceNow provider).

Add a new tile to a dashboard or a perspective and choose the ServiceNow tile.
Select the visualization for your ServiceNow tile:
Donut
Shows the results in a donut shape.
Example:
Scalar
A single value such as a number of customers or incidents.
Example:
Grid
A table of data, for example incidents or tickets.
Tip: You can turn the individual rows into links in the settings. For example, if you're displaying tickets in your grid, you can link the rows to the ticket in your external ticket system.
Did you know? Since Dashboard Server 5.4 users can search the grid, and temporarily change the column size and sorting of the grid (by clicking on the column headers) without having to access the settings. They can also expand a row by clicking on the three dots at the end of each row if cells are too small to show their entire content.

Scope:

The scope section is optional, and allows you to specify a scope to narrow down the query

Requirements for using the scope in the ServiceNow tile

It depends on the ServiceNow account you are using for a provider if you can use the scope.

How the ServiceNow account affects the ServiceNow tile
The permissions of the ServiceNow account you are using for your ServiceNow provider affect what you can see and do in the ServiceNow tile.

We recommend using a service account, which means you create an account specifically to use with the ServiceNow provider. You have different options for setting up this service account:

ServiceNow admin account
Give the ServiceNow account the admin role. This will give you full functionality in the ServiceNow tile.
ServiceNow non-admin account with ACLs
If you don't want to use the admin role due to security concerns, give the ServiceNow account only the rest_api_explorer role and use ACLs to give the account more rights. This will limit the functionality of the ServiceNow tile a little bit (see table below).
How to add the necessary ACLs to your ServiceNow account
When you are using a non-admin ServiceNow account for a provider, the functionality of the ServiceNow tile is limited:
- You'll see an error when you used a scope for your tile
- In the View dropdown, only the non-admin default view is available (contains a default set of columns)
- Under Filter, default filters are not available, only user-created ones are visible
You can reinstate some of the functionality of non-admin ServiceNow accounts by using ACLs.
ACLs can be added in two ways:
- Adding them directly to a user account, meaning you are adding the ACLs to the service account you are using for the ServiceNow provider.
- Adding them to a role. We recommend that you create a new role specifically just for adding the ACLs to it. Then you need to assign the role to the service account you are using for the ServiceNow provider.
  A benefit of adding the ACLs to a role is that it makes them easier to manage and you can assign the role to different users (in this case, service accounts) if you want to use different service accounts for different ServiceNow providers.
You need to add the following ACLs:
- ```
sys_filter
```
- ```
sys_dictionary.*
```
- ```
sys_dictionary
```
- ```
sys_db_object
```
- ```
sys_ui_list
```
- ```
sys_db_object.*
```
- ```
sys_ui_list.*
```
What tile functions do those ACLs add when I use a non-admin ServiceNow account?
- The tile can be scoped
- Under Filter, all default filters are visible
- The ACLs don't affect the views. The View dropdown still shows only the non-admin default view. You need to use an admin Service account to see all the views.
ServiceNow non-admin account without ACLs
If you don't want to create ACLs and use only roles, give the ServiceNow account the roles rest_api_explorer and web_service_admin. This will limit the functionality of the ServiceNow tile a little bit (see table below).

	ServiceNow admin account	ServiceNow non-admin account with ACLs	ServiceNow non-admin account without ACLs
Being able to scope the tile	yes	yes (due to the ACLs)	yes (due to the web_service_admin role)
Being able to see all views in the View dropdown, not only the default view	yes	no	no
Being able to see all default filters, not only user-made ones	yes	yes (due to the ACLs)	no

Scope options on dashboards

Tip: If you experience any problems with scoping tiles, you'll find FAQs and help in the article How to scope tiles.

Note: By default, results are shown across all subscriptions (unless the subscription option is chosen to specify only one or more subscriptions).

Filter by tenant	By default results are shown across all tenants. In Dashboard Server 4.7 and above a user who has access to multiple tenants will see a filter by tenant option. If you see the message "You do not have access to all of the tenants currently selected" or "Tenant ID could not be resolved" In a multi-tenant environment a user who does not have access to all tenants will see this message if they attempt to edit a scope containing tenants that they do not have access to. This may be because: One Dashboard Server admin has added a tile scoped to tenants that other Dashboard Server admins do not have permissions to. The customer/tenant is no longer serviced by this Customer Service Provider (CSP), so the tenant has been permanently removed for all Dashboard Server admins. Symptoms A tile scope shows: "You do not have access to all of the tenants currently selected. Click here to reset which will remove those tenants from the scope." Tenants the user does not have access to show as: "Tenant ID could not be resolved" Procedure The message warns users that they do not have permissions to all the tenants in the scope. If the user chooses to reset and therefore edit the scope then the tenants that they do not have access to will be removed. If saved this scope will also have those tenants removed for users who do have access to them. It is not possible for the user to edit the scope without those tenants being removed from the scope. Where a tenant has been removed permanently you may wish to reset the scope to remove the unresolvable tenants.
List	List allows you to select several individual items to show. You can add multiple items. To remove an item click the x to the right of its name. Tip: Start typing and after two characters you'll see suggestions that match the name appear. Note: It depends on the tile what happens when you select more than one item. For example, when you select two virtual machines for a Status tile, you'll see the status of those VMs individually. When you select two virtual machines for a Cost Management tile, you'll see the cost for the two VMs added together.
Resource group	Select one or more resource groups. Filter by type: Tick filter by type to only show resources of a particular type within the chosen resource group.
Subscription	Select one or more subscriptions from the dropdown box if you wish to restrict results to only one or more subscriptions. When this is not used results are shown across all subscriptions. Filter by type: Tick filter by type to only show resources of a particular type within the chosen subscription.
Tags	Select items with a particular tag. Add the tag name and the tag value you want to use to search for. If you select multiple tags, the search automatically 'ANDs' the tags which means the scope only contains items which are tagged with all the tags listed. Filter by type: Tick filter by type to only show resources of a particular type within the chosen tag(s).
Type	Scope type can be used to show all resources of a particular type, for example all databases across all subscriptions, by typing `databases` and selecting `SQL databases`.
Show hidden types	This works in the same way as the Show hidden types option in the Azure portal. Hidden types include some ancillary resources which are created/managed by Azure infrastructure. It might be useful to display these resources when cleaning up your resource groups or subscriptions.

Provider:
Select your ServiceNow provider from the select provider drop-down and click next.
You can only use providers of the same type as the tile. Providers of other types won't be shown in the select provider drop-down.
Note: If you click on add new, you can create a new ServiceNow provider in a new tab. Click on reload after you created the new provider to be able to choose it from the drop-down.

Table:

Table:

Here you can choose if you want to get incidents or change requests (for any other data, you can't use the ServiceNow tile and need to use the Web API tiles, see How to use the Web API tile with ServiceNow).

View:

Here you choose the view that determines the set of columns which will be displayed. Views are created in ServiceNow and the list of views is populated from there.

To allow the ServiceNow views to be pulled into the ServiceNow Grid visualization the ServiceNow account must also have the 'admin' role in ServiceNow.

If you only see the non-admin default view in the View dropdown

It depends on the ServiceNow account you are using for a provider if you can see all the available views or only the non-admin default view in the View dropdown.

We recommend using a service account, which means you create an account specifically to use with the ServiceNow provider. You have different options for setting up this service account:

ServiceNow admin account
Give the ServiceNow account the admin role. This will give you full functionality in the ServiceNow tile.
ServiceNow non-admin account with ACLs
If you don't want to use the admin role due to security concerns, give the ServiceNow account only the rest_api_explorer role and use ACLs to give the account more rights. This will limit the functionality of the ServiceNow tile a little bit (see table below).
How to add the necessary ACLs to your ServiceNow account
When you are using a non-admin ServiceNow account for a provider, the functionality of the ServiceNow tile is limited:
- You'll see an error when you used a scope for your tile
- In the View dropdown, only the non-admin default view is available (contains a default set of columns)
- Under Filter, default filters are not available, only user-created ones are visible
You can reinstate some of the functionality of non-admin ServiceNow accounts by using ACLs.
ACLs can be added in two ways:
- Adding them directly to a user account, meaning you are adding the ACLs to the service account you are using for the ServiceNow provider.
- Adding them to a role. We recommend that you create a new role specifically just for adding the ACLs to it. Then you need to assign the role to the service account you are using for the ServiceNow provider.
  A benefit of adding the ACLs to a role is that it makes them easier to manage and you can assign the role to different users (in this case, service accounts) if you want to use different service accounts for different ServiceNow providers.
You need to add the following ACLs:
- ```
sys_filter
```
- ```
sys_dictionary.*
```
- ```
sys_dictionary
```
- ```
sys_db_object
```
- ```
sys_ui_list
```
- ```
sys_db_object.*
```
- ```
sys_ui_list.*
```
What tile functions do those ACLs add when I use a non-admin ServiceNow account?
- The tile can be scoped
- Under Filter, all default filters are visible
- The ACLs don't affect the views. The View dropdown still shows only the non-admin default view. You need to use an admin Service account to see all the views.
ServiceNow non-admin account without ACLs
If you don't want to create ACLs and use only roles, give the ServiceNow account the roles rest_api_explorer and web_service_admin. This will limit the functionality of the ServiceNow tile a little bit (see table below).

	ServiceNow admin account	ServiceNow non-admin account with ACLs	ServiceNow non-admin account without ACLs
Being able to scope the tile	yes	yes (due to the ACLs)	yes (due to the web_service_admin role)
Being able to see all views in the View dropdown, not only the default view	yes	no	no
Being able to see all default filters, not only user-made ones	yes	yes (due to the ACLs)	no

Filter:

Here you choose a filter to restrict the query to certain items. You'll see default filters from ServiceNow and filters that have been created by users in ServiceNow.

If you only see user-created filters but no default filters

It depends on the ServiceNow account you are using for a provider if you can see the default filters.

We recommend using a service account, which means you create an account specifically to use with the ServiceNow provider. You have different options for setting up this service account:

ServiceNow admin account
Give the ServiceNow account the admin role. This will give you full functionality in the ServiceNow tile.
ServiceNow non-admin account with ACLs
If you don't want to use the admin role due to security concerns, give the ServiceNow account only the rest_api_explorer role and use ACLs to give the account more rights. This will limit the functionality of the ServiceNow tile a little bit (see table below).
How to add the necessary ACLs to your ServiceNow account
When you are using a non-admin ServiceNow account for a provider, the functionality of the ServiceNow tile is limited:
- You'll see an error when you used a scope for your tile
- In the View dropdown, only the non-admin default view is available (contains a default set of columns)
- Under Filter, default filters are not available, only user-created ones are visible
You can reinstate some of the functionality of non-admin ServiceNow accounts by using ACLs.
ACLs can be added in two ways:
- Adding them directly to a user account, meaning you are adding the ACLs to the service account you are using for the ServiceNow provider.
- Adding them to a role. We recommend that you create a new role specifically just for adding the ACLs to it. Then you need to assign the role to the service account you are using for the ServiceNow provider.
  A benefit of adding the ACLs to a role is that it makes them easier to manage and you can assign the role to different users (in this case, service accounts) if you want to use different service accounts for different ServiceNow providers.
You need to add the following ACLs:
- ```
sys_filter
```
- ```
sys_dictionary.*
```
- ```
sys_dictionary
```
- ```
sys_db_object
```
- ```
sys_ui_list
```
- ```
sys_db_object.*
```
- ```
sys_ui_list.*
```
What tile functions do those ACLs add when I use a non-admin ServiceNow account?
- The tile can be scoped
- Under Filter, all default filters are visible
- The ACLs don't affect the views. The View dropdown still shows only the non-admin default view. You need to use an admin Service account to see all the views.
ServiceNow non-admin account without ACLs
If you don't want to create ACLs and use only roles, give the ServiceNow account the roles rest_api_explorer and web_service_admin. This will limit the functionality of the ServiceNow tile a little bit (see table below).

	ServiceNow admin account	ServiceNow non-admin account with ACLs	ServiceNow non-admin account without ACLs
Being able to scope the tile	yes	yes (due to the ACLs)	yes (due to the web_service_admin role)
Being able to see all views in the View dropdown, not only the default view	yes	no	no
Being able to see all default filters, not only user-made ones	yes	yes (due to the ACLs)	no

Configure the settings for the visualization you chose:

Settings for Scalars

Scalar

Font size	Allows you to set the font size of the value in the tile.
Unit	Allows you to add a unit to the value displayed in the Scalar tile. For example, if your value shows a time in milliseconds, you can enter "ms" or if your value shows pageviews, you can enter "pageviews".
Value formatter	Allows you to format the value by using the mustache picker. For example, you can round the value up or down or convert it.

Color

Conditional formatting:

You can display the scalar in different colors based on conditions you defined here. For example, you can display the scalar in green when the value is below 100 and in red when it is above 100.

Click on add to configure a condition.
Click on select color.... to open the color picker. Select the color for this condition.
Enter your condition in the field next to the color. You can use the value property and manipulate it with JavaScript String and Regex APIs. When you click on the mustache picker, you'll get some examples:
- Value is greater than something, less than something, etc.
  For example: {{value < 10}} (The color you picked will be used if the value is less than 10)
- Value is present in the result
  For example: value.IndexOf('error') != -1 (The color you picked will be used if the string value "error" is present in the results)
- Value matches one of the regular expressions you defined
  For example: value.match(/healthy|good|up/) (The color you picked will be used if the string values are healthy, good, or up)

Display:

Here you decide how the color is used:

Tile background	Highlight the tile in the color you defined.
Text foreground	Display the text in the color you defined.

Link options

Allows you to turn the graph item(s) into links. You can either enter plain text to create a fixed link (URL always stays the same) or use dynamic properties to create a dynamic link.

Dynamic links make use of dynamic properties which are inserted as part of the URL. This creates a template URL that will be resolved to an actual URL based on the items properties.

For example, if you want to link to tickets in your ticket system and the format of the URL for tickets in your system is https://www.my-system/ticket-123, where 123 is the ticket ID, you can use the dynamic property that contains the ticket ID and enter the dynamic URL https://www.my-system/ticket-{{ticketID}}.

For scalars, you can only use the dynamic property value in dynamic links, which means the link changes when the value of the scalar changes. Since a scalar is just one item, it would also make sense to use a fixed link, for example the link to the website of which you are displaying the response time.
For status icon or bars and the rows of a grid, you usually want to use a dynamic link since you get multiple items or rows that represent different things. You can use any of the dynamic properties the mustache picker offers you.

Click done to save the tile.
The tile now shows data according to your settings.

FAQs

Why can't I find the provider I created in the dropdown list?

If you are unable to see your provider in the list check that it is a servicenow provider. Any other types of providers will not be shown in the dropdown.

How do I query data other than Incidents or Change Requests ?

The ServiceNow tile can only show Incidents or Change Requests. If you wish to query other tables use the Web API tile to query the ServiceNow API instead of the ServiceNow tile (see How to use the Web API tile with ServiceNow).

How do I create a new view or filter ?

The list of views and filters is pulled from ServiceNow. When you create any new views and filters in ServiceNow they will be available in Dashboard Server.

AZURE LIVE KB.10.log-255910939.zip
7 KB Download

Default	Displays the donut scaled to the height of the tile.
Fill	Enlarges the donut to use the whole width of the tile. If you chose the fill option and show the legend, you can define the size of the legend with a slider.