<p><strong>Complexity: </strong>Medium</p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"> </p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.0pt; line-height: 107%; font-family: Lato, sans-serif; color: #151920; background: white;">This is a live change and needs to be done on the Redbox.Centralisation database using MS SQL Management studio. </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 10pt; color: #e03e2d;"><strong><span style="line-height: 107%; font-family: Lato, sans-serif; background: white;">RECOMMEND DOING THE CHANGE ON A TEST INSIGHT VM BEFORE APPLYING ON CUSTOMERS INSIGHT SERVER </span></strong></span></p>
<h1 style="margin: 12pt 0cm 0cm; line-height: 107%; break-after: avoid; font-size: 16pt; font-family: &#39;Calibri Light&#39;, sans-serif; color: #2f5496; font-weight: normal;"><span style="background: white;">Raising the severity of an insight alarm </span></h1>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.0pt; line-height: 107%; font-family: Lato, sans-serif; color: #151920; background: white;"> </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.0pt; line-height: 107%; font-family: Lato, sans-serif; color: #151920; background: white;">Below is the query to raise the severity of an alarm </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.0pt; line-height: 107%; font-family: Lato, sans-serif; color: #151920; background: white;">UPDATE [analytics].[NotificationDefinition] SET Severity &#61; </span><em><span style="font-size: 9.0pt; line-height: 107%; font-family: Lato, sans-serif; color: #4472c4; background: white;">X</span></em><span style="font-size: 9.0pt; line-height: 107%; font-family: Lato, sans-serif; color: #151920; background: white;"> WHERE Name &#61; &#39;</span><em><span style="font-size: 9.0pt; line-height: 107%; font-family: Lato, sans-serif; color: #4472c4; background: white;">AlarmName</span></em><span style="font-size: 9.0pt; line-height: 107%; font-family: Lato, sans-serif; color: #151920; background: white;">&#39;;</span></p>
<p style="margin: 0cm 0cm 8pt 36pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><em><span style="font-size: 9.0pt; line-height: 107%; font-family: Consolas; color: #ed7d31;">e.g. To update the severity of the recorder heartbeat alarms on insight </span></em></p>
<p style="margin: 0cm 0cm 8pt 36pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><em><span style="font-size: 9.0pt; line-height: 107%; font-family: Consolas; color: #ed7d31;">UPDATE [analytics].[NotificationDefinition] SET Severity &#61; 2 WHERE Name &#61; </span></em><span style="font-size: 9.0pt; line-height: 107%; font-family: Consolas; color: red;">&#39;</span><em><span style="font-size: 9.0pt; line-height: 107%; font-family: Consolas; color: #ed7d31;">RecorderHeartbeatFailed</span></em><span style="font-size: 9.0pt; line-height: 107%; font-family: Consolas; color: red;">&#39;</span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">Severity values </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">       1 &#61; Warning – does not email when alerts are raised on insight  </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">       2 &#61; Error – Does email when alerts are raised on insight</span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas;"> </span></p>
<h1 style="margin: 12pt 0cm 0cm; line-height: 107%; break-after: avoid; font-size: 16pt; font-family: &#39;Calibri Light&#39;, sans-serif; color: #2f5496; font-weight: normal;">Finding the alarm name of an already raised/cleared alarm  </h1>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"> </p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">Can use the following query to view the list of alarm names </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: blue;">SELECT</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> </span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: gray;">*</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> </span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: blue;">FROM</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> analytics</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: gray;">.</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">NotificationDefinition </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">The ‘Name’ column is where you will find the alarm names. Highlighted below </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"><img src="/sys_attachment.do?sys_id&#61;a7a6297047b72150fa27e929736d435e" alt="A screenshot of a computerDescription automatically generated with medium confidence" width="511" height="246" /></span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">For the “RecorderAlarmXXXX” these reference the alarm code in the recorder.mib files. You can also use the number to raise a test alarm on the recorder to find out what they are </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">Recorder.mib file from 6C_SP1 recorder attached. </span></p>
<p><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: blue;"> </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas;">To find the alarm name of a raised/cleared alarm, in order to raise the severity of that alarm you will need to run the following commands </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: blue;">SELECT</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> </span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: gray;">*</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> </span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: blue;">FROM</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> analytics</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: gray;">.</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: blue;">Notification  </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas;">This query shows all the alarms raised and the time they were raised the latest alarms will be at the bottom of the list  </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas;"><img src="/sys_attachment.do?sys_id&#61;67a6e97047b72150fa27e929736d4313" alt="A screenshot of a computerDescription automatically generated with low confidence" width="587" height="142" /></span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas;">   </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: blue;">SELECT</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> </span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: gray;">*</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> </span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: blue;">FROM</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> analytics</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: gray;">.</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">NotificationClearing </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">this query will show all the alarms cleared</span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"><img src="/sys_attachment.do?sys_id&#61;aba6297047b72150fa27e929736d431f" alt="A screenshot of a computerDescription automatically generated with low confidence" width="602" height="142" /></span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas;">(may find the time shown is -1 hour the time shown on Insight UI)</span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">Can use the ‘NotificationDefinitionID’ value and query the ‘analytics</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: gray;">.</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">NotificationDefinition’ table to find out what alarm name that entry represents by running this query </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> </span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: blue;">SELECT</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> </span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: gray;">*</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> </span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: blue;">FROM</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> analytics</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: gray;">.</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">NotificationDefinition </span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: blue;">WHERE</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> Id</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: gray;">&#61;</span><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: red;">&#39;</span><em><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: #4472c4;">NotificationDefinitionID Value</span></em><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: red;">&#39;</span><em><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: #4472c4;"> </span></em></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">And then can use the update query at the beginning of this KB to raise the severity of that alarm.</span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;">&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;</p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">The following script do the same as above for recent raised alarms. It will output all recent alarms, the date they were raised and severity</span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">1. CREATE VIEW NewAlarmsRaised As<br />     SELECT [Severity],[Name],[RaisedTimestamp]<br />           FROM [analytics].[NotificationDefinition],[analytics].[Notification]<br />           WHERE analytics.NotificationDefinition.Id &#61; [NotificationDefinitionId];</span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;">2. SELECT * FROM [dbo].[NewAlarmsRaised]</span></p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"> </p>
<p style="margin: 0cm 0cm 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 9.5pt; line-height: 107%; font-family: Consolas; color: black;"> </span></p>

HTML Online Editor & Compiler

Write, Run & Share HTML code online using OneCompiler's HTML online Code editor for free. It's one of the robust, feature-rich online Code editor for HTML language, running on the latest version HTML5. Getting started with the OneCompiler's HTML compiler is simple and pretty fast. The editor shows sample boilerplate code when you choose language as HTML. You can also specify the stylesheet information in styles.css tab and scripts information in scripts.js tab and start coding.

About HTML

HTML(Hyper Text Markup language) is the standard markup language for Web pages, was created by Berners-Lee in the year 1991. Almost every web page over internet might be using HTML.

Syntax help

Fundamentals

  • Any HTML document must start with document declaration <!DOCTYPE html>
  • HTML documents begin with <html> and ends with </html>
  • Headings are defined with <h1> to <h6> where <h1> is the highest important heading and <h6> is the least important sub-heading.
  • Paragrahs are defined in <p>..</p> tag.
  • Links are defined in <a> tag.

    Example:

    <a href="https://onecompiler.com/html">HTML online compiler</a>
  • Images are defined in <img> tag, where src attribute consists of image name.
  • Buttons are defined in <button>..</button> tag
  • Lists are defined in <ul> for unordered/bullet list and <ol> for ordered/number list, and the list items are defined in <li>.

HTML Elements and Attributes

  • HTML element is everything present from start tag to end tag.
  • The text present between start and end tag is called HTML element content.
  • Anything can be a tagname but it's preferred to put the meaningful title to the content present as tag name.
  • Do not forget the end tag.
  • Elements with no content are called empty elements.
  • Elements can have attributes which provides additional information about the element.
  • In the below example, href is an attribute and a is the tag name.

    Example:

    <a href="https://onecompiler.com/html">HTML online compiler</a>

CSS

CSS(cascading style sheets) describes how HTML elements will look on the web page like color, font-style, font-size, background color etc.

Example:

Below is a sample style sheet which displays heading in green and in Candara font with padding space of 25px.

body{
  padding: 25px;
}
.title {
	color: #228B22;
	font-family: Candara;
}

HTML Tables

  • HTML Tables are defined in <table> tag.
  • Table row should be defined in <tr> tag
  • Table header should be defined in <th> tag
  • Table data should be defined in <td> tag
  • Table caption should be defined in <caption> tag

HTML-Javascript

  • Javascript is used in HTML pages to make them more interactive.
  • <script> is the tag used to write scripts in HTML
  • You can either reference a external script or write script code in this tag.

Example

<script src="script.js"></script>