Count Objects per Space Instance (Partition)

edit

Hello ,

Please help me with a query to count the objects of a specific type that are stored in space (per partition). I have a space which has 4 partitions (2 working instances and 2 for backups) and various objects stored in these partitions.

I am using the XAP web interface and I want to see how many objects of a specific type are stored per partition. e.q

p1 : obj1, obj2 , obj3

p2: obj1, obj2

I want to see p1 => 3 , p2 => 2

So something like

select count(objID) from <ObjectType> group by <PartitionId>

Thanks, Alex