What is Asset Integration?
Organizations use specific client management solutions for configuration of their Assets and other management requirements. Some of these client management solutions also collect detailed hardware and software inventory information from the Endpoint Assets. While such solutions are designed to be used for client management requirements, they may not be efficient for managing the Assets. SummitAI Application provides the Asset Integration feature to manage the Assets of an organization, efficiently.
The following external database servers are associated with the Asset Integration process:
The following components are part of the SCCM integration process:
- Hardware
- Software that are installed and their usage
- Exe files
- Device Managers
You can configure the SCCM Database server details to import the hardware and software Asset details so that you can schedule the following jobs:
- SCCM Hardware Data Synchronization
- SCCM Software Data Synchronization
- SCCM Exe Data Synchronization
- SCCM Device Manager Data Synchronization
The following parameters are inherited from SCCM integration process:
SCCM Data Import Process
Microsoft SCCM Integration
The Microsoft SCCM integration is a one-direction import of SCCM data into the SummitAI Asset Management.
Scheduled imports bring relevant SCCM data into the SummitAI instance from an SCCM SQL Server database and map it to the tables in Asset Management.
The import is achieved via SummitAI Proxy Server. The integration keeps the SummitAI Asset Management synchronized with the SCCM SQL Server database, so that only relevant data is imported from the SCCM database to SummitAI.
Following is the process flow on how the SCCM data is imported into the SummitAI Asset Management:
- SummitAI Proxy receives the SCCM Discovered data
- SummitAI Proxy posts the data to Data Collector
- Data Collector stores the SCCM Discovered data in SummitAI Staging Tables
- Data moves from SummitAI Staging tables to SummitAI Discovery Tables
- Reports are generated from the Normalised Data that are available in SummitAI DB
After the data is imported from SCCM, the Customer can use Variance features, such as Hardware, Software, New Discovery, and Software Compliance can be generated.
Note: Data is imported only in Discovery Data Table and not into the Fixed Asset Inventory.
Advantages
- Customers can continue to use the client management software while they can use the data collected from Asset Integration in the SummitAI application for a holistic Asset Management experience.
- In this integration process the data is directly collected from the SCCM and Lansweeper databases. Thus, no additional SummitAI Asset Agent is required for such integrations.
Process
The Asset integration consists of the following processes:
- Scheduling data import from an external server to the SummitAI application using the server plugin.
- Managing the life cycle of the Asset Management module using the imported data available in the SummitAI application database.
These data import processes use Proxy Server to import appropriate data from the external database tables to the Asset Management module. Based on the configuration, you can import either full data or incremental data using the database.
Prerequisites
Prerequisites for SCCM Database Server
The following table describes the views, functions, and procedures that must be executed in the SCCM Database server:
File path: ~\SummitWeb\MDLAssetMgmt\AssetFiles\SCCM-Prerequest_Scripts.sql
Component | Description |
|---|---|
Views | |
Vw_EX_Summit_DeviceManager | This View is used to get the Device Manager details of the Assets from the SCCM Database. |
Vw_EX_Summit_Hardware | This View is used to get the Hardware details of the Assets from the SCCM Database. |
Vw_EX_Summit_Software | This View is used to get the Software installed on the Assets from the SCCM Database. |
Functions | |
FN_Ex_SUMMIT_RemoveHiddenChar | This function is used to trim the XML data. |
fn_SplitString | This function is used to convert the comma separated value to table value. |
Stored Procedures | |
USP_EX_SUMMIT_AM_GET_ResourcesIDs | This procedure is used to get the Resource IDs of the Assets from the SCCM Database. |
USP_EX_SUMMIT_GetEXEByResourcecID | This procedure is used to get the EXE file details based on the Resource IDs of the Assets. |
USP_EX_SUMMIT_GetHardwareByResourcecID | This procedure is used to get the Hardware Asset details based on the Resource IDs of the Assets. |
USP_EX_SUMMIT_GetSoftwareByResourcecID | This procedure is used to get the Software Asset details based on the Resource IDs of the Assets. |
USP_EX_SUMMIT_GetDeviceManagerByResourcecID | This procedure is used to get the Device Manager Asset details based on the Resource IDs of the Assets. |
Prerequisites for Lansweeper Database Server
The following table describes the views, functions and procedures that must be executed in the LansweeperDatabase server:
File path: ~\SummitWeb\MDLAssetMgmt\AssetFiles\LANSWEEPER-Prerequest_Scripts.sql
Component | Description |
|---|---|
Views | |
Vw_EX_Summit_Hardware | This View is used to get the Hardware details of the Assets from the Lansweeper Database. |
Vw_EX_Summit_Software | This View is used to get the Software installed on the Assets from the Lansweeper Database. |
Functions | |
FN_Ex_SUMMIT_RemoveHiddenChar | This function is used to trim the XML data. |
fn_SplitString | This function is used to convert the comma separated value to table value. |
Stored Procedures | |
USP_EX_SUMMIT_AM_GET_ResourcesIDs | This procedure is used to get the Resource IDs of the Assets from the Lansweeper Database. |
USP_EX_SUMMIT_GetHardwareByResourcecID | This procedure is used to get the Hardware Asset details based on the Resource IDs of the Assets. |
USP_EX_SUMMIT_GetSoftwareByResourcecID | This procedure is used to get the Software Asset details based on the Resource IDs of the Assets. |
Access Prerequisites for SCCM/Lansweeper:
SCCM/Lansweeper database server must be accessible from the SummitAI Server or Proxy Server based on the monitoring source configuration. SQL port (1433 default) to SCCM/Lansweeper Server must be opened for SUMMIT to send queries to the database. An SQL server authentication account or Windows Authentication account is required. This account requires following permissions:
- While using Transact-SQL statements, the authentication account requires ALTER ANY LINKED SERVER permission on the server or membership in the setupadmin fixed server role.
- While using Management Studio, the authentication account requires CONTROL SERVER permission or membership in the sysadmin fixed server role.
Accessing the Feature
In SummitAI application, you can view and schedule Asset Integration jobs on the ASSET INTEGRATION page and view the Asset Integration Status report on the ASSET INTEGRATION STATUS page. For more information about these pages, see Configuring Asset Integration Details and Asset Integration Status, respectively.