BusinessObjects Board

Scheduling information track.

scheduling Broadcast Agent (BCA)
#1

If we are sending/scheduling reports to users from infoview?

How can we track that which are all reports has been sent which all users?

Is this that any table of BORepository is getting updated? or ay other sugesstions to track all these things?

I am using BO 6.5.1

any suggestions…

Thanks,

Ranjan

ranjan.sahoo :india: (BOB member since 2007-06-11)

#2

Hi,

Have a look on BOB download’s there is a universe on BA users and documents.

Sebastien

#3

if you have deployed Auditor (WA_ views) , it’s easy using the auditor univers or directly in SQL

something like :

SELECT   
  WA_OBJ_M_DOCUMENTS.M_DOC_C_NAME_EXT,
  WA_DS_PENDING_JOB.JOB_STATUS_F,
  WA_DS_PENDING_JOB.JOB_STATE,
  WA_DS_PENDING_JOB.START_DATETIME_F,
  WA_DS_PENDING_JOB.BEGIN_DATE_F,
  WA_DS_PENDING_JOB.EXPIRATION_DATE_F,
  WA_DS_PENDING_JOB.END_DATETIME_F
,
  WA_DS_PENDING_JOB.ERROR_TEXT,
  WA_DS_PENDING_JOB.JOB_PLATFORM_LAB,
  WA_DS_PENDING_JOB.JOB_SCRIPT,
  WA_DS_PENDING_JOB.FREQUENCY_LAB,
  WA_DS_SCHED_INFO.PERIODICITY,
  WA_DS_SCHED_INFO.PERIODICITY_DET,
  WA_DS_PENDING_JOB.IP_ADR_SN_BCA,
  WA_DS_PENDING_JOB.START_DATETIME_F+1/24,
  WA_DS_PENDING_JOB.START_DATETIME_F,
  WA_DS_PENDING_JOB.END_DATETIME_F+1/24,
  WA_DS_PENDING_JOB.END_DATETIME_F
FROM
  WA_OBJ_M_DOCUMENTS,
  WA_DS_PENDING_JOB,
  WA_DS_SCHED_INFO,
  OBJ_M_ACTORLINK  ACTORLK4,
  WA_BCA_OBJ_M_ACTOR
WHERE
  ( WA_OBJ_M_DOCUMENTS.M_DOC_N_ID=WA_DS_PENDING_JOB.DOCUMENT_ID(+)  )
  AND  ( WA_BCA_OBJ_M_ACTOR.M_ACTOR_N_ID=WA_DS_PENDING_JOB.DOCSERVER_ID  )
  AND  ( ACTORLK4.M_ACTL_N_ACTORID=WA_BCA_OBJ_M_ACTOR.M_ACTOR_N_ID  )
  AND  ( ACTORLK4.M_ACTL_N_ACTORTYPE=32  )
  AND  ( WA_DS_SCHED_INFO.BATCH_ID=WA_DS_PENDING_JOB.BATCH_ID  )
  AND  (
  WA_OBJ_M_DOCUMENTS.M_DOC_C_TYPE_EXT  IN  ('BATCH', 'REP', 'WID')
  AND  WA_DS_PENDING_JOB.START_DATETIME_F+1/24  <  '01-01-2037 00:00:00'
  AND  WA_DS_PENDING_JOB.JOB_STATUS_F  IN  ('Failure', 'Running', 'Success', 'Waiting')
  AND  WA_BCA_OBJ_M_ACTOR.M_ACTOR_C_NAME  =  @variable('Enter a BCA queue :')  AND  (ACTORLK4.M_ACTL_N_ACTORTYPE = 32)
  )

bernard timbal :fr: (BOB member since 2003-05-26)

#4

Hi Bernard,

Thanks for the code. But i am unable to get the table DS_SCHED_INFO.

Can you please tell me in which table the info gets stored?

Is this the table name is OBJ_M_ACTORDOC?

Else can you please tell me the table and column name or we need multiple tables to retrive then please name the tables?

Thanks,

Ranjan

ranjan.sahoo :india: (BOB member since 2007-06-11)

#5

These tables came with auditor.

Thus look on BOBdownload’s :wink:

Sebastien

#6

So probably we dont have auditor licenses?
I am not sure.

But the table is not there in BO Repository.

Even though i have 57 tables with respect to Doc+unv+security domain.

Thanks,

Ranjan

ranjan.sahoo :india: (BOB member since 2007-06-11)

#7

have a look at your xml licence key and see the number of users associated with auditor product. if you have not, follow Goiffon suggestion :wink:

bernard timbal :fr: (BOB member since 2003-05-26)

#8

I have checked. I dont have auditor license.

So how do i proceed to check which are the reprts were sent which are the users?

Thanks,

Ranjan

ranjan.sahoo :india: (BOB member since 2007-06-11)

#9
#10

Hi Goiffon,

I am not getting the link of that BA users and documents?

Can you please provide the same?

Thanks,

Ranjan

ranjan.sahoo :india: (BOB member since 2007-06-11)

#11

Did you try this?

Regards
Sebastien

#12

Hi Goiffon,

I got this. The inbox info is there in the report Repository information.rep.

Thank you very much for the info.

Thanks,

Ranjan

ranjan.sahoo :india: (BOB member since 2007-06-11)