Jetzt Ausprobieren

All Assets in SQL Server Clusters Audit

Operating System

Find All Servers Part of an SQL Server Clusters

Discover and list all SQL Server Clusters within your network. Since clustered SQL Servers also need to be taken into account for licensing, it is important to have an accurate overview of all SQL Server clusters in addition to their specific hardware details. This audit gives you a complete overview of your SQL server clustering so you can get accurate information to be compliant for your licensing. All Assets in SQL Server Clusters

All Assets in SQL Server Clusters Query

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

Show

Hide