ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to find the correct polled item count for use in the Sizing Wizard


Article ID: 238203


Updated On:


CA Performance Management - Usage and Administration DX NetOps


How do I find the polled item count for use in the sizing wizard?


All supported releases


1. Access adminTools and choose: 2 Connect to Database

2. Find your schema (you will use this in place of $schema in any of the below calls that mention it):



dradmin=> \dn
        List of schemas
    Name    |  Owner  | Comment
 v_internal | dradmin |
 v_catalog  | dradmin |
 v_monitor  | dradmin |
 public     | dradmin |
 v_func     | dradmin |
 v_txtindex | dradmin |
 dauser     | dauser  |    <--- Schema
(7 rows)

3. Check for the overall database item count:

select count(*) from $schema.v_poll_item;


dradmin=> select count(*) from dauser.v_poll_item;
   936   <--- What you target in the sizing wizard
(1 row)

Additional Information

How do I see how many retired items I have:

How do I see how many filtered items I have: