Re: Multi "Customer" Application dashboard in Grafana
JohnD Blackburn <[email protected]> Wed, 12 Dec 2018 03:30:56 +0000
| Newsgroups | gmane.network.opennms.general |
|---|---|
| Message-ID | <AM6PR0602MB3381AAF6EB5E078D327A4222CBA70@AM6PR0602MB3381.eurprd06.prod.outlook.com> |
--===============1384202624446391541== Content-Language: en-US Content-Type: multipart/alternative; boundary="_000_AM6PR0602MB3381AAF6EB5E078D327A4222CBA70AM6PR0602MB3381_" --_000_AM6PR0602MB3381AAF6EB5E078D327A4222CBA70AM6PR0602MB3381_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Something else for my Multi-Customer Grafana dashboard... I have a datasource variable from which I can select the customers OpenNMS = server, and then about half a dozen other variables with customer specific = details. However, the customer specific variables are not being refreshed = automatically when I select a different datasource. Now, I'm using OpenNMS-Helm which installs Grafana 5.1.4, but comments on t= he grafana issues register suggest there is a fix in 5.3.2 (Issues #6492, #= 13600). Is there a timeframe for Grafana 5.3.2+ being rolled out with OpenNMS-helm?= Or is there a workaround I can use in Grafana 5.1.4 to get the variables = to refresh when I change the datasource? Regards, John From: Kottmann, J=F6rg [mailto:[email protected]] Sent: Tuesday, 11 December 2018 5:47 PM To: 'General OpenNMS Discussion' <[email protected]> Subject: Re: [opennms-discuss] Multi "Customer" Application dashboard in Gr= afana CAUTION: This email originated from outside of the organization. Do not cli= ck links or open attachments unless you recognize the sender and know the c= ontent is safe. Just a little different Syntax: nodeFilter(nodeLabel like '%git%' | nodeLab= el like '%ser%'). The Syntax is documented under https://wiki.opennms.org/wiki/Filters<https:= //emea01.safelinks.protection.outlook.com/?url=3Dhttps%3A%2F%2Fwiki.opennms= .org%2Fwiki%2FFilters&data=3D02%7C01%7Cjohnd.blackburn%40au.abb.com%7Cf3ca6= ce0ce87425ea13608d65f3d1d2b%7C372ee9e09ce04033a64ac07073a91ecd%7C0%7C0%7C63= 6801113452652016&sdata=3DKmSYURPwwKWKjijgXUbqmWhxtSC6hMs9rb0EhXsaRI8%3D&res= erved=3D0> Von: JohnD Blackburn <[email protected]<mailto:johnd.blackburn@au.= abb.com>> Gesendet: Dienstag, 11. Dezember 2018 07:56 An: General OpenNMS Discussion <[email protected]<mailt= o:[email protected]>> Betreff: Re: [opennms-discuss] Multi "Customer" Application dashboard in Gr= afana Thankyou Joerg, That is exactly what I needed. Now I've come across another issue with the same Dashboard. The naming convention for the services server changed, so we have 2 differe= nt naming standards for our services server. The original naming convention contained a product name, so %srv_git% would= match the original standard, however, the naming standard was changed to r= emove the product name and use the more generic "srv_ser" so "%srv_ser%" wo= uld be appropriate for the new naming standard. So how do I get the query = to find both server names? I've tried nodeFilter(nodeLabel like '%git|ser%'), nodeFilter(nodeLabel lik= e '%git%' or nodeLabel like '%ser%') and various other combinations, but no= thing I've tried works. Whats the trick to get the node filter to match multiple strings? From: Kottmann, J=F6rg [mailto:[email protected]] Sent: Monday, 10 December 2018 4:59 PM To: 'General OpenNMS Discussion' <[email protected]<mai= lto:[email protected]>> Subject: Re: [opennms-discuss] Multi "Customer" Application dashboard in Gr= afana CAUTION: This email originated from outside of the organization. Do not cli= ck links or open attachments unless you recognize the sender and know the c= ontent is safe. Hi John, you must create a Template Variable for the Dashboard (Dashboard Settings -= > Variables). Select Query on the Top and as Query Options your OpenNMS. As Query you mus= t add "nodeFilter(nodeLabel like 'batch%')". Regards, Joerg Von: JohnD Blackburn <[email protected]<mailto:johnd.blackburn@au.= abb.com>> Gesendet: Montag, 10. Dezember 2018 06:57 An: General OpenNMS Discussion <[email protected]<mailt= o:[email protected]>> Betreff: [opennms-discuss] Multi "Customer" Application dashboard in Grafan= a I'm trying to set up a dashboard in Grafana to display the statistics for o= ur application clusters in the context of a customer. Basically, the Dashboard needs a dropdown to select the customers OpenNMS s= erver as the datasource, and will display performance metrics for the batch= server, online servers (multiple, depending on customer size), services se= rver and database server. Each customer has the same set of servers with the only difference in serve= r names being a 3 character code representing the customer. I can create 1 dashboard per customer by exporting the JSON from the dashbo= ard of 1 customer, and updating the 3 character code for each of the server= s referenced in the dashboard, but I figured that Grafana should be smarter= than that and I should be able to get the dashboard to display the custome= r specific graphs dependant on the datasource specified. However, I can't figure out how to get Grafana to find the customer specifi= c server names. Each server type has a naming convention that is consistent across all cust= omers, for example, the batch servers would be "batch_cust1", "batch_cust2"= , etc, and the online servers would be "online1_cust1", "online2_cust1", "= online1_cust2", "online2_cust2" etc I can't find much info on how to variablise node names in Grafana for OpenN= MS data sources, so I was looking at the "OpenNMS JVM Metrics" dashboard wh= ich I downloaded from the Grafana site, I can see a variable used to find O= penNMS servers with a query field "nodeFilter(serviceName like 'OpenNMS-JVM= ')", so attempting to model that format, to get the customer batch server n= ame, I've created a variable and tried various query options like: "nodeFil= ter(nodeName like 'batch')", "nodeFilter(nodeName like 'batch%')", "nodeFil= ter(Label like 'batch')" However, without any documentation, I'm flying bl= ind and guessing what I need to configure to get this working. What do I n= eed to do to get this working? If there is a better forum to ask this question, please let me know. Regards, John --_000_AM6PR0602MB3381AAF6EB5E078D327A4222CBA70AM6PR0602MB3381_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr= osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:= //www.w3.org/TR/REC-html40"> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-= 1"> <meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)"> <style><!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:"Calibri Light"; panose-1:2 15 3 2 2 2 4 3 2 4;} @font-face {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} @font-face {font-family:"Segoe UI"; panose-1:2 11 5 2 4 2 4 2 2 3;} @font-face {font-family:ABBvoice; panose-1:2 13 6 3 2 5 3 2 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} h1 {mso-style-priority:99; mso-style-link:"Heading 1 Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US; font-weight:normal;} h2 {mso-style-priority:99; mso-style-link:"Heading 2 Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US; font-weight:normal;} h3 {mso-style-priority:99; mso-style-link:"Heading 3 Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US; font-weight:normal;} h4 {mso-style-priority:99; mso-style-link:"Heading 4 Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US; font-weight:normal;} h5 {mso-style-priority:99; mso-style-link:"Heading 5 Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US; font-weight:normal;} h6 {mso-style-priority:99; mso-style-link:"Heading 6 Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US; font-weight:normal;} p.MsoHeading7, li.MsoHeading7, div.MsoHeading7 {mso-style-priority:99; mso-style-link:"Heading 7 Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoHeading8, li.MsoHeading8, div.MsoHeading8 {mso-style-priority:99; mso-style-link:"Heading 8 Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoHeading9, li.MsoHeading9, div.MsoHeading9 {mso-style-priority:99; mso-style-link:"Heading 9 Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoIndex1, li.MsoIndex1, div.MsoIndex1 {mso-style-priority:99; margin:0cm; margin-bottom:.0001pt; text-align:right; line-height:14.8pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoIndex2, li.MsoIndex2, div.MsoIndex2 {mso-style-priority:99; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoIndex3, li.MsoIndex3, div.MsoIndex3 {mso-style-priority:99; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:30.0pt; margin-bottom:.0001pt; text-indent:-10.0pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoIndex4, li.MsoIndex4, div.MsoIndex4 {mso-style-priority:99; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:40.0pt; margin-bottom:.0001pt; text-indent:-10.0pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoIndex5, li.MsoIndex5, div.MsoIndex5 {mso-style-priority:99; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:50.0pt; margin-bottom:.0001pt; text-indent:-10.0pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoIndex6, li.MsoIndex6, div.MsoIndex6 {mso-style-priority:99; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:60.0pt; margin-bottom:.0001pt; text-indent:-10.0pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoIndex7, li.MsoIndex7, div.MsoIndex7 {mso-style-priority:99; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:70.0pt; margin-bottom:.0001pt; text-indent:-10.0pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoIndex8, li.MsoIndex8, div.MsoIndex8 {mso-style-priority:99; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:80.0pt; margin-bottom:.0001pt; text-indent:-10.0pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoIndex9, li.MsoIndex9, div.MsoIndex9 {mso-style-priority:99; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:90.0pt; margin-bottom:.0001pt; text-indent:-10.0pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoToc1, li.MsoToc1, div.MsoToc1 {mso-style-priority:39; margin-top:12.0pt; margin-right:0cm; margin-bottom:6.0pt; margin-left:0cm; mso-add-space:auto; text-indent:-1.0cm; line-height:16.0pt; mso-line-height-rule:exactly; font-size:12.0pt; font-family:"Arial",sans-serif; color:black; mso-fareast-language:EN-US; font-weight:bold;} p.MsoToc1CxSpFirst, li.MsoToc1CxSpFirst, div.MsoToc1CxSpFirst {mso-style-priority:39; mso-style-type:export-only; margin-top:12.0pt; margin-right:0cm; margin-bottom:0cm; margin-left:0cm; margin-bottom:.0001pt; mso-add-space:auto; text-indent:-1.0cm; line-height:16.0pt; mso-line-height-rule:exactly; font-size:12.0pt; font-family:"Arial",sans-serif; color:black; mso-fareast-language:EN-US; font-weight:bold;} p.MsoToc1CxSpMiddle, li.MsoToc1CxSpMiddle, div.MsoToc1CxSpMiddle {mso-style-priority:39; mso-style-type:export-only; margin:0cm; margin-bottom:.0001pt; mso-add-space:auto; text-indent:-1.0cm; line-height:16.0pt; mso-line-height-rule:exactly; font-size:12.0pt; font-family:"Arial",sans-serif; color:black; mso-fareast-language:EN-US; font-weight:bold;} p.MsoToc1CxSpLast, li.MsoToc1CxSpLast, div.MsoToc1CxSpLast {mso-style-priority:39; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:6.0pt; margin-left:0cm; mso-add-space:auto; text-indent:-1.0cm; line-height:16.0pt; mso-line-height-rule:exactly; font-size:12.0pt; font-family:"Arial",sans-serif; color:black; mso-fareast-language:EN-US; font-weight:bold;} p.MsoToc2, li.MsoToc2, div.MsoToc2 {mso-style-priority:39; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:1.0cm; margin-bottom:.0001pt; mso-add-space:auto; text-indent:-1.0cm; line-height:16.0pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.MsoToc2CxSpFirst, li.MsoToc2CxSpFirst, div.MsoToc2CxSpFirst {mso-style-priority:39; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:1.0cm; margin-bottom:.0001pt; mso-add-space:auto; text-indent:-1.0cm; line-height:16.0pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.MsoToc2CxSpMiddle, li.MsoToc2CxSpMiddle, div.MsoToc2CxSpMiddle {mso-style-priority:39; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:1.0cm; margin-bottom:.0001pt; mso-add-space:auto; text-indent:-1.0cm; line-height:16.0pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.MsoToc2CxSpLast, li.MsoToc2CxSpLast, div.MsoToc2CxSpLast {mso-style-priority:39; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:1.0cm; margin-bottom:.0001pt; mso-add-space:auto; text-indent:-1.0cm; line-height:16.0pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.MsoToc3, li.MsoToc3, div.MsoToc3 {mso-style-priority:39; margin-top:0cm; margin-right:0cm; margin-bottom:6.0pt; margin-left:68.05pt; mso-add-space:auto; text-indent:-39.7pt; line-height:14.8pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoToc3CxSpFirst, li.MsoToc3CxSpFirst, div.MsoToc3CxSpFirst {mso-style-priority:39; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:68.05pt; margin-bottom:.0001pt; mso-add-space:auto; text-indent:-39.7pt; line-height:14.8pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoToc3CxSpMiddle, li.MsoToc3CxSpMiddle, div.MsoToc3CxSpMiddle {mso-style-priority:39; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:68.05pt; margin-bottom:.0001pt; mso-add-space:auto; text-indent:-39.7pt; line-height:14.8pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoToc3CxSpLast, li.MsoToc3CxSpLast, div.MsoToc3CxSpLast {mso-style-priority:39; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:6.0pt; margin-left:68.05pt; mso-add-space:auto; text-indent:-39.7pt; line-height:14.8pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoToc4, li.MsoToc4, div.MsoToc4 {mso-style-priority:39; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoToc5, li.MsoToc5, div.MsoToc5 {mso-style-priority:39; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoToc6, li.MsoToc6, div.MsoToc6 {mso-style-priority:39; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoToc7, li.MsoToc7, div.MsoToc7 {mso-style-priority:39; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoToc8, li.MsoToc8, div.MsoToc8 {mso-style-priority:39; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoToc9, li.MsoToc9, div.MsoToc9 {mso-style-priority:39; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoHeader, li.MsoHeader, div.MsoHeader {mso-style-priority:99; mso-style-link:"Header Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoFooter, li.MsoFooter, div.MsoFooter {mso-style-priority:99; mso-style-link:"Footer Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoIndexHeading, li.MsoIndexHeading, div.MsoIndexHeading {mso-style-priority:99; margin-top:6.0pt; margin-right:0cm; margin-bottom:6.0pt; margin-left:0cm; line-height:14.8pt; mso-line-height-rule:exactly; font-size:13.0pt; font-family:"Arial",sans-serif; color:#00519D; mso-fareast-language:EN-US; font-weight:bold;} p.MsoTof, li.MsoTof, div.MsoTof {mso-style-priority:99; margin:0cm; margin-bottom:.0001pt; line-height:14.8pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoTitle, li.MsoTitle, div.MsoTitle {mso-style-priority:99; mso-style-link:"Title Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoSubtitle, li.MsoSubtitle, div.MsoSubtitle {mso-style-priority:99; mso-style-link:"Subtitle Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} a:link, span.MsoHyperlink {mso-style-priority:99; color:#0563C1; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:#954F72; text-decoration:underline;} em {mso-style-priority:17; font-weight:bold; font-style:normal;} p.MsoAcetate, li.MsoAcetate, div.MsoAcetate {mso-style-priority:99; mso-style-link:"Balloon Text Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.MsoPlaceholderText {mso-style-priority:30; color:gray;} p.MsoNoSpacing, li.MsoNoSpacing, div.MsoNoSpacing {mso-style-priority:99; margin:0cm; margin-bottom:.0001pt; font-size:10.0pt; font-family:"Times New Roman",serif;} p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph {mso-style-priority:99; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:42.55pt; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoQuote, li.MsoQuote, div.MsoQuote {mso-style-priority:99; mso-style-link:"Quote Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.MsoIntenseQuote, li.MsoIntenseQuote, div.MsoIntenseQuote {mso-style-priority:99; mso-style-link:"Intense Quote Char"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.MsoSubtleEmphasis {mso-style-priority:16; color:windowtext; font-style:italic;} span.MsoIntenseEmphasis {mso-style-priority:18; color:windowtext; font-weight:bold; font-style:italic;} span.MsoSubtleReference {mso-style-priority:99; font-variant:normal !important; color:windowtext; text-transform:uppercase; text-decoration:none none; vertical-align:baseline;} span.MsoIntenseReference {mso-style-priority:99; font-variant:normal !important; color:windowtext; text-transform:uppercase; letter-spacing:0pt; font-weight:bold; text-decoration:none none; vertical-align:baseline;} span.MsoBookTitle {mso-style-priority:99; letter-spacing:0pt; font-weight:bold; font-style:italic;} p.MsoTocHeading, li.MsoTocHeading, div.MsoTocHeading {mso-style-priority:39; margin-top:12.0pt; margin-right:0cm; margin-bottom:8.0pt; margin-left:0cm; mso-add-space:auto; line-height:20.0pt; mso-line-height-rule:exactly; page-break-after:avoid; font-size:16.0pt; font-family:"Arial",sans-serif; color:#009036; font-weight:bold;} p.MsoTocHeadingCxSpFirst, li.MsoTocHeadingCxSpFirst, div.MsoTocHeadingCxSpF= irst {mso-style-priority:39; mso-style-type:export-only; margin-top:12.0pt; margin-right:0cm; margin-bottom:0cm; margin-left:0cm; margin-bottom:.0001pt; mso-add-space:auto; line-height:20.0pt; mso-line-height-rule:exactly; page-break-after:avoid; font-size:16.0pt; font-family:"Arial",sans-serif; color:#009036; font-weight:bold;} p.MsoTocHeadingCxSpMiddle, li.MsoTocHeadingCxSpMiddle, div.MsoTocHeadingCxS= pMiddle {mso-style-priority:39; mso-style-type:export-only; margin:0cm; margin-bottom:.0001pt; mso-add-space:auto; line-height:20.0pt; mso-line-height-rule:exactly; page-break-after:avoid; font-size:16.0pt; font-family:"Arial",sans-serif; color:#009036; font-weight:bold;} p.MsoTocHeadingCxSpLast, li.MsoTocHeadingCxSpLast, div.MsoTocHeadingCxSpLas= t {mso-style-priority:39; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:8.0pt; margin-left:0cm; mso-add-space:auto; line-height:20.0pt; mso-line-height-rule:exactly; page-break-after:avoid; font-size:16.0pt; font-family:"Arial",sans-serif; color:#009036; font-weight:bold;} span.Heading1Char {mso-style-name:"Heading 1 Char"; mso-style-priority:9; mso-style-link:"Heading 1"; font-family:"Calibri Light",sans-serif; color:#2F5496; mso-fareast-language:EN-US;} span.Heading2Char {mso-style-name:"Heading 2 Char"; mso-style-priority:9; mso-style-link:"Heading 2"; font-family:"Calibri Light",sans-serif; color:#2F5496; mso-fareast-language:EN-US;} span.Heading3Char {mso-style-name:"Heading 3 Char"; mso-style-priority:9; mso-style-link:"Heading 3"; font-family:"Calibri Light",sans-serif; color:#1F3763; mso-fareast-language:EN-US;} span.Heading4Char {mso-style-name:"Heading 4 Char"; mso-style-priority:9; mso-style-link:"Heading 4"; font-family:"Calibri Light",sans-serif; color:#2F5496; mso-fareast-language:EN-US; font-style:italic;} span.Heading5Char {mso-style-name:"Heading 5 Char"; mso-style-priority:9; mso-style-link:"Heading 5"; font-family:"Calibri Light",sans-serif; color:#2F5496; mso-fareast-language:EN-US;} span.Heading6Char {mso-style-name:"Heading 6 Char"; mso-style-priority:9; mso-style-link:"Heading 6"; font-family:"Calibri Light",sans-serif; color:#1F3763; mso-fareast-language:EN-US;} p.msonormal0, li.msonormal0, div.msonormal0 {mso-style-name:msonormal; mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:0cm; font-size:12.0pt; font-family:"Times New Roman",serif;} span.Heading7Char {mso-style-name:"Heading 7 Char"; mso-style-priority:9; mso-style-link:"Heading 7"; font-family:"Calibri Light",sans-serif; color:#1F3763; mso-fareast-language:EN-US; font-style:italic;} span.Heading8Char {mso-style-name:"Heading 8 Char"; mso-style-priority:9; mso-style-link:"Heading 8"; font-family:"Calibri Light",sans-serif; color:#272727; mso-fareast-language:EN-US;} span.Heading9Char {mso-style-name:"Heading 9 Char"; mso-style-priority:9; mso-style-link:"Heading 9"; font-family:"Calibri Light",sans-serif; color:#272727; mso-fareast-language:EN-US; font-style:italic;} span.HeaderChar {mso-style-name:"Header Char"; mso-style-priority:99; mso-style-link:Header; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.FooterChar {mso-style-name:"Footer Char"; mso-style-priority:99; mso-style-link:Footer; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.TitleChar {mso-style-name:"Title Char"; mso-style-priority:10; mso-style-link:Title; font-family:"Calibri Light",sans-serif; letter-spacing:-.5pt; mso-fareast-language:EN-US;} span.SubtitleChar {mso-style-name:"Subtitle Char"; mso-style-priority:11; mso-style-link:Subtitle; font-family:"Calibri",sans-serif; color:#5A5A5A; letter-spacing:.75pt; mso-fareast-language:EN-US;} span.BalloonTextChar {mso-style-name:"Balloon Text Char"; mso-style-priority:99; mso-style-link:"Balloon Text"; font-family:"Segoe UI",sans-serif; mso-fareast-language:EN-US;} span.QuoteChar {mso-style-name:"Quote Char"; mso-style-priority:29; mso-style-link:Quote; font-family:"Calibri",sans-serif; color:#404040; mso-fareast-language:EN-US; font-style:italic;} span.IntenseQuoteChar {mso-style-name:"Intense Quote Char"; mso-style-priority:30; mso-style-link:"Intense Quote"; font-family:"Calibri",sans-serif; color:#4472C4; mso-fareast-language:EN-US; font-style:italic;} p.StandardText, li.StandardText, div.StandardText {mso-style-name:"Standard Text"; mso-style-priority:99; margin-top:0cm; margin-right:0cm; margin-bottom:5.7pt; margin-left:0cm; line-height:14.8pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.Aufzhlung1, li.Aufzhlung1, div.Aufzhlung1 {mso-style-name:"Aufz=E4hlung 1"; mso-style-priority:19; margin-top:0cm; margin-right:0cm; margin-bottom:5.7pt; margin-left:17.0pt; mso-add-space:auto; text-indent:-17.0pt; line-height:14.8pt; mso-line-height-rule:exactly; mso-list:l2 level1 lfo2; font-size:11.0pt; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.Aufzhlung1CxSpFirst, li.Aufzhlung1CxSpFirst, div.Aufzhlung1CxSpFirst {mso-style-name:"Aufz=E4hlung 1CxSpFirst"; mso-style-priority:19; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:17.0pt; margin-bottom:.0001pt; mso-add-space:auto; text-indent:-17.0pt; line-height:14.8pt; mso-line-height-rule:exactly; mso-list:l2 level1 lfo2; font-size:11.0pt; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.Aufzhlung1CxSpMiddle, li.Aufzhlung1CxSpMiddle, div.Aufzhlung1CxSpMiddle {mso-style-name:"Aufz=E4hlung 1CxSpMiddle"; mso-style-priority:19; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:17.0pt; margin-bottom:.0001pt; mso-add-space:auto; text-indent:-17.0pt; line-height:14.8pt; mso-line-height-rule:exactly; mso-list:l2 level1 lfo2; font-size:11.0pt; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.Aufzhlung1CxSpLast, li.Aufzhlung1CxSpLast, div.Aufzhlung1CxSpLast {mso-style-name:"Aufz=E4hlung 1CxSpLast"; mso-style-priority:19; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:5.7pt; margin-left:17.0pt; mso-add-space:auto; text-indent:-17.0pt; line-height:14.8pt; mso-line-height-rule:exactly; mso-list:l2 level1 lfo2; font-size:11.0pt; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.Aufzhlung2, li.Aufzhlung2, div.Aufzhlung2 {mso-style-name:"Aufz=E4hlung 2"; mso-style-priority:19; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:14.2pt; margin-bottom:.0001pt; text-indent:-14.2pt; line-height:14.8pt; mso-line-height-rule:exactly; mso-list:l1 level2 lfo4; font-size:11.0pt; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.Aufzhlung3, li.Aufzhlung3, div.Aufzhlung3 {mso-style-name:"Aufz=E4hlung 3"; mso-style-priority:19; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:25.5pt; margin-bottom:.0001pt; text-indent:-11.3pt; line-height:14.8pt; mso-line-height-rule:exactly; mso-list:l1 level3 lfo4; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.Aufzhlung4, li.Aufzhlung4, div.Aufzhlung4 {mso-style-name:"Aufz=E4hlung 4"; mso-style-priority:19; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:36.85pt; margin-bottom:.0001pt; text-indent:-11.35pt; line-height:14.8pt; mso-line-height-rule:exactly; mso-list:l1 level4 lfo4; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.Aufzhlung5, li.Aufzhlung5, div.Aufzhlung5 {mso-style-name:"Aufz=E4hlung 5"; mso-style-priority:19; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:48.2pt; margin-bottom:.0001pt; text-indent:-11.35pt; line-height:14.8pt; mso-line-height-rule:exactly; mso-list:l1 level5 lfo4; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.Aufzhlung6, li.Aufzhlung6, div.Aufzhlung6 {mso-style-name:"Aufz=E4hlung 6"; mso-style-priority:19; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:59.55pt; margin-bottom:.0001pt; text-indent:-11.35pt; line-height:14.8pt; mso-line-height-rule:exactly; mso-list:l1 level6 lfo4; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.Aufzhlung7, li.Aufzhlung7, div.Aufzhlung7 {mso-style-name:"Aufz=E4hlung 7"; mso-style-priority:19; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:11.35pt; margin-bottom:.0001pt; text-indent:-11.35pt; mso-list:l1 level7 lfo4; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.Aufzhlung8, li.Aufzhlung8, div.Aufzhlung8 {mso-style-name:"Aufz=E4hlung 8"; mso-style-priority:19; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:11.35pt; margin-bottom:.0001pt; text-indent:-11.35pt; mso-list:l1 level8 lfo4; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.Aufzhlung9, li.Aufzhlung9, div.Aufzhlung9 {mso-style-name:"Aufz=E4hlung 9"; mso-style-priority:19; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:11.35pt; margin-bottom:.0001pt; text-indent:-11.35pt; mso-list:l1 level9 lfo4; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.Version, li.Version, div.Version {mso-style-name:Version; mso-style-priority:1; margin:0cm; margin-bottom:.0001pt; font-size:6.0pt; font-family:"Calibri",sans-serif; color:#D9D9D9; mso-fareast-language:EN-US;} p.TitelHeadline, li.TitelHeadline, div.TitelHeadline {mso-style-name:"Titel Headline"; mso-style-priority:99; margin:0cm; margin-bottom:.0001pt; line-height:24.0pt; mso-line-height-rule:exactly; font-size:18.0pt; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.TitelSubline, li.TitelSubline, div.TitelSubline {mso-style-name:"Titel Subline"; mso-style-priority:99; margin-top:0cm; margin-right:22.7pt; margin-bottom:0cm; margin-left:-22.7pt; margin-bottom:.0001pt; line-height:23.0pt; mso-line-height-rule:exactly; font-size:16.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.TitelFuzeile, li.TitelFuzeile, div.TitelFuzeile {mso-style-name:"Titel Fu=DFzeile"; mso-style-priority:1; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.DokumentenHeadline, li.DokumentenHeadline, div.DokumentenHeadline {mso-style-name:"Dokumenten Headline"; mso-style-priority:99; margin:0cm; margin-bottom:.0001pt; line-height:12.0pt; mso-line-height-rule:exactly; font-size:9.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.Tabellenbeschreibung, li.Tabellenbeschreibung, div.Tabellenbeschreibung {mso-style-name:Tabellenbeschreibung; mso-style-priority:1; margin-top:0cm; margin-right:0cm; margin-bottom:5.7pt; margin-left:0cm; mso-add-space:auto; line-height:14.8pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.TabellenbeschreibungCxSpFirst, li.TabellenbeschreibungCxSpFirst, div.Tabe= llenbeschreibungCxSpFirst {mso-style-name:TabellenbeschreibungCxSpFirst; mso-style-priority:1; mso-style-type:export-only; margin:0cm; margin-bottom:.0001pt; mso-add-space:auto; line-height:14.8pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.TabellenbeschreibungCxSpMiddle, li.TabellenbeschreibungCxSpMiddle, div.Ta= bellenbeschreibungCxSpMiddle {mso-style-name:TabellenbeschreibungCxSpMiddle; mso-style-priority:1; mso-style-type:export-only; margin:0cm; margin-bottom:.0001pt; mso-add-space:auto; line-height:14.8pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.TabellenbeschreibungCxSpLast, li.TabellenbeschreibungCxSpLast, div.Tabell= enbeschreibungCxSpLast {mso-style-name:TabellenbeschreibungCxSpLast; mso-style-priority:1; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:5.7pt; margin-left:0cm; mso-add-space:auto; line-height:14.8pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.Hinweis, li.Hinweis, div.Hinweis {mso-style-name:Hinweis; mso-style-priority:1; margin-top:0cm; margin-right:30.9pt; margin-bottom:5.7pt; margin-left:11.05pt; line-height:14.8pt; mso-line-height-rule:exactly; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.Nummerierung1, li.Nummerierung1, div.Nummerierung1 {mso-style-name:"Nummerierung 1"; mso-style-priority:18; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:1.0cm; margin-bottom:.0001pt; text-indent:-1.0cm; line-height:14.8pt; mso-line-height-rule:exactly; mso-list:l0 level1 lfo6; font-size:11.0pt; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.Nummerierung2, li.Nummerierung2, div.Nummerierung2 {mso-style-name:"Nummerierung 2"; mso-style-priority:18; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:1.0cm; margin-bottom:.0001pt; text-indent:-1.0cm; line-height:14.8pt; mso-line-height-rule:exactly; mso-list:l0 level2 lfo6; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.Nummerierung3, li.Nummerierung3, div.Nummerierung3 {mso-style-name:"Nummerierung 3"; mso-style-priority:18; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:48.2pt; margin-bottom:.0001pt; text-indent:-19.85pt; line-height:14.8pt; mso-line-height-rule:exactly; mso-list:l0 level3 lfo6; font-size:11.0pt; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.Nummerierung4, li.Nummerierung4, div.Nummerierung4 {mso-style-name:"Nummerierung 4"; mso-style-priority:18; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:62.35pt; margin-bottom:.0001pt; text-indent:-14.15pt; line-height:14.8pt; mso-line-height-rule:exactly; mso-list:l0 level4 lfo6; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.Nummerierung5, li.Nummerierung5, div.Nummerierung5 {mso-style-name:"Nummerierung 5"; mso-style-priority:18; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:73.7pt; margin-bottom:.0001pt; text-indent:-11.35pt; line-height:14.8pt; mso-line-height-rule:exactly; mso-list:l0 level5 lfo6; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.berschriftnichtimInhaltsverzeichnis, li.berschriftnichtimInhaltsverzeichn= is, div.berschriftnichtimInhaltsverzeichnis {mso-style-name:"=DCberschrift nicht im Inhaltsverzeichnis"; mso-style-priority:99; margin-top:11.35pt; margin-right:0cm; margin-bottom:8.5pt; margin-left:0cm; line-height:20.0pt; mso-line-height-rule:exactly; font-size:16.0pt; font-family:"Calibri",sans-serif; color:#009036; mso-fareast-language:EN-US; font-weight:bold;} p.Kopfzeile, li.Kopfzeile, div.Kopfzeile {mso-style-name:Kopfzeile; mso-style-link:"Kopfzeile Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.KopfzeileZchn {mso-style-name:"Kopfzeile Zchn"; mso-style-priority:32; mso-style-link:Kopfzeile;} p.Fuzeile, li.Fuzeile, div.Fuzeile {mso-style-name:Fu=DFzeile; mso-style-link:"Fu=DFzeile Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.FuzeileZchn {mso-style-name:"Fu=DFzeile Zchn"; mso-style-priority:33; mso-style-link:Fu=DFzeile;} p.berschrift1, li.berschrift1, div.berschrift1 {mso-style-name:"=DCberschrift 1"; mso-style-link:"=DCberschrift 1 Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.berschrift1Zchn {mso-style-name:"=DCberschrift 1 Zchn"; mso-style-link:"=DCberschrift 1"; font-family:"Arial",sans-serif; color:#009036; mso-fareast-language:EN-US; font-weight:bold;} p.berschrift2, li.berschrift2, div.berschrift2 {mso-style-name:"=DCberschrift 2"; mso-style-link:"=DCberschrift 2 Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.berschrift2Zchn {mso-style-name:"=DCberschrift 2 Zchn"; mso-style-link:"=DCberschrift 2"; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.berschrift3, li.berschrift3, div.berschrift3 {mso-style-name:"=DCberschrift 3"; mso-style-link:"=DCberschrift 3 Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.berschrift3Zchn {mso-style-name:"=DCberschrift 3 Zchn"; mso-style-link:"=DCberschrift 3"; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.berschrift4, li.berschrift4, div.berschrift4 {mso-style-name:"=DCberschrift 4"; mso-style-link:"=DCberschrift 4 Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.berschrift4Zchn {mso-style-name:"=DCberschrift 4 Zchn"; mso-style-link:"=DCberschrift 4"; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.berschrift5, li.berschrift5, div.berschrift5 {mso-style-name:"=DCberschrift 5"; mso-style-link:"=DCberschrift 5 Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.berschrift5Zchn {mso-style-name:"=DCberschrift 5 Zchn"; mso-style-link:"=DCberschrift 5"; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} p.berschrift6, li.berschrift6, div.berschrift6 {mso-style-name:"=DCberschrift 6"; mso-style-link:"=DCberschrift 6 Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.berschrift6Zchn {mso-style-name:"=DCberschrift 6 Zchn"; mso-style-priority:9; mso-style-link:"=DCberschrift 6"; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.berschrift7, li.berschrift7, div.berschrift7 {mso-style-name:"=DCberschrift 7"; mso-style-link:"=DCberschrift 7 Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.berschrift7Zchn {mso-style-name:"=DCberschrift 7 Zchn"; mso-style-priority:9; mso-style-link:"=DCberschrift 7"; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.berschrift8, li.berschrift8, div.berschrift8 {mso-style-name:"=DCberschrift 8"; mso-style-link:"=DCberschrift 8 Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.berschrift8Zchn {mso-style-name:"=DCberschrift 8 Zchn"; mso-style-priority:9; mso-style-link:"=DCberschrift 8"; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.berschrift9, li.berschrift9, div.berschrift9 {mso-style-name:"=DCberschrift 9"; mso-style-link:"=DCberschrift 9 Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.berschrift9Zchn {mso-style-name:"=DCberschrift 9 Zchn"; mso-style-priority:9; mso-style-link:"=DCberschrift 9"; font-family:"Arial",sans-serif; mso-fareast-language:EN-US; font-weight:bold;} p.Titel, li.Titel, div.Titel {mso-style-name:Titel; mso-style-link:"Titel Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.TitelZchn {mso-style-name:"Titel Zchn"; mso-style-priority:4; mso-style-link:Titel; font-family:"Arial",sans-serif; font-weight:bold;} p.Untertitel, li.Untertitel, div.Untertitel {mso-style-name:Untertitel; mso-style-link:"Untertitel Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.UntertitelZchn {mso-style-name:"Untertitel Zchn"; mso-style-priority:5; mso-style-link:Untertitel; font-family:"Times New Roman",serif;} p.Zitat, li.Zitat, div.Zitat {mso-style-name:Zitat; mso-style-link:"Zitat Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.ZitatZchn {mso-style-name:"Zitat Zchn"; mso-style-priority:99; mso-style-link:Zitat; font-style:italic;} p.IntensivesZitat, li.IntensivesZitat, div.IntensivesZitat {mso-style-name:"Intensives Zitat"; mso-style-link:"Intensives Zitat Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.IntensivesZitatZchn {mso-style-name:"Intensives Zitat Zchn"; mso-style-priority:99; mso-style-link:"Intensives Zitat";} span.Hervorheben {mso-style-name:Hervorheben; mso-style-priority:1; font-weight:bold;} span.FarbigundFett {mso-style-name:"Farbig und Fett"; mso-style-priority:1; font-family:"Arial",sans-serif; color:#009036; font-weight:bold;} span.Farbig {mso-style-name:"Farbig\,Fett und Kursiv"; mso-style-priority:1; font-family:"Arial",sans-serif; color:#009036; font-weight:bold; font-style:italic;} span.Farbighervorheben {mso-style-name:"Farbig hervorheben"; mso-style-priority:1; color:#009036;} p.Sprechblasentext, li.Sprechblasentext, div.Sprechblasentext {mso-style-name:Sprechblasentext; mso-style-link:"Sprechblasentext Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} span.SprechblasentextZchn {mso-style-name:"Sprechblasentext Zchn"; mso-style-priority:99; mso-style-link:Sprechblasentext; font-family:"Tahoma",sans-serif;} span.EmailStyle131 {mso-style-type:personal; font-family:"Verdana",sans-serif; color:windowtext; font-weight:normal; font-style:normal; text-decoration:none none;} span.EmailStyle132 {mso-style-type:personal; font-family:"Arial",sans-serif; color:black;} span.EmailStyle133 {mso-style-type:personal; font-family:"Verdana",sans-serif; color:windowtext; font-weight:normal; font-style:normal; text-decoration:none none;} span.EmailStyle134 {mso-style-type:personal; font-family:"Arial",sans-serif; color:black;} span.EmailStyle139 {mso-style-type:personal-reply; font-family:"Verdana",sans-serif; color:windowtext; font-weight:normal; font-style:normal; text-decoration:none none;} .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;} @page WordSection1 {size:612.0pt 792.0pt; margin:72.0pt 72.0pt 72.0pt 72.0pt;} div.WordSection1 {page:WordSection1;} /* List Definitions */ @list l0 {mso-list-id:1229146780; mso-list-template-ids:157818954; mso-list-style-priority:99; mso-list-style-name:zzz_Nummerierung;} @list l0:level1 {mso-level-style-link:"Nummerierung 1"; mso-level-tab-stop:1.0cm; mso-level-number-position:left; margin-left:1.0cm; text-indent:-1.0cm;} @list l0:level2 {mso-level-style-link:"Nummerierung 2"; mso-level-text:"%1\.%2"; mso-level-tab-stop:1.0cm; mso-level-number-position:left; margin-left:1.0cm; text-indent:-1.0cm;} @list l0:level3 {mso-level-number-format:alpha-lower; mso-level-style-link:"Nummerierung 3"; mso-level-text:"%3\)"; mso-level-tab-stop:48.2pt; mso-level-number-position:left; margin-left:48.2pt; text-indent:-19.85pt;} @list l0:level4 {mso-level-number-format:bullet; mso-level-style-link:"Nummerierung 4"; mso-level-text:\2022; mso-level-tab-stop:62.35pt; mso-level-number-position:left; margin-left:62.35pt; text-indent:-14.15pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l0:level5 {mso-level-number-format:bullet; mso-level-style-link:"Nummerierung 5"; mso-level-text:\2022; mso-level-tab-stop:73.7pt; mso-level-number-position:left; margin-left:73.7pt; text-indent:-11.35pt; mso-ansi-font-size:6.0pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l0:level6 {mso-level-number-format:roman-lower; mso-level-text:"\(%6\)"; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:108.0pt; text-indent:-18.0pt;} @list l0:level7 {mso-level-tab-stop:none; mso-level-number-position:left; margin-left:126.0pt; text-indent:-18.0pt;} @list l0:level8 {mso-level-number-format:alpha-lower; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:144.0pt; text-indent:-18.0pt;} @list l0:level9 {mso-level-number-format:roman-lower; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:162.0pt; text-indent:-18.0pt;} @list l1 {mso-list-id:1333949477; mso-list-template-ids:1066941152; mso-list-style-id:1718771440;} @list l1:level1 {mso-level-number-format:alpha-lower; mso-level-text:"%1\)"; mso-level-tab-stop:17.0pt; mso-level-number-position:left; margin-left:17.0pt; text-indent:-17.0pt; color:windowtext;} @list l1:level2 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 2"; mso-level-text:\2022; mso-level-tab-stop:14.2pt; mso-level-number-position:left; margin-left:14.2pt; text-indent:-14.2pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l1:level3 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 3"; mso-level-text:\2022; mso-level-tab-stop:11.35pt; mso-level-number-position:left; margin-left:25.5pt; text-indent:-11.3pt; mso-ansi-font-size:9.0pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l1:level4 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 4"; mso-level-text:\2022; mso-level-tab-stop:11.35pt; mso-level-number-position:left; margin-left:36.85pt; text-indent:-11.35pt; mso-ansi-font-size:7.0pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l1:level5 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 5"; mso-level-text:\2012; mso-level-tab-stop:11.35pt; mso-level-number-position:left; margin-left:48.2pt; text-indent:-11.35pt; mso-ansi-font-size:8.0pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l1:level6 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 6"; mso-level-text:-; mso-level-tab-stop:11.35pt; mso-level-number-position:left; margin-left:59.55pt; text-indent:-11.35pt; mso-ansi-font-size:7.0pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l1:level7 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 7"; mso-level-text:\2022; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:11.35pt; text-indent:-11.35pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l1:level8 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 8"; mso-level-text:\2022; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:11.35pt; text-indent:-11.35pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l1:level9 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 9"; mso-level-text:\2022; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:11.35pt; text-indent:-11.35pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l2 {mso-list-id:1698264816; mso-list-template-ids:-1992540646;} @list l2:level1 {mso-level-number-format:alpha-lower; mso-level-style-link:"Aufz=E4hlung 1"; mso-level-text:"%1\)"; mso-level-tab-stop:17.0pt; mso-level-number-position:left; margin-left:17.0pt; text-indent:-17.0pt; color:windowtext;} @list l2:level2 {mso-level-number-format:bullet; mso-level-text:\2022; mso-level-tab-stop:14.2pt; mso-level-number-position:left; margin-left:14.2pt; text-indent:-14.2pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l2:level3 {mso-level-number-format:bullet; mso-level-text:\2022; mso-level-tab-stop:11.35pt; mso-level-number-position:left; margin-left:25.5pt; text-indent:-11.3pt; mso-ansi-font-size:9.0pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l2:level4 {mso-level-number-format:bullet; mso-level-text:\2022; mso-level-tab-stop:11.35pt; mso-level-number-position:left; margin-left:36.85pt; text-indent:-11.35pt; mso-ansi-font-size:7.0pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l2:level5 {mso-level-number-format:bullet; mso-level-text:\2012; mso-level-tab-stop:11.35pt; mso-level-number-position:left; margin-left:48.2pt; text-indent:-11.35pt; mso-ansi-font-size:8.0pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l2:level6 {mso-level-number-format:bullet; mso-level-text:-; mso-level-tab-stop:11.35pt; mso-level-number-position:left; margin-left:59.55pt; text-indent:-11.35pt; mso-ansi-font-size:7.0pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l2:level7 {mso-level-number-format:bullet; mso-level-text:\2022; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:11.35pt; text-indent:-11.35pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l2:level8 {mso-level-number-format:bullet; mso-level-text:\2022; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:11.35pt; text-indent:-11.35pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l2:level9 {mso-level-number-format:bullet; mso-level-text:\2022; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:11.35pt; text-indent:-11.35pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l3 {mso-list-id:1718771440; mso-list-template-ids:1066941152; mso-list-style-priority:99; mso-list-style-name:"gkvi Aufz=E4hlungszeichen";} @list l3:level1 {mso-level-number-format:alpha-lower; mso-level-text:"%1\)"; mso-level-tab-stop:17.0pt; mso-level-number-position:left; margin-left:17.0pt; text-indent:-17.0pt; color:windowtext;} @list l3:level2 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 2"; mso-level-text:\2022; mso-level-tab-stop:14.2pt; mso-level-number-position:left; margin-left:14.2pt; text-indent:-14.2pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l3:level3 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 3"; mso-level-text:\2022; mso-level-tab-stop:11.35pt; mso-level-number-position:left; margin-left:25.5pt; text-indent:-11.3pt; mso-ansi-font-size:9.0pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l3:level4 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 4"; mso-level-text:\2022; mso-level-tab-stop:11.35pt; mso-level-number-position:left; margin-left:36.85pt; text-indent:-11.35pt; mso-ansi-font-size:7.0pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l3:level5 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 5"; mso-level-text:\2012; mso-level-tab-stop:11.35pt; mso-level-number-position:left; margin-left:48.2pt; text-indent:-11.35pt; mso-ansi-font-size:8.0pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l3:level6 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 6"; mso-level-text:-; mso-level-tab-stop:11.35pt; mso-level-number-position:left; margin-left:59.55pt; text-indent:-11.35pt; mso-ansi-font-size:7.0pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l3:level7 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 7"; mso-level-text:\2022; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:11.35pt; text-indent:-11.35pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l3:level8 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 8"; mso-level-text:\2022; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:11.35pt; text-indent:-11.35pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l3:level9 {mso-level-number-format:bullet; mso-level-style-link:"Aufz=E4hlung 9"; mso-level-text:\2022; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:11.35pt; text-indent:-11.35pt; font-family:"Calibri",sans-serif; color:windowtext;} @list l4 {mso-list-id:1824856949; mso-list-template-ids:-307992080; mso-list-style-priority:99; mso-list-style-name:zzz_Liste_=DCberschriften;} @list l4:level1 {mso-level-style-link:"=DCberschrift 1"; mso-level-text:%1; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:0cm; text-indent:-39.7pt;} @list l4:level2 {mso-level-style-link:"=DCberschrift 2"; mso-level-text:"%1\.%2"; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:0cm; text-indent:-39.7pt;} @list l4:level3 {mso-level-style-link:"=DCberschrift 3"; mso-level-text:"%1\.%2\.%3"; mso-level-tab-stop:34.0pt; mso-level-number-position:left; margin-left:34.0pt; text-indent:-34.0pt;} @list l4:level4 {mso-level-style-link:"=DCberschrift 4"; mso-level-text:"%1\.%2\.%3\.%4"; mso-level-tab-stop:43.95pt; mso-level-number-position:left; margin-left:43.95pt; text-indent:-43.95pt;} @list l4:level5 {mso-level-style-link:"=DCberschrift 5"; mso-level-text:"%1\.%2\.%3\.%4\.%5"; mso-level-tab-stop:51.05pt; mso-level-number-position:left; margin-left:51.05pt; text-indent:-51.05pt;} @list l4:level6 {mso-level-style-link:"=DCberschrift 6"; mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6"; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:0cm; text-indent:0cm;} @list l4:level7 {mso-level-style-link:"=DCberschrift 7"; mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7"; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:0cm; text-indent:0cm;} @list l4:level8 {mso-level-style-link:"=DCberschrift 8"; mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8"; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:0cm; text-indent:0cm;} @list l4:level9 {mso-level-style-link:"=DCberschrift 9"; mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.%9"; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:0cm; text-indent:0cm;} ol {margin-bottom:0cm;} ul {margin-bottom:0cm;} --></style><!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--> </head> <body lang=3D"EN-AU" link=3D"#0563C1" vlink=3D"#954F72"> <div class=3D"WordSection1"> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">Something else for my Multi-Customer Grafana dashboard…<o:p></= o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"><o:p> </o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">I have a datasource variable from which I can select the customers O= penNMS server, and then about half a dozen other variables with customer sp= ecific details. However, the customer specific variables are not being refreshed automatically when I select a different = datasource.<o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"><o:p> </o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">Now, I’m using OpenNMS-Helm which installs Grafana 5.1.4, but = comments on the grafana issues register suggest there is a fix in 5.3.2 (Is= sues #6492, #13600).<o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"><o:p> </o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">Is there a timeframe for Grafana 5.3.2+ being rolled out with Op= enNMS-helm? Or is there a workaround I can use in Grafana 5.1.4 to ge= t the variables to refresh when I change the datasource?<o:p></o:p></span><= /p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"><o:p> </o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">Regards,<o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">John<o:p></o:p></span></p> <div> <p class=3D"MsoNormalCxSpMiddle" style=3D"mso-margin-bottom-alt:auto;mso-ad= d-space:auto"> <span style=3D"font-size:9.0pt;font-family:"ABBvoice",sans-serif;= mso-fareast-language:EN-AU"><o:p> </o:p></span></p> <p class=3D"MsoNormalCxSpMiddle" style=3D"mso-margin-bottom-alt:auto;mso-ad= d-space:auto"> <span style=3D"font-size:9.0pt;font-family:"ABBvoice",sans-serif;= mso-fareast-language:EN-AU"><o:p> </o:p></span></p> </div> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"><o:p> </o:p></span></p> <div> <div style=3D"border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm = 0cm 0cm"> <p class=3D"MsoNormal"><b><span lang=3D"EN-US" style=3D"mso-fareast-languag= e:EN-AU">From:</span></b><span lang=3D"EN-US" style=3D"mso-fareast-language= :EN-AU"> Kottmann, J=F6rg [mailto:[email protected]] <br> <b>Sent:</b> Tuesday, 11 December 2018 5:47 PM<br> <b>To:</b> 'General OpenNMS Discussion' <[email protected]= ge.net><br> <b>Subject:</b> Re: [opennms-discuss] Multi "Customer" Applicatio= n dashboard in Grafana<o:p></o:p></span></p> </div> </div> <p class=3D"MsoNormal"><o:p> </o:p></p> <div style=3D"border:solid #9C6500 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt"> <p class=3D"MsoNormal" style=3D"line-height:12.0pt;background:#FFEB9C"><b><= span lang=3D"DE" style=3D"font-size:10.0pt;color:#9C6500;mso-fareast-langua= ge:EN-AU">CAUTION:</span></b><span lang=3D"DE" style=3D"font-size:10.0pt;co= lor:black;mso-fareast-language:EN-AU"> This email originated from outside of the organization. Do not click links or o= pen attachments unless you recognize the sender and know the content is saf= e.<o:p></o:p></span></p> </div> <p class=3D"MsoNormal"><span lang=3D"DE" style=3D"mso-fareast-language:EN-A= U"><o:p> </o:p></span></p> <div> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-family:"Aria= l",sans-serif;color:black">Just a little different Syntax: nodeFilter(= nodeLabel like '%git%' | nodeLabel like '%ser%').</span><span lang=3D"DE"><= o:p></o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-family:"Aria= l",sans-serif;color:black">The Syntax is documented under <a href=3D"https://emea01.safelinks.protection.outlook.com/?url=3Dhttps%3A%= 2F%2Fwiki.opennms.org%2Fwiki%2FFilters&data=3D02%7C01%7Cjohnd.blackburn= %40au.abb.com%7Cf3ca6ce0ce87425ea13608d65f3d1d2b%7C372ee9e09ce04033a64ac070= 73a91ecd%7C0%7C0%7C636801113452652016&sdata=3DKmSYURPwwKWKjijgXUbqmWhxt= SC6hMs9rb0EhXsaRI8%3D&reserved=3D0"> https://wiki.opennms.org/wiki/Filters</a></span><span lang=3D"DE"><o:p></o:= p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-family:"Aria= l",sans-serif;color:black"> </span><span lang=3D"DE"><o:p></o:p><= /span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-family:"Aria= l",sans-serif;color:black"> </span><span lang=3D"DE"><o:p></o:p><= /span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US"> </span><span lang=3D"DE">= <o:p></o:p></span></p> <div> <div style=3D"border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm = 0cm 0cm"> <p class=3D"MsoNormal"><b><span lang=3D"DE" style=3D"mso-fareast-language:D= E">Von:</span></b><span lang=3D"DE" style=3D"mso-fareast-language:DE"> John= D Blackburn <<a href=3D"mailto:[email protected]">johnd.blackbu= [email protected]</a>> <br> <b>Gesendet:</b> Dienstag, 11. Dezember 2018 07:56<br> <b>An:</b> General OpenNMS Discussion <<a href=3D"mailto:opennms-discuss= @lists.sourceforge.net">[email protected]</a>><br> <b>Betreff:</b> Re: [opennms-discuss] Multi "Customer" Applicatio= n dashboard in Grafana</span><span lang=3D"DE"><o:p></o:p></span></p> </div> </div> <p class=3D"MsoNormal"><span lang=3D"DE"> <o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">Thankyou Joerg,</span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">That is exactly what I needed.</span><span lang=3D"DE"><o:p></o:p></= span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">Now I’ve come across another issue with the same Dashboard.</s= pan><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">The naming convention for the services server changed, so we have 2 = different naming standards for our services server.</span><span lang=3D"DE"= ><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">The original naming convention contained a product name, so %srv_git= % would match the original standard, however, the naming standard was chang= ed to remove the product name and use the more generic “srv_ser” so “%srv_ser%” would be appropri= ate for the new naming standard. So how do I get the query to find bo= th server names?</span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">I’ve tried nodeFilter(nodeLabel like ‘%git|ser%’),= nodeFilter(nodeLabel like ‘%git%’ or nodeLabel like ‘%se= r%’) and various other combinations, but nothing I’ve tried wor= ks.</span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">Whats the trick to get the node filter to match multiple strings?</s= pan><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <div> <p class=3D"MsoNormalCxSpMiddle" style=3D"mso-margin-bottom-alt:auto;mso-ad= d-space:auto"> <span style=3D"font-size:9.0pt;font-family:"ABBvoice",sans-serif;= mso-fareast-language:EN-AU"> </span><span lang=3D"DE"><o:p></o:p></spa= n></p> <p class=3D"MsoNormalCxSpMiddle" style=3D"mso-margin-bottom-alt:auto;mso-ad= d-space:auto"> <span style=3D"font-size:9.0pt;font-family:"ABBvoice",sans-serif;= mso-fareast-language:EN-AU"> </span><span lang=3D"DE"><o:p></o:p></spa= n></p> <p class=3D"MsoNormalCxSpMiddle" style=3D"margin-bottom:13.0pt;mso-add-spac= e:auto"><span style=3D"font-size:9.0pt;font-family:"ABBvoice",san= s-serif;mso-fareast-language:EN-AU"> </span><span lang=3D"DE"><o:p></o= :p></span></p> </div> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <div> <div style=3D"border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm = 0cm 0cm"> <p class=3D"MsoNormal"><b><span lang=3D"EN-US" style=3D"mso-fareast-languag= e:EN-AU">From:</span></b><span lang=3D"EN-US" style=3D"mso-fareast-language= :EN-AU"> Kottmann, J=F6rg [<a href=3D"mailto:[email protected]">mailto= :[email protected]</a>] <br> <b>Sent:</b> Monday, 10 December 2018 4:59 PM<br> <b>To:</b> 'General OpenNMS Discussion' <<a href=3D"mailto:opennms-discu= [email protected]">[email protected]</a>><br> <b>Subject:</b> Re: [opennms-discuss] Multi "Customer" Applicatio= n dashboard in Grafana</span><span lang=3D"DE"><o:p></o:p></span></p> </div> </div> <p class=3D"MsoNormal"> <span lang=3D"DE"><o:p></o:p></span></p> <div style=3D"border:solid #9C6500 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt"> <p class=3D"MsoNormal" style=3D"line-height:12.0pt;background:#FFEB9C"><b><= span lang=3D"DE" style=3D"font-size:10.0pt;color:#9C6500;mso-fareast-langua= ge:EN-AU">CAUTION:</span></b><span lang=3D"DE" style=3D"font-size:10.0pt;co= lor:black;mso-fareast-language:EN-AU"> This email originated from outside of the organization. Do not click links or o= pen attachments unless you recognize the sender and know the content is saf= e.</span><span lang=3D"DE"><o:p></o:p></span></p> </div> <p class=3D"MsoNormal"><span lang=3D"DE" style=3D"mso-fareast-language:EN-A= U"> </span><span lang=3D"DE"><o:p></o:p></span></p> <div> <p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-family:"Arial&q= uot;,sans-serif;color:black">Hi John,</span><span lang=3D"DE"><o:p></o:p></= span></p> <p class=3D"MsoNormal"><span lang=3D"DE" style=3D"font-family:"Arial&q= uot;,sans-serif;color:black"> </span><span lang=3D"DE"><o:p></o:p></sp= an></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-family:"Aria= l",sans-serif;color:black">you must create a Template Variable for the= Dashboard (Dashboard Settings -> Variables).</span><span lang=3D"DE"><o= :p></o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-family:"Aria= l",sans-serif;color:black">Select Query on the Top and as Query Option= s your OpenNMS. As Query you must</span><span lang=3D"DE"><o:p></o:p></span= ></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-family:"Aria= l",sans-serif;color:black">add “nodeFilter(nodeLabel like 'batch= %')”.</span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-family:"Aria= l",sans-serif;color:black"> </span><span lang=3D"DE"><o:p></o:p><= /span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-family:"Aria= l",sans-serif;color:black">Regards,</span><span lang=3D"DE"><o:p></o:p= ></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-family:"Aria= l",sans-serif;color:black">Joerg</span><span lang=3D"DE"><o:p></o:p></= span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US"> </span><span lang=3D"DE">= <o:p></o:p></span></p> <div> <div style=3D"border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm = 0cm 0cm"> <p class=3D"MsoNormal"><b><span lang=3D"DE" style=3D"mso-fareast-language:D= E">Von:</span></b><span lang=3D"DE" style=3D"mso-fareast-language:DE"> John= D Blackburn <<a href=3D"mailto:[email protected]">johnd.blackbu= [email protected]</a>> <br> <b>Gesendet:</b> Montag, 10. Dezember 2018 06:57<br> <b>An:</b> General OpenNMS Discussion <<a href=3D"mailto:opennms-discuss= @lists.sourceforge.net">[email protected]</a>><br> <b>Betreff:</b> [opennms-discuss] Multi "Customer" Application da= shboard in Grafana</span><span lang=3D"DE"><o:p></o:p></span></p> </div> </div> <p class=3D"MsoNormal"><span lang=3D"DE"> <o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">I’m trying to set up a dashboard in Grafana to display the sta= tistics for our application clusters in the context of a customer.</span><s= pan lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">Basically, the Dashboard needs a dropdown to select the customers Op= enNMS server as the datasource, and will display performance metrics for th= e batch server, online servers (multiple, depending on customer size), services server and database server.</span><span lang= =3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">Each customer has the same set of servers with the only difference i= n server names being a 3 character code representing the customer.</span><s= pan lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">I can create 1 dashboard per customer by exporting the JSON from the= dashboard of 1 customer, and updating the 3 character code for each of the= servers referenced in the dashboard, but I figured that Grafana should be smarter than that and I should be able to get the d= ashboard to display the customer specific graphs dependant on the datasourc= e specified.</span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">However, I can’t figure out how to get Grafana to find the cus= tomer specific server names.</span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">Each server type has a naming convention that is consistent across a= ll customers, for example, the batch servers would be “batch_cust1= 221;, “batch_cust2”, etc, and the online servers would be “online1_cust1”, “online2_cust1”, “online1_c= ust2”, “online2_cust2” etc</span><span lang=3D"DE"><o:p><= /o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">I can’t find much info on how to variablise node names in Graf= ana for OpenNMS data sources, so I was looking at the “OpenNMS JVM Me= trics” dashboard which I downloaded from the Grafana site, I can see a variable used to find OpenNMS servers with a query field ̶= 0;nodeFilter(serviceName like ‘OpenNMS-JVM’)”, so attempt= ing to model that format, to get the customer batch server name, I’ve= created a variable and tried various query options like: “nodeFilter= (nodeName like ‘batch’)”, “nodeFilter(nodeName like ‘b= atch%’)”, “nodeFilter(Label like ‘batch’)R= 21; However, without any documentation, I’m flying blind and gu= essing what I need to configure to get this working. What do I need t= o do to get this working?</span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">If there is a better forum to ask this question, please let me know.= </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif"> </span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">Regards,</span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-family:"Verdana",sans-= serif">John</span><span lang=3D"DE"><o:p></o:p></span></p> <p class=3D"MsoNormalCxSpMiddle" style=3D"mso-margin-bottom-alt:auto;mso-ad= d-space:auto"> <span style=3D"font-size:9.0pt;font-family:"ABBvoice",sans-serif;= mso-fareast-language:EN-AU"> </span><span lang=3D"DE"><o:p></o:p></spa= n></p> <p class=3D"MsoNormalCxSpMiddle" style=3D"mso-margin-bottom-alt:auto;mso-ad= d-space:auto"> <span style=3D"font-size:9.0pt;font-family:"ABBvoice",sans-serif;= mso-fareast-language:EN-AU"> </span><span lang=3D"DE"><o:p></o:p></spa= n></p> <p class=3D"MsoNormalCxSpMiddle" style=3D"margin-bottom:13.0pt;mso-add-spac= e:auto"><span style=3D"font-size:9.0pt;font-family:"ABBvoice",san= s-serif;mso-fareast-language:EN-AU"> </span><span lang=3D"DE"><o:p></o= :p></span></p> <p class=3D"MsoNormal"> <span lang=3D"DE"><o:p></o:p></span></p> </div> </div> </div> </body> </html> --_000_AM6PR0602MB3381AAF6EB5E078D327A4222CBA70AM6PR0602MB3381_-- --===============1384202624446391541== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline --===============1384202624446391541== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Please read the OpenNMS Mailing List FAQ: http://www.opennms.org/index.php/Mailing_List_FAQ opennms-discuss mailing list To *unsubscribe* or change your subscription options, see the bottom of this page: https://lists.sourceforge.net/lists/listinfo/opennms-discuss --===============1384202624446391541==--