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

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

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now