Technical Tip: Identifying the group selected in the 'Email Group' field during Report Schedule creation

blarochelle · ‎03-21-2024

Description

This article describes how to identify the group selected in the 'Email Group' field during Report Schedule creation after the scheduled task has already been created.

Scope

FortiNAC-C / FortiNAC-F All Versions.

Solution

From this view, it is possible to create a Scheduled task to run Reports.

When selecting Schedule, it will show the next view where there is a field for 'Email Group'.

Once the group has been selected and the Apply button selected, the task is created.

There is no option to retrieve the 'Email Group' in use by the task from the GUI.

FortiNAC-C Solution:

Log into the CLI as the root user.
Run the following command and note the ID of the Scheduled task for the Report Generation:

schedule -all

Example output:

schedule -all
ID name previousScheduledTime scheduledTime pause hidden
__ ________________________________ ____________________________ ____________________________ _____ ______
1 System Backup Mon Mar 18 01:10:09 EDT 2024 Mon Mar 25 01:10:53 EDT 2024 false false
2 Database Archive and Purge Mon Mar 18 01:01:44 EDT 2024 Mon Mar 25 01:01:53 EDT 2024 false false
3 Certificate Expiration Monitor Thu Mar 21 10:00:00 EDT 2024 Fri Mar 22 10:00:00 EDT 2024 false false
4 Database BackUp Thu Mar 21 00:01:08 EDT 2024 Fri Mar 22 00:01:53 EDT 2024 false false
5 Auto-Definition Synchronizer Thu Mar 14 15:23:48 EDT 2024 Thu Mar 28 15:23:48 EDT 2024 false false
7 Operating System Update Status Sun Mar 17 13:01:00 EDT 2024 Sun Mar 24 13:01:00 EDT 2024 false false
10 Guest Report Thu Mar 21 14:19:00 EDT 2024 Thu Mar 21 19:19:00 EDT 2024 false false
11 grab-log-snapshot Thu Mar 21 12:27:03 EDT 2024 Fri Mar 22 12:27:03 EDT 2024 false false
12 Synchronize Users with Directory Thu Mar 21 09:54:53 EDT 2024 Fri Mar 22 09:54:53 EDT 2024 false false
14 CustomReport Thu Mar 21 13:10:00 EDT 2024 Fri Mar 22 13:10:00 EDT 2024 false false
19 test Thu Mar 21 19:02:00 EDT 2024 true false
20 testscript Thu Mar 21 13:40:21 EDT 2024 Thu Mar 21 18:40:21 EDT 2024 false false
21 ReportScheduledTask Thu Mar 21 19:39:00 EDT 2024 false false

Example:

21 ReportScheduledTask
Run the next command to get the ID of the Group. Note the group ID:

schedule -detail -id <ID of Scheduled task>

Example:

schedule -detail -id 21

Description = Generate Report
Command = ReportServer
ID = 21
Name = ReportScheduledTask
Tag = REPORT_GENERATION
Last Time = null
Next Time = Thu Mar 21 19:39:00 EDT 2024
Paused = false
Internal Object = [NameValue:
Name = GroupID
Value = 13

schedule -detail -id 21
Description = Generate Report
Command = ReportServer
ID = 21
Name = ReportScheduledTask
Tag = REPORT_GENERATION
Last Time = null
Next Time = Thu Mar 21 19:39:00 EDT 2024
Paused = false
Internal Object = [NameValue:
Name = GroupID
Value = 13
Run the next command to retrieve the name of the group:

group -dbid <ID of group>

Example:

group -dbid 13
ID | Name | Type | Owner
______|________________________________________|_______________|______________
13 |All Management Group |Administrator |CM
______|________________________________________|_______________|______________

FortiNAC-F Solution:

Log into the CLI as the admin user.
Run the command:

execute enter-shell
Run the following command and note the ID of the Scheduled task for the Report Generation:

schedule -all

Example output:

schedule -all
ID name previousScheduledTime scheduledTime pause hidden
__ ________________________________ ____________________________ ____________________________ _____ ______
1 System Backup Mon Mar 18 01:10:09 EDT 2024 Mon Mar 25 01:10:53 EDT 2024 false false
2 Database Archive and Purge Mon Mar 18 01:01:44 EDT 2024 Mon Mar 25 01:01:53 EDT 2024 false false
3 Certificate Expiration Monitor Thu Mar 21 10:00:00 EDT 2024 Fri Mar 22 10:00:00 EDT 2024 false false
4 Database BackUp Thu Mar 21 00:01:08 EDT 2024 Fri Mar 22 00:01:53 EDT 2024 false false
5 Auto-Definition Synchronizer Thu Mar 14 15:23:48 EDT 2024 Thu Mar 28 15:23:48 EDT 2024 false false
7 Operating System Update Status Sun Mar 17 13:01:00 EDT 2024 Sun Mar 24 13:01:00 EDT 2024 false false
10 Guest Report Thu Mar 21 14:19:00 EDT 2024 Thu Mar 21 19:19:00 EDT 2024 false false
11 grab-log-snapshot Thu Mar 21 12:27:03 EDT 2024 Fri Mar 22 12:27:03 EDT 2024 false false
12 Synchronize Users with Directory Thu Mar 21 09:54:53 EDT 2024 Fri Mar 22 09:54:53 EDT 2024 false false
14 CustomReport Thu Mar 21 13:10:00 EDT 2024 Fri Mar 22 13:10:00 EDT 2024 false false
19 test Thu Mar 21 19:02:00 EDT 2024 true false
20 testscript Thu Mar 21 13:40:21 EDT 2024 Thu Mar 21 18:40:21 EDT 2024 false false
21 ReportScheduledTask Thu Mar 21 19:39:00 EDT 2024 false false

Example:

21 ReportScheduledTask
Run the next command to get the ID of the Group. Note the group ID:

schedule -detail -id <ID of Scheduled task>

Example:

schedule -detail -id 21

Description = Generate Report
Command = ReportServer
ID = 21
Name = ReportScheduledTask
Tag = REPORT_GENERATION
Last Time = null
Next Time = Thu Mar 21 19:39:00 EDT 2024
Paused = false
Internal Object = [NameValue:
Name = GroupID
Value = 13

schedule -detail -id 21
Description = Generate Report
Command = ReportServer
ID = 21
Name = ReportScheduledTask
Tag = REPORT_GENERATION
Last Time = null
Next Time = Thu Mar 21 19:39:00 EDT 2024
Paused = false
Internal Object = [NameValue:
Name = GroupID
Value = 13
Run the next command to retrieve the name of the group:

group -dbid <ID of group>

Example:

group -dbid 13
ID | Name | Type | Owner
______|________________________________________|_______________|______________
13 |All Management Group |Administrator |CM
______|________________________________________|_______________|______________