Note: The ScheduleToken is set to Since Advertised.
SQL Query:
Select
OfferName Name,
Recieved,
Failures,
ProgramsStarted 'Programs Started',
ProgramsFailure 'Program Errors',
ProgramsSuccess 'Program Success',
ProgramsFailureMIF 'Program Errors',
ProgramsSuccessMIF 'Program Success (MIF)',
PkgName Package,
PkgProgram Program,
CollectionName 'Target Collection',
PresentTime 'Available After',
ExpirationTime 'Expires After',
OfferID 'Advertisement ID'
From vOfferStatusSummarizerRoot
Where ScheduleToken = '0001128000080008'
Order by OfferName
- Edited by whiteknight8 Friday, March 20, 2015 8:43 AM