DATA Step, Macro, Functions and more

Query Active Directory with SAS and produce data set?

Reply
Frequent Contributor
Posts: 135

Query Active Directory with SAS and produce data set?

Is it possible to query my local Active Directory with SAS returning data set?

 

In this case I have a set of 2700 network Id (NID), that might be former/current/locked down status, but I want to connect to my AD and return any information like user name, dept, status, last login date.

 

I guess what I am asking is can I create a libname command or something similar given I have access to AD?  TIA.  -KJ

 

PS I know there are some PowerShell tools out there but I am already preprocessing my data to get the NID, and some security rights fields for the first phase of this project I thought I would check to see if I could get it all done in SAS and not have to use other tools.

PROC Star
Posts: 624

Re: Query Active Directory with SAS and produce data set?

Posted in reply to kjohnsonm

Are you trying to access a network drive from SAS? You can map a network drive in SAS using SAS Management Console. This is an Admin task.

Thanks,
Suryakiran
Frequent Contributor
Posts: 135

Re: Query Active Directory with SAS and produce data set?

Posted in reply to SuryaKiran

SuryaKiran,

No; I already do that in some cases. (meaning I do not use it offten but do use that feature with network file shares)

 

No I literally have a list of 2700 Network ids with access to a server I suport and I need to cross check if the users are still active AD users with rights or not.

 

So I have read my data with NID and group relationships parsed it as I need it, and I want to read from an Active Directory server like it was a libname sucking in all the info about the given 2700 users with a left join (the bonus info would to trap any nid not in the AD set and write indicator field).

 

My AD servers could have a over million of NID records so I really don't want a data dump of all of them if I do not have too...

but if i do, such is life. 8)  -Kj

 

Respected Advisor
Posts: 4,779

Re: Query Active Directory with SAS and produce data set?

Posted in reply to kjohnsonm
Frequent Contributor
Posts: 135

Re: Query Active Directory with SAS and produce data set?

Patrick,
That second doc seems perfect starting point. that is nice, thank you for your time. I do not think I have ever been directed to this dir as a shared local repository for sample code. -KJ
Ask a Question
Discussion stats
  • 4 replies
  • 176 views
  • 1 like
  • 3 in conversation