Microsoft System Center Configuration Manager (SCCM)

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:
   • The best practice is to create a dedicate SQL local user for Axonius usage. For details, see Creating a Local Read-Only User for Microsoft SQL Server.
   • If you are using a domain user, specify the domain and the user name in the following format: domain\username.
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.

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.