Need help with report on who updated articles

karen_pitcavage
Kilo Contributor

I am trying to get a report in ServiceNow that will show me the knowledge base articles that have been updated in the last 7 days, and by whom. Simple, right?

No matter what I try, I cannot get it to tell me who updated the articles. I am using the Knowledge [kb_knowledge] table, and have tried everything listed under Column in that table for the Updated By column, and nothing works. When I use plain "Updated by" under Column, it shows me "system" only, no actual users.

I have a similar report for knowledge created in the last 7 days, using the same table. For that, I use Created By for the column, and it shows me the users. How do I get the same thing for the people who have updated articles?

I've attached both the Created By report header and the Updated By report header. Can anyone help me figure out how to get the Updated By report to act like the Created By report, and show me the actual users?

Help!!!

Thank you!

4 REPLIES 4

ccajohnson
Kilo Sage

Looking at your behavior leads me to believe that there is a scheduled job or other automated process updating your knowledge articles.

See what happens when you modify a knowledge article— does the report change to include your ID?

If you are not an administrator, you will need to check with them to see if they have something running that uses system as a user ID that modifies knowledge articles. Turning that off may fix your issue, but it may be necessary for some other reason. If that is the case and it cannot be turned off, you could report on Author instead of Modified by.

I hope this is helpful,


When I modify an article, the report continue to show only "system". I do have administrator rights, but we do not have any kind of ServiceNow admin. It's maintained by the Help Desk, who does not know the answer to this.

The Author seems to show who created the articles. I already have a report that shows who created which articles, and which works just fine. But Created by and Updated by seem to be two very different animals--Created By works just fine and shows the users. Updated By does not show any user ID, including my own. You can see the screenshots to see the difference.

So the question is, what field do I choose instead of Updated By that will show which users updated articles (not created them; we already have that report)? All updates show up as "system" regardless of who actually updated the articles. I can go in and update an article, and the "system" count will increment by one, but it will not show me as the person who updated it.

I appreciate your responding, but I still have the Updated By showing only "system".


karen_pitcavage
Kilo Contributor

Not sure why this extra field appeared; can't delete it, apparently! Please disregard.


karen_pitcavage
Kilo Contributor

It turns out the field "Updated By" under the Knowledge fields doesn't work at all. But I discovered if I went to .Author → User fields, then chose "Name", it shows both who updated it and who created it. Very strange that Created By and Updated By, both Knowledge Fields, work completely differently. Still doesn't show just updates, it also shows the new articles, but I can live with that.

I greatly appreciate your attempt to help! Thank you!