topic How to Export list of users who have access to xSOAR along with their last login in Cortex XSOAR Discussions

How to Export list of users who have access to xSOAR along with their last login

aparnaas — Sat, 26 Nov 2022 08:31:40 GMT

Hi All

How can i export the list of users along with their last login

In Seetings > User and Role > Users I am able to see the list of users

But i dont see an option to export this data

I want to export them to review each of them and get approval

Thank you

aparna

Re: How to Export list of users who have access to xSOAR along with their last login

MBeauchamp2 — Mon, 28 Nov 2022 15:57:39 GMT

You can do this using the getUsers builtin command, and adding extend context to pull the full data into context. Then the ExportToCSV automation:

!getUsers extend-context=Users=. (Exports everything to the Users key in context using the extend-context option, the default doesn't return the last login of the user.)

!ExportToCSV fileName=xsoarusers.csv csvArray=${Users} headers=email,lastLogin,roles,username (exports the Users key to CSV, the headers option is optional, if you don't use it it will export all the keys as headers.)

Re: How to Export list of users who have access to xSOAR along with their last login

aparnaas — Tue, 29 Nov 2022 08:24:45 GMT

When Try the 2nd command, i am getting the below error

Error from Scripts is : Missing argument values for command ExportToCSV are : csvArray (7)

@MBeauchamp2

Re: How to Export list of users who have access to xSOAR along with their last login

MBeauchamp2 — Tue, 29 Nov 2022 17:16:24 GMT

Well, what is the Users key in context? Is it an array? Does it exist? do you have more than one user in the system? What troubleshooting did you perform?