We have a requirement to create a BigFix Web Report property that displays the following network-related details in a single column within the report:
The objective is to consolidate all the above network information into one column for easier visibility and reporting.
Please review the requirement and let us know the feasibility or if any one having the relevance for the same
I believe you are referring to a Custom Web Report rather than creating a single Web Reports property.
If these values are already available as separate Retrieved Properties (RPs) in your environment, I would recommend displaying each property in a separate column rather than combining all network details into a single column. This makes the report easier to read, filter, and work with.
If you already have the required RPs created, you can use a Custom Web Report similar to the example below to populate the desired network information.
<head>
<meta charset="utf-8">
<title>BigFix Network Configuration Report</title>
<style>
* { box-sizing: border-box; }
body { margin: 0; padding: 41px 0; background: #edf2f7; color: #20242a; font: 11px Arial, Helvetica, sans-serif; }
.report { width: 94.5%; margin: 0 auto; background: #fff; border: 1px solid #cbd5e1; box-shadow: 0 2px 10px rgba(15, 23, 42, .08); }
.hero { padding: 24px 24px 43px; text-align: center; border-bottom: 5px solid #0878d1; }
.brand { display: inline-block; margin-bottom: 14px; padding: 8px 20px; background: #0878d1; color: #fff; font-size: 14px; font-weight: 700; }
h1 { margin: 0; font-size: 24px; line-height: 1.15; letter-spacing: .2px; }
.section-title { padding: 12px 16px; background: #f1f5f9; border-bottom: 1px solid #cbd5e1; font-size: 15px; font-weight: 700; }
.table-wrap { overflow-x: auto; }
table { width: 100%; border-collapse: collapse; }
th { padding: 8px; background: #16449b; color: #fff; font-size: 11px; line-height: 1.2; text-align: left; white-space: nowrap; }
td { padding: 7px 8px; border-right: 1px solid #dbe2ea; border-bottom: 1px solid #dbe2ea; font-size: 11px; line-height: 1.25; vertical-align: top; }
tbody tr:nth-child(even) { background: #f8fafc; }
tbody tr:hover { background: #eaf4ff; }
th:nth-child(1) { min-width: 180px; }
th:nth-child(2), th:nth-child(3), th:nth-child(4) { min-width: 150px; }
th:nth-child(5), th:nth-child(6) { min-width: 140px; }
th:nth-child(7) { min-width: 200px; }
.footer { padding: 12px 16px; background: #fff8e7; color: #5b6470; border-top: 1px solid #edd79d; font-size: 11px; }
</style>
</head>
<body>
<main class="report">
<header class="hero">
<div class="brand">BigFix</div>
<h1>Network Configuration Report</h1>
</header>
<div class="section-title">Network Details</div>
<div class="table-wrap">
<table>
<thead>
<tr>
<th>Hostname</th>
<th>IP Address</th>
<th>MAC Address</th>
<th>NIC Address</th>
<th>DNS Server</th>
<th>Default Gateway</th>
<th>Route IP</th>
</tr>
</thead>
<tbody>
<?relevance
concatenation of trs of
(
td of (item 0 of it)
& td of (item 1 of it)
& td of (item 2 of it)
& td of (item 3 of it)
& td of (item 4 of it)
& td of (item 5 of it)
& td of (item 6 of it)
)
of
(
(name of item 0 of it | "N/A"),
(if (it = "") then "N/A" else it) of (concatenation "; " of (ip addresses of item 0 of it as string) | ""),
(if (it = "") then "N/A" else it) of (concatenation "; " of values of results (item 0 of it, elements of item 1 of it) | ""),
(if (it = "") then "N/A" else it) of (concatenation "; " of values of results (item 0 of it, elements of item 2 of it) | ""),
(if (it = "") then "N/A" else it) of (concatenation "; " of values of results (item 0 of it, elements of item 3 of it) | ""),
(if (it = "") then "N/A" else it) of (concatenation "; " of values of results (item 0 of it, elements of item 4 of it) | ""),
(if (it = "") then "N/A" else it) of (concatenation "; " of values of results (item 0 of it, elements of item 5 of it) | "")
)
of
(
elements of item 0 of it,
item 1 of it,
item 2 of it,
item 3 of it,
item 4 of it,
item 5 of it
)
of
(
set of bes computers,
set of bes properties whose (name of it = "MAC Address"),
set of bes properties whose (name of it = "NIC Address"),
set of bes properties whose (name of it = "DNS Server"),
set of bes properties whose (name of it = "Default Gateway"),
set of bes properties whose (name of it = "Route IP")
)
?>
</tbody>
</table>
</div>
<footer class="footer">Generated by BigFix Web Reports • This is an automated report. Please do not reply.</footer>
</main>
</body>
</html>````
//sample:
Thank you vijay for sharing the report.
However, we do not currently have all the required properties available in BigFix. We need to retrieve and create the below properties so they can be used for reporting purposes:
For many of these, out of the box properties are available today. So, some additional clarifying questions:
