SQL Server Role

List Machines with the SQL Server Role

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,
  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

Run This Report in 3 Easy Steps


1. Download & Install Lansweeper


3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting