Pulling outbound dialer call disposition for post processing?

[david.macias]

Wondering what other people have done to solve the following:

I get a dialing list from a CRM and they want to know the result of the campaign. Answered, busy, etc. What I'm struggling with is should I pull this data with a scheduled task to a local csv? Should I run an ETL job to move it to another DB, then extract it from there? The dialer only runs 9-5 so doing this after hours makes sense, but I'm trying to not over engineer this. Would love to hear how others have solve something similar without impacting the CCE environment.

Thank you!

[Omar Deen]

I've done a scheduled task with a bare minimum powershell script. I then take the CSV file and either move it to a mapped directory or FTP somewhere in the network.

[david.macias]

I figured you would have a solution. 🙂

Did you put the scheduled task on the AW or Logger? Does it run after hours or during the day?

Thank you.

[Omar Deen]

So what I did was use the Invoke-Sqlcmd cmdlet which allowed me to run the query, output it to a CSV file and place it on a mapped drive. I ran this on the Distributor so that I could query the Dialer_Detail table. It works really well... no fuss. I recommend it. Invoke-Sqlcmd is pretty powerful: https://docs.microsoft.com/en-us/powershell/module/sqlserver/invoke-sqlcmd?view=sqlserver-ps

[david.macias]

Lovely. It does blow my mind how powerful powershell has become. Gone are the days of bat files. Thank you!