Release Dates – MCG Support

Administration - Release Dates

This page allows users to enter release dates for applications that can be displayed in report and charts as annotations.

Adding/Editing release date

Release dates can be added by pressing "Add new release date" and edited by selecting the Edit text link to the right for the release date.

The following fields is available:

Application: The application that the release date is placed under, Applications can be created under Administration -> Applications.

Release Date: Date the release was deployed to the application, please note that the date is in UTC/GMT+0 timezone, no timezone information is applied from the logged in users timezone. (In YYYY/MM/DD)

Release Type: Type of the release, can be blank or description of the release, like if it was a Patch, Full release or Performance Improvement.

Release Version: Version for the release, can be a description, date or version code like 1.11.2.

Auto Detected: Automatically filled out, indicated that UXM discovered the version automatically, UXM detects version for monitored Desktop applications and creates the release dates automatically. (If the Scheduled Search "Desktop - Auto-Detect Release Dates" is enabled)

Auto detecting new versions for UXM Desktop applications

You can activate the scheduled search that detects new releases every day by going to Settings -> "Searches, Reports, and Alerts" and filtering on "release".

Select Edit and Enable

You can select Run to create the versions seen the "Last 24 hour" and change the time filter further back to get old release dates created for UXM Desktop applications.

Splunk SPL for Chart with annotations

Please note that >= has to be replaced with >= if copying directly into XML source

<row>
 <panel>
 <title>Apdex score - Last 12 months</title>
 <chart>
 <title>Shows Apdex score for last 12 months grouped by week. (0.00 is worst score, 1.00 is best score possible)</title>
 <search>
 <query>`getSummaryIndex(resolution=hourly,source=web,type=general)` app_key="5c3852d8d0530808e00ad8ab"
| eval satisfiedCount = if(sla==0,1,0) | eval toleratedCount = if(sla==1,1,0) | eval frustratedCount = if(sla==2,1,0)
| stats sum(satisfiedCount) as satisfiedCount, sum(toleratedCount) as toleratedCount, sum(frustratedCount) as frustratedCount, count AS totalCount by _time
| eval Apdex = (((satisfiedCount*1) + (toleratedCount*0.5) + (frustratedCount*0)) / totalCount)
| timechart span=1w eval(round(avg(Apdex),2)) as "Apdex"</query>
 <earliest>-12mon@mon</earliest>
 <latest>now</latest>
 <sampleRatio>1</sampleRatio>
 </search>
 <search type="annotation">
 <query>| inputlookup ux_release_dates_lookup | where application_key="5c3852d8d0530808e00ad8ab" 
 | eval _time=strptime(release_date, "%Y/%m/%d") | addinfo | where _time>=info_min_time
 | lookup ux_applications_lookup _key AS application_key OUTPUT name AS applicationNameLookup 
 | fillnull value="" release_type applicationNameLookup
 | strcat applicationNameLookup " - " release_version " - " release_type annotation_label
 | eval annotation_category = release_type
 | fields _time, annotation_label, annotation_category</query>
 <earliest>-12mon@mon</earliest>
 <latest>now</latest>
 </search>
 <!-- Customize the event annotation colors based on category name -->
 <option name="charting.annotation.categoryColors">{"Full":"0x006D9C","Patch":"0x53A051"}</option>
 <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
 <option name="charting.axisLabelsX.majorLabelStyle.rotation">0</option>
 <option name="charting.axisTitleX.visibility">collapsed</option>
 <option name="charting.axisTitleY.visibility">visible</option>
 <option name="charting.axisTitleY2.visibility">visible</option>
 <option name="charting.axisX.abbreviation">none</option>
 <option name="charting.axisX.scale">linear</option>
 <option name="charting.axisY.abbreviation">none</option>
 <option name="charting.axisY.maximumNumber">1.0</option>
 <option name="charting.axisY.minimumNumber">0.0</option>
 <option name="charting.axisY.scale">linear</option>
 <option name="charting.axisY2.abbreviation">none</option>
 <option name="charting.axisY2.enabled">0</option>
 <option name="charting.axisY2.scale">inherit</option>
 <option name="charting.chart">column</option>
 <option name="charting.chart.bubbleMaximumSize">50</option>
 <option name="charting.chart.bubbleMinimumSize">10</option>
 <option name="charting.chart.bubbleSizeBy">area</option>
 <option name="charting.chart.nullValueMode">gaps</option>
 <option name="charting.chart.showDataLabels">none</option>
 <option name="charting.chart.sliceCollapsingThreshold">0.01</option>
 <option name="charting.chart.stackMode">default</option>
 <option name="charting.chart.style">shiny</option>
 <option name="charting.drilldown">none</option>
 <option name="charting.fieldColors">{"Apdex":0x920a80}}</option>
 <option name="charting.layout.splitSeries">0</option>
 <option name="charting.layout.splitSeries.allowIndependentYRanges">0</option>
 <option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
 <option name="charting.legend.mode">standard</option>
 <option name="charting.legend.placement">bottom</option>
 <option name="charting.lineWidth">2</option>
 <option name="refresh.display">progressbar</option>
 <option name="trellis.enabled">0</option>
 <option name="trellis.scales.shared">1</option>
 <option name="trellis.size">medium</option>
 </chart>
 </panel>
</row>

Splunk SPL for table with release dates