Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

CMDB Query - No relations query timing out

suvro
Mega Sage

3 weeks ago

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?

 

 

0 Helpfuls
  • 398 Views
4 REPLIES 4

lpruit2
Mega Sage

3 weeks ago

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. 

0 Helpfuls

suvro
Mega Sage
In response to lpruit2

2 weeks ago

Hi,

Yes I am using full admin rights

0 Helpfuls

suvro
Mega Sage

2 weeks ago

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?

0 Helpfuls

CasperJT
Tera Guru
In response to suvro

2 weeks ago

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

0 Helpfuls