Hi,

here are two versions:

One for summary (if no version is indicated, then it's a pre V3 client) and
one on a detail level.
Also take a look at the admin reference under SELECT, there is quite a good
description, and with a little bit of  phantasie you can get a lot of
beautiful queries.

Nr 1

select CLIENT_VERSION as "C-Vers", -
       CLIENT_RELEASE as "C-Rel", -
       CLIENT_LEVEL   as "C-Lvl", -
       CLIENT_SUBLEVEL as "C-Sublvl", -
      PLATFORM_name  as "OS" , -
count(*) as "Nr of Nodes" from nodes -
group by
CLIENT_VERSION,CLIENT_RELEASE,CLIENT_LEVEL,CLIENT_SUBLEVEL,platform_name


Nr 2:

select  NODE_NAME      as "Node", -
        CLIENT_VERSION as "C-Vers", -
        CLIENT_RELEASE as "C-Rel", -
        CLIENT_LEVEL   as "C-Lvl", -
        CLIENT_SUBLEVEL as "C-Slvl", -
       PLATFORM_name  as "OS" -
     from nodes
_________________________________________________

Kind Regards
Andreas Buser

Tel: ++41 61 285 73 21  Fax: ++41 61 285 70 98

Email: Andreas.Buser AT Basler DOT ch

Address:
Basler Versicherungen
Andreas Buser
Abt. Informatik
Aeschengraben 21
4002 Basel
Switzerland



                    Bo Nielsen
                    <Bo_Nielsen@F        An:     ADSM-L AT VM.MARIST DOT EDU
                    DB.DK>               Kopie:
                    Gesendet von:        Thema:  Query Client version.......
                    "ADSM: Dist
                    Stor Manager"
                    <ADSM-L AT VM DOT MA
                    RIST.EDU>


                    17.12.99
                    07:47
                    Bitte
                    antworten an
                    "ADSM: Dist
                    Stor Manager"





Hi,

is there anybody, there can help me with a command
to query the client version on a node.


Bo Nielsen
-------------------------------------------------------------------------
FDB Data                                        Phone:  +45 4683 4671
FDB Data                                        Phone:  +45 4683 4671
EDB-Driftscenter                                  Fax:  +45 4683 4990
Roskildevej 65                                  E-mail:  bo_nielsen AT fdb DOT 
dk
DK-2620 Albertslund