Susan A posted a very nice report to flag the systems which might be vulnerable. I would add to that, I modified mine to add the column tblAssetCustom.State so the report can be sorted Active assets versus Inactive ones. My logic was that you would want to fix the Active ones first then go investigate your inactive ones since some may be retired but not yet out of the LS DB. or other reasons.
here is the report code Susan's report not mine, I only added one column, not taking any credit for this:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypename As [Asset Type],
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Scanserver,
tblAssetCustom.State,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Lasttriggered,
tblAssets.LastScheduled,
tblAssets.LastActiveScan,
tblAssets.LastIPScan,
tblAssets.LastLsPush,
tblAssets.ServiceVersion,
tblAssets.LsPushVersion
From tblAssets
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName Desc
