Hello All,

I seemed to have hit a brick wall when trying to compile a SCCM report for my boss. I'm trying to export a list of all devices (computers) within SCCM, which would include the following:

HostName,MAC Address, IP Address, Last Login\Activity

With this list, we would then cross check it with an internal inventory list provided from a third party solution.

Any help would be greatly appreciated!

Thank You All!

Have you looked at the built-in AI reports?

https://technet.microsoft.com/en-au/library/dn581998.aspx

Here is something quick I threw together, just a few caveats:

• Filtered to only return the first IP address. Removes IPv6 or any other additional IPs. 
• Only filters on MAC addresses that are not NULL
• Pick what column you want to determine when the client was last active, there are a few

select sys.Netbios_Name0, NETC.MACAddress0,  SUBSTRING(netc.IPAddress0,1,CHARINDEX(',',ipaddress0)-1), cs.LastOnline, cs.LastDDR, cs.LastHw, cs.LastStatusMessage, cs.LastActiveTime
from v_r_system SYS join
	 v_GS_NETWORK_ADAPTER_CONFIGURATION NETC ON sys.ResourceID = netc.ResourceID join
	 v_CH_ClientSummary CS ON sys.ResourceID = cs.ResourceID
where NETC.MACAddress0 IS NOT NULL