What you need know? (Web Screen Painter Help Release 12.9.00)
type Table info
Add the new reference table to the appropriate Function Group (e.g. 'Change Order Reference')
flag as unique;
Add how many fields you'll need.
sym and delete_flag is a common fields to identify our tables
set a default value of '0'
set 'sym' as the Default Display Field;
Open a Command Prompt
Run pdm_halt command, it´ll stopped CA Service Desk Services
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
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.
Thank You, sharing knowledge, we can make the difference.
Great document Tiago, appreciate you sharing this with the community !
Really, it's a very important step: looking for errors
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.
Thank You, one hand washes the other..
Nice article! I think this quick guide will help a lot for who is looking for creating new tables.
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.
Great article. Thanks for share this.
Thank You for your comments, this document was changed.
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.
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.
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:
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.
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.
Thank you for your comment, I´ll use it.
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.