→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JZastow
Engaged Sweeper II

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

1 ACCEPTED SOLUTION
rader
Champion Sweeper III

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

View solution in original post

1 REPLY 1
rader
Champion Sweeper III

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