CMDB Query - No relations query timing out

[suvro]

Hi,

I have a CMDB Query where I want to get the list of all applications belonginng to a specific managed by group which does not have a relatiosnship with Service Instance.

It works fine if I do not put a filter of Managed by group (its a custom field) . But as soon as I put this filter it starts timing out.

What could be the reason?

[lpruit2]

Greetings @suvro. It's a bit of a long shot but since you mentioned it was a custom field, are you interacting with CMDB Query Builder with full admin-rights? I wonder if there is a missing ACL or insufficient permissions. I've also seen other articles about CMDB QB where it times out such as adding a column to the report. 

[suvro]

Hi,

Yes I am using full admin rights

[suvro]

Anyone has any idea. It works fine in Dev instance but not in Production. What could be the issue and How I can troubleshoot this?

[CasperJT]

Hi Suvro,

Could the reason it works in dev and not prod be, that you have significantly more data and more CI's to query in prod vs dev?

Additionally is the field you are querying indexed?

As a possible alternative, have you consider setting up an audit for this purpose instead?

With an audit you would be able to define a rule that all applications should have a relationships with an application service. This audit will run daily giving you an idea of how many applications meet that criterium, but also how you are progressing in achieving your ambition.

Hope this helps.

//Casper