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.

Orchestrator runbooks not syncing to SCSM

Today I copied one Orchestrator runbook from my test environment over to the production environment. Then I went to the Service Manager console and requested the Orchestrator connector to Synchronize, which it successfully did.

But I could not see the runbook showing up in the SCSM console. Neither could I find it on the Orchestrator web console.

Resolution:
1. Open SQL Management studio and connect to the SQL Server and instance hosting the Orchestrator Database

2.Type in the following SQL Query:

TRUNCATE TABLE
[Microsoft.SystemCenter.Orchestrator.Internal].AuthorizationCache

Refresh the Orchestrator web console, and the runbooks are there.

Resyncing the Orchestrator connector finally put the runbook in SCSM and I could proceed creating my runbook automation template