TSM SQL

TSM SQL >> NODES Table

SQL Builder

COLUMN Use This Limit to: Aggregate As
SELECT ALL
NODE_NAME
PLATFORM_NAME
DOMAIN_NAME
PWSET_TIME
INVALID_PW_COUNT
CONTACT
COMPRESSION
ARCHDELETE
BACKDELETE
LOCKED
LASTACC_TIME
REG_TIME
REG_ADMIN
LASTSESS_COMMMETH
LASTSESS_RECVD
LASTSESS_SENT
LASTSESS_DURATION
LASTSESS_IDLEWAIT
LASTSESS_COMMWAIT
LASTSESS_MEDIAWAIT
CLIENT_VERSION
CLIENT_RELEASE
CLIENT_LEVEL
CLIENT_SUBLEVEL
CLIENT_OS_LEVEL
OPTION_SET
AGGREGATION
URL
NODETYPE
PASSEXP
KEEP_MP
MAX_MP_ALLOWED
AUTO_FS_RENAME
VALIDATEPROTOCOL
TCP_NAME
TCP_ADDRESS
GUID
TXNGROUPMAX
DATAWRITEPATH
DATAREADPATH
SESSION_INITIATION
CLIENT_HLA
CLIENT_LLA
COLLOCGROUP_NAME
PROXY_TARGET
PROXY_AGENT
EMAIL_ADDRESS

SELECT * FROM NODES

Related Queries:

Sample SQL

SELECT NODE_NAME as "Nodes", STGPOOL_NAME as "STG POOL", SUM(PHYSICAL_MB) AS "MB", SUM(NUM_FILES) as "Files" FROM OCCUPANCY GROUP BY NODE_NAME, STGPOOL_NAME