Add objects to the Object Exclusion Database table
To exclude objects (such as clients, ESX hosts, and arrays) from data collection, the object must be inserted into the apt_exclude_object table. If the object is already in the database, the object also will need to be deleted from the database in order to exclude it from the license count.
See Removing objects from the license count.
See Deleting objects using the Inventory List view.
Open a terminal to the Portal server (Linux) or a command prompt on the Portal server (Windows)
For Linux, su - aptare
Execute: sqlplus <ID>/<password>
Use the following SQL statement to view the exclude object table:
SQL> desc apt_exclude_object; Name Null? Type -------------------------------------------- DOMAIN_IDNOT NULLNUMBER(6) OBJECT_NAMENOT NULLVARCHAR2(64) CREATION_DATENOT NULLDATE APTARE_PRODUCT_TYPENOT NULLNUMBER(2) OBJECT_TYPE VARCHAR2(30) CREATION_DATE NOT NULL DATE LAST_EXCLUDED_DATE DATE
Note:
For APTARE_PRODUCT_TYPE you will substitute one of the following numeric values in the command line execution of the procedure, listed later in these steps.
Backup Manager = 1
Capacity Manager = 2 (used for Array objects)
Virtualization Manager = 4
Replication Manager = 8
Fabric Manager = 16
File Analytics = 32
Execute: select domain_name, domain_id from apt_domain;
This is to capture the domain ID, needed for subsequent script executions.
Typically, the domain ID will be 100000, however, in a multi-tenancy, Managed Services environment, the domain ID will be specific to the client's domain.
SQL> select domain_name, domain_id from apt_domain; DOMAIN_NAME DOMAIN_ID ------------------------ CORP07 100000
Execute the following, substituting your specific values:
SQL> insert into apt_exclude_object (domain_id, object_name, aptare_product_type, object_type, creation_date) values (100000, 'Array 123',2,'Array', sysdate);
Note:
The valid object types are: Backup Host, Virtual Host, Array, San, Data Domain Host, and File Analytics Host.
This step adds (inserts) this object into the object exclusion database table.For object_name substitution, use the name, such as the host or array name.
Repeat step 5 for all objects that need to be excluded from data collection.
After completing all the inserts, execute: commit;
If the clients are already in the database, you will need to delete them from the database so they will not be counted against your license.