Select query for servergroups
2002-02-18 08:48:56
Hi,
is it possible to get the output of a select query from different servers
in one output table?
the query is:
all:select sum(a.backup_mb) as "Backup [MB]",sum(a.archive_mb) as
"Archive [MB]",b.domain_name from auditocc a,nodes b
where a.node_name=b.node_name group by b.domain_name
order by b.domain_name
The servergroup all is defined.
is it possible to get the following output:
Backup [MB] Archive [MB] DOMAIN_NAME
----------- ----------- ------------------
300 10917 A
300 10917 A
1795599 453162 B
12625 12960 C
instead of:
Backup [MB] Archive [MB] DOMAIN_NAME
----------- ----------- ------------------
100 0 A
100 0 A
1795599 453162 B
ANR1688I Output for command 'select
sum(a.backup_mb),sum(a.archive_mb),b.domai-
n_name from auditocc a,nodes b where a.node_name=b.node_name group by
b.domain_name order by b.domain_name' issued against server X completed.
ANR1687I Output for command 'select
sum(a.backup_mb),sum(a.archive_mb),b.domai-
n_name from auditocc a,nodes b where a.node_name=b.node_name group by
b.domain_name order by b.domain_name' issued against server Y follows:
Backup [MB] Archive [MB] DOMAIN_NAME
----------- ----------- ------------------
200 10917 A
200 10917 A
12625 12960 C
regards,
Kirsten
Commerzbank AG ZIT P 5.22
Mainzer Landstr. 151 60327 Frankfurt
Tel.: 069/136-22505 Fax: 069/136-25059
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- Select query for servergroups,
Gloeer, Kirsten <=
|
|
|