This query counts the quantity of the different SFP types provisioned on the network. It takes into account the models used for Multipon and GPON on the Lightspan platform, as well as ISAM platform (where the model is not defined, but assumed/known to be GPON). You can adjust your SFP model numbers as needed for those used in your environment.
SELECT
SUM(CASE WHEN intent_config LIKE '%3FE47581BF%' THEN 1 ELSE 0 END) AS Lightspan_MPM,
SUM(CASE WHEN intent_config LIKE '%3FE53441BC%' THEN 1 ELSE 0 END) AS Lightspan_GPON,
SUM(CASE
WHEN intent_config NOT LIKE '%3FE47581BF%'
AND intent_config NOT LIKE '%3FE53441BC%' THEN 1
ELSE 0
END) AS ISAM_GPON
FROM intent
WHERE intent_type = 'fiber';