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 vGSNETWORKADAPTERCONFIGURATION.ResourceID, vGSNETWORKADAPTERCONFIGURATION.IPAddress0, vSMSRSYSTEM.NetbiosName0
inner join vSMSRSYSTEM on vGSNETWORKADAPTERCONFIGURATION.ResourceID = vSMSRSYSTEM.ItemKey
where vSMSRSYSTEM.NetbiosName0 = '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.