I’m working on a requirement to build a dashboard that shows a monthly breakdown of Knowledge Article updates. Specifically, I need to distinguish between two types of changes:
Content Modified: Articles where the actual text or body was updated.
Date Extension Only: Articles where only the Valid To date was changed (and no other fields were touched).
I’ve tried using Metric Definitions on the kb_knowledge table for the valid_to field, but I’m having trouble getting it to capture the data correctly in metric_instance. It seems like metrics are better for durations rather than just flagging specific field-level change events.
Has anyone done this before? I'm thinking a Business Rule might be the way to go to log these changes to a custom table, but I’d love to know if there's a simpler way to do this using out-of-the-box reporting or audit data without hitting performance issues.
Any guidance or script snippets would be greatly appreciated.
