03-09-2018 01:13 PM
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.
03-09-2018 03:59 PM
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.
03-09-2018 04:14 PM
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
03-09-2018 05:07 PM
importad.sas could give you a starting point to get to the code you want to.
03-09-2018 05:35 PM