[dbo].[View_Request_to_Properties] [dbo].[View_Request_to_Properties]| Property | Value |
|---|---|
| ANSI Nulls On |  |
| Quoted Identifier On | |
| Created | 11:10:19 AM Wednesday, March 07, 2007 |
| Last Modified | 9:09:09 PM Friday, December 05, 2008 |
| Name |
|---|
| id |
| persid |
| ref_num |
| summary |
| description |
| status |
| active_flag |
| open_date |
| time_spent_sum |
| last_mod_dt |
| last_mod_by |
| close_date |
| resolve_date |
| rootcause |
| log_agent |
| assignee |
| group_id |
| customer |
| charge_back_id |
| affected_rc |
| support_lev |
| category |
| solution |
| impact |
| priority |
| urgency |
| severity |
| extern_ref |
| last_act_id |
| cr_tticket |
| parent |
| template_name |
| sla_violation |
| predicted_sla_viol |
| macro_predict_viol |
| created_via |
| call_back_date |
| call_back_flag |
| event_token |
| sched_token |
| type |
| string1 |
| string2 |
| string3 |
| string4 |
| string5 |
| string6 |
| problem |
| incident_priority |
| change |
| ticket_avoided |
| tenant |
| cawf_procid |
| caused_by_chg |
| outage_start_time |
| outage_end_time |
| service_type |
| severity_num |
| urgency_num |
| category_name |
| asset |
| impact_num |
| assignee_lastname |
| assignee_firstname |
| assignee_middlename |
| customer_lastname |
| customer_firstname |
| customer_middlename |
| group_name |
| groupID |
| status_name |
| priority_num |
| crprp_id |
| crprp_persid |
| sequence |
| label |
| crprp_description |
| value |
| required |
| sample |
| owning_cr |
| crprp_last_mod_dt |
| crprp_last_mod_by |
| Type | Action | Owning Principal |
|---|---|---|
| Grant | Select | service_desk_admin_group |
| Grant | Select | service_desk_ro_group |