Use MS-Access with ODBC and you won't have to download it explicitly.
besure your ADSM Admin Client install ODBC. GO to Control Panel and
choose odbc and check for adsm, hilight it and then chose configure.
launch MS-Access , choose a DB(blank initially), choose Queries on the sub
window, then new, then OK (it should be on Design View)
(here's the tricky part)
close the Show table window, right click on the blue header boarder
that says Query1: select query, pull down SQL Specific anc choose
pass-through then type in your select, right-click the blue again
for properties and touch ODBC a '...' appears , select it, a data sources
appears go for the back menu machine sources ADSM should be a choice,
fill in userid and password ( i have a query only id for this) hit connect
it will go out and log in then ask if you want to save password in
connection string, close query properties, hit the red
! (bang/exclamation) and watch it run!! the results are now in a spread-
sheet setup under access.
I haven't figure what to do after that jsut yet but its nice to launch
large select queries from my NT desktop with 1 click!
hope this helps. (and what did you do on your Pres Day Holiday??? :-)
cheers ! ... joe.faracchio
P.S. got this out of a SAMS Teach Yourself SQL (in 10 minutes) by Ben
Forta. Great book ! Perfect for an ADSM ADMIN novice as it is 85% Select
statement tutorial stuff!!!
On Mon, 21 Feb 2000, Mauro Jr, Frank wrote:
> Here is a SQL command I use every month which reports on the amount of data
> stored (in MB) and the number of files backed up by ADSM per server:
>
> select node_name, sum(logical_mb) as Data_In_MB, sum(num_files) as
> Num_of_files
> from occupancy group by node_name order by node_name asc
>
> I would then download the data to your PC and using Excel (or whatever other
> tool you like) you can sum up the total.
>
> I stored the data in Microsoft Access so I track the usage of ADSM per
> server on a monthly basis.
>
> Frank Mauro
> Liberty Mutual
> COS - ADSM
> Frank.MauroJr AT LibertyMutual DOT com
> 603.245.3207
>
>
> -----Original Message-----
> From: Gary Ison [SMTP:Gary.Ison AT MAIL.STATE.KY DOT US]
> Sent: Monday, February 21, 2000 4:09 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Question - How can Icount files and MB currently
> under ADSM/TSM?
>
> Hello folks,
>
> I'm trying to determine how many files and how many MB of
> storage
> they occupy in two ADSM/TSM servers. I have the following SQL query
> to get
> the information from ADSM/TSM, but the results look a little fishy
> to me
> based on the number of clients I have enrolled. Anyone have a
> better
> mousetrap? Thanks.
>
> select cast (sum (physical_mb) as decimal(10,0)) -'
> as "Storage Used", -'
> cast (sum (num_files) as decimal(10,0)) -'
> as "Files" -'
> from occupancy'
>
> Gary L. Ison
> 101 Cold Harbor Drive
> Frankfort, Ky. 40601
> Phone: (502) 564-8724
> Fax: (502) 564-6856
> Gary.Ison AT mail.state.ky DOT us <mailto:Gary.Ison AT mail.state.ky
> DOT us>
>
|
