Microsoft System Center Configuration Manager (SCCM)

Microsoft System Center Configuration Manager (SCCM) is a systems management software product for managing large groups of computers running Windows NT, Windows Embedded, macOS (OS X), Linux or UNIX, as well as Windows Phone, Symbian, iOS and Android mobile operating systems

Types of Assets Fetched

This adapter fetches the following types of assets:

• Devices

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. For details on the common adapter connection parameters and buttons, see Adding a New Adapter Connection.

Advanced Settings

1. 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.
2. 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.
3. 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.
4. 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.
5. Fetch v_GS_ADD_REMOVE_PROGRAMS software legacy table (required, default: False) - Select whether to fetch installed software information from v_GS_ADD_REMOVE_PROGRAMS software legacy table.
   • If enabled, all connections for this adapter will fetch installed software information from v_GS_ADD_REMOVE_PROGRAMS software legacy table.
   • If disabled, all connections for this adapter will not fetch installed software information from v_GS_ADD_REMOVE_PROGRAMS software legacy table.
6. Fetch files path table (required, default: True) - Select whether to fetch installed software path from the files path table.
   • If enabled, all connections for this adapter will fetch installed software path from the files path table.
   • If disabled, all connections for this adapter will not fetch installed software path from the files path table. When disabled, fetch process for this adapter will be faster.
7. Fetch v_GS_INSTALLED_SOFTWARE table (required, default: True) - Select whether to fetch installed software from the v_GS_INSTALLED_SOFTWARE table.
   • If enabled, all connections for this adapter will fetch installed software from the v_GS_INSTALLED_SOFTWARE table.
   • If disabled, all connections for this adapter will not fetch installed software from the v_GS_INSTALLED_SOFTWARE table. When disabled, fetch process for this adapter will be faster.
8. Fetch services information (required, default: True) - Select whether to fetch services information for each device.
   • If enabled, all connections for this adapter will fetch services information for each device.
   • If disabled, all connections for this adapter will not fetch services information for each device. When disabled, fetch process for this adapter will be faster.

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.