HI Mike,
Very glad to hear that you are finding it nice..!
The array_id is nothing but reference to id column in Array table(foreign key). That you can find it in one of the cache table column like, in the aggregate cache table query ( Datasource Types->On Command UnifiedManager-> storage->Aggregate table-> "create table sql") as below
CREATE TABLE `storage`.`aggregate` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR(255) NOT NULL ,
`total_size_mb` BIGINT NOT NULL ,
`used_size_mb` BIGINT NOT NULL ,
`available_size_mb` BIGINT NOT NULL ,
`volume_count` INT NOT NULL ,
`status` VARCHAR(255) DEFAULT NULL ,
`array_id` INT NOT NULL , <<-----------------------------
`block_type` VARCHAR(255) COMMENT 'possible values are 32_bit,64_bit' DEFAULT NULL ,
PRIMARY KEY (`id`)
);
In Aggregate dictionary table, it will just listed as Array , not as array_id. You can find it as array_id only in the create cache table query.
In any dictionary table( which is cache-ble) where ever you have a reference that willl be represented as <reference_table_name>_id in the cache table.
BTW, what was the example for a query user input, you were looking..!
Warm Regards
Sivaprasad K