• Admin. Platform Usage By Organization:
  
  • Dataset Report_PlatformUsageByOrganization, new fields:
    • IncomingSMS
• DBA structure changes
  • new tables
    • dbo.CmdOutput
      • fields
        • id
        • output_value 
        • cdate
        • processName

LOGIC CHANGES:

• ETL db changes:
  • changes procedures:
    • dbo.Upload_F_InteractionSkills
      
    • dbo.Upload_F_AgentLife
• DBA db procedures changed:
  • dbo.CleanYearDbs
  • dbo.DropDatabaseOnAO
  • dbo.DropDatabaseFromAOGroup
• Jobs changed:
  
  • ReassignSubscription
• Admin. Platform Usage By Organization:
  • procedures changed:
    • DW.spRpt_CustomersComparativeVoiceMinutes
  • Incoming SMS: 
    • Previous:

      • -

    •  Current:
      • Count(F_Interactions.InteractionId)
        F_Interactions.InteractionCreationType = 'Incoming'
        F_Interactions.InteractionMedia = 'SMS'