
This procedure is used to get the Device Manager Asset details based on the Resource IDs of the Assets.

USP_EX_SUMMIT_GetDeviceManagerByResourcecID This procedure is used to get the Software Asset details based on the Resource IDs of the Assets. This procedure is used to get the Hardware Asset details based on the Resource IDs of the Assets. This procedure is used to get the EXE file details based on the Resource IDs of the Assets. This procedure is used to get the Resource IDs of the Assets from the SCCM Database. This function is used to convert the comma separated value to table value. This function is used to trim the XML data. This View is used to get the Software installed on the Assets from the SCCM Database. This View is used to get the Hardware details of the Assets from the SCCM Database. This View is used to get the Device Manager details of the Assets from the SCCM Database. The following table describes the views, functions, and procedures that must be executed in the SCCM Database server:įile path: ~\SummitWeb\MDLAssetMgmt\AssetFiles\SCCM-Prerequest_Scripts.sql Prerequisites Prerequisites for SCCM Database Server Based on the configuration, you can import either full data or incremental data using the database. These data import processes use SUMMIT server or Proxy server to import appropriate data from the external database tables to the Asset Management module. Managing the life cycle of the Asset Management module using the imported data available in the SUMMIT application database. Scheduling data import from an external server to the SUMMIT application using the server plugin. The Asset integration consists of the following processes:

Thus, no additional SUMMIT Asset agent is required for such integrations.

In this integration process the data is directly collected from the SCCM and LANSWEEPER databases. LANSWEEPER Software Data Synchronization AdvantagesĬustomers can continue to use the client management software while they can use the data collected from Asset integration in SUMMIT application for a holistic Asset management experience. You can configure the LANSWEEPER Database server details to import the hardware and software Asset details so that you can schedule the following jobs: Software that are installed and their usage The following components are part of the LANSWEEPER integration process: Configuring Asset Category Using Form BuilderĬonfiguring Field Display Order on Fixed Asset List PageĬonfigure Software/Executable Execution Type
