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

• Go to Admin tab > Feature Management > 5 clicks on Sisense Logo > Build section.

• Change the customCodeNotebookTimeoutSec.value to a higher value (1880).

• Click Save

• model_skip

• dashboard_skip

• plugin_skip

Using the Asset Auditor Dashboards

Overview

Data Models Overview

Data Models Utilization

Dashboards Overview

Dashboards Validation

Plugins

Editing the Asset Auditor Dashboards

Tables_and_columns

Dashboards

Plugins