How can I find out what the character limit for Service Desk fields are?
search cancel

How can I find out what the character limit for Service Desk fields are?

book

Article ID: 117303

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

It's possible to reference the tables on the MDB using SQL Server Management Studio in order to determine what the character limits are for Service Desk Manager fields. See steps below:

Environment

Release: CA Service Desk Manager 17.X

Resolution

1. Log into the server using SQL Server Management Studio. 
2. Expand MDB.
3. Expand Tables.
4. Navigate to the table where the variable you're looking for is stored, and expand Columns.
5. The variables are listed here, including the maximum size available for the field.