How to use MainView customization to count data objects quickly ?

Version 1
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    MainView Infrastructure


    APPLIES TO:

    any



    QUESTION:

    How can I quickly Count, different object types in a MainView tabular summary view ?

    This process is valid for all tabular views, the example shown here is from the CMF view DEVSTATZ.


    ANSWER:

    The view DEVSTATZ is a Summary view, indicated by the Z at the end of the view name.

    DEVSTATZ from CMF

    We can see that 195 rows of data are presented in the view. 
    We can also see that the second column is the device type (3490 or 3390).
    We can enter the SUM command and place our cursor on the second column and press enter.

    DEVSTATZ from CMF with SUM command


    The result is a summary view by Device Type :

    DEVSTATZ from CMF after SUM command

    In this example we now have 2 data lines for each model type, one for 3390 and one for 3490.
    Also notice that because of the summarization type, all of the numeric values represented are the average, clearly explained in the help panel display.

    Our interest is to know how many device type are counted in this summary.

    We can now enter the view customization , enter CUST in the command line and press enter. We will now create a count column using R(epeat) B. We choose the same column used for the summarization.

    CUST before R B

    The result is a new column (C) is created. We format the new column with the command F(ormat) C.

    After F(ormat) the new field C


    So let's make the field a little bit larger, change the Heading and most important change the Summarization type to C(ount)  :

    CUST the new fiedl C
     
    We now have a new column that represents the count of each device type :
    Done with CUST the new Field C

    Note that the fields are still summarized but now the value represents the average per device type as the help panel explains.

    Help on field





     


    Article Number:

    000166379


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles