How do I export a collection into an Excel file?

Article Id: 180353
Status: Published
Updated On: 11-10-2006 13:52
Legacy Id: HOWTO4462
Products:
Management Platform (Formerly known as Notification Server)
Issue/Introduction:

 

Resolution:

Question
How do I export a collection view to an Excel* spreadsheet?

Answer

  1. Open up the NS console.
  2. Go to Collections > Computer Collections > All Computers.
  3. In the right-hand pane after it’s been populated, click on the copy option. This will put all the info in this report into the Microsoft clipboard.
  4. Open up Notepad.
  5. Paste the contents into Notepad.
  6. Use the replace option to change the column delimiter to a  comma ( , ) instead of a tab value.
  7. Once all the values have been replaced, use the Save As option and save the file as a .CSV file.
  8. You will now be able to open this file as a native Excel spreadsheet.