SMB v1 Report that has it enabled

[internalit1]

I am searching for a report that shows me which servers and workstations has SMB1Protocol enabled.

The SQL report presents me the output but not all the output is the sames as when i go to:
a workstation, select software, select features and click on SMB

Can anyone help me with this?

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblFeature.FeatureId,
tblFeature.featUniId,
tblFeatureUni.featureName
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblFeature On tblAssets.AssetID = tblFeature.AssetId
Inner Join tblFeatureUni On tblFeatureUni.featUniID = tblFeature.featUniId
Where tblFeature.featUniId = 185 And tblAssetCustom.State = 1

[Mister_Nobody]

Also we scan HKLM

SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters

SMB1

SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters

SMB2

[Mister_Nobody]

We use this report

Select Top (1000000) tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen As [Last successful scan],
  tblAssets.Lasttried As [Last scan attempt],
  tblFeatureUni.featureName,
  tblFeatureUni.featureCaption,
  tblFeatureUni.addedDate As DateAdded,
  tblFeature.Lastchanged
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblFeature On tblAssets.AssetID = tblFeature.AssetId
  Inner Join tblFeatureUni On tblFeatureUni.featUniID = tblFeature.featUniId
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
      tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblFeatureUni.featureName Like 'SMB1protocol%' And tblState.Statename =
  'Active'
Order By tblAssets.Domain,
  tblAssets.AssetName,
  tblFeatureUni.featureCaption

[cfizz343434]

That worked, thank you so much!!!!

[cfizz343434]

Any luck with this report and finding where SMBv1 is enabled/installed?