Select Distinct NodeID ,NodeType ,VProcType1 || ': ' || TRIM(VProc1) AS AMPs ,VProcType2 || ': ' || TRIM(VProc2) AS PEs ,VProcType3 || ': ' || VProc3 AS GTW ,VProcType4 || ': ' || VProc4 AS RSG ,VProcType5 || ': ' || VProc5 AS TVS ,VProcType6 || ': ' || VProc6 AS VProc6 ,VProcType7 || ': ' || VProc7 AS VProc7 From DBC.ResUsageSpma Order By NodeID;
If ResUSage is not enable then following query can be use: -- Check number of AMPs and PEs select count(t1.ProcId) Nodes, sum(t1.AmpCount) Amps, sum(t1.PECount) PEs from table (MonitorPhysicalResource()) as t1 where t1.Status = 'U';
|