Say you have an adapter with an import named "ImportCustomMetricLicenseDetails" which obtains source data from a spreadsheet or database with a query like the following that identifies unique names and consumption counts for licenses which you know to have a type of "Custom Metric":
SELECT LicenseName, ConsumptionCount FROM ...
You could then add a custom object query such as the following in the adapter to update the consumption counts:
UPDATE sl
SET NumberInstalled = i.ConsumptionCount
FROM dbo.SoftwareLicense sl
JOIN #ECMImport_ImportCustomMetricLicenseDetails i ON i.LicenseName = sl.Name
If your adapter is configured to use a permanent table (rather than temporary table) to hold the staged source data then change the "#ECMImport_ImportCustomMetricLicenseDetails" table name to "ECMImport_ImportCustomMetricLicenseDetails".
Note that custom object queries like this can only be used with adapters that run in FlexNet Manager Suite On-premises; they cannot be used with FlexNet Manager Suite Cloud / FlexeraOne ITAM.
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
Hi @emtmeta. You need a source to "tsart the connections. If your source is a a csv with 2 columns, License Name and Manual consumption, import that to a physical table; then use the update script provide to set consumption using a join to your physical table. Regards
Hi @emtmeta . Not complex at all. You just tick the box at the bottom of the properties tab - advanced properties, use physical table. Then you can work with that physical table using your other sql update queries.
Say you have an adapter with an import named "ImportCustomMetricLicenseDetails" which obtains source data from a spreadsheet or database with a query like the following that identifies unique names and consumption counts for licenses which you know to have a type of "Custom Metric":
SELECT LicenseName, ConsumptionCount FROM ...
You could then add a custom object query such as the following in the adapter to update the consumption counts:
UPDATE sl
SET NumberInstalled = i.ConsumptionCount
FROM dbo.SoftwareLicense sl
JOIN #ECMImport_ImportCustomMetricLicenseDetails i ON i.LicenseName = sl.Name
If your adapter is configured to use a permanent table (rather than temporary table) to hold the staged source data then change the "#ECMImport_ImportCustomMetricLicenseDetails" table name to "ECMImport_ImportCustomMetricLicenseDetails".
Note that custom object queries like this can only be used with adapters that run in FlexNet Manager Suite On-premises; they cannot be used with FlexNet Manager Suite Cloud / FlexeraOne ITAM.
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
