Hello I need to make query like below, can anyone please help me to make the qeury?
Select UserName,AccountName, Count(all entitlement assigned from Roles), count(all entitlement not assigned by role), count (all entitlement assigned from role) / count (all entitlement not assigned by role) X 100
from tables all required
where entityname like 'A' and u.statuskey = 1
-----------------------------------------------------------------------------------------------------------------------------------
There could be entitlement part of the role but rolekey not updated property in AssignedfromRole. in this case also, we want to consider this entitlement assigned by role by looking ent_Valuekey in roles assigned to user.
