(imported topic written by anthonymap91)
I hope someone can help, please
I need to create a report that will list out the Fixlet ID, Fixlet name, category, source, Source Severity and CVE number.
This report is filtered by:
Include sites:
Patches for Windows (English)
Patches for AIX
Patches for ESX
Patches for HP-UX
Patches for Oracle
Patches for RHEL 3
Patches for RHEL 4
Patches for RHEL 5
Patches for RedHat Enterprise Linux
Patches for RedHat Linux
Patches for SUSE Linux Enterprise
Patches for Solaris
Patches for Solaris Maintenance
Updates for Windows Applications
Include Fixlet categories:
Recommended Security
Required by a Recommended/Security Patch
Security
Security Advisory
Security Fix
Security Hotfix
Security Setting
Security Update
Security fix
Service Pack
Example:
Fixlet name Fixlet ID Category Source Source Severity CVE
MSXX-11 - name 2000401 Security Hotfix Microsoft High CVE-2000-0089, CVE-2000-0090
MSXX-22 - name 2000401 Security Hotfix Microsoft High CVE-2000-0075
MSXX-33 - name 2000401 Security Hotfix Microsoft High CVE-2000-0076
Also I need to have all CVE numbers that are on one line to be on the next line:
Before:
Fixlet name Fixlet ID Category Source Source Severity CVE
MSXX-11 - name 2000401 Security Hotfix Microsoft High CVE-2000-0089,CVE-2000-0090
MSXX-22 - name 2000401 Security Hotfix Microsoft High CVE-2000-0075
MSXX-33 - name 2000401 Security Hotfix Microsoft High CVE-2000-0076
After:
Fixlet name Fixlet ID Category Source Source Severity CVE
MSXX-11 - name 2000401 Security Hotfix Microsoft High CVE-2000-0089
MSXX-11 - name 2000401 Security Hotfix Microsoft High CVE-2000-0090
MSXX-22 - name 2000401 Security Hotfix Microsoft High CVE-2000-0075
MSXX-33 - name 2000401 Security Hotfix Microsoft High CVE-2000-0076
Thanks for the help