show OpenSSH version

[JZastow]

any way to get a report to show the OpenSSH version? would like to add it to this report

Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassetcustom.Model,
tblassets.OScode,
tblassets.Memory,
tblassets.ServiceVersion,
tblassets.Version
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Where tblassetcustom.Model = 'HP t520 Flexible Series TC' And
tblassetcustom.State = 1

[rader · Accepted solution]

Try adding tblassetcustom.SSHServer to the query.

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tsysassettypes.AssetTypename,
  tsysassettypes.AssetTypeIcon10 As icon,
  tblassets.IPAddress,
  tblassetcustom.Model,
  tblassets.OScode,
  tblassets.Memory,
  tblassets.ServiceVersion,
  tblassets.Version,
  tblassetcustom.SSHServer
From tblassets
  Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
  Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Where tblassetcustom.Model = 'HP t520 Flexible Series TC' And
  tblassetcustom.SSHServer <> N'' And tblassetcustom.State = 1