Application Details - Lite

frak

In building a SAM detail view - with a graph for every component, it realised it look pretty silly to have all the components listed twice - once in the graphs and once in the Application Details.

I used this is the SAM ADFS monitor - ADFS (Active Directory Federation Services) 2016 Monitor.  This is the end result - replacement Application Details is on the left

Instructions:

1. Remove the standard Application Details

2. Add a Custom Table

3. Configure the data source for the Custom Table to Advanced Database Query - SQL

4.Set SQL as follows

select 'MANAGEMENT:' as title, '<div class="NodeManagementIcons ui-helper-clearfix" style="margin-bottom: 7px !important;"><a href="thwack.solarwinds.com/.../EditApplication.aspx + cast(ID as varchar(15)) + '"><img src="/Orion/Nodes/images/icons/icon_edit.gif"> Edit Application Monitor</a> <span style="visibility:hidden"></span><a href="javascript:;" onclick="return SW.APM.PollApp.pollNow({ selItems: [{ id: ''' + cast(ID as varchar(15)) + ''', name: ''Active Directory Federation Services 2016'' }], onComplete: function () { window.location.reload(true); }});"><img src="/Orion/images/pollnow_16x16.gif"> Poll Now</a> <span style="visibility:hidden"></span><a href="thwack.solarwinds.com/.../ + cast(ID as varchar(15)) + '&amp;withRelationships=true&amp;presetTime=last12Hours&amp;charts=0_Orion.APM.GenericApplication_' + cast(ID as varchar(15)) + '-Orion.APM.ApplicationStatus.PercentAvailability,0_Orion.APM.GenericApplication_' + cast(ID as varchar(15)) + '-Orion.APM.ApplicationStatus.Availability;0_Orion.APM.GenericApplication_' + cast(ID as varchar(15)) + '-Orion.PerfStack.Events;0_Orion.APM.GenericApplication_' + cast(ID as varchar(15)) + '-Orion.PerfStack.Alerts;0_Orion.Nodes_240-Orion.PerfStack.ScmChanges"><img src="/Orion/PerfStack/images/icons/perfstack_launch.svg" height="16" width="16"> Performance Analyzer</a> <span style="visibility:hidden"></span><ul class="ManagementTaskDropdown"><li class="submenu"><span><img src="/Orion/Nodes/images/icons/maintenance_mode_icon16.png" alt=""> Maintenance Mode</span></li></ul> </div>' as Detail
from APM_Applications where ID = ${ApplicationID}
union all
select NULL, 
'<div class="NodeManagementIcons ui-helper-clearfix" style="margin-bottom: 7px !important;">      
<a href="javascript:;" onclick="return SW.APM.NodeManagement.openRealTimeProcessWindow('+ cast(n.NodeID as varchar(15)) +');"><img src="/Orion/APM/Images/RT_process_explorer.png" class="apmNodeManagementTask"> Real-Time Process Explorer</a> <span style="visibility:hidden"></span>
<a href="javascript:;" onclick="return SW.APM.NodeManagement.openRealTimeServicesWindow('+ cast(n.NodeID as varchar(15)) +',0);"><img src="/Orion/APM/Images/RT_service_manager.png" class="apmNodeManagementTask"> Service Control Manager</a> <span style="visibility:hidden"></span>
<a href="javascript:;" onclick="return SW.APM.NodeManagement.openRealTimeEventExplorerWindow('+ cast(n.NodeID as varchar(15)) +',0);"><img src="/Orion/APM/Images/RT_event_viewer.png" class="apmNodeManagementTask"> Real-Time Event Log Viewer</a> <span style="visibility:hidden"></span>
</div>'
from APM_Applications  ap
inner join Nodes n on ap.NodeID = n.NodeID
where ID = ${ApplicationID}
union all
select 'APPLICATION NAME:', '<a href="thwack.solarwinds.com/.../ApplicationDetails.aspx + cast(ap.ID as varchar(15)) + '">' 
+ ap.Name + '</a> on <a href="thwack.solarwinds.com/.../NodeDetails.aspx + cast(ap.NodeID as varchar(15)) 
+ '">' + n.Caption +'</a>'
from APM_Applications  ap
inner join Nodes n on ap.NodeID = n.NodeID
where ID = ${ApplicationID}
UNION ALL
select 'APPLICATION STATUS:'
,'<img class="apm_StatusIcon" alt="Up" src="/Orion/APM/images/StatusIcons/Small-App-' + stat + '.gif"> Application status is  ' + stat 
FROM (
SELECT [ApplicationID], case when  [PercentAvailability]=100 then 'Up' else 'Down' END Stat, [TimeStamp], max(Timestamp) over (partition by ApplicationID) MaxTimestamp
FROM dbo.APM_ApplicationStatus_Detail 
WHERE ApplicationID = ${ApplicationID}
) p1
where Timestamp = MaxTimestamp
UNION ALL
SELECT 'NODE STATUS:'
,'<img class="StatusIcon" alt="Node status is '+ n.StatusDescription +'." src="/Orion/images/StatusIcons/Small-' + rtrim(ltrim(n.StatusLED)) + '">'
+ ' <a href="thwack.solarwinds.com/.../NodeDetails.aspx cast(n.NodeID as varchar(15)) +'">'+ n.StatusDescription +'</a>'
from APM_Applications  ap
inner join Nodes n on ap.NodeID = n.NodeID
where ID = ${ApplicationID}

5. Set the second column to HTML rendering

kduncan

Excellent work on this as it is exactly what i am looking for.  I am close to getting this to work. However, it is failing from line 29 on. Once I add in this section, I get the dreaded "* Query is not valid."  As this is my first comment to Thwack, please let me know if you need anything further for troubleshooting.