I could interpret your query here in a couple of ways:
Can you clarify which of these you're after? (Or if I've got it wrong entirely?! :-))
For #2, you can get this count by clicking on the system menu > FlexNet Manager Suite License menu option. What is shown will very based on the type of license(s) you have purchased, but the information will look something like the following:
Dec 18, 2021 09:23 PM
Hi ChrisG, thanks for answer.
It's about Flexera License Itself.
I already know about system menu > FlexNet Manager Suite License option, but need not to just see the counts, but automate export, so direct database query i believe will be most effective way.
Dec 20, 2021 12:37 AM
@Andrey_K - The details about the FlexNet License Key are encrypted to prevent a clever resource from changing the terms of the license key. This prevents your desire to obtain this information with a SQL Query.
Dec 20, 2021 06:23 AM
As @kclausen notes, the details of the license key itself are encrypted.
However to get the current number of devices consuming FlexNet Manager Suite licenses you can use the dbo.ComplianceComputerActiveForLicenseReconcile and dbo.ComplianceServersActiveList views in the compliance database to get the total number of devices, and number of server devices respectively.
SELECT TotalDeviceCount = COUNT(*) FROM dbo.ComplianceComputerActiveForLicenseReconcile SELECT ServerDeviceCount = COUNT(*) FROM dbo.ComplianceServersActiveList
Dec 21, 2021 03:43 AM
Thanks ChrisG for answer.
I'm using scripts provided in How Inventory Manager / FlexNet Manager Suite License Enforcement Works article, but your version is much clearer.
It's a pity that i can't get Flexera License count from DB. I was hoping that maybe there is some view or function, which provides this information.
Dec 21, 2021 03:55 AM
For reference on a partially related topic, here is another thread which discusses some ideas about using a business adapter to import FlexNet Manager Suite license consumption details: Adding Flexnet Manager license consumption to Flexnet Manager itself
Jan 04, 2022 03:51 AM