Hello,
I am trying to update the rank of service account owners using enhanced query but its giving me the error as in the screen shot .
select
ao.ACCOUNTOWNERKEY as accountowners__primarykey,
'26' as accountowners__RANK
from
accounts a,
endpoints e,
securitysystems ss,
accountowners ao,
users u
where
a.ENDPOINTKEY = e.ENDPOINTKEY
and a.ACCOUNTKEY = ao.ACCOUNTKEY
and u.USERKEY = ao.OWNERUSERKEY
and u.statuskey is not null
and a.ACCOUNTTYPE = 'Service Account'
and a.status in ( 'Manually Provisioned', 1, 'Active' )
and e.SECURITYSYSTEMKEY = ss.SYSTEMKEY
and ss.STATUS = 1
and e.status = 1
and e.ENDPOINTKEY in (14, 12, 10, 11, 59,91) and ao.rank = 1
and a.name in
(
select
tb2.accountName
from
(
Select
tb.AccountName,
tb.ACCOUNTTYPE,
tb.EndpointName,
tb.ServiceAccountName,
tb.AccountStatus,
GROUP_CONCAT(
tb.rank
ORDER BY
tb.rank SEPARATOR ','
) AS concatenated_values
from
(
select
a.name as 'AccountName',
a.ACCOUNTTYPE,
e.endpointname as 'EndpointName',
a.name as 'ServiceAccountName',
a.status as AccountStatus,
ao.Rank
from
accounts a,
endpoints e,
securitysystems ss,
accountowners ao,
users u
where
a.ENDPOINTKEY = e.ENDPOINTKEY
and a.ACCOUNTKEY = ao.ACCOUNTKEY
and u.USERKEY = ao.OWNERUSERKEY
and u.statuskey is not null
and a.ACCOUNTTYPE = 'Service Account'
and a.status in (
'Manually Provisioned', 1, 'Active'
)
and e.SECURITYSYSTEMKEY = ss.SYSTEMKEY
and ss.STATUS = 1
and e.status = 1
and e.ENDPOINTKEY in (14, 12, 10, 11, 59)
) as tb
group by
tb.AccountName,
tb.ACCOUNTTYPE,
tb.EndpointName,
tb.ServiceAccountName,
tb.AccountStatus
having
concatenated_values not like '%26%'
) as tb2
)
group by a.name, e.endpointname, ao.rank
Do u have an example of how to add a user as an owner to the service account as a default action? also I cant see the "Primary" and "Secondary" certifiers as options to assign to a user
