FInd unused ICM scripts

Unanswered Question
Mar 26th, 2010
User Badges:

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?

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
david.macias Fri, 03/26/2010 - 14:31
User Badges:
  • Blue, 1500 points or more

Why not run a calltype report for the last 30 days?



This Discussion