warning_2.pngWarning: This document contains instructions for adjusting app synchronization settings that can adversely affect your device data, user data, and/or user mapping settings in Incident IQ. As such, only qualified personnel should proceed with making adjustments to the settings outlined in this document.

Guide Overview

The following guide is designed to give district administrators an overview of the following topics:

  • A step-by-step guide on integrating an on-premise (non-cloud) version of a Destiny integration with Incident IQ

 

Guide Index

You can use the following links below to quickly navigate to a specific section in this document. To quickly return to this index, use the "Return to Index" link located at the end of any section.

  1. Setting up the SQL Database
  2. Configuring and Downloading the Destiny Executable File
  3. Setting up a Nightly Sync

 

Setting up the SQL Database

To install the Destiny on-premise integration app you will need to start off by connecting to the Destiny database in SQL Management Studio. Once connected, you will want to right-click on the SQL server in the Object Explorer tree and select Properties.

SCCM_Setup_002.png

In the Select a Page menu, click on the Security page.

SCCM_Setup_003.png

Under Server Authentication click on SQL Server and Windows Authentication mode (if this is not already selected). Click OK.

SCCM_Setup_004.png

The SQL service will need to restart if changes were made. This is done by right-clicking the SQL server node, and clicking Restart. Click OK and, if the SQL Server Agent service is running, you will also need to click OK to confirm it too should be restarted as well.

SCCM_Setup_005.png

In the Object Explorer tree, expand the Security folder, right-click the Logins folder and click New Login.

SCCM_Setup_006.png

Select SQL Server Authentication, provide a Login name, a password, and uncheck the Enforce password policy option.

SCCM_Setup_007.png

In the Select a Page menu, click on User Mapping. Locate the Destiny database in the primary list, and check the checkbox in the Map column next to it. In the Database role membership-list, click the db_datareader. Click OK.

SCCM_Setup_008.png

[Return to Index]

 

Configuring and Downloading the Destiny Executable File

You will now need to configure and download the executable file for the Destiny app to a local machine with access to your SQL server that runs overnight. To do so, begin by selecting Manage on the left navigation bar.

warning_2.pngImportant Note: If the Destiny App has not been installed yet, you should select Browse instead and install the app. After app installation is completed, you may access this app from the Manage menu. 

SCCM_Setup_012.png

This will take you to your Installed Apps page where you can select the Options button to access the Destiny app management.

Manage_Destiny_App.png

From here, click on the Sync Executable tab in the Destiny app.

Destiny_Setup_014.png

In the Sync Executable tab, begin by selecting the Default SQL Command Template to load based on the current version of your SQL server.

Destiny_Setup_015.png

You will now need to identify the following portion of the template code to edit your device categories information:

WHERE
[t].Level2ID IN (
156, -- Audio Visual
157, --Business Machines
160, --Computer Equipment
168, --Video Equipment
170, --Computers
175, --Printers
184, --Networking Equipment
206, --Software Media
302 --Classroom Equipment
--1211 --CTAE Misc.
)

 

To identify your device categories you will need to run the following query on the Destiny SQL server:

SELECT * FROM [CircCatAdmin].[AssetTemplate]

 

After you have run the query and identified the list of your categories you will need to delete the category information from the template code in the Destiny integration until you are left with the following:

WHERE
[t].Level2ID IN (

)

 

Now you will want to copy and paste the category codes separated by commas into the SQL template at which point your code will look similar to the following:

WHERE
[t].Level2ID IN (
1, 100, 101, 102
)

 

Once you have completed editing the predefined template, you will now need to enter the following information in the Database Connection Settings:

  • Server Name/IP
  • Database Name
  • Username
  • Password
  • Page Size

After these fields have been filled out, click on Download Executable. You will then need to run a manual sync of the app to ensure that all settings have been configured properly.

Destiny_Setup_016.png

[Return to Index]

 

Setting up a Nightly Sync

To schedule the sync to occur automatically, you'll need to create a task in Windows Task Manager. You can do so by searching for Administrative Tools and selecting Task Scheduler. This will open the Task Scheduler window.

Task_Scheduler_1.png

In the Task Scheduler window, start by clicking on Action > Create Basic Task...

Task_Scheduler_2.png

This will open the Create Basic Task Wizard. At the very least, you will need to provide a name for the new task. You can also add a task if desired. Once this is completed, click Next.

Task_Scheduler_3.png

In the next step, you will be asked to select when this task should Trigger. We recommend running it daily (overnight) for the most accurate user data. Please ensure that you set the task to run regardless of whether a user is logged in or not on the server. Once complete, click Next.

Task_Scheduler_4.png

For the next step, you will need to specify what action the task will take when running. Select Start a Program and then click Next.

Task_Scheduler_5.png

When specifying the action to perform, locate the file IncidentIQ.Connectors.MicrosoftAd.exe in the Program/script file browser. Supply the argument -service in the Add arguments field. And finally, you will need to indicate the path you unzipped the files to in the Start in field. Once complete, click Next.

Task_Scheduler_6.png

In the final step, you may review all of the settings of your task. Once you have completed your review, check Open the Properties dialog for this task when I click Finish option and then click the Finish.

SCCM_Setup_010.png

In the sync properties window, you will need to check Run whether user is logged on or not as well as Run with highest privileges. Click OK to complete the sync setup.

SCCM_Setup_011.png

[Return to Index]

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.