We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Database View won't run

John Spirko
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

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