[dbo].[View_Request_to_Act_Log] [dbo].[View_Request_to_Act_Log]| Property | Value |
|---|---|
| ANSI Nulls On |  |
| Quoted Identifier On | |
| Created | 10:24:48 AM Sunday, December 05, 2010 |
| Last Modified | 10:24:48 AM Sunday, December 05, 2010 |
| 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 |
| affected_service |
| external_system_ticket |
| incorrectly_assigned |
| major_incident |
| orig_user_admin_org |
| orig_user_cost_center |
| orig_user_dept |
| orig_user_organization |
| outage_detail_what |
| outage_detail_who |
| outage_detail_why |
| outage_reason_desc |
| outage_type |
| pct_service_restored |
| remote_control_used |
| requested_by |
| resolution_code |
| resolution_method |
| resolvable_at_lower |
| return_to_service |
| symptom_code |
| target_closed_count |
| target_closed_last |
| target_hold_count |
| target_hold_last |
| target_resolved_count |
| target_resolved_last |
| target_start_last |
| caextwf_instance_id |
| sap_category |
| sap_client |
| sap_component |
| sap_cprog |
| sap_dbsys |
| sap_frontend |
| sap_instance |
| sap_msg |
| sap_os |
| sap_priority |
| sap_sftwcomp |
| sap_sftwcomppatch |
| sap_sftwcomprel |
| sap_solman |
| sap_state |
| sap_status |
| sap_subject |
| sap_syshost |
| sap_sysid |
| sap_systyp |
| sap_userstatus |
| sap_xnum |
| 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 |
| actlog_id |
| actlog_persid |
| call_req_id |
| actlog_last_mod_dt |
| time_spent |
| time_stamp |
| system_time |
| analyst |
| actlog_desc |
| action_desc |
| actlog_type |
| knowledge_session |
| knowledge_tool |
| internal |
| activity_type |
| analyst_lastname |
| analyst_firstname |
| analyst_middlename |
| Type | Action | Owning Principal |
|---|---|---|
| Grant | Select | service_desk_admin_group |
| Grant | Select | service_desk_ro_group |