| Target Type Values | Meaning |
| 0 | Unknown |
| 1 | Service |
| 2 | Skill Group |
| 3 | Agent |
| 4 | Translation Route |
| 5 | Agent Administration Group |
| 6 | Announcement |
| 7 | Call Type |
| 8 | Enterprise Service |
| 9 | Enterprise Skill Group |
| 10 | Region |
| 11 | Dialed Number |
| 12 | Logical Interface Controller |
| 13 | Physical Interface Controller |
| 14 | Peripheral |
| 15 | Routing Client |
| 16 | Trunk Group |
| 17 | Route |
| 18 | Peripheral Target |
| 19 | Label |
| 20 | Master Script |
| 21 | Script Table |
| 22 | Script Table Column |
| 23 | Script |
| 24 | Schedule |
| 25 | ICR View |
| 26 | View Column |
| 27 | Network Trunk Group |
| 28 | Service Array |
| 29 | Application Gateway |
| 30 | Device Target (deprecated) |
| 31 | User Variable |
| 32 | User Formula |
| 33 | Network VRU Script |
| 34 | Scheduled Target |
| 35 | Network VRU |
| 36 | Skill Group Member |
| 37 | Expanded Call Variable |
| 38 | Agent Team |
| 39 | Campaign |
| 40 | Dialer |
| 41 | Import Rule |
| 42 | Query Rule |
| 43 | Campaign Query Rule |
| 44 | Dialer Port Map |
| 45 | Message Category |
| 46 | Message Destination |
| 47 | Response Template |
| 48 | Enterprise Route |
| 49 | Person |
| 50 | Media Routing Domain Member |
| 51 | Media Routing Domain |
| 52 | Application Path |
| 53 | Peripheral MRD |
| 54 | Script Queue Meters |
| 55 | Campaign Target Sequence |
| 56 | Microapp Defaults |
| 57 | Microapp Currency |
| 58 | Microapp Locale |
| 59 | Object Call |
| 60 | Dialer Skill Group |
| 61 | ECC Payload |
| 62 | Call Type Skill Group |
| 63 | Translation Route Meters |
| 64 | Attribute |
| 65 | Precision Queue |
| 66 | Precision Queue Step |
| 67 | Precision Queue Term |
| 68 | Precision Queue Step Member |
| 69 | Attribute Set |
| 70 | Attribute Set Member |
| 71 | Precision Queue Member |
| 72 | Congestion Control |
| 73 | Precision Queue Step Meter |
| 80 | Contact Share Group |
| 81 | Machine Address |
| 82 | Machine Host |
| 83 | Machine Service |
| 84 | Department |
| 85 | Contact Share Rule |
| 86 | Contact Share Queue |
| 87 | Object Last |
SELECT
MasterScriptName = MS.EnterpriseName
,ESGName = ESG.EnterpriseName
,CurrentVersion = MS.CurrentVersion
,ScriptVersion = S.Version
,SCR.[ScriptID]
,[LocalID]
,[TargetType]
,[ForeignKey]
FROM [Ref_Script_Cross_Reference] SCR
LEFT JOIN Ref_Script S ON S.ScriptID = SCR.ScriptID
LEFT JOIN Ref_Master_Script MS ON MS.MasterScriptID = S.MasterScriptID
LEFT JOIN Enterprise_Skill_Group ESG ON ESG.EnterpriseSkillGroupID = SCR.ForeignKey
WHERE SCR.TargetType = '9' AND (CurrentVersion = S.Version)
ORDER BY MS.EnterpriseName
SELECT
MasterScriptName = MS.EnterpriseName
,ESGName = ESG.EnterpriseName
FROM [Ref_Script_Cross_Reference] SCR
LEFT JOIN Ref_Script S ON S.ScriptID = SCR.ScriptID
LEFT JOIN Ref_Master_Script MS ON MS.MasterScriptID = S.MasterScriptID
LEFT JOIN Enterprise_Skill_Group ESG ON ESG.EnterpriseSkillGroupID = SCR.ForeignKey
WHERE SCR.TargetType = '9'
GROUP BY MS.EnterpriseName, ESG.EnterpriseName
ORDER BY MS.EnterpriseName, ESG.EnterpriseName
Which Enterprise Skillgroups are NOT in any scripts (and can be easily deleted)
SELECT [EnterpriseSkillGroupID]
,[EntityID]
,[EnterpriseName]
,[Description]
,[DepartmentID]
,[ChangeStamp]
,[DateTimeStamp]
,myTemp1.ESGID
FROM [Enterprise_Skill_Group] ESG
LEFT JOIN
(SELECT DISTINCT
ESGID = ESG.EnterpriseSkillGroupID
,ESGName = ESG.EnterpriseName
FROM [Ref_Script_Cross_Reference] SCR
LEFT JOIN Ref_Script S ON S.ScriptID = SCR.ScriptID
LEFT JOIN Ref_Master_Script MS ON MS.MasterScriptID = S.MasterScriptID
LEFT JOIN Enterprise_Skill_Group ESG ON ESG.EnterpriseSkillGroupID = SCR.ForeignKey
WHERE SCR.TargetType = '9')
myTemp1 ON myTemp1.ESGID = ESG.EnterpriseSkillGroupID
WHERE myTemp1.ESGID IS NULL
ORDER BY ESG.EnterpriseName
SELECT
MasterScriptName = MS.EnterpriseName
,CurrentVersion = MS.CurrentVersion
,ScriptVersion = S.Version
,CT.EnterpriseName
,ScriptID = SCR.[ScriptID]
,[LocalID] = SCR.LocalID
,[TargetType] = SCR.TargetType
,[ForeignKey] = SCR.ForeignKey
FROM [Ref_Script_Cross_Reference] SCR
LEFT JOIN Ref_Script S ON S.ScriptID = SCR.ScriptID
LEFT JOIN Ref_Master_Script MS ON MS.MasterScriptID = S.MasterScriptID
LEFT JOIN Call_Type CT ON CT.CallTypeID = SCR.ForeignKey
WHERE SCR.TargetType = '7'
ORDER BY MS.EnterpriseName
Details Scripts which have a Goto Script and which script configured as the Goto Script
SELECT
OriginatingScript = MS1.EnterpriseName
,SCR.[ScriptID]
,S.MasterScriptID
,SCR.[LocalID]
,SCR.[TargetType]
,SCR.[ForeignKey]
,GotoScript = MS2.EnterpriseName
FROM [vhi_awdb].[dbo].[Script_Cross_Reference] SCR
LEFT JOIN Script S ON S.ScriptID = SCR.ScriptID
LEFT JOIN Master_Script MS1 ON MS1.MasterScriptID = S.MasterScriptID
LEFT JOIN Master_Script MS2 ON MS2.MasterScriptID = SCR.ForeignKey
WHERE SCR.TargetType = '20'
--AND ForeignKey = '5642'
ORDER BY MS2.EnterpriseName