SCCM 2006 : SCCM sql query to get clients on Metered Internet connection
Question
Experts, Do we have any SQL report available to know clients on metered internet connection.
Actually, we are in plan of migrating from cisco VPN to Zscaler ZPA and observed that the sccm client activities like policy request, heartbeat DDR, h/w scan, s/w scan, are not running and clients going into inactive.
From logs it was observed, Failed to get management points Error 0x87d00227.
Answers ( 2 )
I think the best option is to get CMPivot query:
Using the following registry to get the metered connection details.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\NetworkList\DefaultMediaCost.
Sure, Thank You Sir.