NG Report: DHCP servers USED by DHCP Windows clients

[Mister_Nobody]

I have generated report for you via AI code generator.
Run report and use filter to show needed DHCPs and assets from TOTAL part.
Empty DHCPs are ignored.
Why NG (next generation)? You must use LS 12.5+ with CTE support into Report Buider. Report is tested with SQL Server 2016 (level 130) and LS 12.6.

With AssetDhcpDetails As (Select tblAssets.AssetID,
      tblAssets.AssetName,
      tblNetwork.DHCPserver As DHCPServerOnClient,
      tblNetwork.IPAddress,
      tblNetwork.MACaddress
    From tblAssets
      Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
    Where tblNetwork.DHCPserver Is Not Null And tblNetwork.DHCPserver != N'' And
      tblNetwork.DHCPenabled = N'True'),
  DhcpSummary As (Select AssetDhcpDetails.DHCPServerOnClient,
      COUNT(*) As TotalNbr
    From AssetDhcpDetails
    Group By AssetDhcpDetails.DHCPServerOnClient)
Select Top 1000000 CombinedResults.AssetID,
  CombinedResults.AssetName,
  CombinedResults.DHCP_Network_Client_IP,
  CombinedResults.MAC_Address,
  CombinedResults.[Row Type],
  CombinedResults.hyperlink_name_DHCPServer,
  CombinedResults.hyperlink_DHCPServer,
  CombinedResults.TotalNbr,
  CombinedResults.backgroundcolor
From (Select '' As AssetID,
      '' As AssetName,
      '' As DHCP_Network_Client_IP,
      '' As MAC_Address,
      N'📊 TOTAL' As [Row Type],
      s.DHCPServerOnClient As hyperlink_name_DHCPServer,
      N'/quicksearch.aspx?q=' + s.DHCPServerOnClient As hyperlink_DHCPServer,
      s.TotalNbr,
      N'LightYellow' As backgroundcolor
    From DhcpSummary s
    Union All
    Select d.AssetID,
      d.AssetName,
      d.IPAddress As DHCP_Network_Client_IP,
      d.MACaddress As MAC_Address,
      N'🖥️ DETAIL' As [Row Type],
      d.DHCPServerOnClient As hyperlink_name_DHCPServer,
      N'/quicksearch.aspx?q=' + d.DHCPServerOnClient As hyperlink_DHCPServer,
      s.TotalNbr,
      N'LightGreen' As backgroundcolor
    From AssetDhcpDetails d
      Inner Join DhcpSummary s On d.DHCPServerOnClient = s.DHCPServerOnClient)
  As CombinedResults
Order By CombinedResults.[Row Type] Desc,
  CombinedResults.TotalNbr Desc,
  CombinedResults.AssetName

[Obi_1_Cinobi]

Hello there!

Thanks for sharing! We appreciate your effort!