Possible Employees With No User Notification

Report that identifies active employees who do not have any user notifications configured in the system, helping administrators identify employees who may be missing important system notification settings

Parameters

This report does not require any parameters. It automatically filters for active employees.

Data Components

The report consists of one main query with a LEFT JOIN between:

Employees table - The main source of employee information
USEREMPNOTIF subquery - Filtered for notification flags 1 or 2

Output Format

The report outputs a list of active employees who have no notification settings.

Column	Description
FullName	Employee's full name (last name, first name)
IDNUM	Employee's ID number

Technical Implementation

The script uses:

LEFT JOIN to identify employees without matching notification records
NULL check in the WHERE clause to identify missing notification records
Filter for active employees only (ACTIVESTATUS = 0)
Ordering by last name and first name

T-SQL

possible_emp_with_no_user_notification.sql

SELECT 
    --E.FILEKEY,
    E.LASTNAME + ', ' + E.FIRSTNAME AS FullName,
    E.IDNUM
FROM 
    Employees E
LEFT JOIN (
    SELECT 
        UN.Filekey
    FROM 
        USEREMPNOTIF UN
    WHERE 
        UN.NOTIFFLAG IN (1, 2)
    GROUP BY 
        UN.Filekey
) UNFiltered ON E.Filekey = UNFiltered.Filekey
WHERE 
    UNFiltered.Filekey IS NULL
    AND E.ACTIVESTATUS = 0
ORDER BY 
    E.LASTNAME, E.FIRSTNAME;

Content Inventory

Doc File: content/docs/reports/employee_information/possible_emp_with_no_user_notification.mdx
SQL Script: SQL/reports/employee_information/possible_emp_with_no_user_notification.sql