We noticed last week that AppPortal began sending approval emails showing negative license counts, even though Flexera shows available licenses.
We have confirmed the ARL that is linked to the license is also associated with the catalog item.
We ran the API that AppPortal used on the Flexera web server and the correct license count is returned: http://localhost/managesoftservices/complianceapiservice/complianceapiservice.asmx?op=SoftwareLicenseGetAvailableByFlexeraID
Then we viewed the available license in the Flexnet Database, we also reviewed all of the reservations. We removed all reservations on the Flexera Database.
DECLARE @FlexeraID nvarchar(256)
DECLARE @SoftwareTitleID int
SET @FlexeraID = 'arl://MGS-APP-00000240056'
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
Everything we run on the Flexera side is coming back properly, we just don't know where AppPortal is getting negative numbers on the email.
This is cumbersome, since we bypass approvals if a license is available, and we're being inundated with approval requests on applications that we have plenty of license for.
Any additional suggestions would very helpful.
Thanks in advance!
‎Aug 18, 2021 02:13 PM
You should open a support case for this. I haven't seen what you're describing. The only times I've seen a discrepancy between App Portal numbers and FNMS numbers have been associated with the reservations.
‎Aug 18, 2021 03:11 PM
If you are seeing a negative license count, then it almost always indicates that the account used to access FNMS does not have the appropriate permissions.. Please try using an account with admin permissions to see if the count looks better. One way or the other this is going to boil down to some type of FNMS issue.. App Broker simply acts on the value returned by the compliance API service in FNMS.
‎Aug 18, 2021 03:40 PM