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?
IntroductionCUCM Routing RulesDial String implementation PolicyCUCM Routing LogicSIP URI Call Routing Analysis+++ Case Study: 1 ++++++ Case Study: 2 +++Conclusion
Over the last few months, I have had the privilege of working on SI...
Are you getting this error “Installer User Interface Mode Not Supported. The installer cannot run in this UI mode. To specify the interface mode, use the -i command-line option, followed by the UI mode identifier. The value UI mode identifiers...