banner_bild_01 banner_bild_02 banner_bild_03 banner_bild_04 banner_bild_05
banner_bild_06 banner_bild_07 banner_bild_08

TSM SQL Beginners Tutorial (10)

button-home

Home SQL

arrow

Previous

Next

Sometimes the TSM Database does not offer the desired level of granularity. Lets assume you want to know how many files have been backed up from Benjamin's "C:\USRSHRS\DEP01" directory, you could enter

select count(*) as "Objects from Benjamin C:" from backups -
where node_name='BENJAMIN' and filespace_name='\\benjamin\c$' -
and hl_name='\USRSHRS\DEP01\'

But this query will only count objects in the specified directory and will ignore everything lying deeper in the directory structure. Fortunately SQL offers the 'fuzzy' clause "Like" to find not only exact matches but also similar entries. Other than most similar algorithms in shells, "Like" uses the percent character "%" as a wildcard rather than "*". So to count not only objects in "C:\USRSHRS\DEP01" but also underneath, we have to enter:

select count(*) as "Objects from Benjamin C:" from backups -
where node_name='BENJAMIN' and filespace_name='\\benjamin\c$' -
and hl_name like '\USRSHRS\DEP01\%'

 Alle erwähnten Produkte und Bezeichnungen können eingetragene Warenzeichen der jeweiligen Hersteller sein und werden als solche betrachtet.
Bei Fragen oder Problemen kontaktieren Sie bitte info@general-storage.de

Navigation  | Über GS  |  Lösungen  |  ServiceReferenzen  |  Impressum  |  Download

© 2016 by General Storage GbR. Alle Rechte vorbehalten

arrow

Previous

Next

Kontaktieren Sie uns:

Telefon: +49 6206 157686
Telefax:  +49 6206 157687
E-Mail: info@general-storage.de

arrow
arrow
GS_Logo1_Neu
gse-logo

13th ISP Symposium 2017
26.-29. September 2017,
Cologne Marriott Hotel


IBM

SSW-2258:
An Alternative to NDMP for Network Attached Storage Backup 
with dsmISI MAGS


Kundenforum
IBM Spectrum Protect und Veeam Kundenform, 28. Juni 2017, Skyloft Frankfurt Airport


Pressemitteilung:
dsmISI for Veeam ermöglicht unbegrenzte Speicher für Backups

Hier nachlesen


General Storage Lösungen
Ready for IBM Tivoli Software

tivoli_ready