cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Mister_Nobody
Honored Sweeper

LS scans some internet protocols: HTTP, HTTPS, FTP, SMTP, SNMP, SSH.

I have developed SQL report to show them:

 

 

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.HTTPTitle,
  tblAssetCustom.HttpServer,
  tblAssetCustom.HttpsServer,
  tblAssetCustom.FTPheader,
  tblAssetCustom.SMTPheader,
  tblAssetCustom.SnmpOID,
  tblAssetCustom.SSHServer
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where (tblAssetCustom.HTTPTitle <> '' Or tblAssetCustom.HttpServer <> '' Or
    tblAssetCustom.HttpsServer <> '' Or tblAssetCustom.FTPheader <> '' or tblAssetCustom.SMTPheader <> '' or tblAssetCustom.SnmpOID <>'' or tblAssetCustom.SSHServer <>'') And
  tblAssetCustom.State = 1

 

 

 

0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now