This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
2
Extracting from sys_history_line table
Post Flair (click to view more posts with a particular flair)
Post Body
I'm trying to create a report to get the names of those who changed the incident ticket status to on hold or awaiting. I've looked into incident metric but the created by and updated by columns only show "system", so I found my way in the sys_history_line table.
The report conditions I used are: Label contains Status New contains On hold
Now, I want to know if there's a way to extract the records for specific tickets only. Using the "Set or Set.ID contains number" doesn't seem to work
Author
Account Strength
60%
Account Age
3 years
Verified Email
Yes
Verified Flair
No
Total Karma
161
Link Karma
41
Comment Karma
120
Profile updated: 2 days ago
Posts updated: 19 hours ago
Subreddit
Post Details
We try to extract some basic information from the post title. This is not
always successful or accurate, please use your best judgement and compare
these values to the post title and body for confirmation.
- Posted
- 2 months ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/servicenow/...