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
