CA Service Management

  • Private Community

  • 1.  recurring sql agent logs

    Posted Dec 26, 2016 07:02 AM

    Dear all,

     

    I see below recurring logs for last one hour. What is its reason? How can i stop it?

     

    12/26 14:53:02.65 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (5000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

    12/26 14:53:02.97 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (10000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

    12/26 14:53:03.43 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (15000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

    12/26 14:53:03.58 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1025 SQL Query has finished (16931) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

    12/26 14:53:04.01 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (5000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

    12/26 14:53:04.46 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (10000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

    12/26 14:53:04.85 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (15000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

    12/26 14:53:05.02 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1025 SQL Query has finished (16931) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

    12/26 14:53:05.38 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (5000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

    12/26 14:53:05.69 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (10000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

    12/26 14:53:06.04 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (15000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

    12/26 14:53:06.18 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1025 SQL Query has finished (16931) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

    12/26 14:53:06.49 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (5000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

    12/26 14:53:06.94 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (10000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

    12/26 14:53:07.46 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (15000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

    12/26 14:53:07.60 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1025 SQL Query has finished (16931) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

    12/26 14:53:08.05 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (5000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>C851F3DD7E2F9043B5E8315A5FA84CD5)

    12/26 14:53:08.41 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (10000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>C851F3DD7E2F9043B5E8315A5FA84CD5)

    12/26 14:53:08.83 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (15000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>C851F3DD7E2F9043B5E8315A5FA84CD5)

    12/26 14:53:08.99 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1025 SQL Query has finished (16931) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>C851F3DD7E2F9043B5E8315A5FA84CD5)

    12/26 14:53:09.44 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (5000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>FB79852D17C4154881DA3C65B7549489)

    12/26 14:53:09.88 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (10000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>FB79852D17C4154881DA3C65B7549489)

    12/26 14:53:10.33 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (15000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>FB79852D17C4154881DA3C65B7549489)

    12/26 14:53:10.51 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1025 SQL Query has finished (16931) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>FB79852D17C4154881DA3C65B7549489)



  • 2.  Re: recurring sql agent logs

    Posted Dec 26, 2016 08:55 AM

    Hi Utku,  this appears to be some type of report that is running.  Its pooking at the contact table and is grabing a bunch if fields along with seceral custom ones.  Are you using boxi or jasper?  If so then i would suggest stipping services on those and seeing if the query stops at that point.  

    Hope this helps

    Jon I



  • 3.  Re: recurring sql agent logs

    Posted Dec 26, 2016 11:23 AM

    Hi Jon,

     

    We are using BI but we dont get any report from prod environment.

    Additionally, those recurring logs take 45 minutes.



  • 4.  Re: recurring sql agent logs

    Posted Dec 27, 2016 08:00 AM
    Hi Utku,  looking at the messages further, i see that the username is "scolak", you may want to check out the user and see if they have a custom scoreboard query or saved search that is refreshing.

    Jon




  • 5.  Re: recurring sql agent logs

    Broadcom Employee
    Posted Dec 27, 2016 12:14 PM

    from the message, it seemed it was user "scolak" ran some built-in reports on incident details. built-in reports are those from web interface

    when you click on reports->detail...

    it is a best practice to restrict the end users to run such reports otherwise it could clog the app. usually you use DP or web page customization for this purpose.