An ADReport Sample Report - Contacts with 60 Columns

Back to ADReport Site

Contact#DomainName (cn)OUFirst NameLast NameDisplay NameInitialsE-mailDescriptionOfficeWeb PageTelephone NumberFaxMobile PhoneHome PhoneIP PhonePagerNotesCompanyDepartmentManagerTitleStreetP.O. BoxCityZip/Postal CodeState/provinceCountry/region (c)Country/region (co)Country/region (countryCode)Original USN*Current USN*Obj Created (UTC)Obj Last Modified (UTC)*Other Phone NumbersOther Fax NumbersOther Mobile PhonesOther Home PhonesOther IP PhonesOther Pager NumbersOther Web Page AddressesCommentDNDivisionEmployee IDGenerational SuffixHome AddressLast Known ParentMiddle NameObject GUIDInstance TypeApprox Immed SubordExch MailExch AliasE-Mail AddressesAddresses Controlled by Recipient PolReceiving Message Max Size (KB)Hide from Exch GALExch Custom Attr 1Exch Custom Attr 2Exch Custom Attr 3
1sanao.comSarah DawsonOU=Demo SarahDawson 18148181483/9/2004 8:13:49 AM3/9/2004 8:13:49 AMNot setNot setNot setNot setNot setNot setNot setCN=Sarah Dawson,OU=Demo,DC=sanao,DC=com1a89c4ab68d0cf4294ff75fd97ff3c0640No YesUse default limitFalse
2sanao.comBill HendonOU=Demo BillHendonBill 81960820466/6/2006 9:02:18 PM6/7/2006 7:32:44 PMNot setNot setNot setNot setNot setNot setNot setCN=Bill Hendon,OU=Demo,DC=sanao,DC=com775c8579e67cb241a6479b5a191c00a840Mail-enabled; X400:c=US;a= ;p=SoveltoS113;o=Exchange;s=Hendon;g=Bill;YesUse default limitFalse
3sanao.comLisa SheridanOU=Demo LisaSheridanLisa 82040820456/7/2006 3:27:14 PM6/7/2006 7:32:44 PMNot setNot setNot setNot setNot setNot setNot setCN=Lisa Sheridan,OU=Demo,DC=sanao,DC=comba4bc99a300c2344b8e4849b180aa90440Mail-enabled; X400:c=US;a= ;p=SoveltoS113;o=Exchange;s=Sheridan;g=Lisa;YesUse default limitFalse

To better examine the results:
1. Right-click the table in IE and select Export to Microsoft Excel.
2. In Excel's Data menu, select Filter => AutoFilter.
3. Use the drop-down lists on the header row to see the selection of values
    or to filter rows.
4. Click cell B2.
5. In Excel's Window menu, select Freeze Panes.


If Microsoft Exchange is present, the report includes 9 Exchange columns.

* Note

The following three attributes are not replicated from one DC toanother. Therefore,
their values vary depending on from which DC they are read: uSNCreated (i.e., Original USN),
uSNChanged (i.e., Current USN), whenChanged (i.e., Obj Last Modified)

This report was generated at 11/1/2006 11:04:15 PM by ADReport,
a program by Sakari Kouti (see