Where does the App Broker License count come from with Device based licensing?

[a_cutler2]

A customer recently starting seeing the error in App Broker that says they are over their current licensing and need to address it, but they having Device based licensing (in Settings>General it actually says DESKTOP based, and the license type is Subscription) and I'm not sure what database table that information is coming from, because I'm used to User based licensing models where it comes from the WD_User table. Where can I see the details on what devices are consuming licenses? And will functionality of App Broker be affected at all in the meantime?

[CharlesW]

the following query is run against the SCCM DB in order to get the device based license count:

SELECT (COUNT(DISTINCT Name)) FROM v_FullCollectionMembership Where ResourceType = 5 AND IsActive = 1

[CharlesW]

And as an FYI, you won't see any loss of functionality, if you exceed your license count.