Export LineURI attributes from Teams to CSV file - works OK in Powershell, not Adaxes

Question

So I need to export a list of all user's Line URI's to a CSV file. Running Adaxes 2021 Version 3.14.18804.0 (64 bit) and Teams Powershell 4.1.0

It works OK doing this manually through Powershell as follows:

get-csonlineuser | where-object {($_.UsageLocation -eq "NZ") -and (($_.Company -eq "ourcompanyname") -or ($_.Company -eq "ourothercompany")) -and (($_.City -eq "Auckland") -or ($_.City -eq "Wellington")) -and ($_.AccountEnabled -eq "True") -and ($_.Title -ne "contractor")} | select userprincipalname,Company,City,LineURI | Sort-Object -Property Company,City,LineURI,userprincipalname
| export-csv c:\temp\teamsusers.csv

However when I put it into Adaxes as follows it does not work. Can someone please advise what I need to do to make this work?

# Get saved credentials
$username = $Context.RunAs.UserName
$password = $Context.RunAs.Password | ConvertTo-SecureString -AsPlainText -Force
$credential = New-Object System.Management.Automation.PsCredential($username, $password)

try
{
    #Connect to Teams and export a list of staff to CSV file
   Connect-MicrosoftTeams -Credential $credential

   get-csonlineuser | where-object {($_.UsageLocation -eq "NZ") -and (($_.Company -eq "ourcompany") -or ($_.Company -eq "ourothercompany")) -and (($_.City -eq "Auckland") -or ($_.City -eq "Wellington")) -and ($_.AccountEnabled -eq "True") -and ($_.Title -ne "contractor")} | select userprincipalname,Company,City,LineURI | Sort-Object -Property Company,City,LineURI,userprincipalname | export-csv c:\temp\teamsusers.csv
}

catch
{
    return # The user doesn't have a Microsoft 365 account
}

finally
{
    # Close the connection and release resources
    Disconnect-MicrosoftTeams
}

Comments

Hello,

What exactly do you mean by does not work? Do you face any error messages? If you do, please, post here or send us (support@adaxes.com) screenshots. Also, please, make sure that there is only the latest version of the Microsoft teams PowerShell module installed on the computer where Adaxes service runs.

---

So I have worked out what the issue is - I am bad at scripting.

I watched the file size go from 0 to 1KB a number of times, so it seems like for each user in OU's I specified, it was running the script for every single one.

If I add -append to the command in Adaxes, it generates the list in the spreadsheet 200 times over for everyone in our org.

I've worked around the issue by assigning it the activity scope to be only over a single test user account, which seems to work OK. It's a shame there's not a more elegant way to run it though.

Answer 1

Hello,

Whenever a custom command, business rule or scheduled task is executed, it is executed for an object. As we understand, you have the script in a scheduled task. In cases when all the search criteria are specified in the script itself and do not depend on the Activity Scope, specifying a single object in the scope is the correct approach. Unfortunately, there is no possibility to do that without having a target object at all.

Comments

oh, ok well that works then, thanks :)