5 Replies Latest reply on Dec 12, 2014 10:28 AM by navidrasi

    Send group members statu on alert

    navidrasi

      I am trying to send an alert when a group status changes and i want to send the list of members and status of each of them

      when the alert triggers.so i edit the Alert me when a groups status changes

      and in the email i tried to used

      ${GroupMemberName}

      ${GroupMemberStatusID}

      but it only return the first member

      then i tried SQL query

      something like this :

       

      ${SQL:SELECT     Containers_AlertsAndReportsData.GroupName AS Group_Name,Containers_AlertsAndReportsData.GroupStatusDescription AS Group_Status,Containers_AlertsAndReportsData.GroupMemberName AS Group_Member_Name,Containers_AlertsAndReportsData.GroupMemberStatusDescription AS Group_Member_Status FROM Containers_AlertsAndReportsData Where GroupID=${GroupID}}

       

      which is return what i want in SQL but in email i can only see the first member

       

      what should i do ?

        • Re: Send group members statu on alert
          mharvey

          In the SQL variable, you can only return one value row of data, so you can't return group name, status, member name and status, you have to choose 1 value to in the SQL Select Variable. 

           

          You could also try  ${GroupDetailsURL} which will send the link to the group page.

            • Re: Send group members statu on alert
              navidrasi

              sorry if i am asking stupid question . i am new in Orion

              so there is now way to get the list ? some kind of loop to read them one by one?

              i saw the reports , can i send the a report in alert ?

              i need the list so the users see it on email or SMS , using the URL is not helpful in my case

                • Re: Send group members statu on alert
                  mharvey

                  There's not a way to embed an entire report, and the SQL variables you could do one to pull the names and another to pull the status, but they'd be in corresponding rows and not a table.  What you may want to do rather than alert on the group status is update on the group member status.  That way you can send the status of the member, then name of the group, and the name of the member that has changed it's status. 

              • Re: Send group members statu on alert
                jim8424

                I'm using ${GroupStatusRootCause} in my group status change alerts. It lists the node or nodes responsible for the group status change. It sounds kind of like what you are trying to do.

                1 of 1 people found this helpful
                • Re: Send group members statu on alert
                  navidrasi

                  Ok i found it in another post

                   

                  ${SQL:SELECT cast(cast([GroupMemberFullName]as varchar(max)) + '' + ' ' + '-' + ' ' as XML), cast(cast([GroupMemberStatusName]as varchar(max)) + '' + CHAR(10) + CHAR(13) as XML) FROM  [SolarWindsOrion].[dbo].[Containers_AlertsAndReportsData] where   GroupID=${GroupID}  FOR XML PATH('')}

                   

                  Thanks everyone