Teljes szöveg:
- Hasznos TSM SQL lekérdezések
- clause - GROUP BY clause - HAVING clause - SELECT clause - ORDER BY clause ====Takarításhoz==== ... lt aktív management class-ok listázása === <file>select domain_name,class_name as "MGMT CLASS without OBJECTS" from mgmtclasses where class_name not in (select distinct class_name from backups) and class_name not in (select distinct class_name from archives) and set_name='
- TSM napi riport shell szkript @shell:riportok
- ################################# # Hasznalt SQL selectek TSM-hez SQL_LICENSZ_HASZNALATOK='select cast(FRONTEND_CAP/1024/1024 as decimal (8,2)) as "Front-End TB... ancy date" from status' #SQL_LICENSZ_HASZNALATOK='select cast(FRONTEND_CAP/1024/1024 as decimal (8,2)) as ... cy date" from status' SQL_UTOLSO24H_ADATMOZGASAI="select nn.domain_name,summary.activity, sum(cast(summary