Some users may be experiencing issues when trying to access customer resources like the Case Portal or the Product Licensing Center. Our team is aware of the issue and is working to resolve it. Click here for more information.
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
User | Count |
---|---|
8 | |
6 | |
3 | |
3 |