NPM reporting customization

MathieuJM

Hi,

We have a report based on the availabiilty for all our defined groups for the last month. We wish to have a direct link in the report to be able to click on the group name and directly go to the group page.

I notice that there is no GroupId variable sothat we are not able to create a dynamic link to the web page of the report.

We are using for the time being NPM10.2.

What did you recommand for this ?

Regards

MathieuJM

Hi

Finally i have i have found a solution create a custom sql report and get the groupid value.

here is the report template:

<Report Version="1.0" Group="Group Availability" Title="Last Month" ModuleTitle="" Type="SQL" TypeDescription="" Icon="SQL" Schema="" SubTitle="" Description="" Footer="" Time_Frame="Named" Named_Time_Frame="Last 30 Days" Relative_Time_Frame="24 Hours" Starting_DateTime="1/2/2012 0:0:0" Ending_DateTime="2/2/2012 0:0:0" Grouping="Date" Group_Position="Beginning" SQL="SELECT  TOP 10000 CONVERT(DateTime,LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),101) AS SummaryMonth,
Containers_AlertsAndReportsData.GroupName AS Group_Name,
AVG(Containers_DailyContainerAvailability.GroupPercentAvailability) AS AVERAGE_of_Group_Availability,
Containers_AlertsAndReportsData.GroupID as GroupID

FROM
Containers_AlertsAndReportsData INNER JOIN Containers_DailyContainerAvailability ON (Containers_AlertsAndReportsData.GroupID = Containers_DailyContainerAvailability.GroupID)

WHERE
( DateTime BETWEEN 40907 AND 40937.9999884259 )

GROUP BY CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101),
Containers_AlertsAndReportsData.GroupName,
Containers_AlertsAndReportsData.GroupID

ORDER BY SummaryMonth ASC, 2 ASC" TopX="All" TopXCount="10" TopXPercent="10" Orientation="Landscape" CookedData="TRUE" Web="TRUE" GroupByDays="TRUE" ShowFolders=""><QueryBuilder><Fields></Fields><Filter></Filter></QueryBuilder><LayoutGroups><Group Field="SummaryMonth" GroupHeader="${SummaryMonth}" WEBURL="" Alignment="0" ForeColor="0" BackColor="16777215" FontSize="8" FontName="Arial" FontBold="TRUE" FontItalic="FALSE" FontUnderline="FALSE" FontStrike="FALSE" Transparent="FALSE"></Group></LayoutGroups><Fields><Field Name="Group_Name" Header="Group Name" Range="ALL" Parser="None" Format="" Alignment="Left" Width="0" Units="" Hidden="FALSE" WebURL="/Orion/NetPerfMon/ContainerDetails.aspx?NetObject=C:${GroupID}" BaseTableName="Containers"></Field><Field Name="SummaryMonth" Header="Month" Range="Positive" Parser="Month" Format="" Alignment="Left" Width="0" Units="" Hidden="FALSE" WebURL="" BaseTableName=""></Field><Field Name="AVERAGE_of_Group_Availability" Header="Average Availability" Range="ZeroAndAbove" Parser="Numeric" Format="0.00" Alignment="Center" Width="0" Units="%" Hidden="FALSE" WebURL="" BaseTableName="DailyContainerAvailability"></Field><Field Name="GroupID" Header="GroupID" Range="ALL" Parser="None" Format="" Width="0" Units="" Hidden="TRUE" WebURL="/Orion/NetPerfMon/ContainerDetails.aspx?NetObject=C:${GroupID}" BaseTableName="ContainerMemberSnapshots"></Field></Fields></Report>

Is it correct for you ?