How to generate occupancy report by platform name?

[rpandey]

Hi
I have generated below using -

SELECT platform_name,COUNT(*) number_nodes FROM nodes GROUP BY platform_name

Now i need to generate occupancy report by PLATFORM_NAME. Please help me to write me script to generate occupancy report by platform name.



PLATFORM_NAME NUMBER_NODES
------------------ -------------
AIX 23
Linux x86-64 28
Linux86 5
LinuxZ64 352
TDP HyperV 11
TDP MSExchg 3
TDP MSSQL Win64 4
TDP VMware 32
WinNT 376
9

 

[marclant]

This is not it, but it's a starting point, it shows how to match the data from the OCCUPANCY table and platform from the NODES table
https://thobias.org/tsm/sql/#toc25

You probably just need to remove the node_name and domain_name from the select and from the group by.