how to compose command in powershell

gautamkumar5 · 2018-04-16T13:11:52.000Z

Hi All, I am very poor in PowerShell. Hence need some help from the experts.

I guess this has to do with Array or functions. The requirement is to pass the values obtained in the powershell command.

I will try to explain.

On Exchange Server 2013 PowerShell if we run this command

Get-CasMailbox user1@contoso.com | fl it will list all the properties for user1@contoso.com among with one of the property is “ActiveSyncAllowedDeviceIDs” which will have values like android3873,SAMSUNG2347,Nokia464 etc.

Then I have to take a note of the ActiveSyncAllowedDeviceIDs and run

Set-CasMailbox user1@contoso.com -ActiveSyncAllowedDeviceIDs @{Remove=“android3873”,“SAMSUNG2347”}

How do I compose a command that will automatically remove the ActiveSyncAllowedDeviceIDs other then BB* & WorxMail*

Requirement is to remove the devices by their DeviceIDs, except ones starting with BB* & WorxMail*

Thanks for your time, effort and knowledge.

@paul-the-psguru @powershellpro

Neally · 2018-04-16T13:33:40.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…

psophos · 2018-04-16T14:23:23.000Z

For all users?

Requirement is to remove the devices by their DeviceIDs, except ones starting with BB* & WorxMail*

It was potentially so simple until that last part

gautamkumar5 · 2018-04-16T14:26:42.000Z

Hi Boyle,

For the time being if we forget the last part, how should the command/script look like ?

psophos · 2018-04-16T14:32:49.000Z

gautamkumar5:

Hi Boyle,

For the time being if we forget the last part, how should the command/script look like ?

You can’t forget the last part as that is what makes it complex.

Is this for every user? If yes do you have a list of users to process already? Manually entering them is a pain.

see if this gives any output:

$deviceIds = (Get-CasMailbox user1@contoso.com).ActiveSyncAllowedDeviceIDs
$deviceIds = $deviceIds | Where-Object { $_ -notlike 'BB*' -or $_ -notlike 'WorxMail*' }
$deviceIds

it won’t change anything, You should test it against a user that has devices that you want to keep.

Neally · 2018-04-16T14:33:12.000Z

maybe something like this:

$data = Get-CasMailbox -ResultSize Unlimited 
$data | where {$_.PrimarySmtpAddress -NotLike "bb*" -or $_.PrimarySmtpAddress -NotLike "WorxMail*"} |
Set-CasMailbox -ActiveSyncAllowedDeviceIDs @{Remove="android3873","SAMSUNG2347"}

gautamkumar5 · 2018-04-16T14:52:15.000Z

Hi Neally,

The value for Remove

Set-CasMailbox -ActiveSyncAllowedDeviceIDs @{Remove=“android3873”,“SAMSUNG2347”}

is going to be unique for every user how can we pass that value.

The input will be given by csv file which will have the email address of the users.

Neally · 2018-04-16T14:59:04.000Z

lol you keep adding more requirements…

what else do you have in the CSV?

foreach ($csvline in (import-csv "file.csv")) {
    if (-not($csvline.PrimarySmtpAddress -like "bb*" -or $csvline.PrimarySmtpAddress -like "WorxMail*")) {
        Set-CasMailbox -ActiveSyncAllowedDeviceIDs @{Remove = $csvline.ActiveSyncAllowedDeviceIDs}
    }
}

^ this assumes you have a column in your CSV called ’ PrimarySmtpAddress’ and ’ ActiveSyncAllowedDeviceIDs’ for the devices.

Can you share the first 2 lines of your CSV (sanatized)

gautamkumar5 · 2018-04-16T14:59:36.000Z

Hi Boyle,

As you asked, Is this for every user? No, The input will be given by csv file which will have the email address of the users. Your script does not have the remove command to remove the devices based on the device ID which is fetched if we run Get-CasMailbox boyle@contoso.com | fl

I am able to remove all the devices other then starting with *BB and *WorkMail by using the below command but it does not gets the job done, because individual devices are to be removed based on the device ID which is fetched

Get-ActiveSyncDevice -Mailbox gakumar | where {$.DeviceUserAgent -notcontains “BB*” -or $.DeviceUserAgent -notcontains “WorxMail*”}| Remove-ActiveSyncDevice

So, I need to find a way to insert the fetched ActiveSyncAllowedDeviceIDs in the remove part as shown below.

Set-CasMailbox user1@contoso.com -ActiveSyncAllowedDeviceIDs @{Remove=“android3873”,“SAMSUNG2347”}

gautamkumar5 · 2018-04-16T15:05:25.000Z

HI Neally, The CSV file has:

PrimarySmtpAddress

Neally@contoso.com

bob@contoso.com

Neally · 2018-04-16T16:03:54.000Z

Again, if you post code, please use the insert code button…

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…

Neally · 2018-04-16T16:07:48.000Z

If you just want to clear it, how about that?

foreach ($csvline in (import-csv "file.csv")) {
    if (-not($csvline.PrimarySmtpAddress -like "bb*" -or $csvline.PrimarySmtpAddress -like "WorxMail*")) {
        Set-CasMailbox $csvline.PrimarySmtpAddress –ActiveSyncAllowedDeviceIDs:$null
    }
}