Unable to see incident_sla in tables but can see it in reports?

[andyy]

Hi, I can see the incident_sla table in reports, have created a report that I want to view on a dashboard. I can view the results on the dashboard as admin but itil users get "Security constraints prevent access to requested page". In trying to diagnose the cause (all publishing it to the ITIL role) I have found that I cant see the incident_sla table in the table list despite being admin etc. I have checked and also cant see an ACL on that table. Is it know as something differently or not a real table (some kind of ad-hoc join between task_sla and incident)? Any thoughts why the report results would be security constrained from ITIL users who can see the sla tasks themselves? Many thanks

[shloke04]

Hi ANdrew,

Incident_Sla table is a join of Task Sla and Incident. To give access for that table to ITIL Users.Write an Read Access ACL for the same both at the Table level as well as on the field level with the Role Condition selected as "itil" role on the ACl's.

I tested this out and its working for me.

Mark the answer as correct/helpful based on impact.

Regards,

Shloke

[amlanpal · Accepted solution]

Hi Andrew,

This incident_sla is a OOB database view available in System definition-->database views. From Fuji onward you need to provide separate access via ACL on the database views to generate reports, just same as Shloke said above. Please find 1.1 in the below link.

http://wiki.servicenow.com/index.php?title=Database_Views#gsc.tab=0

I hope this helps.Please mark correct/helpful based on impact

[andyy]

Thank you both very much