SCCM SQL Query : Advertisement Status For Multiple Advertisement IDs

Select

OfferName Name,

Recieved,

Failures,

ProgramsStarted Started,

ProgramsFailure Errors,

ProgramsSuccess Success,

OfferID ‘Advertisement ID’

From vOfferStatusSummarizerRoot

Where ScheduleToken = ’0001128000080008′

And OfferID In (‘XXX12345′, ‘XXX67890′)

Order by OfferName