Performance Analytics / Platform

[JohnEJasinski]

How do we report on the Comments entries in Analytics Hub?   What table?

As Control Managers, we would like to improve our reporting from ServiceNow, on indicators for control breaches – using the Comments field, from Analytics Hub entries, in order to reduce manual tracking.

Anybody?   

Great karma will be gained upon your helpful response.  😊

Thanks!   JJ 

[Uncle Rob · Accepted solution]

I thought this would be an easy one to track down, but I've dug for 30 minutes and coming up empty.
I checked SNUtils to see what tables contained "comment" and thought I might have hit paydirt with pa_score_notes.  
But that table turned up empty even though I put in a bunch of test comments.
And it doesn't reference anything but user.  😞

4 pages of Google results also came back fruitless.
Perhaps the legendary @Adam Stout might know?

[JohnEJasinski]

Comment [pa_score_notes] - did work - but fields limited 

hope NOW Pdct team reading - come on give us more with this

Giving Uncle Rob the "Solution" - A for tip and effort, and since he's such a GREAT NOW person - tanks to da Duke!  🙂  

JJ

@ Michael Culhane - kudos to you too!   A NOW Master. 

JJ