In which Tabels do I find the status of incidents?

[former_member766285]

Hi experts,

We haven't activated the reporting in our Solution Manager. However, I want to make an analysis on how long an incident remained in a specific status (e.g. created, closed, etc.). Consequently I need to make the analysis manually and therefore need to know in which table I can find the status (CRM content)?

Help appreciated!

Kind regards,

Sofie

[TomCenens · Accepted solution]

Hi Sofie

I don't mind giving a hint here but in general, I expect anyone posting questions to do research first. I doubt you've done much so I'll give a hint:

You want to search for  IT Service Management "Time Recording" or "Time Reporting".

...

Plenty of content on this which can help you get the information you seek.

Best regards

Tom

[former_member766285 · Accepted solution]

Hi Tom,

Appreciate your help. However, this is not what I was looking for.

Found the needed Information in table (CRMD_ORDERADM_H and CRM_JCDS).

Regards,

Sofie

[TomCenens · Accepted solution]

Hi Sofie

I guess I misunderstood the purpose of what you're trying to achieve

My point was already that you would probably be able to figure this out yourself if you look for the information before posting the question so I'm glad that worked out .

SLA management is also something you can configure, I assume you'll be using this information for that purpose in retrospect.

Kind regards

Tom

[former_member766285 · Accepted solution]

yes, exactly.