| Author |
Message |
rp123
Groupie
Joined: 26 Feb 2009
Location: United States
Online Status: Offline
Posts: 47
|
   Topic: find repeat incidents
Posted: 14 Nov 2009 at 3:10am |
Hi All, I want to build a formula so that it can search only the common repeat incidents from {probsummarym1.brief.description}. see the sample. Sample Data:(these are all repeated incidents) {probsummarym1.brief.description}
| 04/09/2009
at 21:28:32 PATROL detected brk02.com |
| 04/10/2009 at 00:06:24 PATROL
detected brk01.com |
| 04/10/2009 at 02:41:24 PATROL
detected brk01.com | | 05/09/2009
at 23:06:50 Patrol Detected a ALARM on WS0144CL@DiskI: FreeSpace 0.00 |
| 05/09/2009 at 23:06:58 Patrol
Detected a ALARM on WS0144CL@DiskQ: FreeSpace 0.00 |
| 05/09/2009 at 23:07:00 Patrol
Detected a ALARM on WS0144CL@DiskP: FreeSpace 0.00 |
| 01/24/2009
at 17:29:54 PATROL detected No Oracle sessions left on instance ALPTPROD on
hup81 |
| 01/24/2009 at 17:29:54 PATROL
detected No Oracle sessions left on instance ALPTPROD on hup81 |
| 01/24/2009 at 17:29:54 PATROL
detected No Oracle sessions left on instance ALPTPROD on hup81 |
01/24/2009 at 17:29:54 PATROL
detected No Oracle sessions left on instance ALPTPROD on hup81
| 08/25/2009
at 22:08:03 Process LARM~:MET is down on vp09 |
| 08/26/2009 at 08:50:06
Process LARM~:NEL is down on vp20 |
| 08/26/2009 at 09:22:38
Process LARM~:SKB is down on vp04 |
| 08/26/2009 at 11:25:59
Process LARM~:MJV is down on vp06 |
| ws1101
IS DOWN after pinging server |
| ws1101 IS DOWN after
pinging server |
| ws1101 IS DOWN after
pinging server |
| ws1101 IS DOWN after
pinging server |
|
|
|
rp
|
 IP Logged |
|
|
Vertex
Newbie
Joined: 29 Oct 2009
Location: India
Online Status: Offline
Posts: 24
|
Posted: 14 Nov 2009 at 11:40am |
|
how to get beginning date from SQL database to display in report...plz help
Edited by Vertex - 14 Nov 2009 at 11:41am
|
|
Hi Peoples
|
|
IP Logged |
|
rp123
Groupie
Joined: 26 Feb 2009
Location: United States
Online Status: Offline
Posts: 47
|
Posted: 14 Nov 2009 at 5:33pm |
|
I did not understand yr question.
but I run the report using parameter by entering start date/time and end date/time.
|
|
rp
|
|
IP Logged |
|
Vertex
Newbie
Joined: 29 Oct 2009
Location: India
Online Status: Offline
Posts: 24
|
Posted: 14 Nov 2009 at 8:07pm |
|
hi my problem is here
if {?Trial} ="This Year" then
fromdate:= minimum (yeartodate)
else if {?Trial} ="Last Year" then
fromdate:= minimum(lastyearYTD)
else if{?Trial} ="ALL" then...
Fromdate:=..........?
so how can i get Date of begining record from Database ....here fromdate is
startind date like for this year and last year ....
thanks
|
|
Hi Peoples
|
|
IP Logged |
|
rp123
Groupie
Joined: 26 Feb 2009
Location: United States
Online Status: Offline
Posts: 47
|
Posted: 15 Nov 2009 at 6:57pm |
|
I just want to get the list of repeated words or common words like as seen in sample data i.e. LARM, ALPTPROD on
hup81 etc.
I want that when i run the report it should look for repeated words/data.
|
|
rp
|
|
IP Logged |
|
Vertex
Newbie
Joined: 29 Oct 2009
Location: India
Online Status: Offline
Posts: 24
|
Posted: 16 Nov 2009 at 7:31am |
|
how to fix the limit between two calendars ..like if i choose the first date from first calendar like
1 may 2009 then the second calender date must be not more them 3 month
..but it can also be 1 day , 2 day , 1 month or more but must not more then 3 month like 1 august 2009
"can search for an extended period such as 3 months"
plsease give me solution
|
|
Hi Peoples
|
|
IP Logged |
|
rp123
Groupie
Joined: 26 Feb 2009
Location: United States
Online Status: Offline
Posts: 47
|
Posted: 16 Nov 2009 at 10:39am |
|
usually its a monthly report which will be running on a monthly basis.
So I would say run 1 month.
but give me the 3 months solution as well if you could provide it. Thankx
|
|
rp
|
|
IP Logged |
|
rp123
Groupie
Joined: 26 Feb 2009
Location: United States
Online Status: Offline
Posts: 47
|
Posted: 18 Nov 2009 at 11:11am |
|
hi guys,
can you please help me on this??
|
|
rp
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 18 Nov 2009 at 12:13pm |
rp,
Can you explain further what you want to do.
There are the LIKE and INSTR functions but you need to predefine teh elements that youa re looking for. It sounds like you want to know if any words in the text are repeated at all...?
|
|
IP Logged |
|
Vertex
Newbie
Joined: 29 Oct 2009
Location: India
Online Status: Offline
Posts: 24
|
Posted: 19 Nov 2009 at 8:17am |
|
hi Dblank
i have two date time parameter (calendar) in my report and at the time of main report preview i want to apply the records selection conditions for report like :-
1. If the first date is selected for example 2 july 2009 then i want to set condition that the second date must not more than 3 months from first date so the second date is restricted to select further of 2 oct 2009.
2. This condition we can also apply through the first date time parameter like if i select any first date then the second date time parameter itself set further 3 months according to first date time parameter but...
3. The limit of record selection is maximum 3 months but the i can also set second date time parameter for 1 day, 2 day or 3 day, 1 week , 2 week, 1 month, 2 month or any date from the first date time parameter but it also not go more than 3 months limit as it define in above 1 and 2 points.
help me....anything which is possible either it record selection formula or it any calendar parameter setting.... thanks
|
|
Hi Peoples
|
|
IP Logged |
|
|
|
