Is there a batch method to retire a large number of KT documents?

Document ID:  TEC1342082
Last Modified Date:  08/02/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Service Desk Manager

Releases

  • CA Service Desk Manager:Release:12.9 CA SDM
  • CA Service Desk Manager:Release:14.1
  • CA Service Desk Manager:Release:17.0

Components

  • Svc Desk KT:SDKT
  • Unicenter SvcPlus Knowledge Tools:USPKT
  • UNICENTER SERVICE DESK RXX:USRD
Question:

Is there a batch method to retire a large number of KT documents?

Environment:
CA Service Desk Manager 12.x, 14.1 and 17.0 All Supported Operating Systems
Answer:

There is no current way to retire a large number of CA SDM Knowledge Documents from the CA SDM GUI. 

However, the following pdm_extract/pdm_load approach might achieve the results: 

1. From a command prompt on the CA SDM server, run the following pdm_extract command 

pdm_extract -f "select ACTIVE_STATE,id,pers_id from SKELETONS where id=***" > kt1.txt 

2. This will create a 'kt1.tx' file with the CA SDM Knowledge Documents based on the where clause 

3. Modify the file with a text editor and change the ACTIVE_STATE field to '2' (which is the code for retired) and set the STATUS_ID field to '80'

4. Save the file with a new name (i.e. kt2.txt) 

5. From a command prompt on the CA SDM server, run the following pdm_load command 

pdm_load -f kt2.txt -u 

6. Check via the CA SDM GUI if the documents are now in a retired status. 

As always, we recommend testing all changes in a non-PROD environment, perhaps test with only a couple of Knowledge Documents first.

Additional Information:

TEC1102036 - If an expiration date was not set on knowledge documents during creation/approval, is there a way to bulk retire documents?

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >