LsAgent Relay vs. Direct Connection Report

[Katgroup]

Hey Sweepies!

I've seen a couple customers requesting a report to see which assets are communicating via the LsAgent relay vs. a direction connection. Here's the report I've created:

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tsysassettypes.AssetTypeIcon10 As icon,
  tblassets.LastLsAgentDirect,
  tblassets.LsAgentVersionDirect,
  tblassets.LastLsAgentThroughRelay,
  tblassets.LsAgentVersionThroughRelay
From tblassets
  Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
  Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Where (tblassets.LastLsAgentDirect Is Not Null Or
    tblassets.LastLsAgentThroughRelay Is Not Null) And tblassetcustom.State = 1

[Obi_1_Cinobi]

Hello there!

Thanks for sharing! Awesome job!