def execute(srv, usr, pwd):
# server = Server('srv1.test.ru')
server = Server(srv)
conn = Connection(server, auto_bind=True, user=usr, password=pwd)
#'userAccountControl' can have these values: 512 Enabled Account; 514 Disabled Account;
# conn.search('ou=АСУ,dc=test,dc=ru','(&(objectClass=person)(userAccountControl=66048))',SUBTREE, attributes =['cn','proxyAddresses','department','sAMAccountName', 'displayName', 'telephoneNumber', 'ipPhone', 'streetAddress','title','manager','objectGUID','company','lastLogon'])
conn.search(
"dc=test,dc=ru",
"(&(objectCategory=Person)(!(UserAccountControl:1.2.840.113556.1.4.803:=2)))",
SUBTREE,
attributes=[
"cn",
"proxyAddresses",
"department",
"sAMAccountName",
"displayName",
"telephoneNumber",
"ipPhone",
"streetAddress",
"title",
"manager",
"objectGUID",
"company",
"lastLogon",
],
)
# get or create default organization
try:
org = Organization.objects.get(name="Не указано")
except:
org = Organization(name="Не указано")
org.save()
# get or create default organization
try:
dep = Subdivision.objects.get(name="Не указано")
except:
dep = Subdivision(organization=org, name="Не указано")
dep.save()
for entry in conn.entries:
print("")
print(" -------------------------- ")
print("entry.cn", entry.cn)
# print('entry.objectGUID', entry.objectGUID)
# search person in contact app
try:
displayName = entry.displayName
except:
displayName = entry.cn
print("displayName", displayName)
try:
person_obj = Person.objects.get(ad_objectguid=entry.objectGUID)
except:
person_obj = None
print("person_obj", person_obj)
if person_obj:
person_obj.name = displayName
# person_obj.ad_objectguid = entry.objectGUID
person_obj.save()
else:
person_obj = Person(name=displayName, ad_objectguid=entry.objectGUID)
person_obj.save()
print("Человек: ", person_obj)
try:
ldapinfo_obj = LdapInfo.objects.get(person=person_obj)
except:
ldapinfo_obj = None
# add AD sAMAccountName
if ldapinfo_obj:
try:
ldapinfo_obj.samaccountname = entry.sAMAccountName
ldapinfo_obj.save()
except:
pass
else:
try:
sAMAccountName = LdapInfo(person=person_obj, samaccountname=entry.sAMAccountName)
sAMAccountName.save()
except:
pass
# add AD lastLogon
if ldapinfo_obj:
try:
ldapinfo_obj.lastlogon = convert_ad_timestamp(int(entry.lastLogon.value))
ldapinfo_obj.save()
except:
pass
else:
try:
lastLogon = LdapInfo(person=person_obj, lastlogon=convert_ad_timestamp(int(entry.lastLogon.value)))
lastLogon.save()
except:
pass
# delete all person phones in contact app
phones = Phone.objects.filter(person=person_obj)
if phones:
phones.delete()
# add phones to contact from Active Directory user entry
try:
newphone = Phone(person=person_obj, number=entry.telephoneNumber)
newphone.save()
except:
pass
try:
newphone = Phone(person=person_obj, number=entry.ipPhone)
newphone.save()
except:
pass
# delete all emails in contact app
emails = Email.objects.filter(person=person_obj)
if emails:
emails.delete()
# add emails to contact app from Active Directory user entry
try:
new_email = Email(person=person_obj, address=entry.proxyAddresses)
new_email.save()
except:
pass
# get organization
try:
entry_company = entry.company
except:
entry_company = None
organization = None
if entry_company:
try:
organization_obj = Organization.objects.get(name=entry.company)
except:
organization_obj = Organization(name=entry.company)
organization_obj.save()
else:
organization_obj = org
print("Организация: ", organization_obj.name)
entry_company = None
# get or create subdivision
try:
entry_subdiv = entry.department
except:
entry_subdiv = None
subdiv = None
if entry_subdiv:
print("len entry.department %s: %s" % (entry.department, len(entry.department)))
try:
subdiv = Subdivision.objects.get(organization=organization_obj, name=entry.department)
except:
subdiv = Subdivision(organization=organization_obj, name=entry.department)
subdiv.save()
else:
subdiv = dep
print("Подразделение: ", subdiv.name)
entry_subdiv = None
# get person position
try:
position = entry.title
except:
position = None
print("Должность", position)
# create employee
employee = None
try:
employee = Employee.objects.get(
organization=organization_obj, subdivision=subdiv, person=person_obj, position=position
)
print("Найден работник")
except:
employee = Employee(organization=organization_obj, subdivision=subdiv, person=person_obj, position=position)
employee.save()
print("Создан работник")
def execute(srv, usr, pwd):
#server = Server('srv1.test.ru')
server = Server(srv)
#conn = Connection(server,auto_bind=True,user='******',password='******')
conn = Connection(server, auto_bind=True, user=usr, password=pwd)
'''
'userAccountControl' can have these values:
512 Enabled Account
514 Disabled Account
544 Enabled, Password Not Required
546 Disabled, Password Not Required
66048 Enabled, Password Doesn't Expire
66050 Disabled, Password Doesn't Expire
66080 Enabled, Password Doesn't Expire & Not Required
66082 Disabled, Password Doesn't Expire & Not Required
262656 Enabled, Smartcard Required
262658 Disabled, Smartcard Required
262688 Enabled, Smartcard Required, Password Not Required
262690 Disabled, Smartcard Required, Password Not Required
328192 Enabled, Smartcard Required, Password Doesn't Expire
328194 Disabled, Smartcard Required, Password Doesn't Expire
328224 Enabled, Smartcard Required, Password Doesn't Expire & Not Required
328226 Disabled, Smartcard Required, Password Doesn't Expire & Not Required
'''
#conn.search('ou=АСУ,dc=test,dc=ru','(&(objectClass=person)(userAccountControl=66048))',SUBTREE, attributes =['cn','proxyAddresses','department','sAMAccountName', 'displayName', 'telephoneNumber', 'ipPhone', 'streetAddress','title','manager','objectGUID','company','lastLogon'])
#conn.search('dc=test,dc=ru','(&(objectCategory=Person)(!(UserAccountControl:1.2.840.113556.1.4.803:=2)))',SUBTREE, attributes =['cn','proxyAddresses','department','sAMAccountName', 'displayName', 'telephoneNumber', 'ipPhone', 'streetAddress','title','manager','objectGUID','company','lastLogon'])
conn.search('dc=test,dc=ru',
'(&(objectCategory=Person))',
SUBTREE,
attributes=[
'cn', 'proxyAddresses', 'department', 'sAMAccountName',
'displayName', 'telephoneNumber', 'ipPhone',
'streetAddress', 'title', 'manager', 'objectGUID',
'company', 'lastLogonTimeStamp', 'userAccountControl'
])
#get or create default organization
try:
org = Organization.objects.get(name="Не указано")
except:
org = Organization(name='Не указано')
org.save()
#get or create default organization
try:
dep = Subdivision.objects.get(name="Не указано")
except:
dep = Subdivision(organization=org, name="Не указано")
dep.save()
out_file = 'import_cont_from_ad_out.txt'
try:
os.remove(out_file)
except OSError:
pass
debug_file = open(out_file, 'w', encoding="utf-8")
debug_file.write(
"%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\n" %
('cn', 'proxyAddresses', 'department', 'sAMAccountName', 'displayName',
'telephoneNumber', 'ipPhone', 'streetAddress', 'title', 'manager',
'objectGUID', 'company', 'lastLogon', 'AD-User-Account-Disabled'))
for entry in conn.entries:
try:
out1 = entry.cn
except:
out1 = 'None'
try:
out2 = entry.proxyAddresses
except:
out2 = 'None'
try:
out3 = entry.department
except:
out3 = 'None'
try:
out4 = entry.sAMAccountName
except:
out4 = 'None'
try:
out5 = entry.displayName
except:
out5 = 'None'
try:
out6 = entry.telephoneNumber
except:
out6 = 'None'
try:
out7 = entry.ipPhone
except:
out7 = 'None'
try:
out8 = entry.streetAddress
except:
out8 = 'None'
try:
out9 = entry.title
except:
out9 = 'None'
try:
out10 = entry.manager
except:
out10 = 'None'
try:
out11 = entry.objectGUID
except:
out11 = 'None'
try:
out12 = entry.company
except:
out12 = 'None'
try:
out13 = convert_ad_timestamp(int(entry.lastLogonTimeStamp.value))
#out13 = entry.lastLogonTimeStamp
except:
out13 = 'None'
try:
out14 = entry.userAccountControl
except:
out14 = 'None'
debug_file.write(
"%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\n" %
(out1, out2, out3, out4, out5, out6, out7, out8, out9, out10,
out11, out12, out13, out14))
print('')
print(' -------------------------- ')
print('entry.cn', entry.cn)
#print('entry.objectGUID', entry.objectGUID)
debug_file.close()
def execute(srv, usr, pwd):
#server = Server('srv1.test.ru')
server = Server(srv)
#conn = Connection(server,auto_bind=True,user='******',password='******')
conn = Connection(server,auto_bind=True,user=usr,password=pwd)
'''
'userAccountControl' can have these values:
512 Enabled Account
514 Disabled Account
544 Enabled, Password Not Required
546 Disabled, Password Not Required
66048 Enabled, Password Doesn't Expire
66050 Disabled, Password Doesn't Expire
66080 Enabled, Password Doesn't Expire & Not Required
66082 Disabled, Password Doesn't Expire & Not Required
262656 Enabled, Smartcard Required
262658 Disabled, Smartcard Required
262688 Enabled, Smartcard Required, Password Not Required
262690 Disabled, Smartcard Required, Password Not Required
328192 Enabled, Smartcard Required, Password Doesn't Expire
328194 Disabled, Smartcard Required, Password Doesn't Expire
328224 Enabled, Smartcard Required, Password Doesn't Expire & Not Required
328226 Disabled, Smartcard Required, Password Doesn't Expire & Not Required
'''
#conn.search('ou=АСУ,dc=test,dc=ru','(&(objectClass=person)(userAccountControl=66048))',SUBTREE, attributes =['cn','proxyAddresses','department','sAMAccountName', 'displayName', 'telephoneNumber', 'ipPhone', 'streetAddress','title','manager','objectGUID','company','lastLogon'])
#conn.search('dc=test,dc=ru','(&(objectCategory=Person)(!(UserAccountControl:1.2.840.113556.1.4.803:=2)))',SUBTREE, attributes =['cn','proxyAddresses','department','sAMAccountName', 'displayName', 'telephoneNumber', 'ipPhone', 'streetAddress','title','manager','objectGUID','company','lastLogon'])
conn.search('dc=test,dc=ru','(&(objectCategory=Person))',SUBTREE, attributes =['cn','proxyAddresses','department','sAMAccountName', 'displayName', 'telephoneNumber', 'ipPhone', 'streetAddress','title','manager','objectGUID','company','lastLogonTimeStamp','userAccountControl'])
#get or create default organization
try:
org = Organization.objects.get(name="Не указано")
except:
org = Organization(name = 'Не указано')
org.save()
#get or create default organization
try:
dep = Subdivision.objects.get(name="Не указано")
except:
dep = Subdivision(organization = org, name="Не указано")
dep.save()
out_file = 'import_cont_from_ad_out.txt'
try:
os.remove(out_file)
except OSError:
pass
debug_file = open(out_file, 'w', encoding="utf-8")
debug_file.write("%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\n" %('cn','proxyAddresses','department','sAMAccountName', 'displayName', 'telephoneNumber', 'ipPhone', 'streetAddress','title','manager','objectGUID','company','lastLogon','AD-User-Account-Disabled'))
for entry in conn.entries:
try:
out1 = entry.cn
except:
out1 = 'None'
try:
out2 = entry.proxyAddresses
except:
out2 = 'None'
try:
out3 = entry.department
except:
out3 = 'None'
try:
out4 = entry.sAMAccountName
except:
out4 = 'None'
try:
out5 = entry.displayName
except:
out5 = 'None'
try:
out6 = entry.telephoneNumber
except:
out6 = 'None'
try:
out7 = entry.ipPhone
except:
out7 = 'None'
try:
out8 = entry.streetAddress
except:
out8 = 'None'
try:
out9 = entry.title
except:
out9 = 'None'
try:
out10 = entry.manager
except:
out10 = 'None'
try:
out11 = entry.objectGUID
except:
out11 = 'None'
try:
out12 = entry.company
except:
out12 = 'None'
try:
out13 = convert_ad_timestamp(int(entry.lastLogonTimeStamp.value))
#out13 = entry.lastLogonTimeStamp
except:
out13 = 'None'
try:
out14 = entry.userAccountControl
except:
out14 = 'None'
debug_file.write("%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\n" %(out1, out2, out3, out4, out5, out6, out7, out8, out9, out10, out11, out12, out13, out14))
print('')
print(' -------------------------- ')
print('entry.cn', entry.cn)
#print('entry.objectGUID', entry.objectGUID)
debug_file.close()
def execute(srv, usr, pwd):
#server = Server('srv1.test.ru')
server = Server(srv)
conn = Connection(server, auto_bind=True, user=usr, password=pwd)
#'userAccountControl' can have these values: 512 Enabled Account; 514 Disabled Account;
#conn.search('ou=АСУ,dc=test,dc=ru','(&(objectClass=person)(userAccountControl=66048))',SUBTREE, attributes =['cn','proxyAddresses','department','sAMAccountName', 'displayName', 'telephoneNumber', 'ipPhone', 'streetAddress','title','manager','objectGUID','company','lastLogon'])
conn.search(
'dc=test,dc=ru',
'(&(objectCategory=Person)(!(UserAccountControl:1.2.840.113556.1.4.803:=2)))',
SUBTREE,
attributes=[
'cn', 'proxyAddresses', 'department', 'sAMAccountName',
'displayName', 'telephoneNumber', 'ipPhone', 'streetAddress',
'title', 'manager', 'objectGUID', 'company', 'lastLogon'
])
#get or create default organization
try:
org = Organization.objects.get(name="Не указано")
except:
org = Organization(name='Не указано')
org.save()
#get or create default organization
try:
dep = Subdivision.objects.get(name="Не указано")
except:
dep = Subdivision(organization=org, name="Не указано")
dep.save()
for entry in conn.entries:
print('')
print(' -------------------------- ')
print('entry.cn', entry.cn)
#print('entry.objectGUID', entry.objectGUID)
#search person in contact app
try:
displayName = entry.displayName
except:
displayName = entry.cn
print('displayName', displayName)
try:
person_obj = Person.objects.get(ad_objectguid=entry.objectGUID)
except:
person_obj = None
print('person_obj', person_obj)
if person_obj:
person_obj.name = displayName
#person_obj.ad_objectguid = entry.objectGUID
person_obj.save()
else:
person_obj = Person(name=displayName,
ad_objectguid=entry.objectGUID)
person_obj.save()
print('Человек: ', person_obj)
try:
ldapinfo_obj = LdapInfo.objects.get(person=person_obj)
except:
ldapinfo_obj = None
#add AD sAMAccountName
if ldapinfo_obj:
try:
ldapinfo_obj.samaccountname = entry.sAMAccountName
ldapinfo_obj.save()
except:
pass
else:
try:
sAMAccountName = LdapInfo(person=person_obj,
samaccountname=entry.sAMAccountName)
sAMAccountName.save()
except:
pass
#add AD lastLogon
if ldapinfo_obj:
try:
ldapinfo_obj.lastlogon = convert_ad_timestamp(
int(entry.lastLogon.value))
ldapinfo_obj.save()
except:
pass
else:
try:
lastLogon = LdapInfo(person=person_obj,
lastlogon=convert_ad_timestamp(
int(entry.lastLogon.value)))
lastLogon.save()
except:
pass
#delete all person phones in contact app
phones = Phone.objects.filter(person=person_obj)
if phones:
phones.delete()
#add phones to contact from Active Directory user entry
try:
newphone = Phone(person=person_obj, number=entry.telephoneNumber)
newphone.save()
except:
pass
try:
newphone = Phone(person=person_obj, number=entry.ipPhone)
newphone.save()
except:
pass
#delete all emails in contact app
emails = Email.objects.filter(person=person_obj)
if emails:
emails.delete()
#add emails to contact app from Active Directory user entry
try:
new_email = Email(person=person_obj, address=entry.proxyAddresses)
new_email.save()
except:
pass
#get organization
try:
entry_company = entry.company
except:
entry_company = None
organization = None
if entry_company:
try:
organization_obj = Organization.objects.get(name=entry.company)
except:
organization_obj = Organization(name=entry.company)
organization_obj.save()
else:
organization_obj = org
print('Организация: ', organization_obj.name)
entry_company = None
#get or create subdivision
try:
entry_subdiv = entry.department
except:
entry_subdiv = None
subdiv = None
if entry_subdiv:
print("len entry.department %s: %s" %
(entry.department, len(entry.department)))
try:
subdiv = Subdivision.objects.get(organization=organization_obj,
name=entry.department)
except:
subdiv = Subdivision(organization=organization_obj,
name=entry.department)
subdiv.save()
else:
subdiv = dep
print('Подразделение: ', subdiv.name)
entry_subdiv = None
#get person position
try:
position = entry.title
except:
position = None
print('Должность', position)
#create employee
employee = None
try:
employee = Employee.objects.get(organization=organization_obj,
subdivision=subdiv,
person=person_obj,
position=position)
print('Найден работник')
except:
employee = Employee(organization=organization_obj,
subdivision=subdiv,
person=person_obj,
position=position)
employee.save()
print('Создан работник')
