{"id":4215,"date":"2022-06-24T10:47:53","date_gmt":"2022-06-24T17:47:53","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=4215"},"modified":"2022-06-24T10:47:54","modified_gmt":"2022-06-24T17:47:54","slug":"how-to-export-ad-users-to-csv-file","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=4215","title":{"rendered":"How to Export AD Users to CSV File"},"content":{"rendered":"\n<p>The below PowerShell command should work<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Get-ADUser -Filter * -SearchBase \"OU=Research,OU=Users,DC=ad,DC=contoso,DC=com\" -Properties * | Select-Object name | export-csv -path c:\\temp\\userexport.csv<\/code><\/pre>\n\n\n\n<p>You can also do the same task using AD GUI<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Open AD, Click on Filter Button.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/answers\/storage\/attachments\/59114-filter.jpg\" alt=\"59114-filter.jpg\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Perform a Custom filter for Organization Unit.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/answers\/storage\/attachments\/59211-ad1.png\" alt=\"59211-ad1.png\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Click on the Export button<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/answers\/storage\/attachments\/59212-export.jpg\" alt=\"59212-export.jpg\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Select CSV file extension<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/answers\/storage\/attachments\/59185-csv.jpg\" alt=\"59185-csv.jpg\"\/><\/figure>\n\n\n\n<p>Ref: https:\/\/docs.microsoft.com\/en-us\/answers\/questions\/239938\/export-ad-users-to-csv-file.html<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The below PowerShell command should work You can also do the same task using AD GUI Open AD, Click on Filter Button. Perform a Custom filter for Organization Unit. Click on the Export button Select CSV file extension Ref: https:\/\/docs.microsoft.com\/en-us\/answers\/questions\/239938\/export-ad-users-to-csv-file.html<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10],"tags":[1220],"class_list":["post-4215","post","type-post","status-publish","format-standard","hentry","category-microsoft","tag-export-ad-users-to-csv-file"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/4215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4215"}],"version-history":[{"count":1,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/4215\/revisions"}],"predecessor-version":[{"id":4216,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/4215\/revisions\/4216"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}