Many client might want to retrieve the deleted Knowledge documents in a published state.
Release: CA Service Desk Manager 17.3.X .
Solution:
When we Search for Knowledge Documents from under Knowledge Tab, It will only display those documents that are in Published Status. This is determined by the column "active_state" present under the SKELETONS table.
Active State - Status =========================================== 0 - Published 1 - Draft 2 - Retired -100 - Deleted
In order to re-activate you will have to update the Active State value from -100 to 0 (Draft State) or 1(Published State) using tool such SQL Query Analyzer, Management Studio or Oracle SQLPlus or Enterprise Management.