cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
robertwileysr
Engaged Sweeper
I am trying to compile a report for our Linux devices that includes the FTP, SSH server type, and http title. Any help would be very appreciated. I don't see much about Linux queries in the forums and I don't see the table that contains this data.

Thanks!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
This information can be found in tblAssets and tblAssetCustom. See sample report below. To use the report, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL code we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the code applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetCustom.DNSName,
tblAssetCustom.HTTPTitle,
tblAssetCustom.FTPheader,
tblAssetCustom.SSHServer,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tsysAssetTypes.AssetTypename = 'linux' And tblAssetCustom.State = 1
Order By tblAssets.IPNumeric

View solution in original post

3 REPLIES 3
Hemoco
Lansweeper Alumni
This information can be found in tblAssets and tblAssetCustom. See sample report below. To use the report, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL code we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the code applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetCustom.DNSName,
tblAssetCustom.HTTPTitle,
tblAssetCustom.FTPheader,
tblAssetCustom.SSHServer,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tsysAssetTypes.AssetTypename = 'linux' And tblAssetCustom.State = 1
Order By tblAssets.IPNumeric
robertwileysr
Engaged Sweeper
Thanks for the response! There would be no issues if I was able to scan these with SSH, thats not an option for us at the current time.

When are basically just trying to gather the information we can with out SSH credentials.

Right now when I scan one of my linux servers I get the following info:

Asset Type: Linux
DNS Name: dnsname.domain.org
Http title: Apache Tomcat/5.0.28
FTP: 220 (vsFTPd 2.0.1)
SSH server: SSH-1.99-OpenSSH_3.9p1

I need to make a report pulling this data only.
Hemoco
Lansweeper Alumni
Linux machines are scanned with SSH. FTP and HTTP aren't queried for these devices, so cannot be reported on. The SSH server information can be found in the SSHServer field of tblAssetCustom.