→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Esben_D
Lansweeper Employee
Lansweeper Employee
The report below gives back a list of clustered SQL servers.

The report will only list assets when the following criteria are met:
  • You have Lansweeper 7.1 or higher.
  • There is SQL Server Cluster data scanned.
  • The assets must be active.

Select Top 1000000 tblSqlServerCluster.Name As ClusterName,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblSqlServers.displayVersion As Edition,
tblSqlServers.skuName As License,
tblSqlServers.spLevel As [SQL SP],
tblSqlServers.serviceName As Service,
tblLanguages.Language As [SQL Language],
(Case
When tblSqlServers.Authentication = 0 Then 'Unkown'
When tblSqlServers.Authentication = 1 Then 'Windows Authentication'
Else 'SQL Server and Windows Authentication'
End) As [SQL Authentication],
tblAssets.IPAddress,
Case
When tblAssetCustom.Location Is Null Then ''
Else tblAssetCustom.Location
End As Location,
tsysIPLocations.IPLocation,
tsysOS.OSname As OS,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblSqlServers.AssetID
From tblSqlServers
Inner Join tblAssets On tblSqlServers.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSqlServerCluster On tblSqlServers.ClusterId =
tblSqlServerCluster.Id
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblLanguages On tblSqlServers.language = tblLanguages.LanguageCode
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where tblAssetCustom.State = 1
Order By ClusterName
0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now