select count(a.id) from com.soffid.iam.model.AccountEntity as a where a.type='P' and a.system.url is not null and a.system.tenant.id=:tenantId
Returns
java.lang.Long
getPamAccounts
select count(a.id) from com.soffid.iam.model.AccountEntity as a where a.launchType = 'P' and a.system.tenant.id=:tenantId
Returns
java.lang.Long
getPamAccountsExpiredPassword
select count(a.id) from com.soffid.iam.model.AccountEntity as a where a.launchType = 'P' and a.passwordStatus = 'PASSWORD_GOOD_EXPIRED' and a.system.tenant.id=:tenantId
Returns
java.lang.Long
getPamAccountsWrongPassword
select count(a.id) from com.soffid.iam.model.AccountEntity as a where a.launchType = 'P' and a.passwordStatus = 'PASSWORD_WRONG' and a.system.tenant.id=:tenantId
Returns
java.lang.Long
getReservedHPAccounts
select count(ua.id) from com.soffid.iam.model.UserAccountEntity as ua where ua.account.type='P' and ua.account.system.url is not null and ua.account.system.tenant.id=:tenantId
Returns
java.lang.Long
findByText
from com.soffid.iam.model.AccountEntity where :text is null
select acc
from com.soffid.iam.model.AccountEntity acc
left join acc.users as users
left join users.user as user
where acc.type='U' and user.id = :userId order by acc.name
select acc
from com.soffid.iam.model.AccountEntity acc
join acc.users as users join users.user as user where user.userName=:user and user.tenant.id=:tenantId and acc.system.passwordDomain.name=:domain and acc.type='U'
select acc
from com.soffid.iam.model.AccountEntity acc
left join acc.users as users
left join users.user as user
left join acc.system as dispatcher
where acc.type='U' and user.userName = :user and dispatcher.name = :dispatcher and dispatcher.tenant.id = :tenantId order by user.userName, acc.name
select acc from com.soffid.iam.model.AccountEntity acc where acc.name = :name and acc.system.name = :system and acc.system.tenant.id = :tenantId order by acc.name
