Export CSV in powershell with Domain name in title

Question

We are performing an audit of different networks and need to distinguish between domains. The code I currently use will export to .csv but just uses the title I choose. What I need is for it to automatically name the .csv file with the domain name in it.

Below is my current code:

Import-Module ActiveDirectory
Get-ADObject -filter 'objectclass -eq "user"' -properties CN,DisplayName,Discription | select | export-csv -NoTypeInformation "c:\ADUsers.csv"

did you do some research on your own? this shouldnt be too hard to figure out... you can get the domain name with (gwmi win32_computersystem).domain just put it in a variable and use it in your export-csv statement — Paul
– Paul, Commented Nov 4, 2014 at 19:01

Adi Inbar · Accepted Answer · 2014-11-04 20:34:27Z

1

Did you want just the current domain, or the domain with parent domains included?

Current Domain Name:

Import-Module ActiveDirectory
$name = Get-ADDomain | Select -ExpandProperty NetBIOSName
Get-ADObject -Filter 'objectclass -eq "user"' -Properties CN,DisplayName,Discription | select |  
Export-Csv -NoTypeInformation "c:\" + $name + ".csv"

edited Nov 4, 2014 at 20:34

Adi Inbar

12.4k13 gold badges60 silver badges71 bronze badges

answered Nov 4, 2014 at 19:46

Bajan

7054 gold badges12 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Adi Inbar Over a year ago

One small oversight: the Import-Module statement needs to come before the Get-ADDomain statement.

Collectives™ on Stack Overflow

Export CSV in powershell with Domain name in title

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related