Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find email-addressess with CSP Query Builder and other detail information about reports

Status
Not open for further replies.

kdavis6416

Technical User
Dec 1, 2011
6
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top