Remove an Inactive Hitachi Array from the Database

In Capacity Manager, if an array has been removed from Hitachi Device Manager (HDvM), it remains in the IT Analytics database as an inactive array and it will continue to be included in reports. Take the following command-line steps to delete the array.

Execute the query:

select storage_array_id from aps_storage_array where array_name='<ARRAY NAME>';

Using the storage_array_id from the above query to execute this code:
```
Begin
  srm_common_pkg.deleteStorageArray(<STORAGEARRAYID>);
End;
/
```
Verify that the array was deleted successfully using this query (should return 0).
```
select count(*)
FROM aps_storage_array
WHERE storage_array_id = <STORAGEARRAYID>;
```

Remove an Inactive Hitachi Array from the Database

Feedback

Feedback