Monitor and Notify When Thresholds are Approached

[suvarna sonar2]

Requirement 1.

We have created below three groups 

1.OpCo_Local_Admin
2. OpCo_Fulfiller_License
3. OpCo_Approver_Admin

Requirement 2.

We have created Custom table 'u_license_tracking' with custom field 

1.Company (Reference to `core_company`)

2.Fulfiller_Count (Integer)

3. Approver_Count (Integer)

4.Fulfiller_Budget (Integer)

5. Approver_Budget (Integer)

Write a scheduled script or Business Rule to populate this table with counts (from the OpCo groups mentioned above).

Requirement 3.

As a License Manager,
I want a scheduled job to check if the number of users with "Fulfiller" or "Approver" roles is nearing the threshold for each company,
so I can take action before limits are exceeded.

Write a scheduled script under System Definition > Scheduled Jobs to:

• Query the u_license_tracking table.

• Compare Fulfiller_Count and Approver_Count to their respective budget.

• Identify companies nearing the thresholds.

2. Create a notification template for threshold warnings.

• Include dynamic fields for company name, counts, and thresholds.

        • If the number of licenses = threshold, the notification should contains "You have no more licenses available", if not, the notification should contains "You have X licenses left to allocate"

3. Trigger the notification to the OpCo_Local_Admin group.

4. Test the script with sample data and ensure notifications are received

Acceptance Criteria should be after implementing above requirement.

A scheduled job runs weekly to compare the user counts to the thresholds.

• If counts are within 10% of the thresholds, a notification is sent to a designated group or email.

• Notifications include company name, current counts, and thresholds.

• If the number of licenses = threshold, the notification should contains "You have no more licenses available", if not, the notification should contains "You have X licenses left to allocate"

Could you please help me for above requirement how to calculate threshold and how to trigger notification with scheduled job.

[suvarna sonar2]

Could you please explain me through scheduled job, Client want scheduled job should run weekly and trigger notification to specific group.