In Report caster schedule,I want to know what are all the ID's added in the distribution list for particular report,where i can find those distribution list details.

Thanks,
Pavi

This message has been edited. Last edited by: FP Mod Chuck,

If your RC repository is stored into a SQL DB, it will be under that DB in BOTSCHED, BOTDEST, BOTDIST, BOTADDR

Below is code that I have which gives all distribution per schedule and per person distributed to

/* WF-8-2 : EXTRACT "SEND TO" CREATING A ROW FOR EACH "SEND TO" VALUE */
SELECT DISTINCT LTRIM(RTRIM(T1.JOBDESC)) AS 'JOBDESC', LTRIM(RTRIM(T2.[MAILSUBJECT])) AS 'MAILSUBJECT'
      ,CASE WHEN T5.[INTERVALTYPE] = 'D' THEN 'Daily'
	        WHEN T5.[INTERVALTYPE] = 'W' THEN 'Weekly'
	        WHEN T5.[INTERVALTYPE] = 'M' THEN 'Monthly'
	        WHEN T5.[INTERVALTYPE] = 'O' THEN 'On Request'
			ELSE T5.[INTERVALTYPE] END AS 'FREQUENCY'
      ,CASE WHEN T5.[WEEKDAYS] = '1111111' THEN 'All 7 Days'
	        WHEN T5.[WEEKDAYS] = '1111100' THEN 'Mon To Fri'
	        WHEN T5.[WEEKDAYS] = '1000000' THEN 'Monday'
	        WHEN T5.[WEEKDAYS] = '0100000' THEN 'Tuesday'
	        WHEN T5.[WEEKDAYS] = '0010000' THEN 'Wednesday'
	        WHEN T5.[WEEKDAYS] = '0001000' THEN 'Thursday'
	        WHEN T5.[WEEKDAYS] = '0000100' THEN 'Friday'
	        WHEN T5.[WEEKDAYS] = '0000010' THEN 'Saturday'
	        WHEN T5.[WEEKDAYS] = '0000001' THEN 'Sunday'
	        WHEN T5.[WEEKDAYS] = '0000000' THEN 'On Request'
	        ELSE T5.[WEEKDAYS] END AS 'WEEKDAYS'
      ,T5.[STARTTIME]
	  ,CASE WHEN T2.[LISTTYPE] = 'S' THEN LOWER(REPLACE(T2.[DISTLIST], '; ', ';'))
	        WHEN T2.[LISTTYPE] = 'R' THEN LOWER(REPLACE(T2.[DISTLIST], '; ', ';'))
			ELSE LOWER(REPLACE(T4.[DESTFN], '; ', ';')) END AS 'SEND_TO'
	  ,CASE WHEN [LISTTYPE] = 'S' THEN 'Single Adr'
	        WHEN [LISTTYPE] = 'D' THEN 'Disttribution List'
			WHEN [LISTTYPE] = 'R' THEN 'Dynamic Dist List'
			WHEN [LISTTYPE] = 'Q' THEN 'Library'
			ELSE [LISTTYPE] END AS 'LISTTYPE'
	  ,T3.BOOKNAME
	  ,ISNULL(T3.[DESCRIPTION], '') AS 'BOOK_DESC'
INTO #TMP_EXT
  FROM [WF82ReposProd].[dbo].[BOTSCHED] T1
  LEFT OUTER JOIN [WF82ReposProd].[dbo].[BOTDIST] T2
    ON T1.SCHEDULEID = T2.SCHEDULEID
  LEFT OUTER JOIN [WF82ReposProd].[dbo].[BOTADDR] T3
    ON SUBSTRING(T2.DISTPATH, PATINDEX('%Schedules/%', DISTPATH) + 10, 100) LIKE T3.BOOKNAME
  LEFT OUTER JOIN [WF82ReposProd].[dbo].[BOTDEST] T4
    ON T3.[ADDRBOOKID] = T4.[ADDRBOOKID]
  INNER JOIN [WF82ReposProd].[dbo].[BOTSIT] T5
    ON T1.[SCHEDULEID] = T5.[SCHEDULEID]
WHERE T1.ACTIVE = 'Y' AND T2.ACTIVE = 1 AND T5.ACTIVE = 1
  AND T2.[LISTTYPE] != 'Q'  -- Q is the type assigned for HOLD schedules
ORDER BY JOBDESC

SELECT JOBDESC, MAILSUBJECT, FREQUENCY, WEEKDAYS, STARTTIME, LISTTYPE, BOOK_DESC, --BOOKNAME,
 CASE WHEN SUBSTRING(SEND_TO, LEN(SEND_TO), 1) = ';' THEN SUBSTRING(SEND_TO, 1, LEN(SEND_TO) -1) ELSE SEND_TO END AS 'SEND_TO'
INTO #TMP_CLEAN
FROM #TMP_EXT

;WITH SPLITRESULT
AS
(
    SELECT JOBDESC, MAILSUBJECT, FREQUENCY, WEEKDAYS, STARTTIME, LISTTYPE, BOOK_DESC, --BOOKNAME,
           [xml_val] = CAST('<t>' + REPLACE(SEND_TO, ';', '</t><t>') + '</t>' AS XML)
    FROM #TMP_CLEAN
)

SELECT DISTINCT JOBDESC, MAILSUBJECT, FREQUENCY, WEEKDAYS, STARTTIME, LISTTYPE, BOOK_DESC, --BOOKNAME,
                SEND_TO = col.value('.','VARCHAR(800)')
FROM SPLITRESULT
CROSS APPLY [xml_val].nodes('/t') CA(col)
WHERE col.value('.', 'VARCHAR(800)') NOT LIKE 'support%'
ORDER BY JOBDESC

DROP TABLE #TMP_EXT
DROP TABLE #TMP_CLEAN

Thanks for your response.

Is there any way to check the distribution list in webfocus legacy home page.I am able to get the details of last run and last accessed but i want to know to whom the report caster report is distributed.

And also how to add the new ID to the existing distribution list.

To know to who it has been distributed, the schedule log should tell you that.

You can manage the distribution list using the Report Caster menu from the Administrator options. But you need to be authorized (have privileges) to do that