ADSM-L

Select query for servergroups

2002-02-18 08:48:56
Subject: Select query for servergroups
From: "Gloeer, Kirsten" <Kirsten.Gloeer AT COMMERZBANK DOT COM>
Date: Mon, 18 Feb 2002 14:44:43 +0100
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 <=