Microsoft System Center Configuration Manager (SCCM)
  • 2 Minutes To Read
  • Print
  • Share
  • Dark
    Light

Microsoft System Center Configuration Manager (SCCM)

  • Print
  • Share
  • Dark
    Light

The Microsoft System Center Configuration Manager (SCCM) adapter uses SQL to fetch information about devices.

Adapter Parameters

  1. SCCM/MSSQL Server (required) - The DNS / IP Address of the Microsoft SQL Server your SCCM instance is using.
  2. Port (optional, default: 1433).
  3. Database (required) - The name of the database inside the SQL Server (Usually starts with "CM_").
  4. User Name (required) - A user name with read-only permissions .
    Important Notes:
  5. Password (required) - The user's password. The password must not include ";".
  6. Choose Instance (required, default: 'Master') - The Axonius node to utilize when connecting to MSSQL Server. For more details, see Connecting Additional Axonius Nodes.
  7. Connection Label (optional, default: empty) - An optional label to help distinguish between multiple connections for the same adapter. This label will be concatenated to the relevant Adapter Name in the Device/User Profile page and the full text will be visible when hovering over the Adapters column in the Devices/Users pages.
    • If supplied, the label will be appended to the adapter name.
    • If not supplied, only the adapter name will be displayed.

image.png

Troubleshooting

  • "Login failed" - If you are using a domain user, in the User Name field, specify the domain and the user name in the following format: domain\username.

Configuring SCCM Advanced Settings

To configure the Lansweeper adapter advanced settings, open the SCCM adapter page, click Advanced Settings, and then click the SCCM Configuration tab:

  • Exclude IPv6 addresses (required, default: False) - Choose whether to fetch IPv6 addresses.
    • If enabled, all connections for this adapter will fetch only IPv4 addresses.
    • If disabled, all connections for this adapter will fetch both IPv4 and IPv6 addresses.
  • Do not fetch devices without 'Last Seen' (required, default: False) - Choose whether to fetch devices without Last Seen date.
    • If enabled, all connections for this adapter will not fetch devices if they do not have a Last Seen indication.
    • If disabled, all connections for this adapter will fetch devices even if they do not have a Last Seen indication.
  • SQL pagination (required, default: 1000) - Set the number of results per page received for a given SQL query, to gain better control on the performance of all connections of for this adapter.
  • Machine domain whitelist (optional, default: empty) - Specify a comma-separated list of SCCM domains.
    • If supplied, all connections for this adapter will only collect devices from the domains provided in this list.
    • If not supplied, all connections for this adapter will collect devices from any domain.

image.png

Was This Article Helpful?