SCCM 2012 - Export Query Results
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
September 20th, 2012 4:12am
September 20th, 2012 6:40am
September 20th, 2012 8:45pm
The KISS principleexcellent.
April 12th, 2013 7:44pm
If you want the headers as well, export the MOF file and open it in notepad. The line
ResultColumnsNames = shows all of the column names in a CSV format. You can format them in excel and then add it to the top of the data.
April 23rd, 2013 2:14pm
nicely painful :) was much better in 2007 to get result with headers.
No add ons for such yet available? Thank you! :)
September 26th, 2013 1:59pm
Unable to get the Agent Time in Excel / notepad, its just blank , Any one knows how to get that populated?
September 4th, 2014 10:27am
Unable to get the Agent Time in Excel / notepad, its just blank , Any one knows how to get that populated?
I just tested this in Excel 2013, 2010 and notepad and it does copy and paste the agent time for all of them. I recommend trying this again or checking your query.
September 4th, 2014 11:59am
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
September 9th, 2014 2:44pm
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?
September 10th, 2014 1:20am
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
March 12th, 2015 11:20am
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
March 12th, 2015 3:18pm
Anyone know how to keep the column header information? It is useful when sorting or sending the info to other people.
April 16th, 2015 12:24pm