Hello!

I am wondering if anyone has created reports using the Caster (BOTDEST, BOTEUSER, BOTGRP, BOTSTATS, etc) and MRE files (IBIMRGRP, IBIDOM,etc). I need to get a list of all scheduled reports, and the distribution list in RC, and shared reports in MRE. I was able to get a report off MRE that shows the following under the USER_PROP column:

USER_PROP
parmrpt,shared,robot,library,email=Tiffany.Monreal@LehighHanson.com"

Does the "shared" wording means the user has "shared" folders in MRE?

Any suggestions will be greatly appreciated. Thanks

Luiz

This message has been edited. Last edited by: Kerry,

We use excel and an ODBC connection to query the files. We create a table and then filter the values we need.

You can create connection adopter for your Rcaster DB and create metadata to run the reports.

If its too much work, use sql script and use sql data dump.

Thanks Dan and Arif for your suggestions. Can you guys tell me which Caster files you've used to get the data? Thanks

Luiz

Luiz,

Here's the microsoft query parameters that we use:


SELECT BOTPARMS.SCHEDULEID, BOTPARMS.TASKID, BOTPARMS.PARAM_NAME, BOTPARMS.PARAM_VALUE, BOTSCHED.CASTER_USER, BOTSCHED.JOBDESC, BOTSCHED.ACTIVE, BOTSCHED.DISTLIST, BOTSCHED.MAILUSER, BOTSCHED.MAILFROM, BOTSCHED.MAILSUBJECT, BOTTASK.TASKNAME, BOTTASK.TASKOBJ, BOTTASK.BURST, BOTTASK.ASVALUE, BOTTASK.SENDFORMAT
FROM S1042267.LAWAPP81DB.BOTPARMS BOTPARMS, S1042267.LAWAPP81DB.BOTSCHED BOTSCHED, S1042267.LAWAPP81DB.BOTTASK BOTTASK
WHERE BOTPARMS.SCHEDULEID = BOTSCHED.SCHEDULEID AND BOTTASK.PACKETID = BOTSCHED.PACKETID AND BOTTASK.TASKID = BOTPARMS.TASKID

why excel?

if you can do an select like this...it can be done in webfocus direct too as far as i know

Frank, you're right. I was able to find the RC files under the ibi folder, and just have to create the synonyms in WebFocus. Thanks everyone for all your help.

Luiz

Frank,

I can't filter and play with the output as easy.

Dan

see Luiz answer
or ask your local representative...they should be able to help you. If you use the proper masters you can create many reports on the reportcaster files, log info, users, adreslist and many more