TeriStevenson
Frequent contributor

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

0 Kudos
3 Replies
TeriStevenson
Frequent contributor

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

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

0 Kudos
mfranz
Shining star

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

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

Softline Group is Europe's leading independent expert in Software Asset Management.
0 Kudos
TeriStevenson
Frequent contributor

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

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.

0 Kudos