Represents the scripts (templates) for the models (Incidents, Changes, Problems, Service Requirements, and Releases) and categories of CMDB (Maintenance)
Data model
Fields
| Field | Type | Description |
|---|---|---|
| description | NVARCHAR (500) | Description of the script |
| id* | INT | Script ID |
| model_id* | INT | Associated model identifier |
| name* | NVARCHAR (100) | Script Name |
| text | NVARCHAR (MAX) | Script text (template) |
Primary Key
| PK_ASMS_SCRIPT |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| model_id* | dbo.ASMS_MODEL | id | FK01_ASMS_SCRIPT |