Data Sources

You can create multiple data source definitions under the Data Sources tab.

Screenshot 2024-11-15 at 15.37.47.png

1- Before starting the Data Source configuration, please add our application to the Object Schema role called “Object schema users“ as shown in the screenshot below for each Object Schema you want to use. You will find the Roles tab under the Schema Configuration.

Screenshot 2024-11-28 at 01.54.39.png

2- Click the Add Data Source button to add a new one.

3- Your data source definition should be given a unique name.

4- Write your AQL query to filter the objects from your JSM Assets.

Pro Tips:

  • If you don’t specify the Object Schema name (objectSchema) or the Object Schema ID (objectSchemaId), the query will run across the schemas. This is sometimes useful. On the other hand, if you have a very large number of objects, we recommend using the schema name or ID in your query.

  • Filter as much as possible and enjoy the advanced features of AQL by using the objectType or objectTypeId keywords.

  • currentUser() AQL function is helpful in case you want to filter according to the portal user.

 

Here are some example AQLs:

AQL

Description

AQL

Description

"Jira User" = currentUser()

This AQL filters all the objects across all schemas which have an attribute called “Jira User” with a “User” type. In case the attribute value is set as the Jira User of the person who is viewing the Portal Profile page, the objects will be displayed.

5- Click the Save and check AQL button. You will get the statistics about the AQL result for number of objects and object types.

In case there are no objects found there are 2 possibilities:

  1. The query may be incorrect. You need to review and update your query. If you are sure that the AQL is correct, that means the AQL doesn’t have a result for your user. You can create some objects as a test. You can move to the next step only if you have one or more objects in this test result.

  2. Our application doesn’t have read permission

 

6- There can be multiple object types in the query result. Commonly, every object type may have different attribute names. In that case, you can configure the list of attributes to be displayed for each object type. The screenshot below is an example where the results of the AQL are from 3 object types.

  • Managed Devices object type from Microsoft Intune object schema

  • Mobile Devices object type from Jamf object schema

  • Users object type from Micsoroft Entra ID object schema

You can select 4 attributes that will be displayed in the summary view. And more attributes to be displayed in the detailed view.

 

7- After selecting the attributes, you can decide whether to display the object's avatar. Enable/disable the “Show Avatars?” option as you like.

8- As the last item on this configuration page, you can select the JSM Servicedesks which this configuration will be available. This way, you can decide which AQLs are valid for which Servicedesk customers and organizations.

9- Click the Save button to save your configuration.

10- The Data Source record will be added to the table. By default, it will be in a disabled state. Click the toggle to enable it.

11- Add more data sources with different AQL queries.

12- Now, you can add the Header and Footer via the Admin tab.

13- Test your results by viewing your Portal Profile page on the service desk portal.