HPE OneView
cancel
Showing results for 
Search instead for 
Did you mean: 

OneView Alert Mails - Filtering out Multiple Conditions

 
SOLVED
Go to solution
Michael Leu
Honored Contributor

OneView Alert Mails - Filtering out Multiple Conditions

I am trying to create a Email Filter in OneView 3.00.08 which should trigger on status:critical and status:warning but ignore the following events:

healthCategory:Appliance eventTypeID:Alerts.DBMaxCapacity
healthCategory:Network eventTypeID:Trap.cpqNic3ConnectivityLost
healthCategory:Network eventTypeID:Trap.HealthStatusArrayCategoryStatus

Any idea how this could be accomplished? Because it seems only one "NOT" is allowed in a query...

11 REPLIES
Highlighted
ChrisLynchHPE
Neighborhood Moderator
Solution

Re: OneView Alert Mails - Filtering out Multiple Conditions

You will need to change your search criteria to something like the following:

NOT alertTypeID:trap.cpqHeThermalTempDegraded NOT alertTypeID:trap.cpqFca2PhyDrvStatusChange

Re: OneView Alert Mails - Filtering out Multiple Conditions

I had luck leveraging a format like below, I used the Activity view and search option to help isolate a search string that seems to work.

status:critical status:warning NOT alertTypeID:trap.cpqHeThermalTempDegraded NOT alertTypeID:trap.cpqFca2PhyDrvStatusChange

Since I don't have the same data, I can't validate, however for the example provided I would try:

status:critical status:warning NOT alertTypeID: Alerts.DBMaxCapacity NOT alertTypeID::Trap.cpqNic3ConnectivityLost NOT alertTypeID::Trap.HealthStatusArrayCategoryStatus

David Claussen
Regular Advisor

Re: OneView Alert Mails - Filtering out Multiple Conditions

In your question, I see a lot of alert/email formatting. I have been searching for this type of information for months.

I have a new install of OneView Standard 3.10.07-0310774. I have a handfull of ProLiant DL380s and 360s added to it.

As stated in other posts, when setting an allert for simply warning and critical, I receive 6 alert emails when a server reboots.

I would like to be able to create an alert something like this:   status:warning status:critical Physical Drive Status Change  

Is there a document anywhere that can help me with creating alerts that are very specific? I am looking to alert on failed hard drives, failed power supplies, etc, but only things like that. When a server reboots, I receive and alert that the network connectivity to iLO has been lost. I don't want to see that hence the request for being very specific with alert definicians.

Thanks all!

- Dave Claussen

Mainecoon
Advisor

Re: OneView Alert Mails - Filtering out Multiple Conditions

Trying to setup some filter in Oneview and it seems to work fine as long as i can find the cpq string in event details, but how to exclude one of these? as there is no "cpq" string in the error details.

The overall status of the system network is in the error state.

  1. Health category InterconnectBay
  1. Event details
  1. portId

    571956-B21-7C940800V5:d9

  2. portStatus

    SubportStateChanged

  3. resourceUri

    /rest/interconnects/61b8cbf6-495a-4e79-8ad0-43e4a633cfc0

nbhms
Advisor

Re: OneView Alert Mails - Filtering out Multiple Conditions

I've been looking for the same thing, no luck so far.  Very sparce documentation on some of the finer points of this product.

Mainecoon
Advisor

Re: OneView Alert Mails - Filtering out Multiple Conditions

Any luck with this, i would like to exclude network, interconnect and security alerts like these every hour about leave certificates. so far not much luck.

status:critical status:warning NO associatedresourcecategory:interconnects

or

status:critical status:warning NOT alertTypeID:trap.cpqNicMibCondition NOT associatedresourcecategory:appliance NOT associatedresourcecategory:interconnects

 

 

David Claussen
Regular Advisor

Re: OneView Alert Mails - Filtering out Multiple Conditions

With no sufficient documentation and zero support here in the forums, I gave up.

I see that there is a new version, so I might try again, but it is likely the same thing will happen.

Forcing us away from System Insight Manager, in to OneView, and not supporting OneView - not cool.

Mainecoon
Advisor

Re: OneView Alert Mails - Filtering out Multiple Conditions

Yes it is frustrating not be able to filter this in a easy way, i mean why would you send an security alert about an expired leave certificate every hour!? who cares!, why all this fuzz about certificates anyway. I'm running the latest version 4.10.03-0364293.

testing now with this one:

status:critical status:warning NOT associatedresourcecategory:interconnects

not sure if it works, als no clue how to filter the security alerts about crtificates, maybe this:

NOT associatedresourcecategory:appliance

Update: unfortunataly i just got about 30+ alerts saying "An error has occurred on connection 2. Interconnect..........." so who can explain me how to filter this...this topic is closed but there is no real answer.

Looking at this comment in one of the manuals:

TIP: Filters have the same syntax as the Smart Search box in the Activity screen, so you can copy them and paste them in this field.

I started to play with the smartfilter and made the query below that i'm now testing:

status:critical status:warning NOT crm.connectionstatechange NOT alerts.certificatestatus.expired NOT remote-support.notconnectedtohp

Not working....now updated to this

status:critical status:warning NOT alertTypeID:crm.connectionstatechange NOT alertTypeID:alerts.certificatestatus.expired NOT alertTypeID:remote-support.notconnectedtohp

ChrisLynchHPE
Neighborhood Moderator

Re: OneView Alert Mails - Filtering out Multiple Conditions


@David Claussen wrote:

With no sufficient documentation and zero support here in the forums, I gave up.

I see that there is a new version, so I might try again, but it is likely the same thing will happen.

Forcing us away from System Insight Manager, in to OneView, and not supporting OneView - not cool.


Please remember that these forums are for the community to interact with.  It is not for official product support.

We are updating our documentation to address this very issue.  So, with the next OneView release, we will have better documentation for how to use the Smart Search and Email Filtering capabilities of OneView.

ChrisLynchHPE
Neighborhood Moderator

Re: OneView Alert Mails - Filtering out Multiple Conditions

Yes it is frustrating not be able to filter this in a easy way, 

I'm sorry that this is frustrating.  As I just mentioned, we are working on updating our user documentation on how to use the Smart Search and Email Filtering capabilities.  

i mean why would you send an security alert about an expired leave certificate every hour!? who cares!, why all this fuzz about certificates anyway.

It is very important for you to know that you have expired certificates.  HPE OneView will not be able to negotiate TLS with the iLO or endpoint whos certificate has expired.  One way to address this is to use an internal enterprise PKI (i.e. Microsoft Certificate Services) to manage endpoint SSL certificates.  That way, you add the issuing certificate authorities public certificate to the appliance once, and that is it.  If the endpoints SSL certificate expires, you simply renew it from the issuer, and we will the implicitly trust that certificate, as long as it is valid and not revoked.

status:critical status:warning NOT alertTypeID:crm.connectionstatechange NOT alertTypeID:alerts.certificatestatus.expired NOT alertTypeID:remote-support.notconnectedtohp

This should work, and is similar to the updated examples we are adding to the user documentation and online help.

Mainecoon
Advisor

Re: OneView Alert Mails - Filtering out Multiple Conditions

Hi Chris, thank you for the responce!

About the certificates is this also the case when you disable th cert. verification? as i had many expired certs and did not see any connection issues to the iLO but got fludded every hour with ton's of email. Also now that i clear most of these there are still old cert warning (that are already updated) that are in a locked state that i cannot clear also not via commandline.

Also about this line:

status:critical status:warning NOT alertTypeID:crm.connectionstatechange NOT alertTypeID:alerts.certificatestatus.expired NOT alertTypeID:remote-support.notconnectedtohp

i can tell you it is not working at least not for the connection state part, for the other two i will have to verify the activity log to see if we had any of these.

I would like to filter the connection alert below that happens during server reboot:

Critical

 An error has occurred on connection XX. Interconnect XXXXXXXXXX, interconnect X port X subport X is unlinked. XXXXXXXX
 Resolution If the server XXXXXXXX, bay X is power cycling or powered off, connectivity alerts may occur as the network adapter
 is either disconnected or negotiates connectivity with the interconnect. These alerts can be ignored and should clear automatically.
 If this server is booted up and running an operating system, this alert indicates a loss of connectivity between the network adapter
 and the interconnect. Verify that the CNA supports the current interconnect downlink speed. Verify the configuration of the
operating system, health and link status of the downlink ports on which the connection depends. If the problem persists,
please contact your authorized support representative and provide them with a support dump.
• Alert details

Updates:

I can confirm that the following is working:

12/17/2018  - "NOT alertTypeID:remote-support.notconnectedtohp"  filters out "Remote support is unable to connect to HPE. Remote Support" .

12/18/2018 - "NOT alertTypeID:profilemgr.connections.connection_scmb_error"  filters out
"An error has occurred on connection X. Interconnect XXXXXXXXX, interconnect X port XX subport a is unlinked" .

12/18/2018 - " NOT alertTypeID:crm.connectionstatechange" filters out "Connection on downlink port XX, subport a has failed. The subport is unlinked".

Now looking into "The overall status of the system network is in the error state."

 I'm NOT yet working for HPE.