I spend most of my time in Excel. Second most time in the SQL Mgmt Studio and 3rd most time in SSRS creating reports so users can "fish". I prefer SQL to WQL.
If I get one request for a report, I develop it in SQL Mgmt studio and cut and paste results to an excel file and send. If I get the request again, or expect it to be an ongoing request, I create a SSRS report from the SQL I already developed.. If it is something I'll use all the time, I take the SQL and create a data connection in Excel and just refresh the data when I need it. Probably not best practice, but I grant most IT users read access to the CM database, so they can refresh excel reports I send them... From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Leuthold Sent: Monday, August 19, 2013 9:29 AM To: [email protected] Subject: RE: [mssms] SCCM2012 Reports 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]<mailto:[email protected]> To: [email protected]<mailto:[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 [WordPress Logo 32px]<http://trevorsullivan.net/> [Twitter Logo 32px] <http://twitter.com/pcgeek86> [Facebook Logo 32px] <http://facebook.com/trevor.sullivan> [Google+ Icon 32px] <https://plus.google.com/106658223083457664096> From: [email protected]<mailto:[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... ________________________________ THIS E-MAIL AND ANY MATERIALS TRANSMITTED WITH IT MAY CONTAIN CONFIDENTIAL OR PROPRIETARY MATERIAL FOR THE SOLE USE OF THE INTENDED RECIPIENT. ANY REVIEW, USE, DISTRIBUTION OR DISCLOSURE BY OTHERS IS STRICTLY PROHIBITED. IF YOU ARE NOT THE INTENDED RECIPIENT, OR AUTHORIZED TO RECEIVE THE INFORMATION FROM THE RECIPIENT, PLEASE NOTIFY THE SENDER BY REPLY E-MAIL AND DELETE ALL COPIES OF THIS MESSAGE.
<<inline: image001.gif>>
<<inline: image002.gif>>
<<inline: image003.gif>>
<<inline: image004.gif>>
