Tables for generating reports, with information on all assignments of the same incidents and/or requests.

[Patrick Rajao]

Hi! Please can anyone tell me if there are any tables that have the information and/or lines of all designations of the same incident or request. I found the sys_history_line and sys_history_set tables, however when I go to the reports, these tables do not appear in the list for generating reports.
Can anyone help me?
Thanks.
Patrick Rajão.

Olá! Por favor alguém sabe me dizer tem alguma tabelas que possua as informações e/ou linhas de todas designações de um mesmo incidente ou solicitação. Encontrei as tabelas sys_history_line e sys_history_set, porém quando vou nos reports, esta tabelas não aparecem da lista para geração de relatórios.
Alguém consegue me ajudar?
Obrigado.
Patrick Rajão.

[Tony Chatfield1 · Accepted solution]

Hi, you might need to clarify your requirements as the post is not clear, IE what does 'designations of the same incident or request' mean?

If you want to report on (re) assignments relating to tasks you should use 'Metrics'

https://docs.servicenow.com/bundle/sandiego-platform-administration/page/use/reporting/concept/c_MetricDefinitionSupport.html

There are some OOB Metric definitions which might deliver your requirements for the incident table (these can be copied and utilized on any other task table), you can also create your own Metric definitions

/metric_definition_list.do?sysparm_query=&sysparm_view=

Reporting on core system tables is not considered best practice as it has the potential to greatly reduce the performance of your instance, ServiceNow prevents reporting on most system tables OOB which is why you cannot see them to run your reports and in my opinion they do this for a very good reason.

If you require custom reporting that using Metrics will not deliver then you can always look at a custom table to record the milestones/details that you require for your reporting.

[Patrick Rajao]

Hi! When I say all assignments, it's a history of all the times that an incident or request was directed to the solution groups, containing the date information of this direction, which group was directed at this moment, etc.
I put the sys_history_line table as an example, as attached, but this table does not appear in Reports so that I can generate indicators.

Olá! Quando digo todas as designações é um histórico de todas as vezes que um incidente ou requisição, foram direcionadas para os grupos de solução, contendo as informações de data deste direcionamento, qual o grupo que foi direcionado neste instante etc.
Coloquei como exemplo a tabela sys_history_line, conforme anexado, porém esta tabela não aparece em Reports para que eu gere indicadores.