Hi guys, I have a query under "Monitoring" - "Overview" - "Queries" and have my results in the result pane however I want to print the report or export to a CSV file. I cant see an easy way to do this? Surely we dont have to create the query then create a report just so we can export or print the report? Information is on my screen and is exactly what I want but no obvious easy way to get this in a format that is usable

I only see the export MOF option available

Thanks

Nick

Ctrl+A, Ctrl+C ;-)

Brilliant, thanks

The KISS principleexcellent.

nicely painful :) was much better in 2007 to get result with headers.

No add ons for such yet available? Thank you! :)

Ctrl+A, Ctrl+

Unable to get the Agent Time in Excel / notepad, its just blank , Any one knows how to get that populated?

I know this is an old post but I see Garth replied a couple days ago - on this same theme I have just upgraded to Office 2013 and the cut and paste from Queries and Collections from SCCM 2012 (which worked fine in Office 2010) seems to now not work with my Excel 2013 - you do mention it works for you in your post.  The results I see that I have 4 columns in my results it just pastes them into 1 cell - it doesn't break up the columns.  I have tried pasting to notepad first then to Excel - doesn't work - also tried Paste - Special - Unicode Text or Text and still it all goes into one cell. Is there something I have to change with either SCCM or Excel to get this to work again?

Let me know if you have run into this with Excel 2013....thanks

Kevin

• Edited by r3knelson Tuesday, September 09, 2014 2:44 PM

I just tested it again and it works for both Queries and Collections. I hate to say it but I think this is a problem on your end.

What OS are you running?

I know this is an old post but I see Garth replied a couple days ago - on this same theme I have just upgraded to Office 2013 and the cut and paste from Queries and Collections from SCCM 2012 (which worked fine in Office 2010) seems to now not work with my Excel 2013 - you do mention it works for you in your post.  The results I see that I have 4 columns in my results it just pastes them into 1 cell - it doesn't break up the columns.  I have tried pasting to notepad first then to Excel - doesn't work - also tried Paste - Special - Unicode Text or Text and still it all goes into one cell. Is there something I have to change with either SCCM or Excel to get this to work again?

Let me know if you have run into this with Excel 2013....thanks

Kevin

I am seeing the same issue.  Win 7/Office 2013 fully patched.

Edit: Got it to work by pasting into Notepad, saving as .txt and opening that file with Excel.

• Edited by DrewMilizia 14 hours 47 minutes ago Added my fix

I know this is an old post but I see Garth replied a couple days ago - on this same theme I have just upgraded to Office 2013 and the cut and paste from Queries and Collections from SCCM 2012 (which worked fine in Office 2010) seems to now not work with my Excel 2013 - you do mention it works for you in your post.  The results I see that I have 4 columns in my results it just pastes them into 1 cell - it doesn't break up the columns.  I have tried pasting to notepad first then to Excel - doesn't work - also tried Paste - Special - Unicode Text or Text and still it all goes into one cell. Is there something I have to change with either SCCM or Excel to get this to work again?

Let me know if you have run into this with Excel 2013....thanks

Kevin

I am seeing the same issue.  Win 7/Office 2013 fully patched.

Edit: Got it to work by pasting into Notepad, saving as .txt and opening that file with Excel.

• Edited by DrewMilizia Thursday, March 12, 2015 4:51 PM Added my fix