Export users from AD

Question

Export users from AD

Glenn Maxwell 13,761

Hi All

We have office in Ireland. for few users office location in Active Directory is given are Dublin, Ireland and for few users it is given as Remote, Ireland
I want to export the users with the office locations Dublin, Ireland & Remote, Ireland ,which of the below syntax is correct. i am not sure of Remote, Ireland

(Office -like '*Remote*' -and Office -like 'Ireland*') -or (Office -like '*Dublin, Ireland*')  
or  
(Office -like '*Remote*' -and Office -like '*Ireland*') -or (Office -like '*Dublin, Ireland*')

0 comments

Answer accepted by question author

Rich Matheisen 48,116

Why complicate things?

(Office -like '*Remote, Ireland*' -or Office -like '*Dublin, Ireland*')

0 comments

1 additional answer

Your answer

Answer 1

Glenn Maxwell 13,761

lets say in office location tomorrow if it is Remote Ireland ABC, or ABC Remote Ireland or anything. i want to make sure my query pulls the words Remote and Ireland from office location.

Rich Matheisen 48,116 Reputation points

2022-08-08T22:58:52.54+00:00

What happened to the commas in your original post? And why not mention that there was more than what you were checking for in the Office property value? If you're looking for help it's a good thing to provide all the information and not return with a "yeah, but what about . . ." after getting an answer that satisfies your original question's specifics.

If all you're worried about it the presence of "ABC" then my answer will still work. If the commas are sometimes present and sometimes not, then using a "Where-Object" would still work, but you'd need four conditions, not two, for it to work: two with commas and two without.

Share via

Export users from AD

1 additional answer

Your answer