MAC Address not visible

[shivendu_pandey]

Hi Team,

I created one custom report for showing MAC Address for all systems but the report is showing MAC for only few systems.
What can i do for getting MAC of all systems scanned by Lansweeper ?

Please reply ASAP.

[Hemoco · Accepted solution]

For Windows computers, you need to build a report based on tblNetwork, which stores a machine's network card(s). E.g.:

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblNetwork.Description As NIC,
tblNetwork.MACaddress,
tblNetwork.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1 And tblNetwork.IPEnabled = 1
Order By tblAssets.Domain,
tblAssets.AssetName,
NIC

[shivendu_pandey]

I figured out what the problem is - machines that are having more than one mac addresses are not displayed.But in that case also how to get mac for those machines.
Please reply ASAP.