spMFUsersByUserGroup

Returns

• 1 = Success

• -1 = Error

Parameters

@Debug smallint (optional)

• Default = 0

• 1 = Standard Debug Mode

• 101 = Advanced Debug Mode

Purpose

To produce a report listing the members of each user group. The report will include users where the usergroup included another usergroup.

Examples

EXEC dbo.spMFUsersByUserGroup;
SELECT * FROM ##spMFUsersByUserGroup;

Changelog

Date	Author	Description
2023-05-25	LC	Create procedure