I hope this helps. You can look for specific fonts or even just put them all on the list. But this is what it would look like.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tsysOS.OSname,
tsysOS.Image As icon
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.AssetID Not In (Select tblFileVersions.AssetID
From tblFileVersions
Where tblFileVersions.FilePathfull Like '%Fonts\EXAMPLE.TTF' And
tblFileVersions.Found = 'True') And tblAssetCustom.State = 1
Order By tblAssets.AssetName
You can also read on scanning the registry for fonts. Here is the link for that.
https://www.lansweeper.com/knowledgebase/report-based-on-registry-keys/