cancel
Showing results forĀ 
ShowĀ Ā onlyĀ  | Search instead forĀ 
Did you mean:Ā 

License query in SQL does not match available license count in FNMS

Hi,

We're having trouble with FNMP database showing correct license counts - this also affects App Portal.  App Portal will always show 0 license available when FNMS shows there are 30.

We ran the following query at the db for each ARKL tied to the Tableau Desktop Professional license and each query returns 0 available.  When we view the license entitlements in FNMS - it shows 30 available based on purchases.  Any ideas why the db queries don't retirn 30?

DECLARE @FlexeraID nvarchar(256)
DECLARE @SoftwareTitleID int

SET @FlexeraID = 'aarl://MGS-APP-00000246863'

SELECT @SoftwareTitleID = flexid.SoftwareTitleID FROM
dbo.SoftwareRecognitionFlexeraID() AS flexid WHERE
flexid.FlexeraID = @FlexeraID

SELECT ISNULL(SUM(available.AvailableReservations),0) [Available Licences]
FROM ( SELECT SoftwareLicenseID, AvailableReservations
FROM dbo.SoftwareLicenseGetAvailableGlobalTable(@SoftwareTitleID)
) AS available

(3) Replies

actual query is 

DECLARE @FlexeraID nvarchar(256)
DECLARE @SoftwareTitleID int

SET @FlexeraID = 'arl://MGS-APP-00000349885'

SELECT @SoftwareTitleID = flexid.SoftwareTitleID FROM
dbo.SoftwareRecognitionFlexeraID() AS flexid WHERE
flexid.FlexeraID = @FlexeraID

SELECT ISNULL(SUM(available.AvailableReservations),0) [Available Licences]
FROM ( SELECT SoftwareLicenseID, AvailableReservations
FROM dbo.SoftwareLicenseGetAvailableGlobalTable(@SoftwareTitleID)
) AS available

Hi,

The query works in my test environment (2020 R1). Did you double check the Flexera ID? Did you double check with other IDs?

Best regards,

Markward

I have tried other ARL's and the query always returns 0 available even though the license entitlements show the correct information.  We are still on 2017 R3 so I'm wondering if that is a bug with the version we are currently on.