All Clustered Nodes

List All Clustered Nodes in Your Environment

Within a network, it is possible to have multiple independent servers working together to increase the availability and scalability of certain Windows features or applications, like SQL Server databases and Hyper-V virtual machines. This kind of setup is called a cluster and the machines within are called nodes. If one node fails, other nodes within the cluster take over the failed machine’s clustered tasks, a process known as failover. The concept of ensuring that a feature runs continuously without disruption is also called high availability (HA). Lansweeper will scan any type of cluster and the overview report below will provide a list of all clustered nodes scanned within your network. From the report, you can click through to the individual cluster nodes to take a look at the detailed information retrieved from the node itself.

All Clustered Nodes Query

COPY

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Memory,
  tsysAssetTypes.AssetTypeIcon16 As icon,
  tblWindowsCluster.Name As ClusterName,
  tblWindowsCluster.Fqdn,
  tblWindowsCluster.IpAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblWindowsClusterNode
  Inner Join tblWindowsCluster On tblWindowsCluster.WindowsClusterId =
    tblWindowsClusterNode.WindowsClusterId
  Inner Join tblAssets On tblAssets.AssetID = tblWindowsClusterNode.AssetId
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Order By ClusterName,
  tblAssets.AssetName

Show

Hide