WikiSysop at 14:31, October 7, 2022

2022-10-07T14:31:11Z

WikiSysop: Created page with "This template prints a consolidated table of ports and protocols, retrieving information from all service-level Architecture pages. List by se..."

2022-10-07T14:16:00Z

Created page with "<noinclude>This template prints a consolidated table of ports and protocols, retrieving information from all service-level Architecture pages.</noinclude> <tabber> List by se..."

New page

<noinclude>This template prints a consolidated table of ports and protocols, retrieving information from all service-level Architecture pages.</noinclude>

<tabber>
List by service=
View CSV: {{#cargo_query:
tables=
ArticlePEServiceArchitecture,
Service,
PEConnections,
IncludedService,
Protocols,
TrafficTypes
|join on=
ArticlePEServiceArchitecture.ServiceId=Service.Id,
ArticlePEServiceArchitecture._pageName=PEConnections._pageName,
PEConnections.Source=IncludedService.Id,
PEConnections.Protocol=Protocols.Id,
PEConnections.Classification=TrafficTypes.Id
|fields=
Service.Name=Service,
Protocols.Name=Protocol,
Port
|where=
PEConnections._pageNamespace="{{NAMESPACENUMBER}}"
AND Service.Name IS NOT NULL
AND Port IS NOT NULL
AND Protocol IS NOT NULL
AND ArticlePEServiceArchitecture._pageNamespace ="{{NAMESPACENUMBER}}"
|limit=10000
|format=csv
|group by=Protocols.Name,Port,Service.Name,ArticlePEServiceArchitecture._pageName
|link text=Download
|filename=PortSummaryByService_{{CURRENTTIMESTAMP}}
}}
{{#cargo_query:
tables=
ArticlePEServiceArchitecture,
Service,
PEConnections,
IncludedService,
Protocols,
TrafficTypes
|join on=
ArticlePEServiceArchitecture.ServiceId=Service.Id,
ArticlePEServiceArchitecture._pageName=PEConnections._pageName,
PEConnections.Source=IncludedService.Id,
PEConnections.Protocol=Protocols.Id,
PEConnections.Classification=TrafficTypes.Id
|fields=
Service.Name=Service,
Protocols.Name=Protocol,
Port
|where=
PEConnections._pageNamespace="{{NAMESPACENUMBER}}"
AND Service.Name IS NOT NULL
AND Port IS NOT NULL
AND Protocol IS NOT NULL
AND ArticlePEServiceArchitecture._pageNamespace ="{{NAMESPACENUMBER}}"
|limit=10000
|format=table
|merge similar cells=yes
|group by=Protocols.Name,Port,Service.Name,ArticlePEServiceArchitecture._pageName
}}
|-|
List by protocol=
View CSV: {{#cargo_query:
tables=
ArticlePEServiceArchitecture,
Service,
PEConnections,
IncludedService,
Protocols,
TrafficTypes
|join on=
ArticlePEServiceArchitecture.ServiceId=Service.Id,
ArticlePEServiceArchitecture._pageName=PEConnections._pageName,
PEConnections.Source=IncludedService.Id,
PEConnections.Protocol=Protocols.Id,
PEConnections.Classification=TrafficTypes.Id
|fields=
Protocols.Name=Protocol,
Port,
Service.Name=Service
|where=
PEConnections._pageNamespace="{{NAMESPACENUMBER}}"
AND Service.Name IS NOT NULL
AND Port IS NOT NULL
AND Protocol IS NOT NULL
AND ArticlePEServiceArchitecture._pageNamespace ="{{NAMESPACENUMBER}}"
|limit=10000
|format=csv
|group by=Protocols.Name,Port,Service.Name,ArticlePEServiceArchitecture._pageName
|link text=Download
}}
{{#cargo_query:
tables=
ArticlePEServiceArchitecture,
Service,
PEConnections,
IncludedService,
Protocols,
TrafficTypes
|join on=
ArticlePEServiceArchitecture.ServiceId=Service.Id,
ArticlePEServiceArchitecture._pageName=PEConnections._pageName,
PEConnections.Source=IncludedService.Id,
PEConnections.Protocol=Protocols.Id,
PEConnections.Classification=TrafficTypes.Id
|fields=
Protocols.Name=Protocol,
Port,
Service.Name=Service
|where=
PEConnections._pageNamespace="{{NAMESPACENUMBER}}"
AND Service.Name IS NOT NULL
AND Port IS NOT NULL
AND Protocol IS NOT NULL
AND ArticlePEServiceArchitecture._pageNamespace ="{{NAMESPACENUMBER}}"
|limit=10000
|format=table
|merge similar cells=yes
|group by=Protocols.Name,Port,Service.Name,ArticlePEServiceArchitecture._pageName
}}
|-|
List by port=
View CSV:
{{#cargo_query:
tables=
ArticlePEServiceArchitecture,
Service,
PEConnections,
IncludedService,
Protocols,
TrafficTypes
|join on=
ArticlePEServiceArchitecture.ServiceId=Service.Id,
ArticlePEServiceArchitecture._pageName=PEConnections._pageName,
PEConnections.Source=IncludedService.Id,
PEConnections.Protocol=Protocols.Id,
PEConnections.Classification=TrafficTypes.Id
|fields=
Port,
Protocols.Name=Protocol,
Service.Name=Service
|where=
PEConnections._pageNamespace="{{NAMESPACENUMBER}}"
AND Service.Name IS NOT NULL
AND Port IS NOT NULL
AND Protocol IS NOT NULL
AND ArticlePEServiceArchitecture._pageNamespace ="{{NAMESPACENUMBER}}"
|limit=10000
|format=csv
|group by=Protocols.Name,Port,Service.Name,ArticlePEServiceArchitecture._pageName
||link text=Download
}}
{{#cargo_query:
tables=
ArticlePEServiceArchitecture,
Service,
PEConnections,
IncludedService,
Protocols,
TrafficTypes
|join on=
ArticlePEServiceArchitecture.ServiceId=Service.Id,
ArticlePEServiceArchitecture._pageName=PEConnections._pageName,
PEConnections.Source=IncludedService.Id,
PEConnections.Protocol=Protocols.Id,
PEConnections.Classification=TrafficTypes.Id
|fields=
Port,
Protocols.Name=Protocol,
Service.Name=Service
|where=
PEConnections._pageNamespace="{{NAMESPACENUMBER}}"
AND Service.Name IS NOT NULL
AND Port IS NOT NULL
AND Protocol IS NOT NULL
AND ArticlePEServiceArchitecture._pageNamespace ="{{NAMESPACENUMBER}}"
|limit=10000
|format=table
|merge similar cells=yes
|group by=Protocols.Name,Port,Service.Name,ArticlePEServiceArchitecture._pageName
}}
</tabber>

@@ Line 1: / Line 1: @@
-<noinclude>This template prints a consolidated table of ports and protocols, retrieving information from all service-level Architecture pages.</noinclude>
+<noinclude>This template prints a consolidated table of ports and protocols, retrieving information from all service-level Architecture pages. And also prints a table with links to the service-level Architecture pages.</noinclude>
 <tabber>
@@ Line 92: / Line 92: @@
          |group by=Protocols.Name,Port,Service.Name,ArticlePEServiceArchitecture._pageName
          |link text=Download
 }}
 {{#cargo_query:
@@ Line 152: / Line 153: @@
 	|format=csv
          |group by=Protocols.Name,Port,Service.Name,ArticlePEServiceArchitecture._pageName
-         ||link text=Download
+         |link text=Download
 }}
 {{#cargo_query:
@@ Line 184: / Line 186: @@
 }}
 </tabber>

Template:PrintPortsSummary - Revision history

WikiSysop at 14:31, October 7, 2022

WikiSysop: Created page with "This template prints a consolidated table of ports and protocols, retrieving information from all service-level Architecture pages. List by se..."