TSM v5
SELECT COUNT(*) FROM NODES WHERE PLATFORM_NAME LIKE ‘WIN%’
TSM v6 and above
SELECT COUNT(*) FROM NODESVIEW WHERE PLATFORM_NAME LIKE ‘WIN%’
Posted in: Helpful TSM SQL Commands
Spirit Software Solutions - TSM Administration and Reporting made easy
IBM TSM Notifications- Terms of Use
- IT43823: DOCUMENTATION FOR THE UPDATE STATUSTHRESHOLD IS MISLEADING.
- IT43779: TIER STORAGE POOL SUMMARY PROCESS HANGS WITH WORKER PROCESS SHOWING ZERO FILES/BYTES PROCESSED.
- IT43750: REMOVE REPLNODE IN MULTI-TARGET REPLICATION ENVIRONMENT CAN SET NODE REPLICATION STATE TO NONE
- IT43630: VERSION 8.1.X API FUNCTION DSMUPDATEFS() PERFORMANCE IS DEGRADEDCOMPARED TO PREVIOUS API VERSIONS
- IT43739: ANR4560E MAY OCCUR ON COMBINATIONS DOCUMENTED AS COMPATIBLE.