I'm currently on 21.5.0.4
That KB definitely looks close, though my app type just says Custom, not Custom B2B. We've got a lot of hands in the pot, so it could be a matter of people not doing something correctly. Or it could be a bug. Thank you for providing the KB though.
I've attached the script I use. Like I said, I don't know where this came, so run at your own risk.
begin tran
Declare
--@VppAccountID INT = 15, ---vppaccount
@CoreUserID INT = 478 ---one admin coreuserid
-- @CoreUserID 478 = admin ID number as found in the console for an admin account. Head to https://mdmconsole.asd20.org/AirWatch/#/Admin/List, find a Global admin, and the end of the URL is the ID number. E.G. https://mdmconsole.asd20.org/AirWatch/Admin/Actions/Edit/478
DECLARE @REAID INT
DECLARE @ConcurrencyID UNIQUEIDENTIFIER
IF OBJECT_ID('tempdb..#REAIDs', 'U') IS NOT NULL
DROP TABLE #REAIDs;
CREATE TABLE #REAIDs
(RecommendedExternalApplicationID INT PRIMARY KEY, ConcurrencyID UNIQUEIDENTIFIER)
--REA's that are set to IsLicensed purchaseType and need to be deleted
INSERT INTO #REAIDs
SELECT lc.RecommendedExternalApplicationID, ConcurrencyID
FROM deviceApplication.VppLicenseCount lc
INNER JOIN deviceApplication.RecommendedExternalApplication rea
ON lc.RecommendedExternalApplicationID = rea.RecommendedExternalApplicationID
WHERE PurchaseType = 2 and producttype = 3 and applicationname =''
--this is for 1810+
DECLARE @RecommendedExternalApplications [deviceApplication].[RecommendedExternalApplicationIdAndConcurrency_DataType]
--Delete REA's with PurchaseType of 2 and if it's an unknown app
WHILE EXISTS(SELECT 1 FROM #REAIDs)
BEGIN
--this is for 1810+
INSERT INTO @RecommendedExternalApplications(RecommendedExternalApplicationID, ConcurrencyID)
SELECT TOP 100 RecommendedExternalApplicationID, ConcurrencyID
FROM #REAIDs
EXEC deviceApplication.RecommendedExternalApplication_Delete @RecommendedExternalApplications = @RecommendedExternalApplications, @CoreUserID = @CoreUserID
DELETE rea1 from #REAIDs rea1
INNER JOIN @RecommendedExternalApplications rea2
ON rea1.RecommendedExternalApplicationID = rea2.RecommendedExternalApplicationID
DELETE FROM @RecommendedExternalApplications
END
--rollback tran
commit tran
