When you save a report as a CSV file it puts a leading comma in the CSV file. When you import this into Excel it throws the columns off.

Products

• Patch Management Solution for Windows
• IT Management Suite

Issue/Introduction

KNOWN ISSUE: 

With ITMS 8.5 RU1 installed do the following:
1.  Open Reports>All Reports>Notification Server Management>Agent>Agent 
Connection Status
2.  At top of the report click the Save As dropdown and select Spreadsheet.
3.  Save the CSV file.  
4.  Open the CSV file with notepadd ++ and you will see that it has a 
leading comma on all the data.
5.  Open excel.  Click on a cell.  
6.  Goto the Data Tab and select the From Text/CSV option and select the CSV 
file you saved.  Change the delimiter to command and select load.

You will see that the first column will be labeled Computer Name.  However,  
all the computers will show up under the SMP Server column.   All data is 
shifted over one column.

This appears to happen on all reports. 

 

Cause

Known Issue.

Environment

ITMS 8.5 RU1

Resolution

This issue has been reported to the Symantec Development Team. The fix will be available with the SMP 8.5 RU2 release.

A pointfix has been created for this issue for the SMP 8.5 RU1 version. Please go through below article for the same:

CUMULATIVE POST 8.5 RU1 POINT FIXES: https://www.symantec.com/docs/INFO5299