‎03-05-2020 08:39 PM
‎03-16-2020 04:26 PM
‎03-10-2020 12:26 AM
‎03-05-2020 11:00 PM
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
‎06-06-2023 03:54 PM
Y must be careful - inside the script is a NOT. So you get all except the one where the font is installed.
Although you have to filescan in front.
And user installed fonts are saved as file inside the user profile at
%userprofile%\AppData\Local\Microsoft\Windows\Fonts\xxxxx.ttf
‎03-06-2020 03:53 PM
‎03-06-2020 09:50 PM
Todd wrote:
I can find the registry keys no problem but I can't seem to get the font report to work. No matter what I do, it just shows up with every computer on the list regardless of if it has that font in the C:\windows\fonts folder or not.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now