cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
TurboGFF
Engaged Sweeper III
Hey, I'd like to create the following report

Asset type is cell phones, I would like to see "Asset Name, Model, Location, and custom fields 12,13, and 14. (Phone number, IMIE, and SIM card respectively)

Could anyone help me build it?

Thanks
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Try:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetCustom.Model,
tblAssetCustom.Location,
tblAssetCustom.Custom12,
tblAssetCustom.Custom13,
tblAssetCustom.Custom14,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tsysAssetTypes.AssetTypename = 'cell phone' And tblAssetCustom.State = 1

View solution in original post

12 REPLIES 12
TurboGFF
Engaged Sweeper III
Alright, thanks. I'll look into it and report any findings 🙂
Hemoco
Lansweeper Alumni
You will have to review the phone's documentation. The DeviceTester is not getting any data from SIP; it's pulling from HTTP instead.
TurboGFF
Engaged Sweeper III
Lansweeper DeviceTester 5.0.0.7
Scanning Lansweeper Service (on this machine)..
Status: Running
Version: 5.0.0.69
Pinging 172.18.123.21
Ping ok.
Scanning TCP ports..
Open ports:
80 (HTTP)
Closed ports:
21 (FTP)
22 (SSH)
23 (Telnet)
25 (SMTP)
135 (EPMAP)
139 (NetBIOS Session Service)
443 (HTTPS)
445 (SMB)
9100 (Jetdirect)
Scanning MAC..
00:04:F2:18:B5:0E
Scanning netbios (UDP)..
Could not scan netbios
Scanning SIP..
Error: No reply
Scanning HTTP..
Url: http://172.18.123.21
Response Uri: http://172.18.123.21/index.htm
Connection: close
Pragma:
no-store
no-cache
must-revalidate
Content-Length: 1902
Cache-Control: no-cache
Content-Type: text/html
Date: TUE, 07 MAY 2013 21:02:28 GMT
Expires: -1
Last-Modified: WED, 27 FEB 2013 17:45:02 GMT
Server: Polycom SoundPoint IP Telephone HTTPd
Title: Polycom - SoundPoint IP Configuration Utility
Scanning SNMP..
SNMP disabled or wrong community
Done.



Same issue. Unless our phones just can't give out SIP info. I'm generally unfamiliar with SIP and only know the basics.

Would there be an option on the phone itself that could be blocking this?
Hemoco
Lansweeper Alumni
Could you re-run this test on your Lansweeper server. Tests performed from other machines are not reliable and cannot be used for troubleshooting purposes.
Hemoco
Lansweeper Alumni
Please perform a connection test to one of these devices using the DeviceTester.exe found under Program Files (x86)\Lansweeper\Actions on your Lansweeper server. This will show which protocols are open and which data can be retrieved.

If the device was scanned, all recoverable data should already be listed on the device's Lansweeper webpage.
TurboGFF
Engaged Sweeper III
Lansweeper wrote:
Please perform a connection test to one of these devices using the DeviceTester.exe found under Program Files (x86)\Lansweeper\Actions on your Lansweeper server. This will show which protocols are open and which data can be retrieved.

If the device was scanned, all recoverable data should already be listed on the device's Lansweeper webpage.



Lansweeper DeviceTester 5.0.0.7
Scanning Lansweeper Service (on this machine)..
Status: Service not found
Version: Executable not found
Pinging 172.18.123.13
Ping ok.
Scanning TCP ports..
Open ports:
80 (HTTP)
Closed ports:
21 (FTP)
22 (SSH)
23 (Telnet)
25 (SMTP)
135 (EPMAP)
139 (NetBIOS Session Service)
443 (HTTPS)
445 (SMB)
9100 (Jetdirect)
Scanning MAC..
00:04:F2:1B:40:47
Scanning netbios (UDP)..
Could not scan netbios
Scanning SIP..
Error: No reply

Scanning HTTP..
Url: http://172.18.123.13
Response Uri: http://172.18.123.13/index.htm
Connection: close
Pragma:
no-store
no-cache
must-revalidate
Content-Length: 1902
Cache-Control: no-cache
Content-Type: text/html
Date: TUE, 07 MAY 2013 17:00:41 GMT
Expires: -1
Last-Modified: WED, 27 FEB 2013 13:46:40 GMT
Server: Polycom SoundPoint IP Telephone HTTPd
Title: Polycom - SoundPoint IP Configuration Utility
Scanning SNMP..
SNMP disabled or wrong community

WARNING: LANSWEEPER SERVICE NOT FOUND!
Done.
Hemoco
Lansweeper Alumni
Lansweeper can only scan network devices that have one or more of the following protocols enabled: FTP, HTTP, HTTPS, JetDirect, SIP, SMTP, SNMP (SNMPv1 or SNMPv2), SSH or Telnet.
TurboGFF
Engaged Sweeper III
Lansweeper wrote:
Lansweeper can only scan network devices that have one or more of the following protocols enabled: FTP, HTTP, HTTPS, JetDirect, SIP, SMTP, SNMP (SNMPv1 or SNMPv2), SSH or Telnet.



You mention SIP scanning. How would I get that set up? I have Polycom Soundpoint SIP phones.

LS does find them, and categorizes them as VoIP devices, and gives me IP addresses, but can it also give me the line information on the phones?

Thanks!
TurboGFF
Engaged Sweeper III
You need to add them as an asset manually.