I'm trying to find what ICM scripts have not been used in the last month.
Presumably, if one were to run the following query just before midnight each day for a period of time, one would learn what scripts were not run each day during that period.
What it shows is the scripts that have no calls yet today (even though the query asks about the last month)
select R.ScriptID, R.DateTime, R.Calls, M.EnterpriseName from Script_Real_Time R, Script S, Master_Script M where R.DateTime > '2010-02-26' and R.Calls = 0 and S.ScriptID = R.ScriptID and S.MasterScriptID = M.MasterScriptID and S.Version = M.CurrentVersion order by R.ScriptID
Is there a more efficient way to see what scripts have not been used in the last month than running this query nightly for the next 30 days?
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...