For all of the things Kaseya does, there are still a lot of things that are either very difficult or impossible to do in the interface. Here is a collection of SQL queries to get the job done.
Changing the name of Securiy profiles (KES)
There is no way in the Kaseya interface to change the name of a security profile for KES. However, the table on the backend is fairly straight forward,
AVProfile. I used the following:
select * from AVProfile
update AVProfile set ProfileName = 'Workstation' where id = 4
Finding scheduled reports by recipient
If you wanted to go into the details of every single scheduled report on the system, I guess this would be possible through the interface. However, this is impractical for a request like, "The reports that goes to 'firstname.lastname@example.org' should got to 'email@example.com' instead". Here's how to track it down:
Select EventId, Data from Hermes.Event WHERE Data like '%firstname.lastname@example.org%'
Select id, rowdesc, emailaddr from orgCalendarScheduleDistr WHERE emailaddr like '%email@example.com%'
Then to change the email address, I ran:
update orgCalendarScheduleDistr set emailaddr = 'firstname.lastname@example.org' where id = XX
update Hermes.Event set data = replace(data, 'email@example.com', 'firstname.lastname@example.org') WHERE eventid = XX
In addition, it can be impossible to find reports just given the email address. To find the scheduled report in the interface (for example to remove it) I have retrieved the DateUpdated field from Hermes.Event and then sorted the Scheduled Reports by created date and used that date to find the report.