CA Service Management

 View Only

CA Service Desk - Create a new table - out-of-box 

Jul 10, 2015 04:01 PM

Publish Schema Modifications

What you need know? (Web Screen Painter Help Release 12.9.00)



CASDM_20150710_Publish_01.jpgOpen a WSP - Web Screen Painter




Open Schema Designer, you have two options to open, you can do a click on icon or you can do it on menu, Tools... Schema Designer
CASDM_20150710_Publish_05.jpgClick on Add Table button
CASDM_20150710_Publish_06.jpgClick on Add Table button
CASDM_20150710_Publish_07.jpgtype a New table name


type Table info


Add the new reference table to the appropriate Function Group (e.g. 'Change Order Reference')

CASDM_20150710_Publish_09.jpgClick on Add New Column icon
CASDM_20150710_Publish_10.jpgtype a new column name


flag Required

flag as unique;


Add how many fields you'll need.


sym and delete_flag is a common fields to identify our tables



check 'Required'

set a default value of '0'

CASDM_20150710_Publish_14.jpgClick on Save button

set 'sym' as the Default Display Field;

CASDM_20150710_Publish_15.jpgClick on Save and Publish menu
CASDM_20150710_Publish_16.jpgClick Yes
CASDM_20150710_Publish_17.jpgClick ok

Open a Command Prompt

Run pdm_halt command, it´ll stopped CA Service Desk Services

CASDM_20150710_Publish_20.jpgrun pdm_status for a check, CA Service Desk services need be stopped to publish
CASDM_20150710_Publish_21.jpgRun pdm_publish command

Start CA Service Desk services -


net start pdm_daemon_manager


Check SDM Log files and looking for errors $NX_ROOT\log normally: C:\Program Files (x86)\CA\Service Desk Manager\log

By: Kyle_R


CASDM_20150710_Publish_24.jpgCheck your new table on Schema Designer



Do you need more information about custom tables/columns cdtj wrote more improving this doc  How to create custom BREL/QREL/LREL attribute



CA CMDB Technical Reference Guide 12.5

Web Screen Painter Help Release 12.9.00

     To add new tables to the database

     To add new columns

     Test new Schema

      Publish Schema Modifications

CA Service Desk Manager | CA Service Management Cookbook@



Was this information helpful? left a comment.

0 Favorited
0 Files

Tags and Keywords


Sep 17, 2015 10:27 AM

Hi Raghu,


    Thank You, sharing knowledge, we can make the difference.



Sep 16, 2015 10:51 PM

Great document Tiago, appreciate you sharing this with the community !



Sep 10, 2015 03:15 PM

HI Kyle_R,


  Really, it's a very important step: looking for errors


Thank You

Aug 07, 2015 12:34 AM

Thanks Tiago, another great article.


You don't include a reference to (a) restarting the Service Desk Manager service after this and (b) checking the logs at startup the first time for customisation errors.


Kind of obvious, but you've spelled everything else out, so I thought I'd throw that in.


Thanks, Kyle_R.

Jul 22, 2015 05:27 PM

Hi, diogo.nobrega,


  Thank You, one hand washes the other..

Jul 22, 2015 05:10 PM

Nice article! I think this quick guide will help a lot for who is looking for creating new tables.

Jul 22, 2015 09:56 AM

Hi Gutis,


   You spoke about this procedure? CA Service Desk - Create a new Menu Tree - New node - out-of-box, i wrote following your last comment, please look it.


Thank You

Jul 14, 2015 10:38 AM

Great article. Thanks for share this.

Jul 14, 2015 10:00 AM

Hi James,camja06


   Thank You for your comments, this document was changed.


Good Work.

Jul 13, 2015 09:16 AM

It will not insert any z to attribute for custom table, only the table name will mandatory contain z at the begining. As mentioned before this allows you to add common antrybutes like sym and delete_flag and have standart functionality for them.

Jul 13, 2015 08:45 AM




Hy cdtj,



   Thank you, i know, i´ll change this article.



   Now, we dont need type "z" because CA SDM will insert on the begins for us but if we type "z" CA SDM won't change our field.



Thank You

Jul 12, 2015 10:17 PM

I would recommend using labels 'sym' and 'delete_flag' rather than 'zsym' and 'zdelete_flag', for consistency with the other reference tables.  The following are also good practice:

  • set a default value of '0' for 'delete_flag';
  • check 'Required' for both 'sym' and 'delete_flag';
  • flag 'sym' as indexed and unique;
  • set 'sym' as the Default Display Field;
  • add the new reference table to the appropriate Function Group (e.g. 'Change Order Reference')

After these little adjustments, when you come to create the detail and list forms for your new reference table (using the templates that WSP provides) they will inherit the behaviour that you would expect from the out-of-box forms, including access controls.

Jul 11, 2015 04:17 AM


seems like you have started to create one more great article!

I also want to notice that you can publish attributes without "z" prefix in your own tables.




Jul 10, 2015 05:00 PM

Hi Gutis,


    Thank you for your comment, I´ll use it.



Jul 10, 2015 04:51 PM

It would be nice to add instructions how to expose this table to SDM interface in order to add some information to it. From may experience additional tables are mostly created to have some additional classificators for incidents, CI and etc. So almost each time we create new table we have to expose it under administration tab somewhere under servicedesk node to allow add some values to this table.

Related Entries and Links

No Related Resource entered.