how to find a mac address in sccm web tools

V_RA_System_IPAddresses ON v_RA_System_MACAddresses.ResourceID = v_RA_System_IPAddresses.ResourceIDĬASE WHEN IPAddress0 like '%,%' THEN left(IPAddress0,CHARINDEX(',',IPAddress0)-1)

V_RA_System_ResourceNames ON v_RA_System_MACAddresses.ResourceID = v_RA_System_ResourceNames.ResourceID INNER JOIN V_RA_System_IPAddresses.IP_Addresses0 AS SELECT v_RA_System_ResourceNames.Resource_Names0 AS , WHERE CS.Operating_System_Name_and0 LIKE '%nt%server%' Join v_RA_System_IPAddresses IP on IP.ResourceID = CS.ResourceID RAM.TotalPhysicalMemory0/1024 as ,īIOS.ReleaseDate0 as 'BIOS Manufacture Date',įULL join v_GS_PC_BIOS BIOS on BIOS.ResourceID = CS.ResourceIDįULL join v_GS_OPERATING_SYSTEM OS on OS.ResourceID = CS.ResourceIDįULL join V_GS_X86_PC_MEMORY RAM on RAM.ResourceID = CS.ResourceIDįULL JOIN v_GS_PROCESSOR Processor on Processor.ResourceID=CS.ResourceIDįULL join v_GS_SYSTEM_ENCLOSURE SE on SE.ResourceID = CS.ResourceIDįULL join v_GS_COMPUTER_SYSTEM CU on CU.ResourceID = CS.ResourceID SCCM REPORT TO LIST IP ADDRESSES – FULL VERSION Order by A.Name0,c.IPAddress0 ,D.IP_Subnets0 Group by A.Name0,c.IPAddress0 ,D.IP_Subnets0 Inner Join v_RA_System_IPSubnets D ON A.ResourceID=D.ResourceID Inner join v_GS_NETWORK_ADAPTER_CONFIGUR C ON A.ResourceID=C.ResourceID Inner join v_FullCollectionMembership B on A.ResourceID=B.ResourceID SCCM REPORT TO LIST IP ADDRESSES – LITE VERSION

I normally just run the queries directly on the SQL DB, but you can also use SCCM Reporting and SCCM Queries under Monitoring.

Here are some common methods for dealing with IP addresses. So, when viewed, you’ll see 1-6 (or more) IP addresses all crammed together. A dirty little secret of Microsoft, and why you don’t see IP address columns in the SCCM console, is that MS stores all the IP addresses of a machine into a single row, into an array.

How to find a mac address in sccm web tools