kdavis6416
Technical User
I am trying to pull this data from the CSP query builder. For some reason the email address does not show. I assume it is because I need to see each individual recurring event and not grouped. Does someone have a query that will show the report name , then the detail of what I have listed below.
SELECT
SI_NAME,
SI_CREATION_TIME,
SI_NEXTRUNTIME,
SI_KIND,
SI_SCHEDULE_STATUS,
SI_OWNER,
SI_AUTHOR,
SI_DESCRIPTION,
SI_APS_NAME,
SI_STARTTIME,
SI_ENDTIME,
SI_MAIL_ADDRESSES
FROM CI_INFOOBJECTS
WHERE SI_RECURRING = 1
order by SI_NAME asc
SELECT
SI_NAME,
SI_CREATION_TIME,
SI_NEXTRUNTIME,
SI_KIND,
SI_SCHEDULE_STATUS,
SI_OWNER,
SI_AUTHOR,
SI_DESCRIPTION,
SI_APS_NAME,
SI_STARTTIME,
SI_ENDTIME,
SI_MAIL_ADDRESSES
FROM CI_INFOOBJECTS
WHERE SI_RECURRING = 1
order by SI_NAME asc