SQL Server Role

List Machines with the SQL Server Role

Diiscover 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

Click to Open - 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

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting