Saviynt Forums

William3squivel · ‎07/19/2023

Our team is looking to hide admin and systemadmin accounts when a users selects the (does not work for me option in step 1 of employment verification). Is there a query to hide these accounts so users do not reassign there certification to admins

pmahalle · ‎07/19/2023

Hi @William3squivel ,

Can you put below query in Consult User Query

select u from Users u where 1=1 and u.username not in ('admin', 'systemadmin')

Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

johnson · ‎07/31/2023

I'm curious, why is the 1=1 part necessary?

pmahalle · ‎07/31/2023

@johnson ,

Its not necessary, you can skip that part.

Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

dgandhi · ‎07/31/2023

This is not required and will work without adding 1=1 condition.

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.

dgandhi · ‎07/19/2023

Can you add below query in the consult/reassign user query

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.

William3squivel · ‎07/19/2023

Thank you, the query worked and removed admin and system admin from the reassignment view.

Saviynt Forums

Does not work for me ( hide admin from reassignments)