Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: steen.jensen on April 14, 2023, 07:59:21 pm

Title: Any tips & trix how to get an report of users i ms-SQL repository
Post by: steen.jensen on April 14, 2023, 07:59:21 pm

Halloy.
We have about 65 users i ouer ms-SQL repository in 15 diffrent user groups.
Is there any doc-template or SQL-script that can list users och groups för possible export to excel & document printout

Title: Re: Any tips & trix how to get an report of users i ms-SQL repository
Post by: qwerty on April 14, 2023, 08:48:34 pm

Query t_secuser and t_secgroup. That should get you the reasonable information.

q.

Title: Re: Any tips & trix how to get an report of users i ms-SQL repository
Post by: rupertkiwi on April 17, 2023, 02:40:34 pm

this might help :

select d.groupname AS Groupname,a.firstname + ' ' + a.surname AS Name
from t_secuser a
inner join t_secusergroup b on a.userid=b.userid
 inner join t_secgroup d on b.groupid=d.groupid
 order by 1,2

Title: Re: Any tips & trix how to get an report of users i ms-SQL repository
Post by: steen.jensen on April 18, 2023, 07:46:21 am

Quote from: rupertkiwi on April 17, 2023, 02:40:34 pm

this might help :

select d.groupname AS Groupname,a.firstname + ' ' + a.surname AS Name
from t_secuser a
inner join t_secusergroup b on a.userid=b.userid
 inner join t_secgroup d on b.groupid=d.groupid
 order by 1,2

Thanks  8)