HPPI Report issue

[HP_Tools]

Hi Expert,

We are using the HP PI verison 5.31 on windows.

We are added 4000 nodes in HPPI.

I want to know,if any nodes reports not get geneate so how to find out that  nodes which is not generate the PI reports or it not get discover in HPPI.

Please suggest.....

[vasanthapr335]

Hi ,

            Either you can check log files, it willbe in installed drive, OVPI/logs . You just open and check which  node has issue.

Also you can check NRT report for interface ,i guess by default it will be there in OVPI. Just download report and check how many nodes are missing in it.

            Normally we follow, after addiing nodes we do type discovery, then enable required interface.
 I have basic knowledge of OVPI . Check it works or not.

[Piku]

Hi,

You can use the table k_ovpa_global_history, it contains the last poll time for each node in epoch time.

hth

[HP_Tools]

 Hi Expert,

Not able to find the table k_ovpa_global_history.

can you please suggest how to find out the table k_ovpa_global_history.

Thanks for your help.

[Piku]

Hi,

Try k_ovpa_global and ksi_managed_node.
Not having the system so cannot tell the exact column name and table.
But one the table should have column name last poll and ill have last poll time in unix epoch time as large integer value.

Regards,

[HP_Tools]

Hello,

I have found KSI_MANAGED_NODE table is PI but not found k_ovpa_global.

please check below update.

SQL> desc KSI_MANAGED_NODE;
 Name                                      Null?    Type
 ----------------------------------------- -------- -------------------
 DSI_KEY_ID                                NOT NULL NUMBER(10)
 DSI_TARGET_NAME                           NOT NULL VARCHAR2(64)
 DSI_TABLE_KEY                                      VARCHAR2(128)
 COMM_STRING_ID                            NOT NULL NUMBER(10)
 SNMP_PROFILE_ID                           NOT NULL NUMBER(10)
 SNMP                                      NOT NULL NUMBER(3)
 SNMPV2                                    NOT NULL NUMBER(3)
 STATUS                                    NOT NULL NUMBER(3)
 DSI_DESCR                                          VARCHAR2(255)
 IFENTRY_DISCOVER_FLAG                              NUMBER(3)

SQL> desc  k_ovpa_global;
ERROR:
ORA-04043: object k_ovpa_global does not exist

[Piku]

Hi,

both k_ovpa_global and k_ovpa_global_history should be there.

Are you not using the system resource pack for servers?

Check with sysdba privileges.

Regards,

[HP_Tools]

Hi Expert,

Please confirm how to check system resource pack on server.