I have had issues using Orchestrator and the SCSM IPs returning values for the extensions and thought it may be more reliable to run a SQL query in SCO. The values are visible in my customized CR form so the thought is that the values exist in the DB even if SCO can't retrieve them.
What table can these values be found?
Better yet, what would the query look like to return values for a specific CR?