Create Report to Show Incidents created without Configuration Item

[Alex Wa]

I need to show a report that has incidents that were created where the Configuration Item is blank.
The report is intended to see how often CIs are assigned at incident creation.
I can easily create a report to see incidents without a CI but want to view incidents that may have a CI assigned now but were blank when the incident was created.

Can anyone help provide any guidance?

[Mike_R]

Unfortunately, I don't think there's an easy way to get this without a script and querying the audit table. 

For Incidents going forward, you have a few options:

• Create a new Metric Definition to track this https://docs.servicenow.com/en-US/bundle/tokyo-platform-administration/page/use/reporting/task/creat...
• Create a new field on the Incident table to track the time that the CI was added. Populate it via Business Rule.
• Just make the CI field mandatory if this is something you wish to enforce.

[SanjivMeher]

You can create a report on sys_history_line table get where old value is empty and newValue is not empty and element id is cmdb_ci and table is incident. But the table is huge/...So may take some time to load.

[OlaN]

Hi,

Do you save this detail on the Incident, whether the record was created without a connected CI or not?

If you're not saving this data, it's kind of hard making a report on it.

You can create a field (true/false) that is set to true only if a Incident is created with a CI connected at insert (create a Business Rule to set the value), and then report on it later on when you have collected enough data.