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.

CompeteScan

Data source: O365LSTNPOST-VM\SQL2019,51433

select
ResultID, ShortCompetitorName, Competitor,
sr.CSMonthID, MinorCSMonthID, sr.FiscalMonth, m.FiscalMonthFullName, m.FiscalQuarterName, m.FiscalYearName, ScanCode, MXSolution, PreviousScanCode, PreviousMXSolution,
Stayed, IsTrial, [Add], [Drop], AddGmail, DropGmail, AddO365, DropO365, SSOLogin, SSOLoginProvider, TPID, HasExo, PreviousSSOLogin,
DiscoveryDate, ScannedDomain, ProcessedDate, TerminationDate, AreaName, SubsidiaryName, IsMonthlyPublish
from vwFactConsolidatedScanResults sr with(nolock)
inner join [dbo].[vwDimFiscalMonth] m on m.CSMonthID = sr.CSMonthID
where
Competitor in ('Box','GApps','Line','MXRecord','Okta','SalesForce','Slack','WebEx','Workplace','Zoom')