filename creation

allspice-777 · 2022-08-19T15:28:05.000Z

Greetings all. I’m a novice scripter needing a little help. I created the script below, which extracts names and emails from an AD group and names the file with currentdateAB.csv. However, I’d like to name the file using the group name entered by the user. I thought I could output (instead of Export) to $group ( Out-File “$group$_.csv”) but the script fails.

$scriptFolder = $MyInvocation.MyCommand.Path | Split-PAth -Parent
$group = Read-Host -Prompt “Enter AD Group” | Get-ADGroupMember | Get-aduser -properties Mail | Select surname, givenname, mail | export-csv $scriptFolder-$((Get-date).Tostring(‘MM-dd-yyyy’))AB.csv -Notypeinformation -append

Question: What is the best way to use the entered group to parse and use as the file name for output?

ex. I enter group1 (when prompted) and the data extracted is placed in a file called group.csv

Neally · 2022-08-19T15:37:53.000Z

Welcome

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

192033ab-bb8f-4032-88a5-8e2313af0344-codebutton_small.png

Neally Bot

allspice-777 · 2022-08-19T15:47:49.000Z

$scriptFolder = $MyInvocation.MyCommand.Path | Split-PAth -Parent
$group = Read-Host -Prompt "Enter AD Group" | Get-ADGroupMember | Get-aduser -properties Mail | Select surname, givenname, mail | export-csv $scriptFolder\-$((Get-date).Tostring('MM-dd-yyyy'))AB.csv -Notypeinformation -append

Apologies all. I posted code in wrong location.

Neally · 2022-08-19T15:59:03.000Z

allspice-777:

Question: What is the best way to use the entered group to parse and use as the file name for output?

IDK about ‘best way’ but one way:

e.g.

$scriptFolder = $MyInvocation.MyCommand.Path | Split-PAth -Parent

$groupName = Read-Host "Enter AD Group" 

if(Get-ADGroup $group){
    $groupmemberInfo = 
    (Get-ADGroup $groupName -Properties members).members |
    Get-aduser -properties Mail |
    Select surname, givenname, mail

    $groupmemberInfo |
    export-csv "$scriptFolder\$(Get-date -format 'MM-dd-yyyy')-$groupName.csv" -Notypeinformation

}else{
    Write-Warning "Group '$groupName' not found"
}

allspice-777 · 2022-08-19T16:20:19.000Z

Neally. Thank you! I had to update your code to include the defined name groupName and it worked very nicely. Thanks!

if(Get-ADGroup $groupName)

Neally · 2022-08-19T16:24:47.000Z

allspice-777:

Neally. Thank you! I had to update your code to include the defined name groupName and it worked very nicely. Thanks!
if(Get-ADGroup $groupName)

Would be boring if you had nothing to do ;¬)

allspice-777 · 2022-08-19T17:17:05.000Z

copy that!

allspice-777 · 2022-08-19T17:18:02.000Z

…and Thanks again!