Discover what assets have been applied with a workflow schema

Squiz Matrix General Discussion
1

Hi,

Is there any way to ascertain what assets have been applied or linked to a workflow schema?

 

with thanks.

2

Hi,

You should be able to find this out using Usage Screen on workflow schema.

 

Ash

3

Thanks Ash,

What about user group? how do we find what assets have been assigned the permission to the user group?

4

one LDAP user group has been deleted, how to find all the assets which had the relationship with this user group?

thanks.

5

Thanks Ash,

What about user group? how do we find what assets have been assigned the permission to the user group?

 

Hi,

Doesn't look like there is any direct way of doing this. But if you have access to DB you should be able to find out what is required. Also using a simple Query with DB Datasource should help you list the user group and the assets it is granted permissions on.

 

Ash

6

one LDAP user group has been deleted, how to find all the assets which had the relationship with this user group?

thanks.

 

The above solution I mentioned on the other reply would work here too.

The table you need to query is sq_ast_perm. And it is defined as follows:

 
\d sq_ast_perm;
 
   
   Column   |          Type          |                Modifiers
------------+------------------------+-----------------------------------------
 assetid    | character varying(255) | not null
 userid     | character varying(255) | not null default '0'::character varying
 permission | smallint               | not null default 0
 granted    | character(1)           | not null default '0'::bpchar
 cascades   | character(1)           | not null default '1'::bpchar
7

in table sq_ast_perm, is the userid for the usergroupid? and assetid is for all the assets?

any example of the query?

thanks!

8

Hi,

Yes the userid column will have the usergroup id (e.g  XXX:ou=Labs,ou=Staff,o=Company,c=au,dc=demo etc.). and the assetid will be all the assets the permission for that usergroup is granted to. 

For more detailed result you can add granted column parameter to the query to see if the permissions granted is 1 ,2 ,3 for read, write and admin respectively.

 

Example:

To get all the assetid where the permissions granted to '12345' userid is admin:

 

 

SELECT assetid from sq_ast_perm WHERE userid = '12345' and permission = 3;
 

 

 

 

To get all the assetid where the permissions granted to 'XXX:ou=Labs,ou=Staff,o=Company,c=au,dc=demo' (LDAP) usergroup is more or atleast write:

 

 

SELECT assetid from sq_ast_perm WHERE userid = 'XXX:ou=Labs,ou=Staff,o=Company,c=au,dc=demo' permission > 1 and granted = '1';
 

 

 

Hope this helps. 

 

Ash

9

Thanks, really appreciated.