By default the maximum number of results that will be displayed in a query result prompt in a request offering form is 500. This limit is to ensure that the SCSM database is not too heavily impacted by returning very large data sets such as "all users". That would result in a large impact to the database, network, etc. and also result in a poor user experience. Rather than returning very large lists in a query result prompt it is recommended to use other prompts prior to the query result prompt to gather some information that can be used as criteria to the query result prompt. For example, you could create a simple list prompt that prompted the user for the user's department and then use the selected department as criteria to the query.
However, it may still be necessary to change the max number of results that can come back from the SCSM database. This setting can be configured in SettingsItem table, key:
GridviewRecordCap
See: User Guide: Overview of Setting Items options
Important notes:Â This setting also impacts the max number of results that comes back in a work item grid view such as Active Work, Team Work, My Work, etc. so it is important to think of the impact on the performance of the system in general considering that as well.