Glide Record not working in Database view

[Garima Pant1]

I created a database view for 3 tables- cmdb_ci (Configuration Item), cmdb_software_instance (Software Instances), cmdb_ci_spkg (Software Packages). When I try to glide into the table and get the number of records, it shows me incorrect value.

Database view: u_softwares_on_windows_servers

Table	Order	Left join	Active	Variable prefix	Where clause
cmdb_ci	100	true	true	cmdbci	(cmdbci_sys_id = si_installed_on)
cmdb_software_instance	200	false	true	si
cmdb_ci_spkg	300	false	true	sp	si_software = sp_sys_id

Total records in database view: 1,000,954

Records shown when gliding the table: 10,001

Background script : 

var incidents = new GlideRecord("u_softwares_on_windows_servers");
incidents.query();
gs.print(incidents.getRowCount());

[Ravi9]

See if this helps !
doc link

[Nikita30 · Accepted solution]

Hi Garima,

Please edit the property glide.db.max_view_records to manage the number of records in the database view.

Please mark the response as Helpful/Correct, if applicable. Thanks!