Can an AI Agent search the sys_user table? If so, how?

[MiguelSalvador]

Hello everyone!

This is my first post ever in the community, so if i made a mistake on this post, please do tell me.

I am implementing Now Assist for a client, it is still in demo phase, to show them how everything is going, i showed them a new functionality that was requested, where it unlocked a user that was locked out, all by just chatting with Now Assist, and they asked me if it could also tell if a user was locked out or not, and i have been testing several things to try to get it to that, but i still did not find a way. 

Is it even possible?

Thank you all in advance!

[Tanushree Maiti]

Hi @MiguelSalvador 

Check if you are looking for this KB:

KB3031064 Error "You don't have the required access to complete this request. Try another request." ... 

Resolution

1. Create a new AI user with a valid user ID.
2. Assign the required roles (e.g., admin and sn_aia_admin) to the new AI user.
3. Configure the Define data access setting in the AI Agent to use the new AI user with the valid user ID and assigned roles.
4. Verify that the AI Agent operates successfully with the new configuration.

[MiguelSalvador]

Hello @Tanushree Maiti 

Thank you for your reply, but it unfortunately is not the case. I did give the agent the admin role, so it would have access to everything i have, and it still can not recognise if/when a user is locked out. 

My suspicion would be that it simply is now allowed to do it, or maybe i need to create a tool where it can search the sys_user table, although i tried a few tools (so far i tried Search Retrieval Tool, and Subflow tool), and was unable to get the AI Agent to read the locked out state and give a correct answer.

With this extra context, do you have any idea if I'm doing something wrong, or if is this even allowed?

Thank you for your help so far,

Regards