
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-05-2013 08:38 AM
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.
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.
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-07-2013 05:19 PM
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
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-07-2013 05:19 PM
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-05-2013 02:55 PM
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.
Please reply ASAP.
