Note: This content is automatically generated by the ETL tool. Last build time is 2024-03-19 13:44:37. Please contact MWS Insights Data Infrastructure for the query.

SupportAgreement

Data source: link://ssdmcubes.trafficmanager.net

EVALUATE
SUMMARIZECOLUMNS(
AgreementOverview[MSSales ID],
AgreementOverview[Agreement ID],
AgreementOverview[Agreement State],
AgreementOverview[Agreement Status],
AgreementOverview[CSAM],
AgreementOverview[CSAM Manager],
AgreementOverview[Package ID],
AgreementOverview[Package Name],
AgreementOverview[Package State],
AgreementOverview[Package-CSAM],
AgreementOverview[Package-CSAM Manager],
AgreementOverview[Package-Start Date],
AgreementOverview[Package-End Date],
AgreementOverview[Package-Offering],
AgreementOverview[Package-Sub Offering],
AgreementOverview[Package-Sold Advisory Hours],
AgreementOverview[Package-Sold Proactive Hours],
AgreementOverview[Package-Sold Proactive/EDE/STA Hours],
AgreementOverview[Package-Sold EDE/STA Hours],
AgreementOverview[Package-Sold Reactive Hours],
AgreementOverview[Package-Sold SDM Hours],
AgreementOverview[Package-Consumed Proactive/EDE/STA Hours],
AgreementOverview[Package-Consumed Reactive Hours],
AgreementOverview[Package-Consumed SDM Hours],
AgreementOverview[Package-Over Consumed Proactive/EDE/STA incl Unbilled Hours],
AgreementOverview[Package-Remaining Proactive/EDE/STA Hours],
AgreementOverview[Package-Unbilled Booked Proactive/EDE/STA Hours],
AgreementOverview[Work Performed For],
AgreementOverview[WPF TPID],
filter(AgreementOverview,AgreementOverview[Is Package Excluded]=false),
filter(AgreementOverview,AgreementOverview[Package State]="Active")
)