Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

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

276
Views
0
Helpful
1
Replies