How to get users from windows server -local user accounts

• midan1

  SSCertifiable

  Points: 5100

  More actions

  October 9, 2005 at 9:58 am

  #90213

  can sql server get to - local user accounts ??

  i wont to get all the users and the local groups from  Windows Server

  in my Server (Doamin)

  and insert to new table in sql server

  thnks

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  October 9, 2005 at 8:31 pm

  #596191

  you cannot get domain group members by using t-sql that I aware of.

  

• midan1

  SSCertifiable

  Points: 5100

  More actions

  October 11, 2005 at 12:59 pm

  #596636

  and if i am The ADMINISTRATOR ???

• noeld

  SSC Guru

  Points: 96590

  More actions

  October 11, 2005 at 2:09 pm

  #596652

  Are you using AD ?

  if Yes create a linked server and then interrogate it :

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/distributed_query.asp

  If no

  Then run:

  create table #t1 (data varchar(255))

  insert into #t1 exec master..xp_cmdshell 'net user'

  select  -- this parsing is just as a demo purpose you may need to change it for your own case   

         Left(data, charindex(' ', data, 1)) FirstCol,

         Substring(data,26,charindex(' ', data, 26)- 25) SecondCol,

         Substring(data,51,charindex(' ', data, 51) - 50) ThirdCol

  from #t1

  where data is not null

        and data not like '%\\%'

        and data not like 'The command completed successfully.%'

        and data not like '-----------------%'

  drop table #t1

   

  
  * Noel