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
āJan 21, 2021 06:46 PM
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
āJan 21, 2021 06:48 PM
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
āJan 22, 2021 06:33 AM
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.
āJan 22, 2021 10:26 AM