Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Database View won't run

John Spirko
ServiceNow Employee
ServiceNow Employee

Am I doing something wrong here?  I'm not sure why this just spins.

 

JohnSpirko_0-1746658167252.png

 

2 REPLIES 2

John Spirko
ServiceNow Employee
ServiceNow Employee

Got it but it feel backwards.

JohnSpirko_0-1746660224296.png

 



folusho
Tera Guru

@John Spirko 

 

I tried the same in my instance, and it doesn't hang... no performance issues observed. I suspect you may be trying to return a very large number of records, or your query on the cmdb_rel_ci table is causing the slowdown due to its size.

I recommend adding more conditions to the WHERE clause on the relationship query to improve performance.

 

 

folusho_0-1746660189234.png

 

folusho_2-1746660376020.png