Database Table Creation
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.
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.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 IT Asset Management 2024 R2.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 IT Asset Management and only applies to IT Asset Management in Flexera One. If you are using IT Asset Management 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 IT Asset Management 2024 R2.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 IT Asset Management will not be
impacted by this change; however, a schema upgrade is recommended for the adapter to work.
IT Asset Management 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.
IT Asset Management (Cloud)
Current