This will return all devices with SMB v1, 2, or 3 set
SELECT name, type, key, data, CASE WHEN (name = 'SMB1' AND data = 1) THEN 'SMB Version 1' WHEN (name = 'SMB2' AND data = 1) THEN 'SMB Version 2' WHEN (name = 'SMB3' AND data = 1) THEN 'SMB Version 3' ELSE 'SMB is not enabled'END AS SMB_VersionFROM registry WHERE path LIKE 'HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters\%'AND name LIKE 'SMB%'
SELECT name, type, key, data,
CASE
WHEN (name = 'SMB1' AND data = 1) THEN 'SMB Version 1'
WHEN (name = 'SMB2' AND data = 1) THEN 'SMB Version 2'
WHEN (name = 'SMB3' AND data = 1) THEN 'SMB Version 3'
ELSE 'SMB is not enabled'
END AS SMB_Version
FROM registry WHERE path LIKE 'HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters\%'
AND name LIKE 'SMB%'