Access and Reporting on Generative AI Logs (sys_generative_ai_log)

[mouradhadj-]

Hello Community,

I am working on developing Custom Reporting and Performance Analytics (PA) KPIs for our Now Assist adoption and usage. I have identified two key tables for reporting:

1. sys_gen_ai_usage_log (The main usage log for billing and high-level activity).

2. sys_generative_ai_log (A deeper log table that seems to contain more granular data).

I've encountered a security issue with the second table and have some related questions on its reporting utility and risks.

---

1. Access Issue with sys_generative_ai_log

When attempting to view or report on the sys_generative_ai_log table, I receive a security constraint message (as shown below).

"Security restricted access to data in the table Generative AI Log [sys_generative_ai_log]. Number of rows removed from this list by Security constraints: 20"

My Question:

• What specific ACL/Role is typically required to gain read access to the sys_generative_ai_log table? I have already added the main usage table (sys_gen_ai_usage_log) to the glide.ui.permitted_tables property, but this deeper log seems to have additional restrictions.

---

2. Reporting Utility: Counting Skills per Ticket

Assuming I gain access, I want to confirm if the sys_generative_ai_log table can solve a specific reporting challenge.

The main usage table (sys_gen_ai_usage_log) is great for counting unique tickets where AI was used (COUNT DISTINCT on the Document field). However, I want to know the total number of individual skills or use cases triggered per ticket (e.g., Ticket INC123 had 'Summarize' (1) and 'Suggest Resolution' (1) = 2 Skills/Use Cases used).

My Question:

• Does the sys_generative_ai_log table contain a more granular record of each skill trigger or AI step that would allow me to accurately calculate the "Average number of use cases used per ticket"?

---

3. KPI Ideas and Data Risks

I'm looking for suggestions on valuable KPIs using this granular data. I am already implementing:

• Adoption: % of tickets resolved with at least one use case used.

My Questions:

• KPI Suggestions: Does anyone have suggestions for "Value" or "Quality" KPIs using the detailed data from sys_generative_ai_log? (e.g., correlating logs with the Feedback field).

• Data Access Risks: Given the sensitivity of the data (prompts and potential responses are logged), are there any security or performance risks to be aware of when granting broad read or report_on access to the sys_generative_ai_log table?

Thank you in advance for any insights!

Best regards,

[GlideFather]

Hi @mouradhadj-,

it's up to you to trust @MaxMixali or not. They posted tens of similar messages, obviously copied from gen AI client and most of the stuff they posted today was incorrect.

You can make oyur own opinion by reviewing their replies :))) I would recommend you not to take their message seriously but it's up to you.

In regards to your issue, I faced the same situation and I didn't manage to solve it 😕 the only option I saw and I shared with you above - to update the ACL, you did it and it didn't help??

[Yogesh Shinde]

Hi @mouradhadj- , 

sys_generative_ai_log is behind the Maint wall, i.e., only ServiceNow internal staff can access it. For Maint operations, raise a support (HI) ticket.

However, you can access sys_gen_ai_log_metadata, which contains a subset of non-sensitive fields from sys_generative_ai_log and is designed for admin reporting and analytics. It does not include all columns or sensitive data, but it is useful for most analytics use cases.

Also, for reporting, check the OOTB KPIs/Metrics in Now Assist Admin > Analytics.

[Yogesh Shinde · Accepted solution]

Hi @mouradhadj- , sys_generative_ai_log is behind the Maint wall, i.e., only ServiceNow internal staff can access it. For Maint operations, raise a support (HI) ticket.

However, you can access sys_gen_ai_log_metadata, which contains a subset of non-sensitive fields from sys_generative_ai_log and is designed for admin reporting and analytics. It does not include all columns or sensitive data, but it is useful for most analytics use cases.

Also, for reporting, check the OOTB KPIs/Metrics in Now Assist Admin > Analytics.

[mouradhadj-]

Hello @Yogesh Shinde ,

Yes with this table sys_gen_ai_log_metadata i found what i need Thanks for your Help,
but it seems the metadata table & metadata document column are not recorded for my previous Usage its empty when i m using my custom use case, only recorded for OOTB use case