NEW report mac addresses

[alyam]

how to add in this query mac addresses?

SELECT distinct
CS.name0 as 'Computer Name',
CS.domain0 as 'Domain',
CS.UserName0 as 'User',
BIOS.SerialNumber0 as 'Bios serial',
SE.SerialNumber0 as 'System Enclosure serial',
CS.Manufacturer0 as 'Manufacturer',
CS.Model0 as 'model',
OS.Caption0 as 'OS',
RAA.SMS_Assigned_Sites0 as 'Site',
RAM.TotalPhysicalMemory0 as 'Total Memory',
sum(isnull(LDisk.Size0,'0')) as 'Hardrive Size',
sum(isnull(LDisk.FreeSpace0,'0')) AS 'Free Space',
CPU.Name0 AS 'CPU Name'
from
v_GS_COMPUTER_SYSTEM CS
right join v_GS_PC_BIOS BIOS on BIOS.ResourceID = CS.ResourceID
right join v_GS_SYSTEM SYS on SYS.ResourceID = CS.ResourceID
right join v_GS_OPERATING_SYSTEM OS on OS.ResourceID = CS.ResourceID
right join v_RA_System_SMSAssignedSites RAA on RAA.ResourceID = CS.ResourceID
right join V_GS_X86_PC_MEMORY RAM on RAM.ResourceID = CS.ResourceID
right join v_GS_Logical_Disk LDisk on LDisk.ResourceID = CS.ResourceID
right join v_GS_Processor CPU on CPU.ResourceID = CS.ResourceID
right join v_GS_SYSTEM_ENCLOSURE SE on SE.ResourceID = CS.ResourceID
join v_FullCollectionMembership fcm on fcm.resourceid=SYS.resourceid
where
LDisk.DriveType0 =3
and fcm.Collectionid= @Collection
group by
CS.Name0,
CS.domain0,
CS.Username0,
BIOS.SerialNumber0,
SE.SerialNumber0,
CS.Manufacturer0,
CS.Model0,
OS.Caption0,
RAA.SMS_Assigned_Sites0,
RAM.TotalPhysicalMemory0,
CPU.Name0

 

[Garth]

I would not recommend adding either IP or MAC to this query, as it will mean multiple row for most computers. One row for each NIC. aka 1 for each LAN post and 1 for Wifi.

 

[alyam]

I would not recommend adding either IP or MAC to this query, as it will mean multiple row for most computers. One row for each NIC. aka 1 for each LAN post and 1 for Wifi.

need ethernet + wifi adapter address

 

[Garth]

need ethernet + wifi adapter address

And how do you know what is a WIFI or ethernet adapter address vs a VPN or other?