ADSM-L

Re: SQL query ??

1999-04-08 06:24:29
Subject: Re: SQL query ??
From: Dick Nieuwenhuizen <dnieuwen AT SOLAIR1.INTER.NL DOT NET>
Date: Thu, 8 Apr 1999 12:24:29 +0200
I've already made some scripts but I was hoping ADSM had a better way to
get this kind of information.

Thanks a lot for your effort
Regards
Dick

Russell Street wrote:

> > Thank for your reply, but I still got not the information I need to
> > satisfy my manager. He likes to know what impact it has when we
> > decrease expiration dates and number of versions. There must be some
> > way to find out what inactive files are deleted files. ADSM does.
>
> I do not think there is a way to distinguish between extra versions
> and deleted files at the ADSM server end.
>
> How about this for another approach.
>
> At the client end you can use
>
>         dsmc query backup /filespace/* -inactive -su=yes
>
> to get a list of ALL the files the client has, whether they are active
> or inactive and their size.
>
> You can then match this against all the files currently on the client
> and divide them into
>
> - active files
>
> - files that are on the "query backup" list, marked as inactive and
> present on the client: extra versions
>
> - files that are on the "query backup" list, marked as inactive and
> not present: deleted files.
>
> Doing this on a few typical clients then scaling could produce an
> answer that is close enough for management purposes.
>
> Russell
<Prev in Thread] Current Thread [Next in Thread>