Common Dashboards

Create a new Data Provider

For more information on how to create a Data Provider and Data Provider types, please see our Data Providers page.

1. Select Dashboards > Data Providers under Platform Features from the left side navigation.

   
2. Click + New.

3. Under General enter:

   • Name - Device Age

   • (Optional) Description

   • Data Provider Type - Adaptiva SQL

4. Under Data Sets click + Add Data Set and enter the following:

   • Name - Device age greater than 15 days

   • (Optional) Description

5. Click + Add Column and enter the following for Column Name, Column Display, Column Type for each of the associated columns that will be returned in the SQL query (see below):

   • ComputerName | Computer Name | Text

   • OfficeName | Office Name | Text

   • AdaptivaClientVersion | Adaptiva Client Version | Text

   • OSName | Operating System | Text

   • LastMessageReceiveTime | Last Message Received | Date-Time

   • numberdays | Number of Days Old | Whole Number

   • IPAddress | IP Address | Text

   
6. Click Save after each column information is entered.

7. Under Data Set Queries copy and paste the following SQL query into the Data Query tab field:

   Copy

   SELECT * 
   FROM (
       SELECT 
       device_name AS ComputerName
       , location AS OfficeName
       , version AS AdaptivaClientVersion
       , device_type AS OSName
       , [last_check-in] AS LastMessageReceiveTime
       , DATEDIFF(dd, [last_check-in], GETDATE()) AS numberdays
       , ip_address AS IPAddress
       FROM a_AdaptivaClientDetails
       WHERE DATEDIFF(dd, [last_check-in], GETDATE()) > 15
       ) data

   
8. Copy and past the following SQL query into the Count Query tab field:

   Copy

       SELECT COUNT(*) 
       FROM (
           SELECT 
           device_name AS ComputerName
           , location AS OfficeName
           , version AS AdaptivaClientVersion
           , device_type AS OSName
           , [last_check-in] AS LastMessageReceiveTime
           , datediff(dd, [last_check-in], getdate()) AS numberdays
           , ip_address AS IPAddress
           FROM a_AdaptivaClientDetails
           WHERE datediff(dd, [last_check-in], getdate()) > 15
           ) data

9. Click Submit.

10. Click Save.

For more information on how to create a Dashboard, please see our Dashboards and Dashboard Widgets pages.

1. Select Dashboards > Dashboards from the left side navigation..

2. Click + New.

3. Select Default Dashboard.

   
4. Click the pencil icon to change the Name to Device Age.

   
5. Click on the ellipses (...) from the column toolbar and select Add Widget > Table.

   
6. Enter the following:

   • Card Title - Device Age

   • Data Provider - Browse and select the data provider you created Device Age

   • Default Sort Column - NumDaysOld

   • Default Sort Ascending - Toggle OFF

   
7. Click OK.

8. Click Save.

You can click Preview to see if any devices have been inactive for longer than 15 days. Any device that is less than 15 days, will not be displayed.

For more information, please see our Subscriptions page.

The user Dashboard Subscription will send selected Roles an email notification with an Excel (.xlsx) file attached.

1. Select Dashboards > Subscriptions from the left side navigation.

2. Click + New.

3. Under Details enter the following:

   • Name - Send Email for Devices Inactive More than 15 Days

   • (Optional) Description

4. Under Email Settings enter your desired Email Subject Line and Email Body Text.

5. Click Browse and select the Roles you wish to notify.

   
6. Click Browse under Dashboard Settings and select the Device Age dashboard you created above.

7. Click OK.

8. Click Browse under Schedules and select a schedule when you would like this subscription to be run, this will the schedule when your specified Roles will receive the email notification.

   • We recommend a daily schedule since this is a daily accrual of inactive days.

9. Click Browse Next to Data Provider for Condition and select Device Age data provider created above. This will autofill the Data Set for condition dropdown with the data set you created: Device age greater than 15 days.

10. Click Save.

If you would like to test your subscription before your specified schedule, you can click the More dropdown and select Run Subscription.