Asset Auditor

Installation and configuration

• On-prem and Cloud

• Self-managed or Managed Cloud

• Live connections, Sisense Elasticubes, and Sisense Build to Destination

• Linux

Extract files from the zip archive

• QBeeQ Asset Auditor Code.sipynb

• QBeeQ Asset Auditor.smodel

• QBeeQ Asset Auditor Dashboards.dash

Enable Custom Code

1. Navigate to Admin Tab > Feature Management > Advanced Analytics.

2. Toggle Custom Code to on and click Save.

Import the data model and delete table

1. Locate the zip file and extract the QBeeQ Asset Auditor.smodel file

2. Navigate to the Data Tab and import the data model without assets, using the above file.

3. Open the model QBeeQ Asset Auditor

4. Delete the RESTAPIMetadataDataModels table from the model

Import custom code notebook

1. Click + Custom at the top of the Data Model page

2. Select Add Custom Code from the dropdown

3. Select Import Notebook

Open custom code in the notebook

1. Click + Custom at the top of the Data Model page

2. Select Add Custom Code from the dropdown

3. Select the Notebook named QBeeQ Asset Auditor Code

4. Click Open in Jupyter Notebook link. The Jupyter Notebook will open in a new browser tab.

Replace code variables

licensing_email = 'yourlicenseemail@mail.com'
hostname = "https://test.com"
bearerToken = "test" 
headers = {
            'Content-Type': 'application/json',
            'Authorization': 'Bearer ' + bearerToken
          }
TimeoutRequest=100 # set timeout for API request(default is 100)
model_skip= 0 # set 1 to skip the section Models
dashboard_skip=0 # set 1 to skip the section Dashboards
plugin_skip=0 # set 1  to skip the section Plugins

• Replace hostname with your Sisense URL
⚠️

When replacing the hostname, the new URL should not include the slash

✅ "https://myinstance.sisense.com"

❌ "https://myinstance.sisense.com/"

• Replace bearerToken with your Sisense bearer token
⚠️

The Sisense bearerToken is not the same as your individual API key and must be generated from the REST API

1. Navigate to Admin Tab > REST API
2. If not already selected, click 1.0
3. Scroll to locate and expand the authentication endpoints
4. Expand the GET/authentication/tokens/api endpoint



1. Click the Try it button
2. Click the Execute button
3. Copy the token from the response "token": "this_is_the_sample_token” and replace in the Notebook

Run code in notebook

1. Run the code in the Notebook by clicking Run > Run All Cells from the top menu bar

1. When completed successfully, save the Notebook

1. Leave the Notebook tab, but leave it open. Do not close the tab.

Add custom code RESTAPIMetadataDataModels

1. Click + Custom at the top of the Data Model page

2. Select Add Custom Code from the dropdown

3. Select the Notebook named QBeeQ Asset Auditor Code

4. Click Done

5. Hover over the table New Custom Code newNotebook, and click the three-dot menu

6. Rename the new table as RESTAPIMetadataDataModels

Build the Elasticube

1. Build the Elasticube and select Replace All

Import dashboards

1. Locate the zip file QBeeQ Asset Auditor Dashboards.dash

2. Create a new folder, named QBeeQ Asset Auditor

3. Hover over Dashboards list in the home page and click the + symbol.
1. You can also right-click anywhere in the dashboards list, or click on the menu of one of your existing folders to import a dashboard into a folder.

4. Select Import Dashboard from the menu.

5. Select QBeeQ Asset Auditor Dashboards.dash file and click OK

Troubleshooting

Using the Asset Auditor Dashboards

• Overview

• Data Models

• Data Models Utilization

• Dashboards

• Dashboards Validation

• Plugins

• Plugins Validation

• Users

• Users Validation

• The first dashboard provides a general overview of what is happening with that asset across the environment/tenants.

• The second dashboard identified areas of underutilization, errors, and issues. This dashboard also includes recommendations/next steps for taking action to address the above areas.

Interpreting the Asset Auditor Dashboards

Data Models

Tables

Columns

Dashboards

Widgets

Plugins

Editing the Asset Auditor Dashboards

Column_Types

Dashboard_Share

Dashboards

Dashboards_Validation

DataModels

Groups

License

Model_Validation

Models_Shares

Plugins

Tables_and_Columns

Tenants

Users

Users_with_Groups

Widgets