Skip to content

Instantly share code, notes, and snippets.

@BrentOzar

BrentOzar/fn_hadr_fabric_get_node_health_states.xml

Created March 16, 2018 19:00
Show Gist options
  • Save BrentOzar/aabf1f016e3b65b3dd080268b2e532d8 to your computer and use it in GitHub Desktop.
Save BrentOzar/aabf1f016e3b65b3dd080268b2e532d8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
fn_hadr_fabric_get_node_health_states.xml
<HealthEvent>
<HealthInformation>
<SourceId>System.FM</SourceId>
<Property>State</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>Fabric node is up.</Description>
<SequenceNumber>14</SequenceNumber>
<RemoveWhenExpired>false</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 12:06:16.546</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 12:06:24.436</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>System.FabricNode</SourceId>
<Property>Certificate_client</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>Certificate expiration: thumbprint = a3abbebd2c222662f335db8360f0fde7f0376cdf, expiration = 2020-03-13 07:58:01.000, remaining lifetime is 728:15:03:50.611, please refresh ahead of time to avoid catastrophic failure. Warning threshold Security/CertificateExpirySafetyMargin is configured at 30:0:00:00.000, if needed, you can adjust it to fit your refresh process.</Description>
<SequenceNumber>131656064503880590</SequenceNumber>
<RemoveWhenExpired>false</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 16:54:10.388</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 16:54:15.743</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>System.InfrastructureService</SourceId>
<Property>Azure:RoleInstanceStatus</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>ReadyRole</Description>
<SequenceNumber>131655892350858742</SequenceNumber>
<RemoveWhenExpired>false</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 12:07:15.085</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:56:11.112</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>System.InfrastructureService</SourceId>
<Property>Azure:RoleInstanceStatusLastUpdatedAt</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>2018-03-15T22:51:10.0000000Z</Description>
<SequenceNumber>131656279248377432</SequenceNumber>
<RemoveWhenExpired>false</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 22:52:04.837</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:56:11.112</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>RepairPolicyEngineService</SourceId>
<Property>RepairPolicyEngineService::LastErrorAt</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>0</Description>
<SequenceNumber>131655959220933260</SequenceNumber>
<RemoveWhenExpired>false</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 13:58:42.093</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:55:51.864</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>RepairPolicyEngineService</SourceId>
<Property>RepairPolicyEngineService::LastHealthyAt</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>2018-03-15 22:55:41.561</Description>
<SequenceNumber>131656281415775605</SequenceNumber>
<RemoveWhenExpired>false</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 22:55:41.577</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:55:51.864</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>RepairPolicyEngineService</SourceId>
<Property>RepairPolicyEngineService::RepairHistory</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description></Description>
<SequenceNumber>131655959220933259</SequenceNumber>
<RemoveWhenExpired>false</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 13:58:42.093</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:55:51.926</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>DB4.DB.4, fabric:/WatchdogsTenant, MachineLocalWatchdog.Code</SourceId>
<Property>.NetVersion</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>Required version of .Net Framework has been installed on the OS image</Description>
<SequenceNumber>131656276853364282</SequenceNumber>
<RemoveWhenExpired>true</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 22:48:05.336</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:48:28.608</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>DB4.DB.4, fabric:/WatchdogsTenant, MachineLocalWatchdog.Code</SourceId>
<Property>CertificateWatchdog</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>WARNING</State>
<Description>The following certificate(s) are nearing expiry: [Subject] CN=Microsoft Authenticode(tm) Root Authority, O=MSFT, C=US [Issuer] CN=Microsoft Authenticode(tm) Root Authority, O=MSFT, C=US [Serial Number] 01 [Not Before] 1/1/1995 8:00:01 AM [Not After] 12/31/1999 11:59:59 PM [Thumbprint] 7F88CD7223F3C813818C994614A89C99FA3B5247 , [Subject] OU=Copyright (c) 1997 Microsoft Corp., OU=Microsoft Time Stamping Service Root, OU=Microsoft Corporation, O=Microsoft Trust Network [Issuer] OU=Copyright (c) 1997 Microsoft Corp., OU=Microsoft Time Stamping Service Root, OU=Microsoft Corporation, O=Microsoft Trust Network [Serial Number] 01 [Not Before] 5/13/1997 4:12:59 PM [Not After] 12/30/1999 11:59:59 PM [Thumbprint] 245C97DF7514E7CF2DF8BE72AE957B9E04741E85 , [Subject] OU="NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.", OU=VeriSign Time Stamping Service Root, OU="VeriSign, Inc.", O=VeriSign Trust Network [Issuer] OU="NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.", OU=VeriSign Time Stamping Service Root, OU="VeriSign, Inc.", O=VeriSign Trust Network [Serial Number] 4A19D2388C82591CA55D735F155DDCA3 [Not Before] 5/12/1997 12:00:00 AM [Not After] 1/7/2004 11:59:59 PM [Thumbprint] 18F7C1FCC3090203FD5BAA2F861A754976C8DD25 , [Subject] OU=Class 3 Public Primary Certification Authority, O="VeriSign, Inc.", C=US [Issuer] OU=Class 3 Public Primary Certification Authority, O="VeriSign, Inc.", C=US [Serial Number] 00E49EFDF33AE80ECFA5113E19A4240232 [Not Before] 1/29/1996 12:00:00 AM [Not After] 1/7/2004 11:59:59 PM [Thumbprint] 4F65566336DB6598581D584A596C87934D5F2AB4 , [Subject] CN=Microsoft IT SSL SHA2, OU=Microsoft IT, O=Microsoft Corporation, L=Redmond, S=Washington, C=US [Issuer] CN=Baltimore CyberTrust Root, OU=CyberTrust, O=Baltimore, C=IE [Serial Number] 0727AA47 [Not Before] 5/7/2014 5:04:09 PM [Not After] 5/7/2018 5:03:30 PM [Thumbprint] 97EFF3028677894BDD4F9AC53F789BEE5DF4AD86 , [Subject] OU=www.verisign.com/CPS Incorp.by Ref. LIABILITY LTD.(c)97 VeriSign, OU=VeriSign International Server CA - Class 3, OU="VeriSign, Inc.", O=VeriSign Trust Network [Issuer] OU=Class 3 Public Primary Certification Authority, O="VeriSign, Inc.", C=US [Serial Number] 46FCEBBAB4D02F0F926098233F93078F [Not Before] 4/17/1997 12:00:00 AM [Not After] 10/24/2016 11:59:59 PM [Thumbprint] D559A586669B08F46A30A133F8A9ED3D038E2EA8 , [Subject] CN=Microsoft Windows Hardware Compatibility, OU=Microsoft Corporation, OU=Microsoft Windows Hardware Compatibility Intermediate CA, OU=Copyright (c) 1997 Microsoft Corp. [Issuer] CN=Microsoft Root Authority, OU=Microsoft Corporation, OU=Copyright (c) 1997 Microsoft Corp. [Serial Number] 198B11D13F9A8FFE69A0 [Not Before] 10/1/1997 7:00:00 AM [Not After] 12/31/2002 7:00:00 AM [Thumbprint] 109F1CAED645BB78B3EA2B94C0697C740733031C , [Subject] OU=Class 3 Public Primary Certification Authority, O="VeriSign, Inc.", C=US [Issuer] OU=Class 3 Public Primary Certification Authority, O="VeriSign, Inc.", C=US [Serial Number] 00E49EFDF33AE80ECFA5113E19A4240232 [Not Before] 1/29/1996 12:00:00 AM [Not After] 1/7/2004 11:59:59 PM [Thumbprint] 4F65566336DB6598581D584A596C87934D5F2AB4 , [Subject] CN=*.dsts.core.windows.net [Issuer] CN=Microsoft IT SSL SHA2, OU=Microsoft IT, O=Microsoft Corporation, L=Redmond, S=Washington, C=US [Serial Number] 5A0003A1A176F84C8598CC004B00010003A1A1 [Not Before] 6/17/2016 10:49:50 PM [Not After] 5/7/2018 5:03:30 PM [Thumbprint] 1A46B7FBF2EAA42D1F3C18A75E525272FFB9A337 , [Subject] CN=Microsoft Authenticode(tm) Root Authority, O=MSFT, C=US [Issuer] CN=Microsoft Authenticode(tm) Root Authority, O=MSFT, C=US [Serial Number] 01 [Not Before] 1/1/1995 8:00:01 AM [Not After] 12/31/1999 11:59:59 PM [Thumbprint] 7F88CD7223F3C813818C994614A89C99FA3B5247 , [Subject] OU=Copyright (c) [Truncated]</Description>
<SequenceNumber>131655961118250214</SequenceNumber>
<RemoveWhenExpired>true</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 14:01:51.825</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 14:02:19.377</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>DB4.DB.4, fabric:/WatchdogsTenant, MachineLocalWatchdog.Code</SourceId>
<Property>DiskWatchdog</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>The following detected physical drives match the sku specification: disk0(34.36GB) disk1(1649.27GB) disk2(5956.05GB) disk3(1911.26GB) disk4(1.61GB)</Description>
<SequenceNumber>131656276856960611</SequenceNumber>
<RemoveWhenExpired>true</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 22:48:05.696</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:48:28.670</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>DB4.DB.4, fabric:/WatchdogsTenant, MachineLocalWatchdog.Code</SourceId>
<Property>EventLogWatchdog</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>Event log watch dog is healthy</Description>
<SequenceNumber>131656276862114824</SequenceNumber>
<RemoveWhenExpired>true</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 22:48:06.211</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:48:28.670</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>DB4.DB.4, fabric:/WatchdogsTenant, MachineLocalWatchdog.Code</SourceId>
<Property>EventLogWatchdog.Error</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>Event log is clear</Description>
<SequenceNumber>131656276862114823</SequenceNumber>
<RemoveWhenExpired>true</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 22:48:06.211</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:48:28.670</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>DB4.DB.4, fabric:/WatchdogsTenant, MachineLocalWatchdog.Code</SourceId>
<Property>EventLogWatchdog.Information</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>Event log is clear</Description>
<SequenceNumber>131656276862114821</SequenceNumber>
<RemoveWhenExpired>true</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 22:48:06.211</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:48:28.670</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>DB4.DB.4, fabric:/WatchdogsTenant, MachineLocalWatchdog.Code</SourceId>
<Property>EventLogWatchdog.Warning</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>Event log is clear</Description>
<SequenceNumber>131656276862114822</SequenceNumber>
<RemoveWhenExpired>true</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 22:48:06.211</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:48:28.670</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>DB4.DB.4, fabric:/WatchdogsTenant, MachineLocalWatchdog.Code</SourceId>
<Property>FrozenVmWatchdog</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>Disk I/O check passed during periodical check.</Description>
<SequenceNumber>131656280997362431</SequenceNumber>
<RemoveWhenExpired>true</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 22:54:59.736</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:55:28.701</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>DB4.DB.4, fabric:/WatchdogsTenant, MachineLocalWatchdog.Code</SourceId>
<Property>InfrastructureConfigurationVersion</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>14.0.1001.559-WASDA3@49,e29d2901</Description>
<SequenceNumber>131656276862114825</SequenceNumber>
<RemoveWhenExpired>true</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 22:48:06.211</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:48:28.670</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>DB4.DB.4, fabric:/WatchdogsTenant, MachineLocalWatchdog.Code</SourceId>
<Property>NetworkConfigurationEcnCapability</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>Value = disabled</Description>
<SequenceNumber>131656276862583966</SequenceNumber>
<RemoveWhenExpired>true</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 22:48:06.258</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:48:28.670</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>DB4.DB.4, fabric:/WatchdogsTenant, MachineLocalWatchdog.Code</SourceId>
<Property>AcceleratedNetworking:Device</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>No device found</Description>
<SequenceNumber>131656276862896313</SequenceNumber>
<RemoveWhenExpired>true</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 22:48:06.289</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:48:28.670</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>DB4.DB.4, fabric:/WatchdogsTenant, MachineLocalWatchdog.Code</SourceId>
<Property>AcceleratedNetworking:Driver</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>Not installed</Description>
<SequenceNumber>131656276862583967</SequenceNumber>
<RemoveWhenExpired>true</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 22:48:06.258</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 22:48:28.670</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>System.FabricNode</SourceId>
<Property>Certificate_cluster</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>Certificate expiration: thumbprint = a3abbebd2c222662f335db8360f0fde7f0376cdf, expiration = 2020-03-13 07:58:01.000, remaining lifetime is 728:11:11:16.417, please refresh ahead of time to avoid catastrophic failure. Warning threshold Security/CertificateExpirySafetyMargin is configured at 30:0:00:00.000, if needed, you can adjust it to fit your refresh process.</Description>
<SequenceNumber>131656204045827977</SequenceNumber>
<RemoveWhenExpired>false</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 20:46:44.582</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 20:46:49.705</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
<HealthEvent>
<HealthInformation>
<SourceId>System.FabricNode</SourceId>
<Property>Certificate_server</Property>
<TimeToLiveSeconds>0</TimeToLiveSeconds>
<State>OK</State>
<Description>Certificate expiration: thumbprint = a3abbebd2c222662f335db8360f0fde7f0376cdf, expiration = 2020-03-13 07:58:01.000, remaining lifetime is 728:11:00:10.172, please refresh ahead of time to avoid catastrophic failure. Warning threshold Security/CertificateExpirySafetyMargin is configured at 30:0:00:00.000, if needed, you can adjust it to fit your refresh process.</Description>
<SequenceNumber>131656210708270648</SequenceNumber>
<RemoveWhenExpired>false</RemoveWhenExpired>
</HealthInformation>
<SourceUtcTime>03/15/2018 20:57:50.827</SourceUtcTime>
<LastModifiedUtcTime>03/15/2018 20:58:19.853</LastModifiedUtcTime>
<IsExpired>false</IsExpired>
</HealthEvent>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment