How to get user details from Service Now

I have a scenario in which I have to fetch user details from service now whenever any new user creates a ticket for a particular application for access.

How to get that user details from Service now through Snaplogic?

Anyone has worked on above scenario then please help.

@Pakhi You can setup a trigger to run the pipeline with GID of user as parameter whenever a new ticket is created.
For the pipeline you can use ServiceNow Query Snap and can query sys_user table with GID supplied as pipeline parameter. This should get you all the details of that particular user.

Is there any table in service now which stores ticket details with user id?

that depends on your application. Out of the box there is incident table which stores the INC records with userid in createdby field.