X7Jkdx0nsupch6hvOncqhQ{ED9ED3A3-A611-42FC-99B2-6A33DCF896E6}SSRS Monitoring{2B3B1AD6-FA6C-4E4F-B819-2865237A4DFF}SSRS monitoirng Phase 1{ED9ED3A3-A611-42FC-99B2-6A33DCF896E6}132755570130000000132756934630000000S-1-5-21-3602508369-3028243498-3628307438-500FALSEFALSEFALSE1TRUE{ED072843-4671-4B46-BA28-E48F37C35AAC}{2B3B1AD6-FA6C-4E4F-B819-2865237A4DFF}Monitor Date/Time21227{257A2C51-67E6-40C6-8F49-4059E9C3D45E}TRUE132755570150000000132756934630000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE1FALSEFALSEFALSEFALSETRUE,Monitor Date/Timeinterval0020TRUE{3A2CB0CD-8A7D-4891-8CDF-45EE7F58C732}{2B3B1AD6-FA6C-4E4F-B819-2865237A4DFF}Invoke Runbook246227{9C1BF9B4-515A-4FD2-A753-87D235D8BA1F}TRUE132755570140000000132756934630000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0FALSEFALSEFALSETRUE,Trigger Policy{153F6F2C-4CE8-49AD-8363-5FCDFA559C5D}Policies\Stefan\Forum\SSRS Monitoring\SSRS monitoirng Phase1bFALSEFALSE{0CC7912C-1BA3-4F44-837B-1FE796E57316}{3A2CB0CD-8A7D-4891-8CDF-45EE7F58C732}{68D53574-BE6F-428F-8BD9-F8FEB9932EC0}\`d.T.~Ed/{DA3E6594-DADD-44AA-8C58-2E285E129DC2}.line\`d.T.~Ed/linenumber{3A2CB0CD-8A7D-4891-8CDF-45EE7F58C732}FALSE{DA3E6594-DADD-44AA-8C58-2E285E129DC2}{2B3B1AD6-FA6C-4E4F-B819-2865237A4DFF}Measure File171227{ED7F2A41-107A-4B74-BAFE-ADAE63632B79}TRUE132756932590000000132756934630000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0FALSEFALSEFALSETRUE,Run .Net ScriptPowerShell$Concurrency = 25 $YOURFILE = "E:\Performance\Clear SCCM Cache\ServerList.txt" [int]$lines = (Get-Content $YOURFILE | Measure-Object -Line).Lines $blocks = [math]::Round($lines / $Concurrency) $firstline = @() $lastline = @() $i = 1 while(($i -lt $lines) ){ $firstline += $i $i = $i + $blocks if ( ($i - 1) -le $lines) { $lastline += ($i - 1) } else { $lastline += $lines } }<ExecutionData><Item><Description>C#</Description><Hint></Hint><ID>ScriptType</ID><Text>Script Language</Text><Type>String</Type></Item><Item><Description></Description><Hint></Hint><ID>line</ID><Text>line</Text><Type>Integer</Type></Item></ExecutionData><ItemRoot><Entry><IsCollection>false</IsCollection><Name>line</Name><Type>Integer</Type><Variable>line</Variable></Entry></ItemRoot>{2A0FC005-0FE4-4773-86C0-2B8810E27FB2}{2B3B1AD6-FA6C-4E4F-B819-2865237A4DFF}Link{7A65BD17-9532-4D07-A6DA-E0F89FA0203E}TRUE132755570140000000132756934630000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0Link{ED072843-4671-4B46-BA28-E48F37C35AAC}{DA3E6594-DADD-44AA-8C58-2E285E129DC2}000{9C5273B9-98FE-4B01-972D-4CA8EC447715}{2B3B1AD6-FA6C-4E4F-B819-2865237A4DFF}Link{7A65BD17-9532-4D07-A6DA-E0F89FA0203E}TRUE132756932590000000132756934630000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0Link{DA3E6594-DADD-44AA-8C58-2E285E129DC2}{3A2CB0CD-8A7D-4891-8CDF-45EE7F58C732}000{153F6F2C-4CE8-49AD-8363-5FCDFA559C5D}SSRS monitoirng Phase 1b{ED9ED3A3-A611-42FC-99B2-6A33DCF896E6}132756921500000000132756934750000000S-1-5-21-3602508369-3028243498-3628307438-500FALSEFALSEFALSEFALSEFALSEFALSEFALSE10TRUE{C9C12473-86F4-4101-A918-67F85D7072E4}{153F6F2C-4CE8-49AD-8363-5FCDFA559C5D}Initialize Data2177{6C576F3D-E927-417A-B145-5D3EFF9C995F}TRUE132756932060000000132756934760000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0FALSEFALSEFALSEFALSETRUE,Custom Start{68D53574-BE6F-428F-8BD9-F8FEB9932EC0}{C9C12473-86F4-4101-A918-67F85D7072E4}linenumberString{5C389397-D27A-4E62-A83D-57725C5CAED5}{153F6F2C-4CE8-49AD-8363-5FCDFA559C5D}Read Line9677{A7FB4661-885C-4A36-9856-5FD0AB136A69}TRUE132756932050000000132756934750000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0FALSEFALSEFALSETRUE,Read LineE:\Non-Prod Servers\All SSRS Server List.txtAuto\`d.T.~Ed/{C9C12473-86F4-4101-A918-67F85D7072E4}.{68D53574-BE6F-428F-8BD9-F8FEB9932EC0}\`d.T.~Ed/{F96E361C-F909-458F-B6AD-0499F8FB531B}{153F6F2C-4CE8-49AD-8363-5FCDFA559C5D}Invoke Runbook17177{9C1BF9B4-515A-4FD2-A753-87D235D8BA1F}TRUE132756932060000000132756934760000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0FALSEFALSEFALSETRUE,Trigger Policy{5FA286FE-0AA5-4840-B589-C40509BCF53D}Policies\Stefan\Forum\SSRS Monitoring\SSRS monitoirng Phase 2FALSETRUE{5C538020-EED4-492D-82F9-D607929F1691}{F96E361C-F909-458F-B6AD-0499F8FB531B}{5ED4FA62-6325-4255-B848-CE9C61BB3D69}\`d.T.~Ed/{5C389397-D27A-4E62-A83D-57725C5CAED5}.LineText\`d.T.~Ed/ComputerName{F96E361C-F909-458F-B6AD-0499F8FB531B}TRUE300<Conditions><Entry><UniqueID>{E86AD136-CE7A-4D29-822F-45B8FB205AEF}</UniqueID><EdKey>{F96E361C-F909-458F-B6AD-0499F8FB531B}.EMailNeeded</EdKey><Operator>equals</Operator><Value>False</Value></Entry><Entry><UniqueID>{0AFC8925-AD64-4517-AB7F-F24CE05E8827}</UniqueID><EdKey>{F96E361C-F909-458F-B6AD-0499F8FB531B}.Loop.NumberOfAttempts</EdKey><Operator>isgreaterthan</Operator><Value>3</Value></Entry></Conditions>{CD4616EA-3C81-41DB-A9AB-7024DA739B96}{153F6F2C-4CE8-49AD-8363-5FCDFA559C5D}Send Failure Email39677{EAB9A2AF-FA87-4E2A-82EC-DC414B20E733}TRUETRUEFALSE132756932060000000132756934760000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE1FALSEFALSEFALSEFALSETRUE,Send EmailASISCORAlert@corvel.comSSRS Service is down on server \`d.T.~Ed/{5C389397-D27A-4E62-A83D-57725C5CAED5}.LineText\`d.T.~Ed/The SSRS Service on the server \`d.T.~Ed/{5C389397-D27A-4E62-A83D-57725C5CAED5}.LineText\`d.T.~Ed/ is currently down and must be restarted.01mail.corvel.com25001\`d.T.~Ec/\`d.T.~De/JcR+YMVtJwwreM7K52LYwqnQwcDv6/9NV8RNNoTa1Q4\`d.T.~De/{975B4A14-7F15-440E-8B29-41C45FE9B88D}{CD4616EA-3C81-41DB-A9AB-7024DA739B96}0
Tom_Bingeman@CORVEL.com
{BFBA395A-0F55-42C7-8C52-CC796795FAF1}{CD4616EA-3C81-41DB-A9AB-7024DA739B96}0
Heath_Lemoine@corvel.com
{D9AFF77B-407A-4EAA-9C98-38390244C84A}{153F6F2C-4CE8-49AD-8363-5FCDFA559C5D}EMailNeeded True{7A65BD17-9532-4D07-A6DA-E0F89FA0203E}TRUE132756932060000000132756934760000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0Link{F96E361C-F909-458F-B6AD-0499F8FB531B}{CD4616EA-3C81-41DB-A9AB-7024DA739B96}001{84F95B91-4C7A-4B21-A78F-92639ED2FE27}{D9AFF77B-407A-4EAA-9C98-38390244C84A}triggerequals{F96E361C-F909-458F-B6AD-0499F8FB531B}.EMailNeededTrue{07F11163-370E-452D-A018-72CEF689F850}{153F6F2C-4CE8-49AD-8363-5FCDFA559C5D}Link{7A65BD17-9532-4D07-A6DA-E0F89FA0203E}TRUE132756932050000000132756934750000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0Link{5C389397-D27A-4E62-A83D-57725C5CAED5}{F96E361C-F909-458F-B6AD-0499F8FB531B}000{BE7291EB-F6DB-4D3B-82E7-E25DB49E0AA7}{153F6F2C-4CE8-49AD-8363-5FCDFA559C5D}Link{7A65BD17-9532-4D07-A6DA-E0F89FA0203E}TRUE132756932050000000132756934760000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0Link{C9C12473-86F4-4101-A918-67F85D7072E4}{5C389397-D27A-4E62-A83D-57725C5CAED5}000
{5FA286FE-0AA5-4840-B589-C40509BCF53D}SSRS monitoirng Phase 2{ED9ED3A3-A611-42FC-99B2-6A33DCF896E6}132755570130000000132756933700000000S-1-5-21-3602508369-3028243498-3628307438-500FALSEFALSEFALSEFALSEFALSEFALSEFALSE25TRUE<Data><Entry><Description></Description><Name>EMailNeeded</Name><Type>String</Type><Code>EMailNeeded</Code></Entry></Data>{475CE58D-5498-4190-B6E6-087CB04AE667}{5FA286FE-0AA5-4840-B589-C40509BCF53D}Initialize Data21152{6C576F3D-E927-417A-B145-5D3EFF9C995F}TRUE132755570140000000132756933700000000S-1-5-21-3602508369-3028243498-3628307438-500FALSEFALSEFALSEFALSEFALSETRUE,Custom Start{5ED4FA62-6325-4255-B848-CE9C61BB3D69}{475CE58D-5498-4190-B6E6-087CB04AE667}ComputerNameString{227B8509-460A-4253-9229-4129DCFD0815}{5FA286FE-0AA5-4840-B589-C40509BCF53D}Determine if the SSRS Service is down321152{ED7F2A41-107A-4B74-BAFE-ADAE63632B79}TRUE132755570140000000132756933700000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0FALSEFALSEFALSEFALSETRUE,Run .Net ScriptPowerShell$Service = Get-WmiObject Win32_Service -ComputerName \`d.T.~Ed/{475CE58D-5498-4190-B6E6-087CB04AE667}.{5ED4FA62-6325-4255-B848-CE9C61BB3D69}\`d.T.~Ed/ | Where-object {$_.name -eq “SQLServerReportingServices”} | select State -ExpandProperty State if ($Service -eq "Running"){ $EMailNeeded = "False" }Else{ $EMailNeeded = "True" }<ExecutionData><Item><Description></Description><Hint></Hint><ID>EMailNeeded</ID><Text>EMailNeeded</Text><Type>String</Type></Item><Item><Description>C#</Description><Hint></Hint><ID>ScriptType</ID><Text>Script Language</Text><Type>String</Type></Item></ExecutionData><ItemRoot><Entry><IsCollection>false</IsCollection><Name>EMailNeeded</Name><Type>String</Type><Variable>EMailNeeded</Variable></Entry></ItemRoot>{3D7FA378-741D-447E-9740-D2681F296E4A}{5FA286FE-0AA5-4840-B589-C40509BCF53D}EMailNeeded True54677{FA70125F-267E-4065-A4F6-D5493167D663}TRUE132755575160000000132756933700000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0FALSEFALSEFALSETRUE,Publish Policy Data{AB3D922D-F3A5-40A2-BD29-2702B01CABC6}{3D7FA378-741D-447E-9740-D2681F296E4A}EMailNeededTrue{B78FFB2A-A12C-49F5-B119-F0FC1F27C0D0}{5FA286FE-0AA5-4840-B589-C40509BCF53D}EMailNeeded false546227{FA70125F-267E-4065-A4F6-D5493167D663}TRUE132755575160000000132756933700000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0FALSEFALSEFALSETRUE,Publish Policy Data{D96D0EE7-398C-4705-943D-B8DFAF304A5E}{B78FFB2A-A12C-49F5-B119-F0FC1F27C0D0}EMailNeededFalse{4C120374-DA20-449A-BE3F-524F41C2DB9E}{5FA286FE-0AA5-4840-B589-C40509BCF53D}EMailNeeded True{7A65BD17-9532-4D07-A6DA-E0F89FA0203E}TRUE132755570150000000132756933700000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0Link{227B8509-460A-4253-9229-4129DCFD0815}{3D7FA378-741D-447E-9740-D2681F296E4A}001{14DD7979-62BB-4FF2-A828-32A41F0B5C99}{4C120374-DA20-449A-BE3F-524F41C2DB9E}triggerequals{227B8509-460A-4253-9229-4129DCFD0815}.EMailNeededTrue{8E3C6240-E7C4-40F5-BC0A-CB0BC9CBE293}{5FA286FE-0AA5-4840-B589-C40509BCF53D}Link{7A65BD17-9532-4D07-A6DA-E0F89FA0203E}TRUE132756933700000000FALSE0Link{475CE58D-5498-4190-B6E6-087CB04AE667}{227B8509-460A-4253-9229-4129DCFD0815}000{B3CF55AF-8672-4B25-B654-D7BE8D69DD1A}{5FA286FE-0AA5-4840-B589-C40509BCF53D}Return EMailNeeded False{7A65BD17-9532-4D07-A6DA-E0F89FA0203E}TRUE132755575160000000132756933700000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0Link{227B8509-460A-4253-9229-4129DCFD0815}{B78FFB2A-A12C-49F5-B119-F0FC1F27C0D0}001{54585D98-088D-4730-AF28-92FC929D4E8D}{B3CF55AF-8672-4B25-B654-D7BE8D69DD1A}triggerequals{227B8509-460A-4253-9229-4129DCFD0815}.EMailNeededFalse