Need Help ON DL Export

grsl · 2021-06-16T09:16:58.000Z

Edit: Welcome to SpiceWorks

Show us the code you have so far.

rapartykish1863 · 2021-06-16T10:11:59.000Z

Hi,

Below is my code

$Groups = Import-CSV -Path “.\xxx.csv”

foreach($group in $groups)

{

“Command: Get-ADGroupMember -Identity {0} -Recursive” -f $group.Name
Start-Sleep 1
Get-ADGroupMember -Identity $group.Name -Recursive | Select-Object SAMAccountName, name | Sort-Object SAMAccountName
#Get-ScreenShot -Path $path

$membership = Get-ADGroupMember -Identity $group.Name -Recursive | Select-Object SAMAccountName, name | Sort-Object SAMAccountName

$membershipString = “Username | Namen" foreach($user in $membership) { $membershipString += "{0} | {1}n” -f $user.SAMAccountName, $user.name
}

$description = @"
Group Name: {0}
{1}
"@ -f $group.Name, $membershipString
}

grsl · 2021-06-16T11:28:33.000Z

$Groups = Import-CSV -Path ".\Groups.csv"

foreach($group in $groups)
{
    Get-ADGroupMember -Identity $group.Name -Recursive

    Start-Sleep 1

    Get-ADGroupMember -Identity $group.Name -Recursive | Select-Object SAMAccountName, name | Sort-Object SAMAccountName

    #Get-ScreenShot -Path $path

    $membership = Get-ADGroupMember -Identity $group.Name -Recursive | Select-Object SAMAccountName, name | Sort-Object SAMAccountName

    $membershipString = "Username | Name`n"
    foreach($user in $membership)
    {
        $membershipString += "{0} | {1}`n" -f $user.SAMAccountName, $user.name
    }
    
#    $description = @()
#    @description += "Group Name:=" + $group.Name.ToString() + "Membership=" + $membershipString

Works apart from the last two lines. What are you trying to acheive with them?

rapartykish1863 · 2021-06-16T11:33:10.000Z

Hi

I am trying to export the results into multiple PDFs/TXT files with DL name. For example, there are 10 DL’s in the CSV with name like DL- Test1,Dl-Test2, etc. I want the output of the members ( Name, login name) in a text file with name Dl-test1.txt

grsl · 2021-06-16T12:37:14.000Z

$Groups = Import-CSV -Path ".\Groups.csv"
foreach($group in $groups) {
    Get-ADGroupMember -Identity $group.Name -Recursive
    Start-Sleep 1
    Get-ADGroupMember -Identity $group.Name -Recursive | Select-Object SAMAccountName, name | Sort-Object SAMAccountName
    #Get-ScreenShot -Path $path
    $membership = Get-ADGroupMember -Identity $group.Name -Recursive | Select-Object SAMAccountName, name | Sort-Object SAMAccountName
    $membershipString = "Username | Name`n"
    foreach($user in $membership) {
        $membershipString += "{0} | {1}`n" -f $user.SAMAccountName, $user.name
    }
    $filename = $group.Name.ToString() + ".txt"
    New-Item -Path .\$filename -ItemType File -Value $membershipString
}

Neally · 2021-06-16T12:43:41.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…

rapartykish1863 · 2021-06-16T13:41:28.000Z

# Modify these
$Labels = "Lablel Goes here"
$username = 'xxxxx'
$apiToken = 'xxxxxxxxx'

#Statics
$jiraServer = 'https://xyz.atlassian.net'
$Project = 'Test'
$IssueType = 'Task'

 

$jiraParameters = @{
    Project = $Project
    IssueType = $IssueType
    Labels = $Labels
    Fields = @{reporter = @{id="abc1235677899"}
    }

      
    }

   
#Add JiraPS module
#Install-Module JiraPS
#Update-Module JiraPS
Import-Module JiraPS
Set-JiraConfigServer -Server $jiraServer

#Create Jira Session
[securestring]$secStringPassword = ConvertTo-SecureString $apiToken -AsPlainText -Force
[pscredential]$credObject = New-Object System.Management.Automation.PSCredential ($username, $secStringPassword)
$null = New-JiraSession -Credential $credObject

$Path = "E:\Spiceworks\Scripts\steves-scripts\"
$Groups = Import-CSV -Path "E:\spiceworks\Scripts\steves-scripts\SOX\GroupsMonitored.csv"
$output = @()

foreach($group in $groups) 

{
    Get-ADGroupMember -Identity $group.Name -Recursive
    Start-Sleep 1
    Get-ADGroupMember -Identity $group.Name -Recursive | Select-Object SAMAccountName, name | Sort-Object SAMAccountName
    #Get-ScreenShot -Path $path
    $membership = Get-ADGroupMember -Identity $group.Name -Recursive | Select-Object SAMAccountName, name | Sort-Object SAMAccountName
    $membershipString = "Username | Name`n"
    foreach($user in $membership) {
        $membershipString += "{0} | {1}`n" -f $user.SAMAccountName, $user.name
    }
    $filename = $group.Name.ToString() + ".txt"
    New-Item -Path .\$filename -ItemType File -Value $membershipString
}
    $issue = New-JiraIssue @jiraParameters -Summary ($group.Name) -Description $description
    Add-JiraIssueAttachment -Issue $issue.Key -File $path

Hi

Thanks a ton you saved my life. One last thing. My actual requirement is to create a Jira issue using an API and upload the attachment. Now that this script is connecting to Jira and is creating the text files as required. But when uploading it’s throwing an error.

Add-JiraIssueAttachment : No file could be found with the provided path 'E:\Kishore\Scripts\steves-scripts'.
At E:\spiceworks\Scripts\steves-scripts\untitled.ps1:57 char:5

Add-JiraIssueAttachment -Issue $issue.Key -File $path
CategoryInfo : ObjectNotFound: (E:\spiceworks\Scripts\steves-scripts:String) [Add-JiraIssueAttachment], ArgumentException
FullyQualifiedErrorId : ParameterValue.FileNotFound,Add-JiraIssueAttachment

Can you please help me on that

jimlong3 · 2021-06-16T15:18:22.000Z

grsl:

foreach($group in $groups) {
    Get-ADGroupMember -Identity $group.Name -Recursive
    Start-Sleep 1
    Get-ADGroupMember -Identity $group.Name -Recursive | Select-Object SAMAccountName, name | Sort-Object SAMAccountName
}

Just out of curiosity, why do you do the Get-ADGroupMember call twice?

grsl · 2021-06-16T15:36:16.000Z

You’ll have to ask the OP. All I did was tweak his/her code so it works. Wasn’t asked to optimise it!

jimlong3 · 2021-06-16T19:13:29.000Z

Eureka!

I’ve got the .CSV creation sorted!

This will give you a set of .CSV files, each having the name of a Distribution Group, each containing the Name and SAMAccountName of each Member of that Group.

<#
Audit-DistributionGroups.ps1

For each Distribution Group, put a list of all Members Names and SAMAccountNames into a .CSV file with the Group Name as it's name.
#>
ForEach ($Group in (Get-DistributionGroup -ResultSize 4 | Sort Name)){
	$FileName = $Group.Name.ToString() + ".CSV"
	(Get-ADGroupMember $Group.Name | Sort Name | Select-Object Name, SAMAccountName) |
	 ConvertTo-CSV -NoTypeInformation |
	 Select -Skip 1 |
	 Set-Content .\$FileName
}  # End For Each Group

I’ve been wanting almost exactly this for a long time, so I thank you for the nudge!

(Take away the “-ResultSize 4” for your final run!)

Neally · 2021-06-16T19:17:03.000Z

Just want to point out that this might not work for large groups as ‘Get-ADGroupMember’ has limitations, for that there is alway ‘get-adgroup $GROUP -properties members’

rapartykish1863 · 2021-06-17T00:45:38.000Z

Hey grsl,

Can you help me on the attachment part?

rapartykish1863 · 2021-06-17T05:08:37.000Z

Hey GRSL,

Today I had another issue with the script. The script is creating the files but its not creating multiple Jira tickets. Its creating Jira only with the last file and that to without attachement

grsl · 2021-06-17T06:00:03.000Z

The script is creating the files but its not creating multiple Jira tickets. Its creating Jira only with the last file and that to without attachement

Sorry, I know nothing about Jira, but sounds like the ticket creation code needs to be in a loop.

rapartykish1863 · 2021-06-17T07:03:42.000Z

Can you help me where i am going wrong?

rapartykish1863 · 2021-06-17T07:25:46.000Z

Hey Grsl,

I figured the Jira ticket creation with your help. Now I am stuck in attaching the attachments. The script is not reading from the location. Below is the code

$Path = "E:\spiceworks\Scripts\steves-scripts"
$Groups = Import-CSV -Path “.\SOX\GroupsMonitored.csv”
$output = @()

foreach($group in $groups)

{
Get-ADGroupMember -Identity $group.Name -Recursive
Start-Sleep 1
Get-ADGroupMember -Identity $group.Name -Recursive | Select-Object SAMAccountName, name | Sort-Object SAMAccountName

$membership = Get-ADGroupMember -Identity $group.Name -Recursive | Select-Object SAMAccountName, name | Sort-Object SAMAccountName
$membershipString = “Username | Namen" foreach($user in $membership) { $membershipString += "{0} | {1}n” -f $user.SAMAccountName, $user.name
}
$filename = $group.Name.ToString() + “.txt”
New-Item -Path .$filename -ItemType File -Value $membershipString

$issue = New-JiraIssue @jiraParameters -Summary ($group.Name) -Description $description
Add-JiraIssueAttachment -Issue $issue.Key -File - $Path
}

And I am getting the below error

Add-JiraIssueAttachment : No file could be found with the provided path ‘-’.
At E:\spicewoks\Scripts\steves-scripts\untitled.ps1:57 char:5

Add-JiraIssueAttachment -Issue $issue.Key -File - $Path
CategoryInfo : ObjectNotFound: (-:String) [Add-JiraIssueAttachment], ArgumentException
FullyQualifiedErrorId : ParameterValue.FileNotFound,Add-JiraIssueAttachment

Your help on this is highly appreciated

Thanks

grsl · 2021-06-17T07:45:58.000Z

5211cf4b-0765-4407-8c6b-1d7dfce5853f-sw.PNG800×400 69.8 KB

grsl · 2021-06-17T07:49:18.000Z

RAPARTY:

Add-JiraIssueAttachment : No file could be found with the provided path ‘-’.

At E:\spicewoks\Scripts\steves-scripts\untitled.ps1:57 char:5
Add-JiraIssueAttachment -Issue $issue.Key -File - $Path
CategoryInfo : ObjectNotFound: (-:String) [Add-JiraIssueAttachment], ArgumentException

FullyQualifiedErrorId : ParameterValue.FileNotFound,Add-JiraIssueAttachment
Thanks

If you read the error message the file can’t be found.

Look at from where are you running the script and

Get-Help Set-Location
Get-Help Test-Path

rapartykish1863 · 2021-06-17T08:38:41.000Z

Thanks a Ton grsl, my issue has been fixed

grsl · 2021-06-17T08:45:06.000Z

RAPARTY:

Thanks a Ton grsl, my issue has been fixed

You’re welcome. That’s what we are all here for to give and receive help.