SCCM 2006 : SCCM sql query to get clients on Metered Internet connection


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.

    Best answer

Leave an answer

Sorry, you do not have permission to answer to this question .