Flexera IT Asset Management
  • 30 Apr 2023
  • 2 Minutes to read
  • Dark
  • PDF

Flexera IT Asset Management

  • Dark
  • PDF

Article summary

Flexera lets enterprises gain visibility and control of IT assets, reduce ongoing software costs, and maintain continuous license compliance.

Types of Assets Fetched

This adapter fetches the following types of assets:

  • Devices


  1. MSSQL Server (required) - The DNS / IP Address of the Microsoft SQL Server your Flexera 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 port used for the connection.
  3. Database Name (required) - The name of the database inside the SQL Server. The common value is 'FNMSCompliance'.
  4. Inventory Database Name (optional, default: blank) - Specify the name of the Inventory Database that you want to fetch the software version, description, vendor, software path, and software name.
  5. Database Type (required) - Select the database server as the source for data: IM or FNMP. The common value is 'FNMP'.
  6. User Name (required) - A user name that has the Required Permissions to fetch assets.
  7. Password (required) - The user's password. The password must not include ";".
  8. For details on the common adapter connection parameters and buttons, see Adding a New Adapter Connection.


Advanced Settings


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 on the performance of all connections for this adapter.
  2. Remove duplicate hardware name (optional, default: false) - Select this option to avoid fetching multiple times devices with the same host name.
  3. Use AssetStatusID from the Asset Table (required, default: false) - Select whether the Status field uses the value in the Asset.AssetStatusID or AssetStatus.StatusDefaultValue.
    • If not selected, the Status obtains its value from the AssetStatus.StatusDefaultValue.
    • If selected, the Status obtains its value from the Asset.AssetStatusID of the Asset table.
  4. Do not fetch hostnames containing specific strings - Enter strings separated by commas. Devices that contain any of the strings will not be fetched.
  5. Query to fetch - From the drop-down select the query from which to fetch devices. Select either Basic Query which includes mostly data from the ComplianceComputer table, or select Additional Asset Information which also includes data from the Asset table.

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

Required Ports

Axonius must be able to communicate with the MSSQL Server via the following ports:

  • Microsoft SQL Server discovery port - 1433.
  • The specific port for the supplied named instance, if relevant.

Required Permissions

The value supplied in User Name must have read access to devices.


  • "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.

Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
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.