Hidden Feature: Export Data to Excel from a View

Hidden Feature: Export Data to Excel from a View

  • Comments 4
  • Likes

OK, speaking of hidden features…  I didn’t even know about this one until today.   Somewhere along the way the console framework development team added support to the Grid view type to copy the data from selected objects in the grid view to the clipboard in TSV (tab separated value) format.  From there you can directly paste it into Excel.  This works for any kind of Grid view in the console – incident views, computer views, search results, etc.

The reason I call this is a hidden feature is that it is not exposed in the user interface in any way.  There are no links in the task pane for this, no options in the menu, no option on the right click menu, etc.  Don’t ask me why! :)  You can only do this with the standard clipboard keyboard shortcuts – CTRL+C for copy.  CTRL+A also works for Select All.  So with a couple of quick keyboard shortcuts you can easily dump all the data from a view to Excel - CTRL+A, CTRL+C, ALT+TAB (to switch to Excel), CTRL+V (Paste).  Awesome!!

Here is a screenshot showing the data pasted into notepad and Excel from the Service Manager console.

image

Note: I have no idea when this was added and since I am only testing on RC builds on this point it may only work in an RC build of Service Manager which is coming out very soon…

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
  • Travis,

    this is the same in OpsMgr console from RTM. Probably grid view is taken from there?

    Peter

  • Our grid view is a new version of the grid view from Operations Manager, but it is built by the same team.  So, yeah, they must have ported that functionality over at some point.

  • Travis,

    Is it possible to view the SCOM alerts or warnings in excel?

  • @Prabhu -

    Two options:

    1) Go to the Data Warehouse/Cubes view and select the incident/problem cube and choose Analyze in Excel.

    2) Open the SCOM alert-generated incidents view in the Work Items workspace and do the above trick in the blog post.  These are *incidents* which have been generated from alerts, not exactly alerts but pretty close.