Courion Tip – Requests

The information for a request that is pending approval is stored in the transaction repository. In my case, the transaction repository is [ILM].[dbo], yours is probably different.

SELECT * from [TransactionRepository].[RequestView] order by RequestID desc

SELECT * from [TransactionRepository].[ApprSteps] order by RequestID desc

SELECT * from [TransactionRepository].[AttributesView] order by RequestID desc

  • Contains ALL the details that you have exposed in the Unique Resource Data.
Advertisements

Posted September 29, 2011 by mmdmurphy in Courion Tip

Tagged with

%d bloggers like this: