How to get user details from Service Now

[Pakhi]

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?

[Pakhi]

Anyone has worked on above scenario then please help.

[Chandan]

@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.

[Pakhi]

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

[Chandan]

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