Advertisement
Guest User

Template picker for SQL Monitor

a guest
Feb 3rd, 2015
219
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. // ==UserScript==
  2. // @name         Template Selector for SQL Monitor
  3. // @namespace    
  4. // @version      1.0
  5. // @description  Chooses templates in SQL Monitor
  6. // @author       You
  7. // @match        http://monitor.red-gate.com/Analysis/Graphs
  8. // @grant        none
  9. // ==/UserScript==
  10.  
  11.  
  12.  
  13. //
  14. // Replace these names and templates with your own choices (also make sure to set the @match URL above to your local installation of SQL Monitor
  15. //
  16.  
  17. var analysisPageTemplates = [
  18.     { Name: "Machine and SQL Server CPU",
  19.       Template: {"selections":[{"dataStream":"[Cluster].[Machine].[Processors].[PercentProcessorTime]","path":[{"value":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,","text":"254914-ntclus.lon.intensive.int","isVisible":true,"isAllSelected":false,"isAsAboveSelected":false},{"value":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,","text":"(All)","isVisible":true,"isAllSelected":true,"isAsAboveSelected":false}],"id":0},{"dataStream":"[Cluster].[SqlServer].[Process].[PercentProcessorTime]","path":[{"value":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,","text":"(As above)","isVisible":true,"isAllSelected":false,"isAsAboveSelected":true},{"value":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,","text":"(All)","isVisible":true,"isAllSelected":true,"isAsAboveSelected":false}],"id":1}],"serializedTime":"1422946613000_1422989813000","lineSelection":{"selectionId":1,"cir":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,9:SqlServer,1,4:Name,s4:ins1,7:Process,0,"}}
  20.     },
  21.     { Name: "User connections",
  22.      Template: {"selections":[{"dataStream":"[Cluster].[SqlServer].[GeneralStatistics].[UserConnections]","path":[{"value":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,","text":"254914-ntclus.lon.intensive.int","isVisible":true,"isAllSelected":false,"isAsAboveSelected":false},{"value":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,","text":"(All)","isVisible":true,"isAllSelected":true,"isAsAboveSelected":false}],"id":0}],"serializedTime":"1422946661000_1422989861000","lineSelection":{"selectionId":0,"cir":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,9:SqlServer,1,4:Name,s4:ins1,17:GeneralStatistics,0,"}}
  23.     }
  24.    
  25.     ];
  26.  
  27. $(".toggle-compare").after("<select class='choose-template'><option val='-1'>(select template)</option></select>");
  28.  
  29. for (var i in analysisPageTemplates) {
  30.     $(".choose-template").append("<option value=" + i + ">"+analysisPageTemplates[i].Name+"</option>");
  31. }
  32.  
  33. $(".choose-template").change(function() {
  34.     var i = parseInt($(".choose-template").val());
  35.     if (!analysisPageTemplates[i]) return;
  36.     var template = analysisPageTemplates[i].Template;
  37.     window.sessionStorage.setItem("AnalysisGraphState", JSON.stringify(template));
  38.     location.reload();
  39. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement