Count Objects per Space Instance (Partition)
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