Relationship matrix user information

[rupertkiwi]

Hi there,
I am trying to display user information on a relationship matrix.

I would like Users as the Source, and Groups as the Target.

I have created a query for the users, but can't seem to get the information displaying in the matrix:

select a.UserID AS CLASSGUID, 'Object_Type' AS CLASSTYPE,a.firstname + ' ' + a.surname AS Name
from t_secuser a
order by 3


Does anyone have any ideas?

Thanks,
Rupert

[Geert Bellekens]

Rupert,

The Relationship matrix will only show you the relations between elements (t_object) when there is a relation (t_connector) between them.

It doesn't work to show relations between users and usergroups.

You can however create a search query that will give you an overview of users and the security groups they are in.
You'll have to join t_secuser with t_secusergroup and then with t_secgroup.

Geert

[rupertkiwi]

Thanks Geert.

I already have that query:

select a.userlogin,a.firstname + ' ' + a.surname AS Name,d.groupname
from t_secuser a inner join t_secusergroup b
on a.userid=b.userid
inner join t_secgroup d
on b.groupid=d.groupid


but I wanted to display it in a Pivot table or Matrix form.

Doesn't look like it's possible unfortunately.

Cheers,
Rupert

[qwerty]

You could copy/paste the result to Excel and use grouping there.

q.