query current report only and not since advertised but removing the since advertised give me multiple row
How can i query the current report only?



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
March 20th, 2015 8:42am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics