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 do I see how many filtered items I have?

book

Article ID: 238205

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

How can I find out how many filtered items the database has?

Environment

All supported releases

Resolution

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):

\dn

Example:

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 filtered items:

select is_filtered, count(*) from $schema.v_poll_item group by 1;

Example: 

dradmin=> select is_filtered, count(*) from dauser.v_poll_item group by 1;
 is_filtered | count
-------------+-------
           1 |    97     <--- Filtered Items
           0 |   839

 

Additional Information

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

https://knowledge.broadcom.com/external/article?articleId=238203

How do I see how many retired items I have:

https://knowledge.broadcom.com/external/article?articleId=238206