The query retrieves the list of all object type not having the categories needed for link escalation, below are the four categories:
6500;"ESCALATION_AS_CALLER_CHILD";"To be part of escalation as caller child";"ACTIVE "
6501;"ESCALATION_AS_CALLEE_CHILD";"To be part of escalation as callee child";"ACTIVE "
6502;"ESCALATION_AS_CALLER_PARENT";"To be part of escalation as called parent";"ACTIVE "
6503;"ESCALATION_AS_CALLEE_PARENT";"To be part of escalation as callee parent";"ACTIVE "
Run the below query to get the above categories:
select * from Cat where IdCat in (6500, 6501, 6502, 6503)
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS |
In Enlighten if you have missing Escalated links then run the below query to find the object type involved.
SELECT DISTINCT t.IdTyp , t.TypDsc, t.TypNam FROM (SELECT t.IdTyp , t.TypDsc, t.TypNam FROM Typ t JOIN (SELECT DISTINCT tc.IdTyp FROM TypCat tc JOIN (SELECT * FROM Cat WHERE CatNam LIKE 'EnlightenGraphable' ) c ON c.IdCat = tc.IdCatParent ) all_graphable ON t.IdTyp = all_graphable.IdTyp ) t JOIN TypCat tc ON tc.IdTyp = t.IdTyp LEFT JOIN (SELECT * FROM Cat WHERE IdCat IN (6500, 6501, 6502, 6503) ) c ON c.IdCat = tc.IdCatParent WHERE ( t.IdTyp IN ( SELECT all_graphable.IdTyp FROM (SELECT DISTINCT tc.IdTyp FROM TypCat tc JOIN (SELECT * FROM Cat WHERE CatNam LIKE 'EnlightenGraphable' ) c ON c.IdCat = tc.IdCatParent ) all_graphable LEFT JOIN ( SELECT tc.IdTyp, COUNT(1) count_ FROM TypCat tc JOIN (SELECT * FROM Cat WHERE IdCat IN (6500, 6501, 6502, 6503) ) c ON c.IdCat = tc.IdCatParent GROUP BY tc.IdTyp ) typ_esc ON all_graphable.IdTyp = typ_esc.IdTyp WHERE typ_esc.IdTyp IS NULL OR typ_esc.count_ != 4 ) ) ORDER BY t.TypDsc
416;".NET AddOn";"NET_EVENT_ADDON"
137626;".NET AppSetting found in configuration file";"CAST_DotNet_AppSettingType"
371;".NET Assembly";"NET_ASSEMBLY_EXT"
138103;".NET Assembly";"CAST_DotNet_Assembly"
389;".NET Class";"NET_CLASS"
TBD
TBD