I've moved this post to Server Administration , where you might get more replies.
As for your question, here is a helpful reference for you.
I am having the exact same issue, wanting to report on Incidents / tasks, but joining the data is a nightmare.
Hopefully someone can help with this soon.
Have you had any lucky getting the data pulled? I am still facing the same issue.
Let me know the subject you are concentrating. Many of them we get alone in Incident, Change_Request Tables. Task is just a single table which contains all the data of Incident, Change_Request, Problem etc.
I've messed with this a bit and have some good joins that work:
Task.SysID = Incident.SysID
Incident.AssignmentGroup = Group.SysID
Incident.AssignedTo = User.SysID
If you don't need Incident, you can exclude it and join Task to Group and User the same way.
Highly recommend registering for ServiceNow Community. This is where I got all of my information. Check out this thread: Database Schema for select tables offered via T... | ServiceNow Community
Thank you for the information, I have a few concerns though.
You used left joins, meaning it will show data regardless if there is a match to the other table or not (when I do this I get results but no matches)
So I used inner joins between these tables with the suggested links, and I get no matches between the GROUP or USER tables when connecting to INCIDENT.
I do however get matches when i link the TASK to the INCIDENT tables.
Any other suggestions?
To have the records fetched i suggest the below. Group left outer join on User and Left outer join on Incident as each Incident is assigned to a user and user is part of any of the groups.
The join I shared only works if you want Incidents. For Tasks only, exclude the Incidents table and try that.
I suppose if you want Tasks and Incidents in one data source, you might be able to left join Tasks to Incidents and then join Users and Groups to both Tasks and Incidents.
Hope I didn't give you bad information. Please see this link for detailed info from a ServiceNow guru: Database Schema for select tables offered via T... | ServiceNow Community.
Here is an example of the info provided:
Also, please see Kasi's suggestion above.
On which columns though? How do you join group and user?