Notification Report V2

Generates a report showing which employees a specific user has access to based on workgroup permissions. This report helps administrators understand user access scope and verify that notification permissions are properly configured.

Parameters

• UA.USERID - The specific user ID to check access for (hardcoded in WHERE clause, example: 1284)

Data Components

The report consists of:

1. User Information - Details about the user being checked
2. Employee Access List - All employees the user has access to based on workgroup permissions
3. Workgroup Mapping - Shows the workgroup structure (WG1, WG2, WG3) for access control

Output Format

Technical Implementation

The script uses:

• JOIN operations to link USERACCESS, USERS, and EMPLOYEES tables
• Workgroup-based access control logic with OR conditions for flexible permissions
• Active status filtering to show only current employees
• Hierarchical workgroup structure (WG1, WG2, WG3) for access determination

Access Logic

The workgroup access logic works as follows:

• User has access if their workgroup matches the employee's workgroup OR their workgroup is 0 (universal access)
• This applies to all three workgroup levels (WG1, WG2, WG3)
• Only active employees (ACTIVESTATUS = 0) are included

Notes

• Useful for verifying user access permissions and troubleshooting notification issues
• Results are ordered by USERID and employee FullName for easy review
• The USERID parameter must be manually updated in the script for different users
• Only shows active employees to reflect current organizational structure

Alternative Formats

• Export results to CSV or Excel for access auditing and documentation
• Can be modified to check multiple users by removing the specific USERID filter

T-SQL

SELECT 
    UA.USERID,
	U.FRIENDLYNAME,
	e.LASTNAME+', '+e.FIRSTNAME as FullName,
    E.IDNUM,
    E.WG1,
    E.WG2,
    E.WG3
FROM 
    USERACCESS UA

JOIN USERS U
	ON UA.USERID = U.Uniqueid

JOIN Employees E
	ON 
		(UA.WG1 = E.WG1 OR UA.WG1 = 0) AND
		(UA.WG2 = E.WG2 OR UA.WG2 = 0) AND
		(UA.WG3 = E.WG3 OR UA.WG3 = 0)

where 
	e.ACTIVESTATUS = 0 
	and UA.USERID = 1284
ORDER BY 
    UA.USERID, FullName;

Content Inventory

• Doc File: content/docs/reports/users_information/NotificationReportV2.mdx
• SQL Script: SQL/reports/users_information/NotificationReportV2.sql