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!

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

How to fund number of repeated instances

Status
Not open for further replies.
AurobindoSaha

AurobindoSaha

Programmer
Mar 11, 2004
57
0
0
US
Hi,

We have around 45000 reports in BOXI 3.1 environment.
Many of these WebI and Crystal Reports are scheduled multiple times.

I would like to find how many duplicate recurring schedules are there with same parameters.

How many of those instances has failed, succeeded, pending and running status.

I am using Auditor database, and Activity universe.

Can any one suggest the SQL or some other means to find that?
 
Status
Not open for further replies.

Similar threads

JOEYB99
  • Locked
  • Question
Problem with Webi Hyperlink to SAP t-code CATS_DA
Replies
0
Views
103
JOEYB99
JOEYB99
Emmy2368
  • Locked
  • Question
Creating Year to Date Filter
Replies
4
Views
122
Emmy2368
Emmy2368
t1sugar
  • Locked
  • Question
which version of crystal reports for boxi 4.1; Help 1
Replies
3
Views
109
hilfy
hilfy
PWD
  • Locked
  • Question
Query Filter to "End of Month Date Time" Web Intelligence Rich Client Version 12:4:0
Replies
3
Views
79
SkipVought
S
PWD
  • Locked
  • Question
Count of Dates For Non-Unique Values
Replies
2
Views
73
PWD
PWD

Part and Inventory Search

Sponsor

Back
Top