Agree with Trevor. I ALWAYS have my SSMS console open for quick access to data. :) If someone needs some one off report and will not run it often. Typically I'll just run the query, select all, copy to clipboard with headers, paste in excel, and send it over. From: [email protected] To: [email protected] Subject: RE: [mssms] SCCM2012 Reports Date: Mon, 19 Aug 2013 08:45:28 -0500
Greg, I agree overall with your analysis. It’s not an ideal solution, but personally I prefer to simply run SQL queries inside of SQL Management Studio (SSMS). It’s the easiest way for me to obtain raw data when necessary. Unfortunately, this doesn’t help for publishing information to end users. Cheers,Trevor Sullivan From: [email protected] [mailto:[email protected]] On Behalf Of Greg DeGuire Sent: Friday, August 16, 2013 10:53 AM To: '[email protected]' Subject: [mssms] SCCM2012 Reports Is there any way to create a simple report the ‘old school’ way (2007)? By this I mean just entering SQL, typing all the joins, etc. and getting a report quickly – like the ‘grey bar’ reports from 2007? It just seems to me like ANY report in 2012 is a lot of needless clicking/width adjusting for even the simplest output…
<<inline: image001.gif>>
<<inline: image002.gif>>
<<inline: image003.gif>>
<<inline: image004.gif>>
