How to Get Local Admin Users list from Client Machine using SCCM Harender Jangra

I have mentioned all steps that is required to configure SCCM Server to get local admin users list from Client Machine.
please find below query to get local admin users list from machine using SQL Server.
Query 1: List all clients with members of the local Administrators group:

from v_gs_localgroupmembers0 lgm

Query 2: List members of the local Administrators group on specific client:

from v_gs_localgroupmembers0 lgm
and sys1.Name0='clientname'

Query 3: List all clients with members of the local Administrators group excluding certain users or group :

'Domain Admins','wintelMonitoring','WintelAdmins','eskonr'

declare @PC nvarchar (255);set @PC='computername'
from v_gs_localgroupmembers0 lgm

[ilkerciftci]

Very nice video, it worked very well. Thank you.

[anwer]

Hi Harender, Nice video, shell we apply this VB script to SCCM1902?

[supriyatalks]

Hi Harender,
I followed this Video and deploy the configuration baseline to the client machine...but the configuration does not apper on the client machine...so i am not able to pull the data....i have did the basic troubleshoot and also uninstalled the SCCM client and reinstalled again also
but no luck...can you please suggest how to proceed further....

[gauravpaul]

sir ek site replication and troubleshooting k upar banaie video

[muhammedafsalkc]

Kashif

U can help me get the below details from SCCM
1) Report for local admin details For all sccm Users

Thanks

[RajKumar-zokl]

Hi harender, sccm install showing some error SQL service account failed showing pls help me