Hello, since the TSM Database knows nearly everything about the files on our clients (NT Servers) I though it would be a good idea to do some reporting with sql about - distribution of different file types - i. e. how many avis, mp3 are there around , how much volumina.... - how old are the files on the NT servers and how long aren't they accessed.... The first one is easily done by SQL The second one needs information about fileattributes and here is the problem: How to access fileattributs information. There should be a solution since the Backupclient has also access to this information without retrieving the files. Can I use sql or do I have to use the Backupclient-API? With Regards ---------------------------------------------------------------------------- -- Stefan Holzwarth ADAC e.V. (Rechenzentrum, Produktionsplanung und Organisation) Am Westpark 8, 81373 M�nchen Tel.: (089) 7676-5212, Fax: (089) 76768924 -----BEGIN GEEK CODE BLOCK----- Version: 4.0 GCM/S d- s+: a C+(++) ULA++ P+>++ L+(++) E--- W++>+ N++ o-- K? w+(++) O+ M V? PS+ PE Y+ PGP->+ t+ 5+ !X R tv b !DI D G e+++ h--- r z? -------END GEEK CODE BLOCK-----
