- 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