How to find Mac Address of reported systems..

[Guru_Prasad]

Dear Concern,

I am trying to generate report on system name v Mac address of all reported systems reported in Lansweeper. But, the report is partial and not showing complete list. When i tried to check few systems from (which are not reporting in SQL) http://<servername>/lansweeper, it shows the complete details. Not sure, why SQL query is not showing this data.

Please let me know how to generate complete report in SQL.

Thanks and Regards,
Guru.R

[Guru_Prasad]

Got it.. i could able to find the query. Thanks for the information. 🙂

[Guru_Prasad]

Hi,

Can you please let me know the query to collect Mac address information only for Ethernet adaptor along with computer name? Not sure how to filter with IPenabled=1. Please help.

regards,
Guru.R

[Guru_Prasad]

Is there a way to upload screenshot here.
Also, this query is showing mac of all types of network adaptors like bluetooth, wireless etc. Need only Mac address of Ethernet adaptor. Can this be possible?

[Hemoco]

Guru Prasad wrote:
Is there a way to upload screenshot here.
Also, this query is showing mac of all types of network adaptors like bluetooth, wireless etc. Need only Mac address of Ethernet adaptor. Can this be possible?

You can click the "attach" button on the right.
You can filter with ipenabled=1

[Guru_Prasad]

Here is the query iam using..

Select tblNetwork.Computername, tblNetwork.MACaddress
From tblNetwork

[Hemoco]

Guru Prasad wrote:
Here is the query iam using..

Select tblNetwork.Computername, tblNetwork.MACaddress
From tblNetwork

That should get you everything, do you have an example of what's missing but showing on the website?

[Hemoco]

Could you post your SQL please.