ICM 7.1 scripting ICM 7.1 scripting asim78 (TechnicalUser) (OP) 17 Feb 09 14:37 we are using IPCC 7.1 with CVP 3.1, ICM 7.2 is there any way to block the customer that called the customer service number more that 5 times per daythanks RE: ICM 7.1 scripting whykap (Vendor) 17 Feb 09 18:09 is this a specific customer or any customer that happens to call 5 times in a 24hr period? You can by using ANI as a variable that has a counter on that specific ANI and route the call wherever you want (including hung up).Excellent customer service by the way. RE: ICM 7.1 scripting PDHall (MIS) 18 Feb 09 00:35 I guess you could write a query on the TCD to search for ANI's with more than 5 records for that date and then add the number to a blacklisted for the day table which you would need to look up against, bit chunky but should work! RE: ICM 7.1 scripting asim78 (TechnicalUser) (OP) 18 Feb 09 12:10 THANKS all for quick responsewe made sql insert trigger to get ANI and datetime for each call that reached (termination call detail table) and put the result on onother table the problem is termination call detail table not inserting to table which we want to put the result in it we test this trigger with onother table and it worked findplease help RE: ICM 7.1 scripting vampirej (TechnicalUser) 24 Feb 09 10:03 Having thought about what you want to do, you may need a SQL job or DTS packages to extract data from TCD, and then import these results into another table.Another thing you could perhaps try to do is to query directly on TCD, setting the DateTime variable as today. Bear in mind that TCD writes at least 2 records per call. RE: ICM 7.1 scripting rosy1013 (TechnicalUser) 11 Aug 09 18:18 Hi Guys,I am new to this forum and its really great; I have been working on mostly Cisco Call Manager, but I have an interview with a compnay on UCCE/ICM/CVP. Can anyone please help with any questions that i can expect and any challenging situation you faced with ICM, cvp etc and how did you troubleshoot the realtime problem. Please please reply me asap.