Snippet Name: My_Work_View_Definition

Tags:

Created Date: 2025-06-16 13:12:45
Last Modified Date: 2025-05-31 10:31:47

Dependencies:

DBA Notes:

Sample Output:

Title: My Work View Definition
Author: user
in the application "ServiceNow", there is a view called "My Work". do you have the definition of that view?

Author: ChatGPT
The "My Work" view in **ServiceNow** typically refers to a dashboard or list that displays tasks, incidents, or other work items assigned to the logged-in user. It aggregates items from various tables like **Incident**, **Task**, **Change Request**, and others depending on the modules in use.

While the exact definition may vary depending on the configuration of your ServiceNow instance, the "My Work" view commonly includes the following:

- **Assigned to me**: Displays incidents, tasks, or tickets where the "Assigned to" field is set to the current user.
- **Active work items**: Items that are currently open or in progress.
- **Priority and due date**: Often, the view highlights priority and due dates to help users manage their workload.
- **Filters**: A set of predefined filters, such as "Open" or "Awaiting my action," to streamline the view for more focused task management.
  
Administrators can customize this view based on user roles and specific business requirements.

If you need the precise definition of the view from your organization's ServiceNow instance, you may want to ask your ServiceNow administrator or check the UI Page or List Layout configuration for "My Work" under your account.

Author: user
in service now, i need to create a report that combines all Incidents, tasks , changes, assigned to me or created by me

Author: ChatGPT
To create a report in **ServiceNow** that combines **Incidents**, **Tasks**, and **Change Requests** assigned to or created by you, follow these steps:

### 1. Create a Report
1. **Navigate to Reports**:
   - Go to the ServiceNow homepage.
   - Type **Reports** in the filter navigator and select **Create New**.

### 2. Choose the Data Source
You can create a report that pulls from multiple tables by using a **Data Source** or a **Database View**.

- **Option 1**: Create a single report for each table (Incidents, Tasks, Changes) and merge them with a filter for your criteria.
- **Option 2**: Use a Database View (ideal for pulling data from multiple tables into a single report).

#### Option 1: Separate Reports with Common Filters
1. **Table**: Start by selecting the **Incident**, **Task**, or **Change Request** table.
   - For Incidents: Choose **Incident [incident]**.
   - For Tasks: Choose **Task [task]** (Note: `Incident` and `Change Request` inherit from Task).
   - For Changes: Choose **Change Request [change_request]**.

2. **Filters**:
   - In the filter condition, set **Assigned to** `is (me)` OR **Created by** `is (me)`.

3. **Visualize**:
   - Select a chart type or list format depending on how you'd like to visualize the data.

4. **Run the Report** to ensure it's working as expected. You can repeat this process for each type of record (Incident, Task, Change Request).

#### Option 2: Using a Database View (Preferred for combining tables)
1. **Create a Database View**:
   - If you are an administrator or have the necessary permissions, you can create a **Database View** to combine multiple tables (Incident, Task, Change Request) into a single dataset.
   - Navigate to **System Definition > Database Views**.
   - Create a new Database View, and select the **Incident**, **Task**, and **Change Request** tables, ensuring the `sys_id` fields are properly linked.

2. **Create a New Report**:
   - Use the Database View as the table in the report.
   - Apply filters like **Assigned to** `is (me)` or **Created by** `is (me)` to ensure that only your items are displayed.

### 3. Add Conditions
In the **filter** section of the report, add these conditions:
   - **Assigned to** `is (me)` **OR**
   - **Created by** `is (me)`

### 4. Run and Save
1. **Run** the report to see if it reflects all Incidents, Tasks, and Change Requests assigned to you or created by you.
2. **Save** the report and give it a descriptive name like "My Work (Incidents, Tasks, Changes)".

### 5. (Optional) Add to Dashboard
If you'd like to include this report on your dashboard, you can go to your **dashboard** and add the report as a widget.

This method gives you a combined view of your Incidents, Tasks, and Change Requests in one place! Let me know if you'd like more details on creating a **Database View** or any other part of this process.