Hi,
Is there any way we can update consumed Consumed entitlements field using business adapter ?
i can not find the Consumed entitlements property in Licenses adpater.
Regards,
Junaid Vengadan
Jun 28, 2021 09:52 AM
I dug up an example of this to illustrate.
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.
Jul 07, 2021 11:51 PM
Take a look at the following forum thread which discusses this topic: Update Custom Metric license consumption automatically? (using adapter or other means)
Jun 28, 2021 09:11 PM
@ChrisG
Thanks a lot for the feedback.
but can we use this when we are using source as csv\xlsx ?
Seems the query mentioned in the article is for updating a fixed value.
Reagrds,
Junaid Vengadan
Jun 29, 2021 01:25 AM
Jun 29, 2021 01:32 AM
Jun 29, 2021 02:42 AM
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.
Regards
Jun 29, 2021 03:25 AM
@Nico_Erasmus
yeah , that's sounds the correct and simple way, thanks mate 🙂
@ChrisG thanks for the quick reply as always , really appreciated .
Cheers,
Junaid Vendagan
Jul 02, 2021 10:40 AM
I dug up an example of this to illustrate.
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.
Jul 07, 2021 11:51 PM
Jul 14, 2021 06:55 AM