Database Table Creation

FlexNet Manager Suite (Cloud)

The staging server requires an operating version of Microsoft SQL Server 2012 or later. Any edition is suitable, including Microsoft SQL Server Express (if its limitations on CPU, RAM, and database size are adequate for your purposes). As described in Choosing a Staging Server, the staging database may be located on a separate staging server.

In the SQL\ subdirectory of your unzipped adapter archive, the script ADDM_staging.sql is provided for creating the staging database, its tables, and its stored procedure. Obviously, this must be run on the SQL Server instance that is to host the staging database.
Important: If you have been using an earlier version of ADDM, and are now migrating to BMC Discovery release 11 (or later), you must run the same ADDM_staging.sql script to update your staging database schema. If you are continuing to use ADDM release 10 (or earlier), the update to the staging database schema is not required, and you may omit it for now; but if you choose to apply the upgrade now (so that the staging database is prepared for any future migration to BMC Discovery 11 or later), you must also use the latest version of the FnmpADDMStage.exe executable from the same Adapter Tools for FlexNet Manager Suite 2021 R1.2.zip archive. This executable transfers BMC Discovery data (for any BMC Discovery/ADDM version) to the staging database, and is schema-aware for the upgraded staging database.

Using BMC Discovery to import printers and network devices into Flexera One

Using IT Asset Management in Flexera One provides you with the ability to use BMC Discovery to import printers and network devices into Flexera One. This functionality does not apply to FlexNet Manager Suite and only applies to IT Asset Management in Flexera One. If you are using FlexNet Manager Suite instead of Flexera One, this printer and network device data is ignored.

To import printers and network devices into Flexera One, you must use the latest version of the FnmpADDMStage.exe executable from the Adapter Tools for FlexNet Manager Suite 2021 R1.2.zip archive with new schema, which changes the staging version from 1.11 to 1.12. Other configuration changes remain the same – Flexera One customers using the new adapter from FlexNet Manager Suite will not be impacted by this change; however, a schema upgrade is recommended for the adapter to work. FlexNet Manager Suite Cloud customers should not upgrade to this latest version of the FnmpADDMStage.exe executable because the new functionality that is included only applies Flexera One.

FlexNet Manager Suite (Cloud)

Current