Forum Discussion
SC Orchestrator 2022 web api not showing runbooks
Hi,
I have tried all sorts of ways to try and get the web api to show runbooks but no go. Have truncated the table, replaced .net runtimes with different version.
The web console shows job data but blank for listing runbooks.
If I go to the web api http://server:81/api/runbook, I get a blank page. If I go to http://server:81/api/runbook,Jobs then I get the xml file.
Any idea what might be going on?
So I did actually find the issue. Run the following 3 commands for the Orchestrator database:
Taken from the this https://learn.microsoft.com/en-us/answers/questions/1374240/system-center-orchestrator-2022-web-api-and-consol:
GRANT EXECUTE ON object::[Microsoft.SystemCenter.Orchestrator].[GetSecurityToken] TO [Microsoft.SystemCenter.Orchestrator.Operators]
GRANT SELECT ON object::[Microsoft.SystemCenter.Orchestrator.Internal].[Settings] TO [Microsoft.SystemCenter.Orchestrator.Operators]
GRANT SELECT ON object::[Microsoft.SystemCenter.Orchestrator.Internal].[AuthorizationCache] TO [Microsoft.SystemCenter.Orchestrator.Admins]
1 Reply
So I did actually find the issue. Run the following 3 commands for the Orchestrator database:
Taken from the this https://learn.microsoft.com/en-us/answers/questions/1374240/system-center-orchestrator-2022-web-api-and-consol:
GRANT EXECUTE ON object::[Microsoft.SystemCenter.Orchestrator].[GetSecurityToken] TO [Microsoft.SystemCenter.Orchestrator.Operators]
GRANT SELECT ON object::[Microsoft.SystemCenter.Orchestrator.Internal].[Settings] TO [Microsoft.SystemCenter.Orchestrator.Operators]
GRANT SELECT ON object::[Microsoft.SystemCenter.Orchestrator.Internal].[AuthorizationCache] TO [Microsoft.SystemCenter.Orchestrator.Admins]