Any tips & trix how to get an report of users i ms-SQL repository

[steen.jensen]

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

[qwerty]

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

q.

[rupertkiwi]

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

[steen.jensen]

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