This ServiceNow Grafana Datasource Plugin enables communication between Grafana and ServiceNow to pull in all kinds of data from your instance. This plugin can query ANY table (even database views), perform aggregate or trend queries on ANY table, time-series metrics from the metricBase, display the Service Dependency Map, and many more features. www.servicenow.com

If you have updated from an older version to v1.3.0, please Click here to fix the breaking changes

Check out the new Gallery Here to see some screenshots from our plugin in action

• Change Notes 🔧
• Supported ServiceNow Versions
• Setup Instructions
  • Step 1: Install application in ServiceNow Instance
    • Search for and click on "studio" in the application navigator
    • Click on the "Import From Source Control" button
    • Enter import details as shown below
    • Create a new user in ServiceNow for Grafana to connect with
  • Step 2: Install Grafana Plugin
    • Quick Install
    • Manual Install
  • Step 3: Grafana Datasource Configuration
  • Step 4: Import Our Grafana Dashboards
• Dashboards
  • Which dashboards should I import?
    • Visibility + ITOM AIOps(Event Mgmt + HLA)
    • Visibility + Cloud Native Operations(CNO)
    • ACC-M
    • Visibility - Cloud
• UI Actions Setup Instructions
• Variables
• FAQ
  • I just updated to v1.3.0 and everything is broken. How do I fix it?
  • How do I fix the "Panel plugin not found: x" error?
  • Why am I getting a Bad Gateway error on my panels?
  • How do I fix the error "String object would exceed maximum permitted size of 33554432"?
  • How do I fix the error Bad Request "Requested URI does not represent any resource"?
  • Why do the select boxes show "No options found"?
  • How do I change the icons in the Topology(Service Dependency Graph) panel?
  • How do I fix blank Topology panel icons?
• Query Editor Options
  • Query Categories
    • Metrics
    • Alerts
    • Changes
    • Topology
    • Live Agent Data
    • Table
    • Row Count
    • Aggregate
    • GeoHash Map
    • Log Data
    • Trend Data
    • Outage Status
    • Anomaly

• Rome
• Quebec
• Paris

For your ServiceNow instance to work with our Grafana plugin, you must first install our Grafana Plugin application on your ServiceNow instance.

• URL: https://github.com/R2DToo/Grafana-Plugin-ServiceNow.git
• Branch: master
• Credentials: Any GitHub account will work. (Even though the repo is public, ServiceNow requires credentials regardless of visibility)

• This user may have any username and password you wish
• Timezone for the user MUST BE GMT
• The user will also need these roles:
  • soap_query
  • evt_mgmt_operator
  • itil

Option based scripts written for each operating system give you the option to install Grafana + our plugin or just our plugin in your existing Grafana. Click here for Quick Install Setup

Download or clone the repository and move the unzipped folder into your Grafana plugins folder, then restart Grafana.

1. Open Grafana Configuration => Data Sources
2. Click on the "Add data source" Button
3. Search for and add our "optimiz-servicenow-datasource"
4. Configure the data source based on fields below. Required fields are marked with a ❗

• Logo URL: URL to an image you wish to use as logo. (Default value is a ServiceNow Logo)
• API Path: Path to our application's API's in your ServiceNow instance. (Please do not change the default value unless you are a developer or understand the implications)
• Cache Timeout: Choose length of time to cache each query
• ❗ URL: The URL to your ServiceNow instance. (For convenience the default value is mostly filled in. Just replace <instance_name> with your own)
• ❗ Access: Leave this value as Server (default)
• ❗ Basic Auth: Set this to true
• ❗ With Credentials: Set this to true
• ❗ User: Enter the ServiceNow username we created earlier in Step 1
• ❗ Password: Enter the ServiceNow user's password we created earlier in Step 1

5. Click on the "Save & Test" Button. If you get the message "Data source connection is successful" then the plugin is ready to use!

Dashboard descriptions will be added soon..

• ACC Agents Inventory
• ACC-L CI Details
• Advanced - ACC Agent Inventory
• Advanced - Application Services
• Advanced - vCenter Inventory
• Anomaly Insights
• Application Service Details
• Application Services
• AWS CI Details
• AWS Function Details
• AWS Inventory - US Regions
• AWS Lambda Functions
• Azure CI Details
• Azure Inventory
• CI Details
• Compare CIs
• Generic CI Details
• Kubernetes Details 2
• Kubernetes Details
• Kubernetes
• Landing Page
• Linux Inventory ACC-L
• Live CI Data
• Live Logs
• Observability Dashboard
• Observability Live Logs
• Observability with Log KPIs
• Outage Dashboard
• Related Alerts
• Simple Event Management(Node-Based)
• Simple Event Management
• Tag Health
• UI Actions
• vCenter CI Details
• vCenter Inventory

You may choose to import all dashboards, or start small and work your way up. Below are some suggestions to get you started:

• Landing Page
• Application Services
• Application Service Details
• Outage Dashboard
• Simple Event Management
• Generic CI Details
• Tag Health
• UI Actions
• Log Analytics
• Live Logs
• Related Alerts

• Landing Page
• Observability Dashboard
• Observability Dashboard with Log KPIs
• Kubernetes
• Simple Event Management
• Generic CI Details
• CI Details
• Kubernetes Details
• Kubernetes Details 2
• Tag Health
• UI Actions
• Log Analytics
• Observability Live Logs
• Related Alerts
• Application Services
• Application Service Details
• Outage Dashboard

• Landing Page
• ACC Agents Inventory
• Advanced - ACC Agents Inventory (example using location/support groups/environment)
• Compare CIs
• Anomaly Insights
• Simple Event Management
• Generic CI Details
• CI Details
• Tag Health
• UI Actions
• Log Analytics
• Live Logs
• Related Alerts

• Landing Page
• AWS Inventory - US Regions
• AWS CI Details
• Kubernetes
• Kubernetes Details
• Kubernetes Details 2
• Azure Inventory
• Generic CI Details
• CI Details
• AWS Lambda Function
• AWS Function Details
• Tag Health
• vCenter Inventory

If you would like to make use of our UI Actions dashboard, there are a few fields that will need to be updated for each instance.

1. Navigate to the plugins menu and search for the button panel shown below. Click into the panel and hit the install button.

2. Create a Grafana API key using the Admin role. Key name and TTL are up to you.

3. Once you hit add, copy the API key shown on screen.

4. Navigate to the UI Actions dashboard inside the Drilldown Dashboards folder. Then edit the button panel.
5. Add an Authorization header using your new key. Don't forget to hit the plus button when your done

Name = Authorization
Value = Bearer <API_KEY>

6. Change the URL field pictured above to reflect the FQDN your grafana instance is currently using. Please only change the domain and nothing after the port number. The /api portion should remain the same.

Version 1.3.0 includes a change to the plugin id and name, meaning Grafana does not recognize them as the same. To get back up and running please follow the steps below:

• Navigate to the datasource configuration tab inside your Grafana instance and delete the old version of the datasource
• Follow these steps to re-configure the updated datasource
• Delete and re-import all included dashboards so that they work with the updated datasource

You are seeing this because the panel plugin we used in the dashboard is not installed on your instance of Grafana.

• Take note of the panel plugin name displayed in the error (plugin names are formatted like (author)-(pluginName)-(pluginType))
• Navigate to Grafana Configuration => Plugins
• Search for the plugin in the error (Search based on the middle word the plugin displayed in the error)
• Click into the plugin (You will know its the correct one based off the authors name)
• Click the Install Button

The default timeout for requests made by Grafana in 30 seconds. If your request takes longer than 30 seconds you will see this error.

There are a few possible fixes for this error. Please try each fix as they all work differently and will depend on your needs of the data.

• If you are looking for a subset of data rather than the entire table, try adding some filters to the Sysparam Query
• If displaying every field on the record is not a necessity, try specifying which fields you would like to see in the Table Columns option
• If your familiar with pagination we also have this as an option to reduce the amount of records returned in each query. To use pagination, in the Limit option enter in the number of records to return per request(default is 9999). Then increment the Page option by 1 each time you wish to advance pages(default starts at 0)
• The last fix here is one I do not recommend but is still an option. In the data source configuration page there is an option called Timeout, there you can specify your desired request timeout in seconds(default is 30). I do not recommend this fix as it will likely lead you to the error below this one, use at your own risk.

This happens when the amount of data being returned from a query is greater than 32MB.

• To fix this issue, try the steps in the above question as both are fixed in nearly the same way.

We do not currently know what causes this issue as it happens on some instances but not others. If you have more information, please let us know :)

• Inside of your ServiceNow instance, search for and click on "Scripted REST APIs"
• Search the Name field for "Grafana API" and open the record
• Remove the "Scripted REST External Default" ACL from the list and save the record
• In the same record, add the "Scripted REST External Default" ACL back into the list and save the record again

Currently you will see this on nearly every select box, but we plan to improve/fix this in a future update.

• To get past the "No options found" message, simply enter a space or start typing your desired option and the options will be updated to show actual values

Icons are based on CI Class and use RegEx.

• Clicking on a node in the Topology panel will display that CI's Class.
  • (Node labeled Starting Point will NOT display a class)
• In the panel options, go to the section called Icon Mapping. At the bottom of this section, click the Add Icon Mapping button.
  • (IGNORE the section called External Icon Mapping)
• Copy & paste or create a RegEx that matches the CI Class you saw in step 1.
• Then select an icon which will be mapped to all CI's whose Class matches your RegEx.

When changing data in the Topology panel, the icons will not load dynamically.

To fix the icons without reloading the entire page, follow the steps below.

• Click on the Refresh(🗘) symbol inside the panel. This will fix the icons, but your layout won't look right
• Click on the Tree structure symbol to fix the layout.

If you still see blank icons please double check your Icon Mapping RegEx to ensure it matches the CI Class of the node you are looking at. Click here to learn about creating an icon mapping

Also note that the "Starting Point" node shows a blank icon by default. This can be changed by adding an Icon Mapping entry with blank RegEx and your desired icon.

The plugin supports a wide variety of "Query Categories" allowing you to query data in different ways or perform special processing on the data. Each Query Category will provide you with different options to fill out in order to get the data your looking for.

• Metrics
• Alerts
• Changes
• Topology
• Live Agent Data
• Table
• Row Count
• Aggregate
• GeoHash Map
• Log Data
• Trend Data
• Outage Status
• Anomaly

Used to gather time-series metric data from CI's.

Used to gather Alerts(em_alert) along with some additional processing to determine impacted services, parse TBAC tags out of additional_info and more.

Used to query the Changes(change_request) table.

Used to recreate service mapping/topology diagrams. Must be used in combination with our included version of the Service Dependency Graph(forked from novatec-sdg-panel) panel plugin.

The table category allows you to query any table or database view inside your ServiceNow instance.