Importing SCCM data into Assets

To import SCCM data into Assets, navigate to the Import section in the object schema configuration. Learn more about importing in Assets

Import type settings

Optional date patterns

You don't need to specify the date pattern in the general import configuration settings. However, it could be wise to specify them since you will get some improved performance.

Date Format

dd/MM/yyyy

Date/Time Format

dd/MM/yyyy hh:mm

Module specific configuration

Name

Description

SCCM SQL Server

Address of your SQL Server. For example:

  • 192.20.12.100\myDBInstance
  • mysqlserver.example.com
SCCM Database Name

Name of your SCCM Database.

Database UserName of the user that have readable access to the SCCM Database.
Database PasswordPassword for the selected user to connect to the SCCM Database.
Authentication Type*
  • SQL Server Authentication (default)
  • Native Authentication (Windows Kerberos)
  • Java Kerberos


*Note that the selection only modifies the internal connection string to the database server. It will add the following part to the connection string, where %s is the selected authentication type:

integratedSecurity=true;authenticationScheme=%s;

To use Kerberos you need to ensure that the system is able to create Kerberos tickets. Read more about Kerberos

Last modified on Mar 7, 2025

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.