Hi Everyone,

I posted this in the Developers Forum and didn't get a response so I am hoping someone here might be able to help.  I am trying to get a list of licenses by users using a PowerShell script.

This is my code:
gc.exe license users list -a |
ConvertFrom-Json | Write-Output |
Select-Object id, licenses |
export-csv C:\Genesys\Licenses.csv

When I run the code I get all the ID's, but the licenses come back as System.Object[]

Can anyone tell me how to update my script to be able to pull back all the licenses by ID?

Thanks in advance!

Try this:  

gc -p {{profileName}} license users list -a | jq -r ".[] | [.name, .email, .addresses[].address] | @csv" > output.csv

Should get you users with their licenses.

Hi Everyone,

I posted this in the Developers Forum and didn't get a response so I am hoping someone here might be able to help.  I am trying to get a list of licenses by users using a PowerShell script.

This is my code:
gc.exe license users list -a |
ConvertFrom-Json | Write-Output |
Select-Object id, licenses |
export-csv C:\Genesys\Licenses.csv

When I run the code I get all the ID's, but the licenses come back as System.Object[]

Can anyone tell me how to update my script to be able to pull back all the licenses by ID?

Thanks in advance!

Thanks Robert...unfortunately I don't have jq installed so the query is failing...I will see if I can get permission to install it and try again.

Try this:  

gc -p {{profileName}} license users list -a | jq -r ".[] | [.name, .email, .addresses[].address] | @csv" > output.csv

Should get you users with their licenses.

Hi Everyone,

I posted this in the Developers Forum and didn't get a response so I am hoping someone here might be able to help.  I am trying to get a list of licenses by users using a PowerShell script.

This is my code:
gc.exe license users list -a |
ConvertFrom-Json | Write-Output |
Select-Object id, licenses |
export-csv C:\Genesys\Licenses.csv

When I run the code I get all the ID's, but the licenses come back as System.Object[]

Can anyone tell me how to update my script to be able to pull back all the licenses by ID?

Thanks in advance!

Hi @Jason Lorden

Did you get your working to capture the license info? 

Thanks Robert...unfortunately I don't have jq installed so the query is failing...I will see if I can get permission to install it and try again.

Try this:  

gc -p {{profileName}} license users list -a | jq -r ".[] | [.name, .email, .addresses[].address] | @csv" > output.csv

Should get you users with their licenses.

Hi Everyone,

I posted this in the Developers Forum and didn't get a response so I am hoping someone here might be able to help.  I am trying to get a list of licenses by users using a PowerShell script.

This is my code:
gc.exe license users list -a |
ConvertFrom-Json | Write-Output |
Select-Object id, licenses |
export-csv C:\Genesys\Licenses.csv

When I run the code I get all the ID's, but the licenses come back as System.Object[]

Can anyone tell me how to update my script to be able to pull back all the licenses by ID?

Thanks in advance!

I have not successfully captured the license information yet as I have not been able to get approval to install jq on my machine.  

Hi @Jason Lorden

Did you get your working to capture the license info? 

Thanks Robert...unfortunately I don't have jq installed so the query is failing...I will see if I can get permission to install it and try again.

Try this:  

gc -p {{profileName}} license users list -a | jq -r ".[] | [.name, .email, .addresses[].address] | @csv" > output.csv

Should get you users with their licenses.

Hi Everyone,

I posted this in the Developers Forum and didn't get a response so I am hoping someone here might be able to help.  I am trying to get a list of licenses by users using a PowerShell script.

This is my code:
gc.exe license users list -a |
ConvertFrom-Json | Write-Output |
Select-Object id, licenses |
export-csv C:\Genesys\Licenses.csv

When I run the code I get all the ID's, but the licenses come back as System.Object[]

Can anyone tell me how to update my script to be able to pull back all the licenses by ID?

Thanks in advance!

Thank you for letting me know. 

I have not successfully captured the license information yet as I have not been able to get approval to install jq on my machine.  

Hi @Jason Lorden

Did you get your working to capture the license info? 

Thanks Robert...unfortunately I don't have jq installed so the query is failing...I will see if I can get permission to install it and try again.

Try this:  

gc -p {{profileName}} license users list -a | jq -r ".[] | [.name, .email, .addresses[].address] | @csv" > output.csv

Should get you users with their licenses.

Hi Everyone,

I posted this in the Developers Forum and didn't get a response so I am hoping someone here might be able to help.  I am trying to get a list of licenses by users using a PowerShell script.

This is my code:
gc.exe license users list -a |
ConvertFrom-Json | Write-Output |
Select-Object id, licenses |
export-csv C:\Genesys\Licenses.csv

When I run the code I get all the ID's, but the licenses come back as System.Object[]

Can anyone tell me how to update my script to be able to pull back all the licenses by ID?

Thanks in advance!