SNMP Service

[kevinoie]

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,

[dawnlowery]

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]

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 · Accepted solution]

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