Search String: Display: Description: Sort:

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*select\s+node\s+summary\s*$/: 4 ]

Total 4 documents matching your query.

1. select node summary (score: 1)
Author: Joni Moyer <joni.moyer AT HIGHMARK DOT COM>
Date: Thu, 18 Nov 2004 12:52:40 -0500
Hello All! I believe that I am getting the syntax of a select statement wrong for summarizing the backup information summary for all nodes that begin with ln* from 11/12/2004 - 11/13/2004. Here is wh
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2004-11/msg00567.html (11,618 bytes)

2. Re: select node summary (score: 1)
Author: Andrew Raibeck <storman AT US.IBM DOT COM>
Date: Thu, 18 Nov 2004 11:50:20 -0700
I think you are looking more for something like this: select entity as node_name, date(start_time) as date, cast(activity as varchar(10)) as activity, time(start_time) as start, time(end_time) as end
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2004-11/msg00570.html (12,915 bytes)

3. Re: select node summary (score: 1)
Author: Joni Moyer <joni.moyer AT HIGHMARK DOT COM>
Date: Thu, 18 Nov 2004 16:00:46 -0500
Thanks Andy! It worked like a charm! I do not mean to sound ignorant, but why do I not see the TDP backups for these servers within this summary? They are TDP for domino backups, but I guess I just a
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2004-11/msg00577.html (14,062 bytes)

4. Re: select node summary (score: 1)
Author: Andrew Raibeck <storman AT US.IBM DOT COM>
Date: Fri, 19 Nov 2004 07:53:35 -0700
Off-hand, I am not sure why you don't see them. Try searching the table with less restrictive criteria and see what entries exist. For example, select * from summary where entity='BLAH' where BLAH is
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2004-11/msg00600.html (14,920 bytes)


This search system is powered by Namazu