List of data items in Active Directory and the corresponding column in NSP database:
|
Item in Active Directory |
Column in NSP database |
NSP Table |
|
DisplayName |
DisplayName |
SYS_DEF_USER |
|
givenName |
FirstName |
SYS_DEF_PERSON |
|
sn |
LastName |
SYS_DEF_PERSON |
|
|
|
SYS_DEF_USER |
|
telephoneNumber |
Phone |
SYS_DEF_USER |
|
sAMAccountName |
WindowsUserName |
SYS_DEF_USER |
|
objectSid |
WindowsSidString |
SYS_DEF_USER |
|
postalCode |
PostalCode |
SYS_DEF_ADDRESS |
|
homepostalAddress |
HomeAddress |
SYS_DEF_PERSON |
|
mobile |
MobileNumber |
SYS_DEF_PERSON |
|
l |
City |
SYS_DEF_ADDRESS |
|
co |
Country |
SYS_DEF_ADDRESS |
|
description |
Description |
SYS_DEF_PERSON |
|
personalTitle |
Title |
SYS_DEF_PERSON |
|
company |
Company |
SYS_DEF_PERSON |
|
department |
Department |
SYS_DEF_PERSON |
|
c |
CountryRegion |
SYS_DEF_PERSON |
|
maxStorage |
MaxStorage |
SYS_DEF_PERSON |
|
comment |
Comment |
SYS_DEF_PERSON |
|
facsimileTelephoneNumber |
FaxNumber |
SYS_DEF_PERSON |
|
homeDirectory |
HomeFolde |
SYS_DEF_PERSON |
|
homeDrive |
HomeDrive |
SYS_DEF_PERSON |
|
homePhone |
HomePhone |
SYS_DEF_PERSON |
|
homePostalAddress |
HomeAddress |
SYS_DEF_PERSON |
|
info |
Notes |
SYS_DEF_PERSON |
|
IpPhone |
IpPhoneNumber |
SYS_DEF_PERSON |
|
manager |
Manager |
SYS_DEF_PERSON |
|
middleName |
MiddleName |
SYS_DEF_PERSON |
|
pager |
PagerNumber |
SYS_DEF_PERSON |
|
physicalDeliveryofficeName |
OfficeLocation |
SYS_DEF_ADDRESS |
|
postOfficeBox |
PostOfficeBox |
SYS_DEF_ADDRESS |
|
st |
StateProvince |
SYS_DEF_ADDRESS |
|
streetAddress |
StreetAddress |
SYS_DEF_ADDRESS |
|
street |
Street |
SYS_DEF_ADDRESS |
|
title |
JobTitle |
SYS_DEF_PERSON |
|
wwwHomePage |
WebPageAddress |
SYS_DEF_PERSON |
|
memeberOf |
MemeberOf |
SYS_DEF_PERSON |