Powershell Megathread: Verb-Noun Scripting is the future

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Powershell Megathread: Verb-Noun Scripting is the future

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

I need to find out how many AD users in a certain OU have extensionAttribute7 populated, and export this to a .csv file. I'm sure it'll start with Get-ADuser, but as a newb to this I'm having trouble fleshing out the rest. Can anyone help?

EDIT: The following gave me what I wanted, except from all of AD. Now trying to figure out how to get from just one OU

code:

Get-ADUser -filter * -properties extensionAttribute7 | Select-Object name, extensionAttribute7 | export-csv $dir$\ExAt7.csv -Encoding "Unicode"

TITTIEKISSER69 fucked around with this message at 19:19 on Jan 22, 2019

# ¿ Jan 22, 2019 19:06

Adbot: ADBOT LOVES YOU

# ¿ Apr 29, 2024 01:44

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

Thanks, I ended up doing it like this:

code:

Get-ADUser -filter * -properties extensionAttribute7 | where-object {$_ -like  "*OU=SubOUname*" } | Select-Object name, extensionAttribute7 | export-csv $dir$\ExAt7.csv -Encoding "Unicode"

EDIT: Crap, that just gave me everyone in the OU regardless of whether EA 7 is populated or not. Gonna try your way.

TITTIEKISSER69 fucked around with this message at 19:32 on Jan 22, 2019

# ¿ Jan 22, 2019 19:30

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

Tried the full command and got "Missing an argument for parameter 'Filter'"

# ¿ Jan 22, 2019 19:42

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

Yeah, I tried removing one then the other but still got errors.

# ¿ Jan 22, 2019 19:48

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

code:

PS C:\Users\TK69> Get-ADUser -Filter {extensionAttribute7 -like "*"} -SearchBase "OU=Consultants,DC=redacted,DC=net" -properties extensionAttribute7 | Select-Object name, extensionAttribute7 | export-csv $redacted$\ExAt7.csv -Encoding "Unicode" -NoTypeInformation
Get-ADUser : Directory object not found
At line:1 char:1
+ Get-ADUser -Filter {extensionAttribute7 -like "*"} -SearchBase "OU=Consultants,D ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : ObjectNotFound: (:) [Get-ADUser], ADIdentityNotFoundException
    + FullyQualifiedErrorId : Directory object not found,Microsoft.ActiveDirectory.Management.Commands.GetADUser

# ¿ Jan 22, 2019 19:54

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

That was it, I had to change it to "OU=SubOU,OU=TopOU,DC=etc..."

Thanks!

# ¿ Jan 22, 2019 20:13

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

Thanks all!

# ¿ Jan 22, 2019 20:57

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

I need to figure out whose mailboxes are being forwarded to OldGuy, and instead forward them all to NewGuy. On-prem Exchange 2013. Where do I begin?

# ¿ Jun 19, 2019 15:59

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

I have 50 security groups that I need to add 2 users to the Delivery Management list so they can send to all of them. They're all in the format companyname.office.cityname, is it possible to add user1@company.com and user2@company.com to the allowed senders for companyname.office.* ?

# ¿ May 27, 2020 16:24

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

Submarine Sandpaper posted:

if I"m reading right:

Set-Mailbox -Identity "Robin Wood" -AcceptMessagesOnlyFrom "Lori Penor","Jeff Phillips" -AcceptMessagesOnlyFromDLMembers "Legal Team 1"

https://docs.microsoft.com/en-us/exchange/recipients/user-mailboxes/message-delivery-restrictions?view=exchserver-2019

I'm thinking it would be more like the example linked here: https://community.spiceworks.com/topic/2232835-remove-member-from-delivery-management-with-exhange-powershell

quote:

Set-DistributionGroup "GROUP-NAME-HERE" -AcceptMessagesOnlyFromSendersOrMembers((Get-DistributionGroup "GROUP-NAME-HERE").AcceptMessagesOnlyFromSendersOrMembers + "IDENTITY-OF-USER-OR-GROUP-HERE")

The trick is I'm hoping I can literally enter companyname.office.* so all of the groups can be updated at once.

# ¿ May 27, 2020 16:48

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

What command can I use to generate a list of mailboxes that one employee has Send As permission on?

# ¿ Jul 10, 2020 16:01

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

That's showing me FullAccess, but not Send As

# ¿ Jul 10, 2020 17:20

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

code:

PS C:\Users\TK69> Get-Mailbox | Get-RecipientPermission -Trustee USERNAME
Get-RecipientPermission : The term 'Get-RecipientPermission' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was 
included, verify that the path is correct and try again.
At line:1 char:15
+ Get-Mailbox | Get-RecipientPermission -Trustee USERNAME
+               ~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : ObjectNotFound: (Get-RecipientPermission:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

# ¿ Jul 10, 2020 18:49

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

My bad, I should have stated that up front

# ¿ Jul 10, 2020 18:51

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

(Names changed) We've had a couple of promotions/title changes and now "Barney" is no longer the Manager (in AD) for a bunch of people, instead "Jenny" is. Is it possible to use PS to change all of these people's Manager field to Jenny? They're all in the same OU.

# ¿ Oct 23, 2020 17:58

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

Thank you both! For the initial question I took a second look and saw it was only ten users that needed updating, so I got those done by hand. However this will help with other OUs full of users that need updating.

Question: how do I filter the users by their job title? Some titles report to Manager A while some report to Manager B, etc.

# ¿ Oct 23, 2020 18:25

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

I need to determine which mailboxes (of disabled users) are forwarding to oldmanager, and then either turn off the forwarding or change it to newmanager - which one of those it will be is TBD. This is on-prem Exchange 2016, how do I begin?

# ¿ Mar 2, 2021 17:29

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

I've got a user who is getting emails sent to dynamic distribution groups of which she is not a member - I exported the memberships of the three groups to CSV files and she isn't on any of them.

My hunch is that a former employee is still on one of these lists and their mailbox is forwarding to her. What PS command can I run to see what mailboxes have forwarding enabled to her?

EDIT: This is in Exchange Online

TITTIEKISSER69 fucked around with this message at 23:28 on Jul 10, 2023

# ¿ Jul 10, 2023 23:26

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

Afraid not, as the sender put the dynamic distro groups' addresses in BCC.

# ¿ Jul 11, 2023 13:44

Adbot: ADBOT LOVES YOU

# ¿ Apr 29, 2024 01:44

TITTIEKISSER69: Mar 19, 2005; SAVE THE BEES
PLANT MORE TREES
CLEAN THE SEAS
KISS TITTIESS

TITTIEKISSER69 posted:

I've got a user who is getting emails sent to dynamic distribution groups of which she is not a member - I exported the memberships of the three groups to CSV files and she isn't on any of them.

My hunch is that a former employee is still on one of these lists and their mailbox is forwarding to her. What PS command can I run to see what mailboxes have forwarding enabled to her?

EDIT: This is in Exchange Online

Any ideas?

# ¿ Jul 17, 2023 17:57

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Powershell Megathread: Verb-Noun Scripting is the future