SCSM Self Service Portal MaximumInstanceCount

Challenge:

You create a request offering in Service Manager which contains a Query Result prompt that returns a large result set. The Self Service Portal that ships with Service Manager (SMPortal) will only return 2000 values. If you are lucky you will find your value there, but otherwise you are out of luck.

Solution:

Extend the value that limits the result set

1. Open IIS Manager on your web server that contains SMPortal

2. Extend Sites > SCSMWebContentServer > ServiceHost

3. Double click on Application Settings

3. Create a new application setting by pressing Add in the task pane

4. Enter MaximumInstanceCount with your desired value

Please note that this will slow down/halt your silverlight application in the web browser until it is finished loading the result from the query. Consider changing your query or splitting the request offering into multiple offerings.