C+1qCMVC5G3/J19nhUECgQ{ED9ED3A3-A611-42FC-99B2-6A33DCF896E6}SSRS Monitoring{2B3B1AD6-FA6C-4E4F-B819-2865237A4DFF}SSRS monitoirng Phase 1{ED9ED3A3-A611-42FC-99B2-6A33DCF896E6}132755570130000000132755580320000000S-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}TRUE132755570150000000132755580330000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE1FALSEFALSEFALSEFALSETRUE,Monitor Date/Timeinterval005TRUE{9BC13600-C1E2-4197-90FC-6C99FB182E8A}{2B3B1AD6-FA6C-4E4F-B819-2865237A4DFF}Read Line96227{A7FB4661-885C-4A36-9856-5FD0AB136A69}TRUE132755580330000000FALSE0FALSEFALSEFALSETRUE,Read LineE:\Non-Prod Servers\All SSRS Server List.txtAuto{3A2CB0CD-8A7D-4891-8CDF-45EE7F58C732}{2B3B1AD6-FA6C-4E4F-B819-2865237A4DFF}Invoke Runbook171227{9C1BF9B4-515A-4FD2-A753-87D235D8BA1F}TRUE132755570140000000132755580320000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0FALSEFALSEFALSETRUE,Trigger Policy{5FA286FE-0AA5-4840-B589-C40509BCF53D}Policies\Stefan\Forum\SSRS Monitoring\SSRS monitoirng Phase 2FALSETRUE{89CDE648-E013-44AC-BB43-42724D84C78B}{3A2CB0CD-8A7D-4891-8CDF-45EE7F58C732}{5ED4FA62-6325-4255-B848-CE9C61BB3D69}\`d.T.~Ed/{9BC13600-C1E2-4197-90FC-6C99FB182E8A}.LineText\`d.T.~Ed/ComputerName{3A2CB0CD-8A7D-4891-8CDF-45EE7F58C732}TRUE60<Conditions><Entry><UniqueID>{E86AD136-CE7A-4D29-822F-45B8FB205AEF}</UniqueID><EdKey>{3A2CB0CD-8A7D-4891-8CDF-45EE7F58C732}.EMailNeeded</EdKey><Operator>equals</Operator><Value>False</Value></Entry><Entry><UniqueID>{0AFC8925-AD64-4517-AB7F-F24CE05E8827}</UniqueID><EdKey>{3A2CB0CD-8A7D-4891-8CDF-45EE7F58C732}.Loop.NumberOfAttempts</EdKey><Operator>isgreaterthan</Operator><Value>3</Value></Entry></Conditions>{DA2A24BF-40B5-4D40-9089-6049F5517783}{2B3B1AD6-FA6C-4E4F-B819-2865237A4DFF}Send Failure Email396227{EAB9A2AF-FA87-4E2A-82EC-DC414B20E733}TRUETRUEFALSE132755580330000000FALSE1FALSEFALSEFALSEFALSETRUE,Send EmailASISCORAlert@corvel.comSSRS Service is down on server \`d.T.~Ed/{9BC13600-C1E2-4197-90FC-6C99FB182E8A}.LineText\`d.T.~Ed/The SSRS Service on the server \`d.T.~Ed/{9BC13600-C1E2-4197-90FC-6C99FB182E8A}.LineText\`d.T.~Ed/ is currently down and must be restarted.01mail.corvel.com25001\`d.T.~Ec/\`d.T.~De/zYiNpuMkQXet2ei6mHjh8v1MNNUyqFKKgRR3NucAySs\`d.T.~De/{501E8EDC-086B-4BDB-A086-5AC88D88D219}{DA2A24BF-40B5-4D40-9089-6049F5517783}0
Heath_Lemoine@corvel.com
{48FF49A5-D532-4227-911E-979E1820B6DD}{DA2A24BF-40B5-4D40-9089-6049F5517783}0
Tom_Bingeman@CORVEL.com
{2A0FC005-0FE4-4773-86C0-2B8810E27FB2}{2B3B1AD6-FA6C-4E4F-B819-2865237A4DFF}Link{7A65BD17-9532-4D07-A6DA-E0F89FA0203E}TRUE132755570140000000132755580320000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0Link{ED072843-4671-4B46-BA28-E48F37C35AAC}{9BC13600-C1E2-4197-90FC-6C99FB182E8A}000{1F19788F-FAF8-4AA0-8D9F-84DFC086D069}{2B3B1AD6-FA6C-4E4F-B819-2865237A4DFF}Link{7A65BD17-9532-4D07-A6DA-E0F89FA0203E}TRUE132755580320000000FALSE0Link{9BC13600-C1E2-4197-90FC-6C99FB182E8A}{3A2CB0CD-8A7D-4891-8CDF-45EE7F58C732}000{F9EA1815-5F77-4AAF-92F6-EF60C8EB24D0}{2B3B1AD6-FA6C-4E4F-B819-2865237A4DFF}EMailNeeded True{7A65BD17-9532-4D07-A6DA-E0F89FA0203E}TRUE132755580330000000FALSE0Link{3A2CB0CD-8A7D-4891-8CDF-45EE7F58C732}{DA2A24BF-40B5-4D40-9089-6049F5517783}001{6297CD75-F1B8-46ED-9C87-C5AC9CBA1FA9}{F9EA1815-5F77-4AAF-92F6-EF60C8EB24D0}triggerequals{3A2CB0CD-8A7D-4891-8CDF-45EE7F58C732}.EMailNeededTrue
{5FA286FE-0AA5-4840-B589-C40509BCF53D}SSRS monitoirng Phase 2{ED9ED3A3-A611-42FC-99B2-6A33DCF896E6}132755570130000000132755576920000000S-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}TRUE132755570140000000132755576920000000S-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}TRUE132755570140000000132755576920000000S-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}TRUE132755575160000000132755576920000000S-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}TRUE132755575160000000132755576920000000S-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}TRUE132755570150000000132755576920000000S-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{AA462E8F-E796-4063-BE94-B313AF6C0883}{5FA286FE-0AA5-4840-B589-C40509BCF53D}Link{7A65BD17-9532-4D07-A6DA-E0F89FA0203E}TRUE132755570150000000132755576920000000S-1-5-21-3602508369-3028243498-3628307438-500FALSE0Link{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}TRUE132755575160000000132755576920000000S-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