Re: SQL query ??
1999-04-08 06:24:29
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>
|
- SQL query ??, Dick Nieuwenhuizen
- Re: SQL query ??, Roger Hohmann
- Re: SQL query ??, Trevor Foley
- Re: SQL query ??, Dick Nieuwenhuizen
- Re: SQL query ??, Dick Nieuwenhuizen
- Re: SQL query ??, Russell Street
- Re: SQL query ??, Dick Nieuwenhuizen
- Re: SQL query ??, Trevor Foley
- Re: SQL query ??, Russell Street
- Re: SQL query ??,
Dick Nieuwenhuizen <=
- Re: SQL query ??, Dick Nieuwenhuizen
- SQL query ??, Dick Nieuwenhuizen [SMTP:dnieuwen
- Re: SQL query ??, Dick Nieuwenhuizen [mailto:dnieuwen
|
|
|