Join us for the exclusive 2024 Summer Product Launch, secure your spot today!   – Save your seat 🍿

TRY NOW

SQL Server Role

Operating System

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

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

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.