Select tblWindowsCluster.Name As ClusterName,
  tblAssets.AssetID As ClusterNodeAssetId,
  tblAssets.AssetName As ClusterNodeName,
  tblAssets_2.AssetID As ClusterNodeSourceAssetId,
  tblAssets_2.AssetName As ClusterNodeSourceName,
  tblAssets_3.AssetID As ClusterNodeDestinationAssetId,
  tblAssets_3.AssetName As ClusterNodeDestinationName,
  tblHyperVGuest.Name As GuestName,
  tblHyperVGuest.GuestAssetId,
  Case tblWindowsClusterLog.Action
    When 0 Then 'None'
    When 1 Then 'Create'
    When 2 Then 'Move'
    When 3 Then 'Delete'
  End As Action,
  tblWindowsClusterLog.EventTimeCreated,
  tblWindowsClusterLog.EventId,
  Case tblWindowsClusterLog.EventLevelId
    When 2 Then 'Critical Error'
    When 3 Then 'Error'
    When 4 Then 'Warning'
    When 6 Then 'Information'
    When 8 Then 'Verbose'
  End As EventLevelId,
  tblNtlogMessage.Message
From tblWindowsClusterLog
  Left Join tblNtlogMessage On tblNtlogMessage.MessageID =
    tblWindowsClusterLog.EventMessageId
  Left Join tblWindowsCluster On tblWindowsCluster.WindowsClusterId =
    tblWindowsClusterLog.WindowsClusterId
  Left Join tblWindowsClusterNode On tblWindowsClusterNode.WindowsClusterNodeId
    = tblWindowsClusterLog.WindowsClusterNodeScannedId
  Left Join tblAssets As tblAssets On
    tblAssets.AssetID = tblWindowsClusterNode.AssetId
  Left Join tblWindowsClusterNode As tblWindowsClusterNode_2 On
    tblWindowsClusterNode_2.WindowsClusterNodeId =
    tblWindowsClusterLog.WindowsClusterNodeSourceId
  Left Join tblAssets As tblAssets_2 On tblAssets_2.AssetID =
    tblWindowsClusterNode_2.AssetId
  Left Join tblWindowsClusterNode As tblWindowsClusterNode_3 On
    tblWindowsClusterNode_3.WindowsClusterNodeId =
    tblWindowsClusterLog.WindowsClusterNodeDestinationId
  Left Join tblAssets As tblAssets_3 On tblAssets_3.AssetID =
    tblWindowsClusterNode_3.AssetId
  Left Join tblHyperVGuest On tblHyperVGuest.hypervguestID =
    tblWindowsClusterLog.HyperVGuestId