Discover all machines within your network which have the designated SQL Server Role assigned to them. This role indicated the purpose of a specific machine in your environment an identify the use of a machine more easily. Lansweeper automatically retrieves this information when scanning a Windows computer. With the help of the report you can easily find all SQL Servers.
SQL Server Role Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblComputersystem.Lastchanged,
tsysOS.Image As icon
From tblComputersystem
Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblComputersystem.Roles Like N'%sqlserver%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName
