Saving a Report as a Spreadsheet has HTML code in the spreadsheet
search cancel

Saving a Report as a Spreadsheet has HTML code in the spreadsheet

book

Article ID: 281071

calendar_today

Updated On:

Products

IT Management Suite Client Management Suite

Issue/Introduction

How can we remove the HTML and other Code in the spreadsheet when using the Reporting option: Save as > spreadsheet?

As an example the Windows Compliance by CVE ID report as a spreadsheet, as seen here with the clickable CVE ID:

Results in the following data in the CSV file:

CVE ID Compliance Applicable (Count) Installed (Count) Not Installed (Count) CVSS v2 CVSS v3 Description
<a href="/Altiris/Console/Dashboard/DashboardView.aspx?ResourceGuid=86bb9a50-51c0-4099-83d4-d2ce5536d9f2&TabGuid=2B1885A6-C844-4F3A-B842-C5E8E5478DDE" target="_blank" title="CVE-2024-26246">CVE-2024-26246</a> 100.00% 13 13 0   3.9 <span title="Microsoft Edge (Chromium-based) Security Feature Bypass Vulnerability">Microsoft Edge (Chromium-based) Security Feature Bypass Vulnerability</a>
<a href="/Altiris/Console/Dashboard/DashboardView.aspx?ResourceGuid=22cf0db3-245f-4dbd-baff-413c05cae594&TabGuid=2B1885A6-C844-4F3A-B842-C5E8E5478DDE" target="_blank" title="CVE-2024-26197">CVE-2024-26197</a> 100.00% 7 7 0   6.5 <span title="Windows Standards-Based Storage Management Service Denial of Service Vulnerability">Windows Standards-Based Storage Management Service Denial of Service Vulnerability</a>

Cause

Since the Report has hyperlinks to other pages, those hyperlinks are also included when you save a Report as a spreadsheet.

Resolution

The following works for reports like the Windows Compliance by CVE ID, where the CVE ID and Description have HTML code.

To remove the HTML code from the Report, do the following:

  1. Clone the Report
  2. Edit the Report and select the Views tab
  3. Select MyGridView and click Edit
  4. Remove the Display Description AND the Link to CVE ID resource
    2. NOTE: Leave the Add % sign to Compliance if you want the Compliance to show "100%" instead of "100".
  5. Save the Report and view the results

The links should be removed.

Saving the Report as a Spreadsheet should only have Text in each column:

CVE ID Compliance Applicable (Count) Installed (Count) Not Installed (Count) CVSS v2 CVSS v3 Description
CVE-2024-26246 100.00% 13 13 0   3.9 Microsoft Edge (Chromium-based) Security Feature Bypass Vulnerability
CVE-2024-26197 100.00% 7 7 0   6.5 Windows Standards-Based Storage Management Service Denial of Service Vulnerability
Powered by Wolken Software