Finding no contacted numbers in OCS calling list

[cavagnaro]

Hi guys,
One question, have any of you created a query to find which numbers (not how many) or better said, contacts, have been not contacted after the campaign have ended at the end of the day?
Thanks

[blakshmikanth]

select count(*) from <table_name> where attempt = 0 and chain_n in (select distinct(chain_n) from <table_name>)

Cheers,
Lucky

[PhoneBill]

Don't forget to account for any dialing filter that might be applied to the campaign calling list as well as other factors such as if you are checking after the last dial_till time. Checking after you unload the campaign will ensure there aren't any in progress as well.

[cavagnaro]

Yes attempt=0 will do a part, but for example, a chain_id with 3 chain_n and all 3 chains gave me No Answer will have attempt > 0 and even is not a contacted customer because we dialed and tried but no answer from remote side. Same for busy, faxes, SIT, etc.
I have a query with these values but I believe I might be missing some ideas.

[cavagnaro]

Taking blakshmikanth query as a base I believe this can be the one:

select * from <table> where call_result!=33
and chain_id not in(select distinct chain_id from <table> where call_result=33)

What do you think?

[blakshmikanth]

Cavangro,

As you are aware, chain_id may contain 'n' records for a single contact and will return more number of records than expected.

To find the no. of contacts, I modified the query as below

select count(*) from
(
select distinct chain_id from <table> where chain_id not in
(select chain_id from <table> where call_result=33)
)

Is it helpful?

Regards,
Lucky

[cavagnaro]

Yes, in order to determine the ammount of customers 
Thanks!