|--Sort(ORDER BY:([Extent1].[ART_Asset_ID] ASC, [Extent2].[IDB_Ports_ID] ASC, [Expr1189] ASC, [Union1133] ASC, [Union1134] ASC, [Union1135] ASC, [Union1136] ASC, [Union1137] ASC, [Union1138] ASC, [Union1139] ASC, [Union1140] ASC, [Union1141] ASC, [Union1132] ASC))
       |--Compute Scalar(DEFINE:([Expr1189]=CASE WHEN [Union1133] IS NULL THEN NULL ELSE (1) END))
            |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1005]))
                 |--Top(TOP EXPRESSION:((2)))
                 |    |--Compute Scalar(DEFINE:([Expr1004]=CASE WHEN [HarNet].[dbo].[IDB_Ports].[IDB_Ports_ID] as [Extent2].[IDB_Ports_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_Ports].[IDB_Ports_ID] as [Extent2].[IDB_Ports_ID],0) END))
                 |         |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1005]))
                 |              |--Compute Scalar(DEFINE:([Expr1005]=CONVERT(int,[HarNet].[dbo].[ART_Asset].[ART_Asset_ID] as [Extent1].[ART_Asset_ID],0)))
                 |              |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Extent1].[ART_Asset_ID]))
                 |              |         |--Index Seek(OBJECT:([HarNet].[dbo].[ART_Asset].[IDX_ART_Asset_Host] AS [Extent1]), SEEK:([Extent1].[Host]='SDNI-U00-IR-01') ORDERED FORWARD)
                 |              |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[ART_Asset].[PK_ART_Assets] AS [Extent1]), SEEK:([Extent1].[ART_Asset_ID]=[HarNet].[dbo].[ART_Asset].[ART_Asset_ID] as [Extent1].[ART_Asset_ID]) LOOKUP ORDERED FORWARD)
                 |              |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_Ports].[PK_IDB_Ports] AS [Extent2]), WHERE:([Expr1005]=CONVERT(int,[HarNet].[dbo].[IDB_Ports].[ART_Asset_ID] as [Extent2].[ART_Asset_ID],0)))
                 |--Concatenation
                      |--Compute Scalar(DEFINE:([Expr1038]=CASE WHEN [Expr1028] IS NULL THEN NULL ELSE (1) END, [Expr1039]=(1), [Expr1045]=(1), [Expr1048]=(1), [Expr1053]=CASE WHEN [Expr1028] IS NULL THEN NULL ELSE (1) END, [Expr1054]=CASE WHEN [Expr1028] IS NULL THEN NULL ELSE CONVERT(int,[Expr1028],0) END, [Expr1055]=CASE WHEN [Expr1028] IS NULL THEN NULL ELSE CONVERT(int,[Expr1036],0) END, [Expr1056]=NULL, [Expr1057]=NULL, [Expr1058]=NULL, [Expr1059]=NULL, [Expr1060]=NULL, [Expr1061]=NULL, [Expr1062]=NULL))
                      |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1250]))
                      |         |--Compute Scalar(DEFINE:([Expr1052]=CASE WHEN [HarNet].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent11].[NSD_InterfaceTypeID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent11].[NSD_InterfaceTypeID],0) END))
                      |         |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1044]))
                      |         |         |--Compute Scalar(DEFINE:([Expr1051]=CASE WHEN [HarNet].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent10].[NSD_InterfaceCodeID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent10].[NSD_InterfaceCodeID],0) END))
                      |         |         |    |--Compute Scalar(DEFINE:([Expr1046]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent6].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent6].[IDB_InterfaceLayer2_ID],0) END))
                      |         |         |         |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1250], [Expr1555]) OPTIMIZED WITH UNORDERED PREFETCH)
                      |         |         |              |--Hash Match(Right Outer Join, HASH:([Expr1253])=([Expr1042]), RESIDUAL:([Expr1042]=[Expr1253]))
                      |         |         |              |    |--Compute Scalar(DEFINE:([Expr1253]=CONVERT(int,[HarNet].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent10].[NSD_InterfaceCodeID],0)))
                      |         |         |              |    |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[NSD_InterfaceCode].[PK_NSD_InterfaceCode] AS [Extent10]))
                      |         |         |              |    |--Compute Scalar(DEFINE:([Expr1050]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent9].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_Interface_ID] as [Extent9].[IDB_Interface_ID],0) END))
                      |         |         |              |         |--Hash Match(Right Outer Join, HASH:([Expr1255])=([Expr1254]), RESIDUAL:([Expr1254]=[Expr1255]))
                      |         |         |              |              |--Compute Scalar(DEFINE:([Expr1255]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent9].[IDB_InterfaceLayer3_ID],0)))
                      |         |         |              |              |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent9]))
                      |         |         |              |              |--Compute Scalar(DEFINE:([Expr1049]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent8].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent8].[IDB_InterfaceLayer3_ID],0) END))
                      |         |         |              |                   |--Merge Join(Left Outer Join, MANY-TO-MANY MERGE:([Expr1254])=([Expr1256]), RESIDUAL:([Expr1254]=[Expr1256]))
                      |         |         |              |                        |--Compute Scalar(DEFINE:([Expr1047]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent7].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_Interface_ID] as [Extent7].[IDB_Interface_ID],0) END))
                      |         |         |              |                        |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1250], [Expr1554]) WITH ORDERED PREFETCH)
                      |         |         |              |                        |         |--Sort(ORDER BY:([Expr1254] ASC))
                      |         |         |              |                        |         |    |--Compute Scalar(DEFINE:([Expr1254]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent5].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent5].[IDB_InterfaceLayer3_ID],0) END))
                      |         |         |              |                        |         |         |--Hash Match(Right Outer Join, HASH:([Expr1259])=([Expr1040]), RESIDUAL:([Expr1040]=[Expr1259]))
                      |         |         |              |                        |         |              |--Compute Scalar(DEFINE:([Expr1259]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_Interface_ID] as [Extent5].[IDB_Interface_ID],0)))
                      |         |         |              |                        |         |              |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent5]))
                      |         |         |              |                        |         |              |--Compute Scalar(DEFINE:([Expr1250]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent4].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent4].[IDB_InterfaceLayer2_ID],0) END))
                      |         |         |              |                        |         |                   |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1040], [Expr1553]) OPTIMIZED WITH UNORDERED PREFETCH)
                      |         |         |              |                        |         |                        |--Compute Scalar(DEFINE:([Expr1040]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[IDB_Interface_ID] as [Extent3].[IDB_Interface_ID],0), [Expr1041]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[ART_Asset_ID] as [Extent3].[ART_Asset_ID],0), [Expr1042]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[NSD_InterfaceCodeID] as [Extent3].[NSD_InterfaceCodeID],0), [Expr1043]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[ART_Component_ID] as [Extent3].[ART_Component_ID],0), [Expr1044]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[NSD_InterfaceTypeID] as [Extent3].[NSD_InterfaceTypeID],0)))
                      |         |         |              |                        |         |                        |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Extent3].[IDB_Interface_ID], [Expr1552]) OPTIMIZED WITH UNORDERED PREFETCH)
                      |         |         |              |                        |         |                        |         |--Index Seek(OBJECT:([HarNet].[dbo].[IDB_Interface].[IX_idb_interface_art_asset] AS [Extent3]), SEEK:([Extent3].[ART_Asset_ID]=[Expr1005]),  WHERE:([Expr1005]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[ART_Asset_ID] as [Extent3].[ART_Asset_ID],0)) ORDERED FORWARD)
                      |         |         |              |                        |         |                        |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_Interface].[PK_IDB_Interface] AS [Extent3]), SEEK:([Extent3].[IDB_Interface_ID]=[HarNet].[dbo].[IDB_Interface].[IDB_Interface_ID] as [Extent3].[IDB_Interface_ID]) LOOKUP ORDERED FORWARD)
                      |         |         |              |                        |         |                        |--Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer2].[IX_idb_interfacelayer2_idb_interface] AS [Extent4]), SEEK:([Extent4].[IDB_Interface_ID]=[Expr1040]),  WHERE:([Expr1040]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_Interface_ID] as [Extent4].[IDB_Interface_ID],0)) ORDERED FORWARD)
                      |         |         |              |                        |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer2].[PK_IDB_InterfaceLayer2] AS [Extent7]), SEEK:([Extent7].[IDB_InterfaceLayer2_ID]=[Expr1250]),  WHERE:([Expr1250]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent7].[IDB_InterfaceLayer2_ID],0)) ORDERED FORWARD)
                      |         |         |              |                        |--Sort(ORDER BY:([Expr1256] ASC))
                      |         |         |              |                             |--Compute Scalar(DEFINE:([Expr1256]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent8].[IDB_InterfaceLayer3_ID],0)))
                      |         |         |              |                                  |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent8]))
                      |         |         |              |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer2].[PK_IDB_InterfaceLayer2] AS [Extent6]), SEEK:([Extent6].[IDB_InterfaceLayer2_ID]=[Expr1250]),  WHERE:([Expr1250]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent6].[IDB_InterfaceLayer2_ID],0)) ORDERED FORWARD)
                      |         |         |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[NSD_InterfaceType].[PK_NSD_InterfaceType] AS [Extent11]), WHERE:([Expr1044]=CONVERT(int,[HarNet].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent11].[NSD_InterfaceTypeID],0)))
                      |         |--Nested Loops(Inner Join)
                      |              |--Compute Scalar(DEFINE:([Expr1028]=[HarNet].[dbo].[IDB_LANinterface].[IDB_LANinterface_ID] as [Extent12].[IDB_LANinterface_ID], [Expr1029]=[HarNet].[dbo].[IDB_LANinterface].[Speed] as [Extent12].[Speed], [Expr1030]=[HarNet].[dbo].[IDB_LANinterface].[Duplex] as [Extent12].[Duplex], [Expr1031]=[HarNet].[dbo].[IDB_LANinterface].[VLAN] as [Extent12].[VLAN], [Expr1032]=[HarNet].[dbo].[IDB_LANinterface].[ConnectorType] as [Extent12].[ConnectorType], [Expr1033]=[HarNet].[dbo].[IDB_LANinterface].[PortFast] as [Extent12].[PortFast], [Expr1034]=[HarNet].[dbo].[IDB_LANinterface].[PortSecurity] as [Extent12].[PortSecurity], [Expr1035]=[HarNet].[dbo].[IDB_LANinterface].[InterfaceStatus] as [Extent12].[InterfaceStatus], [Expr1036]=[HarNet].[dbo].[IDB_LANinterface].[IDB_InterfaceLayer2_ID] as [Extent12].[IDB_InterfaceLayer2_ID]))
                      |              |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Extent12].[IDB_LANinterface_ID]) OPTIMIZED)
                      |              |         |--Index Seek(OBJECT:([HarNet].[dbo].[IDB_LANinterface].[IX_idb_laninterface_idb_laninterfacelayer2] AS [Extent12]), SEEK:([Extent12].[IDB_InterfaceLayer2_ID]=[Expr1250]),  WHERE:(CONVERT(int,[HarNet].[dbo].[IDB_LANinterface].[IDB_InterfaceLayer2_ID] as [Extent12].[IDB_InterfaceLayer2_ID],0)=[Expr1250]) ORDERED FORWARD)
                      |              |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_LANinterface].[PK_IDB_LANinterface] AS [Extent12]), SEEK:([Extent12].[IDB_LANinterface_ID]=[HarNet].[dbo].[IDB_LANinterface].[IDB_LANinterface_ID] as [Extent12].[IDB_LANinterface_ID]) LOOKUP ORDERED FORWARD)
                      |              |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer2].[PK_IDB_InterfaceLayer2] AS [Extent13]), SEEK:([Extent13].[IDB_InterfaceLayer2_ID]=[Expr1250]),  WHERE:([Expr1250]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent13].[IDB_InterfaceLayer2_ID],0)) ORDERED FORWARD)
                      |--Compute Scalar(DEFINE:([Expr1101]=(2), [Expr1102]=(2), [Expr1108]=(2), [Expr1111]=(2), [Expr1115]=CASE WHEN [HarNet].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent22].[NSD_InterfaceTypeID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent22].[NSD_InterfaceTypeID],0) END, [Expr1116]=NULL, [Expr1117]=NULL, [Expr1118]=NULL, [Expr1119]=NULL, [Expr1120]=NULL, [Expr1121]=NULL, [Expr1122]=NULL, [Expr1123]=NULL, [Expr1124]=NULL, [Expr1125]=NULL, [Expr1126]=(2), [Expr1128]=(2), [Expr1129]=CASE WHEN [Expr1093] IS NULL THEN NULL ELSE CONVERT(int,[Expr1093],0) END, [Expr1130]=CASE WHEN [Expr1099] IS NULL THEN NULL ELSE CASE WHEN [Expr1100] IS NULL THEN NULL ELSE CONVERT(int,[Expr1100],0) END END))
                           |--Hash Match(Right Outer Join, HASH:([Expr1271])=([Expr1270]), RESIDUAL:([Expr1270]=[Expr1271]))
                                |--Compute Scalar(DEFINE:([Expr1100]=[HarNet].[dbo].[IDB_AddressMapIPv4].[IDB_AddressMapIPv4_ID] as [Extent30].[IDB_AddressMapIPv4_ID]))
                                |    |--Hash Match(Left Outer Join, HASH:([Expr1271])=([Expr1282]), RESIDUAL:([Expr1271]=[Expr1282]))
                                |         |--Compute Scalar(DEFINE:([Expr1099]=[HarNet].[dbo].[IDB_AddressIPv4].[IDB_AddressIPv4_ID] as [Extent29].[IDB_AddressIPv4_ID], [Expr1271]=CONVERT(int,[HarNet].[dbo].[IDB_AddressIPv4].[IDB_AddressIPv4_ID] as [Extent29].[IDB_AddressIPv4_ID],0)))
                                |         |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_AddressIPv4].[PK_IDB_AddressIPv4] AS [Extent29]))
                                |         |--Compute Scalar(DEFINE:([Expr1282]=CONVERT(int,[HarNet].[dbo].[IDB_AddressMapIPv4].[IDB_AddressIPv4_ID] as [Extent30].[IDB_AddressIPv4_ID],0)))
                                |              |--Index Scan(OBJECT:([HarNet].[dbo].[IDB_AddressMapIPv4].[IX_idb_addressmap_ipv4_idb_addressipv4] AS [Extent30]))
                                |--Hash Match(Left Outer Join, HASH:([Expr1270])=([Expr1272]), RESIDUAL:([Expr1270]=[Expr1272]))
                                     |--Compute Scalar(DEFINE:([Expr1109]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent17].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent17].[IDB_InterfaceLayer2_ID],0) END))
                                     |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1267], [Expr1561]) OPTIMIZED WITH UNORDERED PREFETCH)
                                     |         |--Compute Scalar(DEFINE:([Expr1110]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent18].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_Interface_ID] as [Extent18].[IDB_Interface_ID],0) END))
                                     |         |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1267], [Expr1560]) OPTIMIZED WITH UNORDERED PREFETCH)
                                     |         |         |--Hash Match(Right Outer Join, HASH:([Expr1262])=([Expr1107]), RESIDUAL:([Expr1107]=[Expr1262]))
                                     |         |         |    |--Compute Scalar(DEFINE:([Expr1262]=CONVERT(int,[HarNet].[dbo].[NSD_InterfaceType].[NSD_InterfaceTypeID] as [Extent22].[NSD_InterfaceTypeID],0)))
                                     |         |         |    |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[NSD_InterfaceType].[PK_NSD_InterfaceType] AS [Extent22]))
                                     |         |         |    |--Compute Scalar(DEFINE:([Expr1114]=CASE WHEN [HarNet].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent21].[NSD_InterfaceCodeID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent21].[NSD_InterfaceCodeID],0) END))
                                     |         |         |         |--Hash Match(Right Outer Join, HASH:([Expr1263])=([Expr1105]), RESIDUAL:([Expr1105]=[Expr1263]))
                                     |         |         |              |--Compute Scalar(DEFINE:([Expr1263]=CONVERT(int,[HarNet].[dbo].[NSD_InterfaceCode].[NSD_InterfaceCodeID] as [Extent21].[NSD_InterfaceCodeID],0)))
                                     |         |         |              |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[NSD_InterfaceCode].[PK_NSD_InterfaceCode] AS [Extent21]))
                                     |         |         |              |--Compute Scalar(DEFINE:([Expr1113]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent20].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_Interface_ID] as [Extent20].[IDB_Interface_ID],0) END))
                                     |         |         |                   |--Hash Match(Left Outer Join, HASH:([Expr1264])=([Expr1265]), RESIDUAL:([Expr1264]=[Expr1265]))
                                     |         |         |                        |--Compute Scalar(DEFINE:([Expr1112]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent19].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent19].[IDB_InterfaceLayer3_ID],0) END))
                                     |         |         |                        |    |--Hash Match(Left Outer Join, HASH:([Expr1264])=([Expr1266]), RESIDUAL:([Expr1264]=[Expr1266]))
                                     |         |         |                        |         |--Compute Scalar(DEFINE:([Expr1131]=CASE WHEN [HarNet].[dbo].[IDB_StandbyIPv4].[IDB_StandbyIPv4_ID] as [Extent25].[IDB_StandbyIPv4_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_StandbyIPv4].[IDB_StandbyIPv4_ID] as [Extent25].[IDB_StandbyIPv4_ID],0) END))
                                     |         |         |                        |         |    |--Hash Match(Right Outer Join, HASH:([Expr1273])=([Expr1127]), RESIDUAL:([Expr1127]=[Expr1273]))
                                     |         |         |                        |         |         |--Compute Scalar(DEFINE:([Expr1273]=CONVERT(int,[HarNet].[dbo].[IDB_StandbyIPv4].[IDB_AddressMapIPv4_ID] as [Extent25].[IDB_AddressMapIPv4_ID],0)))
                                     |         |         |                        |         |         |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_StandbyIPv4].[PK_IDB_StandbyIPv4] AS [Extent25]))
                                     |         |         |                        |         |         |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1275], [Expr1559]) WITH UNORDERED PREFETCH)
                                     |         |         |                        |         |              |--Compute Scalar(DEFINE:([Expr1127]=CONVERT(int,[HarNet].[dbo].[IDB_AddressMapIPv4].[IDB_AddressMapIPv4_ID] as [Extent24].[IDB_AddressMapIPv4_ID],0), [Expr1270]=CONVERT(int,[HarNet].[dbo].[IDB_AddressMapIPv4].[IDB_AddressIPv4_ID] as [Extent24].[IDB_AddressIPv4_ID],0)))
                                     |         |         |                        |         |              |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1276], [Expr1558]) WITH UNORDERED PREFETCH)
                                     |         |         |                        |         |              |         |--Hash Match(Inner Join, HASH:([Expr1275])=([Expr1264]), RESIDUAL:([Expr1264]=[Expr1275]))
                                     |         |         |                        |         |              |         |    |--Compute Scalar(DEFINE:([Expr1275]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceIPv4].[IDB_InterfaceLayer3_ID] as [Extent23].[IDB_InterfaceLayer3_ID],0), [Expr1276]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceIPv4].[IDB_AddressMapIPv4_ID] as [Extent23].[IDB_AddressMapIPv4_ID],0)))
                                     |         |         |                        |         |              |         |    |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_InterfaceIPv4].[PK_IDB_InterfaceIPv4] AS [Extent23]))
                                     |         |         |                        |         |              |         |    |--Compute Scalar(DEFINE:([Expr1264]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent16].[IDB_InterfaceLayer3_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent16].[IDB_InterfaceLayer3_ID],0) END))
                                     |         |         |                        |         |              |         |         |--Hash Match(Right Outer Join, HASH:([Expr1277])=([Expr1103]), RESIDUAL:([Expr1103]=[Expr1277]))
                                     |         |         |                        |         |              |         |              |--Compute Scalar(DEFINE:([Expr1277]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_Interface_ID] as [Extent16].[IDB_Interface_ID],0)))
                                     |         |         |                        |         |              |         |              |    |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent16]))
                                     |         |         |                        |         |              |         |              |--Compute Scalar(DEFINE:([Expr1267]=CASE WHEN [HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent15].[IDB_InterfaceLayer2_ID] IS NULL THEN NULL ELSE CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent15].[IDB_InterfaceLayer2_ID],0) END))
                                     |         |         |                        |         |              |         |                   |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Expr1103], [Expr1557]) OPTIMIZED WITH UNORDERED PREFETCH)
                                     |         |         |                        |         |              |         |                        |--Compute Scalar(DEFINE:([Expr1103]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[IDB_Interface_ID] as [Extent14].[IDB_Interface_ID],0), [Expr1104]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[ART_Asset_ID] as [Extent14].[ART_Asset_ID],0), [Expr1105]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[NSD_InterfaceCodeID] as [Extent14].[NSD_InterfaceCodeID],0), [Expr1106]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[ART_Component_ID] as [Extent14].[ART_Component_ID],0), [Expr1107]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[NSD_InterfaceTypeID] as [Extent14].[NSD_InterfaceTypeID],0)))
                                     |         |         |                        |         |              |         |                        |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Extent14].[IDB_Interface_ID], [Expr1556]) OPTIMIZED WITH UNORDERED PREFETCH)
                                     |         |         |                        |         |              |         |                        |         |--Index Seek(OBJECT:([HarNet].[dbo].[IDB_Interface].[IX_idb_interface_art_asset] AS [Extent14]), SEEK:([Extent14].[ART_Asset_ID]=[Expr1005]),  WHERE:([Expr1005]=CONVERT(int,[HarNet].[dbo].[IDB_Interface].[ART_Asset_ID] as [Extent14].[ART_Asset_ID],0)) ORDERED FORWARD)
                                     |         |         |                        |         |              |         |                        |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_Interface].[PK_IDB_Interface] AS [Extent14]), SEEK:([Extent14].[IDB_Interface_ID]=[HarNet].[dbo].[IDB_Interface].[IDB_Interface_ID] as [Extent14].[IDB_Interface_ID]) LOOKUP ORDERED FORWARD)
                                     |         |         |                        |         |              |         |                        |--Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer2].[IX_idb_interfacelayer2_idb_interface] AS [Extent15]), SEEK:([Extent15].[IDB_Interface_ID]=[Expr1103]),  WHERE:([Expr1103]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_Interface_ID] as [Extent15].[IDB_Interface_ID],0)) ORDERED FORWARD)
                                     |         |         |                        |         |              |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_AddressMapIPv4].[PK_IDB_AddressMapIPv4] AS [Extent24]), SEEK:([Extent24].[IDB_AddressMapIPv4_ID]=[Expr1276]),  WHERE:(CONVERT(int,[HarNet].[dbo].[IDB_AddressMapIPv4].[IDB_AddressMapIPv4_ID] as [Extent24].[IDB_AddressMapIPv4_ID],0)=[Expr1276]) ORDERED FORWARD)
                                     |         |         |                        |         |              |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent26]), SEEK:([Extent26].[IDB_InterfaceLayer3_ID]=[Expr1275]),  WHERE:(CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent26].[IDB_InterfaceLayer3_ID],0)=[Expr1275]) ORDERED FORWARD)
                                     |         |         |                        |         |--Compute Scalar(DEFINE:([Expr1266]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent19].[IDB_InterfaceLayer3_ID],0)))
                                     |         |         |                        |              |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent19]))
                                     |         |         |                        |--Compute Scalar(DEFINE:([Expr1265]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer3].[IDB_InterfaceLayer3_ID] as [Extent20].[IDB_InterfaceLayer3_ID],0)))
                                     |         |         |                             |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer3].[PK_IDB_InterfaceLayer3] AS [Extent20]))
                                     |         |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer2].[PK_IDB_InterfaceLayer2] AS [Extent18]), SEEK:([Extent18].[IDB_InterfaceLayer2_ID]=[Expr1267]),  WHERE:([Expr1267]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent18].[IDB_InterfaceLayer2_ID],0)) ORDERED FORWARD)
                                     |         |--Clustered Index Seek(OBJECT:([HarNet].[dbo].[IDB_InterfaceLayer2].[PK_IDB_InterfaceLayer2] AS [Extent17]), SEEK:([Extent17].[IDB_InterfaceLayer2_ID]=[Expr1267]),  WHERE:([Expr1267]=CONVERT(int,[HarNet].[dbo].[IDB_InterfaceLayer2].[IDB_InterfaceLayer2_ID] as [Extent17].[IDB_InterfaceLayer2_ID],0)) ORDERED FORWARD)
                                     |--Hash Match(Right Outer Join, HASH:([Expr1281])=([Expr1272]), RESIDUAL:([Expr1272]=[Expr1281]))
                                          |--Compute Scalar(DEFINE:([Expr1281]=CONVERT(int,[HarNet].[dbo].[IDB_AddressMapIPv4].[IDB_AddressIPv4_ID] as [Extent28].[IDB_AddressIPv4_ID],0)))
                                          |    |--Index Scan(OBJECT:([HarNet].[dbo].[IDB_AddressMapIPv4].[IX_idb_addressmap_ipv4_idb_addressipv4] AS [Extent28]))
                                          |--Compute Scalar(DEFINE:([Expr1093]=[HarNet].[dbo].[IDB_AddressIPv4].[IDB_AddressIPv4_ID] as [Extent27].[IDB_AddressIPv4_ID], [Expr1094]=[HarNet].[dbo].[IDB_AddressIPv4].[Address] as [Extent27].[Address], [Expr1272]=CONVERT(int,[HarNet].[dbo].[IDB_AddressIPv4].[IDB_AddressIPv4_ID] as [Extent27].[IDB_AddressIPv4_ID],0)))
                                               |--Clustered Index Scan(OBJECT:([HarNet].[dbo].[IDB_AddressIPv4].[PK_IDB_AddressIPv4] AS [Extent27]))