Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Does not work for me ( hide admin from reassignments)

HOMER333
New Contributor III
New Contributor III

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 

6 REPLIES 6

pmahalle
All-Star
All-Star

Hi @HOMER333 ,

Can you put below query in Consult User Query

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

pmahalle_0-1689783152702.png

 


Pandharinath Mahalle(Paddy)
If this reply helps your question, please consider selecting Accept As Solution and hit Kudos 🙂

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

@cedric ,

Its not necessary, you can skip that part.


Pandharinath Mahalle(Paddy)
If this reply helps your question, please consider selecting Accept As Solution and hit Kudos 🙂

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
All-Star
All-Star

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

dgandhi_0-1689785662943.png

 

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.

HOMER333
New Contributor III
New Contributor III

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