Cherwell IT Service Management (SQL)
  • 16 Aug 2022
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Cherwell IT Service Management (SQL)

  • Dark
    Light
  • PDF

Cherwell IT Service Management Database is a service desk platform enabling automation for process workflows, supporting tasks, and related approvals.
The Cherwell IT Service Management Database adapter uses SQL to fetch information about devices.

Types of Assets Fetched

This adapter fetches the following types of assets:

  • Devices

Parameters

  1. MSSQL Server (required) - The DNS / IP Address of the Microsoft SQL Server your Cherwell IT Service Management Database instance is using.
    • To use a specific named instance, the value supplied should be in the following format: {server_host}{instance_name}.
    • If no instance is supplied, the default instance will be used.
  2. Port (optional, default: 1433) - The required ports are:
    • Microsoft SQL Server discovery port - 1433.
    • The specific port for the supplied named instance, if relevant.
  3. Database (required, default: MGTPCSM) - The name of the database inside the SQL Server.
  4. User Name (required) - The credentials for a user account that has the required permissions to fetch assets.
    Note:
    • The best practice is to create a dedicated SQL local user for Axonius usage. For details on creating an Axonius user for Microsoft SQL Server, 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.

Cherwell.png

Advanced Settings

Note:

From Version 4.6, Advanced settings can either apply for all connections for this adapter, or you can set different advanced settings and/or different scheduling for a specific connection, refer to ​Advanced Configuration for Adapters.

  1. SQL pagination (required, default: 1000) - Set the number of results per page received for a given SQL query, to gain better control of the performance of all connections for this adapter.

  2. CI type name include list (optional) - Specify a comma-separated list of CI types (Configuration Items, such as: computer or mobile device.) in Cherwell.

    • If supplied, all connections for this adapter will only collect devices of the CI types provided in this list.
    • If not supplied, all connections for this adapter will not collect any devices of any CI type.
  3. Use Last Reconciled as Last Seen

    • If enabled, all connections for this adapter will map Cherwell's Last Reconciled field as the device's Last Seen field.
    • If disabled, all connections for this adapter will not map Cherwell's Last Reconciled field as the device's Last Seen field.
  4. Use Last Discovery as Last Seen - If enabled, all connections for this adapter will map Cherwell's Last Discovery field as the device's Last Seen field.

  5. Status include list (optional) - Only fetch devices with the specified status. Enter a list of statuses separated by commas.

  6. Fetch only deployed devices

    • If enabled, all connections for this adapter will fetch only deployed devices.
    • If disabled, all connections for this adapter will fetch all devices types.


Note:

For details on general advanced settings under the Adapter Configuration tab, see Adapter Advanced Settings.


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.



What's Next
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.