→ 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: 
kevinoie
Engaged Sweeper III
HI.. Not sure if this is possible, but is there any way I can run a report over all my servers to find out if ths SNMP service is running?

Many Thanks,
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Please try this. You can add other subqueries for other services this way:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
SNMPService.[SNMP Service Started]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join (Select Top 1000000 tblServices.AssetID,
tblServices.Started As [SNMP Service Started]
From tblServices
Inner Join tblServicesUni On tblServices.ServiceuniqueID =
tblServicesUni.ServiceuniqueID
Where tblServicesUni.Name = 'SNMP') SNMPService On tblAssets.AssetID =
SNMPService.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1
Order By tblAssets.AssetName

View solution in original post

3 REPLIES 3
dawnlowery
Engaged Sweeper
Can this report also report client machines in addition to servers? Could it also report what community name(s) are being used? Such as public, private etc?
Hemoco
Lansweeper Alumni
dawnlowery wrote:
Can this report also report client machines in addition to servers?

Remove the tblComputersystem.Domainrole expression from your report by hitting the next to the expression.

dawnlowery wrote:
Could it also report what community name(s) are being used? Such as public, private etc?

No. Lansweeper only stores the SNMP credentials you submit in the Lansweeper web console under Configuration/Scanning Setup/Scanning Credentials and will never display these credentials in plain text. SNMP credentials are passwords; displaying them would be a security risk.
Hemoco
Lansweeper Alumni
Please try this. You can add other subqueries for other services this way:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
SNMPService.[SNMP Service Started]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join (Select Top 1000000 tblServices.AssetID,
tblServices.Started As [SNMP Service Started]
From tblServices
Inner Join tblServicesUni On tblServices.ServiceuniqueID =
tblServicesUni.ServiceuniqueID
Where tblServicesUni.Name = 'SNMP') SNMPService On tblAssets.AssetID =
SNMPService.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1
Order By tblAssets.AssetName