Maintain Sparx User - Reporting

[Mintra]

Hello,

Is there a way to export the user/group list from the system? I need to do a report on the Sparx user, and manually entering each user into the spreadsheet is time-consuming.

Also, I was wondering if there is a limitation or how many licenses can Sparx consume?

TIA!
Mintra

[Geert Bellekens]

You can write an SQL search containing the users and groups and export the results to CSV

Something like

Code: [Select]

select u.UserLogin, u.FirstName, u.Surname, g.GroupName
from t_secuser u
left join t_secusergroup ug on ug.UserID = u.UserID
left join t_secgroup g on g.GroupID = ug.GroupID
Geert