Show/Use device IP-address from NotificationAgent update in Console
In VPN scenarios the DNS resolution is missing or delayed very often. To troubleshoot a device the current device IP-address is important.
You can force a DDR /heartbeat from the console, but this take a while until the information is arrived and actually it is unnecessary because the IP-address Information is already existing in the SCCM database from the NotificationAgent update cycle.
(SELECT v_GS_NETWORK_ADAPTER_CONFIGURATION.ResourceID, v_GS_NETWORK_ADAPTER_CONFIGURATION.IPAddress0, vSMS_R_SYSTEM.Netbios_Name0
inner join vSMS_R_SYSTEM on v_GS_NETWORK_ADAPTER_CONFIGURATION.ResourceID = vSMS_R_SYSTEM.ItemKey
where vSMS_R_SYSTEM.Netbios_Name0 = 'DEVICENAME')
It would be nice to get the Information directly in the console. And it would be nice as well, when the Client-Agent-Push use the IP-address info as fallback, too.