Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
New Member

FInd unused ICM scripts

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 REPLY

Re: FInd unused ICM scripts

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

david

288
Views
0
Helpful
1
Replies
CreatePlease to create content