DB Query Asset to Owner

1

Hi All

Can anyone tell me what the DB linkages are to get the owner for an asset .

Thanks in advance as always

P.

2

If you have the asset ID you can check the “Groups” table look for:

SELECT ( id ) FROM Groups WHERE ( Domain = 'RT::Asset-Role' AND Instance = '123' );

Using the group ID you can check the “GroupMembers” table for that GroupId and the MembersId values.