Importing SCCM data into Assets

On this page

Still need help?

The Atlassian Community is here for you.

Ask the community

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

specific the Address of your SQL Server

e.g. 192.20.12.100\myDBInstance

or mysqlserver.example.com

SCCM Database Name

specified the name of your SCCM Database

Database Userspecified the name of the user that have readable access to the SCCM Database
Database Passwordthe password 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.

You can read more about that here:

https://blogs.msdn.microsoft.com/psssql/2015/01/09/jdbc-this-driver-is-not-configured-for-integrated-authentication/

Last modified on Dec 13, 2022

Was this helpful?

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