0 Replies Latest reply on Jun 17, 2014 1:58 PM by basil_free

    Well hey all, I am new to SolarWinds and could use some help with charts for group memebers.

    basil_free

      I am attempting to chart the availability of members of group. I was able to
      duplicate the group member availability table report from the report writer on
      the server to the web piece by using the sql method.  It was the only way
      to get the group availability column. Apparently I need a time column
      defined to align with the datasource and under the more option I don’t have
      that column available for the group.  My question is how can I add
      that option, is there something I can add to the sql query below?  I am not a SQL guy.  Any help would be appreciated.

       

      Text of the sql query :

      Select Group_Name,
      Group_Member_Name,  Cast(Group_Member_Status As nvarchar(250)) as
      Group_Member_Status, Group_Member_Availability From ( SELECT

       

      Containers_AlertsAndReportsData.GroupName
      AS Group_Name, Containers_AlertsAndReportsData.GroupMemberName AS
      Group_Member_Name, Containers_AlertsAndReportsData.GroupMemberStatusDescription
      AS Group_Member_Status,
      Containers_AlertsAndReportsData.GroupMemberPercentAvailability AS
      Group_Member_Availability

       

      FROM

       

      Containers_AlertsAndReportsData

       

      WHERE 

       

      (

       
      (Containers_AlertsAndReportsData.GroupName LIKE '%Tier-1-Windows%')

       

      )

       

       

       

      ) As r ORDER BY 1 ASC, 2 ASC

       

       


      webreport1.jpg

       

      webreport2.jpg

       

      webreport3.jpg


       

      Free out