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: select sys1.netbios_name0 ,lgm.name0 [Name of the local Group] ,lgm.account0 as [Account Contained within the Group] ,lgm.domain0 [Domain for Account] , lgm.type0 [Type of Account] from v_gs_localgroupmembers0 lgm join v_gs_workstation_status ws on ws.resourceid=lgm.resourceid join v_r_system sys1 on sys1.resourceid=lgm.resourceid where lgm.name0='Administrators' order by sys1.netbios_name0, lgm.name0, lgm.account0 Query 2: List members of the local Administrators group on specific client: select sys1.netbios_name0 ,lgm.name0 [Name of the local Group] ,lgm.account0 as [Account Contained within the Group] , lgm.category0 [Account Type] , lgm.domain0 [Domain for Account] , lgm.type0 [Type of Account] from v_gs_localgroupmembers0 lgm join v_gs_workstation_status ws on ws.resourceid=lgm.resourceid join v_r_system sys1 on sys1.resourceid=lgm.resourceid where lgm.name0='Administrators' and sys1.Name0='clientname' order by sys1.netbios_name0, lgm.name0, lgm.account0 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' select sys1.netbios_name0 ,lgm.name0 [Name of the local Group] ,lgm.account0 as [Account Contained within the Group] ,lgm.domain0 [Domain for Account] , lgm.type0 [Type of Account] from v_gs_localgroupmembers0 lgm join v_gs_workstation_status ws on ws.resourceid=lgm.resourceid join v_r_system sys1 on sys1.resourceid=lgm.resourceid where lgm.name0='Administrators' -- and sys1.name0=@pc and lgm.account0 not in ('Domain Admins','wintelMonitoring','WintelAdmins','eskonr') order by sys1.netbios_name0, lgm.name0, lgm.account0