Hi,
Need some help with auto increment function of service account name rule. So this is our current query:
${if(Application.length() < 11 && Application.equals('CyberArk')){Type.concat('_Ca').concat(OSType.substring(0,3)).concat('user')} else if(Application.length() < 11){Type.concat('_').concat(((((((((Application.replace(' ','')).replace('(','')).replace(')','')).replace('-','')).replace('/','')).replace('.','')).replace('&','')).replace(':','')).replace('�','')).concat('_').concat(Environment.split('-')[0])} else {Type.concat('_').concat(((((((((Application.substring(0,10).replace(' ','')).replace('(','')).replace(')','')).replace('-','')).replace('/','')).replace('.','')).replace('&','')).replace(':','')).concat('_').replace('�','')).concat(Environment.split('-')[0])} }###INCREMENTINDEX###
The relevant part here is the first condition where application name equals CyberArk, there it should be Ca + either Win or Lin (based on what user selects in a dynamic attribute) + user + increment number. So this query works in one environment where there were no already present users by this name which meant the increment started from scratch. However, in a rela-time environment, we already have multiple cawinuser1,2,3....in hundreds, same with calinusers.
Does anyone have any input on how to write this code? I already tried with the below:
${if(Application.length() < 11 && Application.equals('CyberArk')){Type.concat('_Ca').concat(OSType.substring(0,3)).concat('user').concat(select count(*) from accounts a where a.endpointkey = 131 and a.name like concat('_Ca','Winuser','%'))} else if(Application.length() < 11){Type.concat('_').concat(((((((((Application.replace(' ','')).replace('(','')).replace(')','')).replace('-','')).replace('/','')).replace('.','')).replace('&','')).replace(':','')).replace('�','')).concat('_').concat(Environment.split('-')[0])} else {Type.concat('_').concat(((((((((Application.substring(0,10).replace(' ','')).replace('(','')).replace(')','')).replace('-','')).replace('/','')).replace('.','')).replace('&','')).replace(':','')).concat('_').replace('�','')).concat(Environment.split('-')[0])} }###INCREMENTINDEX###
but for some reason when i try to save this code it does not save only - im guessing there must be some flaw in this. My logic was that the count code would count the number of accounts that had something appended to cawinuser and then automatically add that number and increment the account
If someone can help would be much appreciated.
Thanks in advance
