We are needing to find out where in the Kaseya SQL database the Scheduled Reports information resides and how to interpret it. We have found in the 'ksubscribers.dbo.schedReports' table a column named 'schedId' which is what we think we are looking for but no idea how to interpret it. For example, one of the schedId's is 77587501, another is 35170510. We need to find out which reports are set to go, for example, on a weekly basis without having to check each report individually in Kaseya itself (we have just under 30,000 agents checking in with a few hundred reports so it would take an enormous amount of time to do that).
Does anyone know if this is the correct table/view? Or does anyone know how to interpret the 'schedId'?
Any help appreciated.