When you issue the Q filespace f=d command, have it spool to disk.

     Q filspace f=d > filspace.txt

filspace.txt (or what ever name you wish to use) will be created in the ADSM
directory on the machine you issued the admin command from.  The format of the
report will be line oriented (instead of column oriented as you described),
and is suitable for printing (although the line length exceed the 132 colums),
or for use as input into a program or REXX Exec.

Jerry Lawson
jlawson AT itthartford DOT com
________________________Forward Header________________________
Author: INTERNET.OWNERAD
Subject: ADSM Reporting Capabilities
05-03-96 12:48 PM

Many times I have come accross instances where the reports
that can be generated using the admin client cannot be generated
from the command line utilities.

For instance, from the command line the "query filspace" command
does not represent the details that I require.  Upon issuing a
"query filespace format=detailed" changes the format - it is no
longer in columnar format, it is now going down the page.  What
I want to do is generate the report available from the admin
GUI interface on a scheduled basis and mail the results to the
users that are affected (IE: drive utilization, date of last
backup, etc).  The file produced from the GUI interface is
ideal:  one line (record) per node, and a fixed length of 520
bytes.  How can I do this via the command line?

Another instance:
I was trying to find an easy way to produce a report which
simply contains the scheduling classes and the nodes that
belong to it - is there an easier way that selecting each
class one by one?

One way to solve my reporting problems would be to get an
engine that can access the Database that ADSM uses - or at
least the file layout of the records.  Has anyone else come
across this problem, or better yet - Anyone have a solution?




Bryan King
Network Specialist
ISM Manitoba
Winnipeg, Canada
204-946-6640
bking AT ism DOT ca