The views are now listed here: http://technet.microsoft.com/en-us/library/dn581978.aspx Mike D- Date: Tue, 22 Jul 2014 10:53:29 -0500 Subject: Re: [mssms] Call for reporting tutorials (AKA help me to not suck at custom reports) From: [email protected] To: [email protected]
I learned SQL from this. http://www.w3schools.com/sql/And I learned the views and tables from years and years of writing reports. On Tue, Jul 22, 2014 at 10:16 AM, Atkinson, Matt <[email protected]> wrote: Hi All, I’ve recently had a few request for custom reports to be created. I don’t have any kind of SQL/WQL background, so terms like Inner Join/Outer Join don’t mean much to me. Do you have any good tutorials on report building that you can send my way? For example, here is something that I was asked to create yesterday. I’m not sure the best way to start, or if something like this is even possible: “Are there any readily available reports in SCCM that show the number of pushes/deployments completed by application title and number of systems to which the application was deployed?” They are basically looking for a report like this: Application Name Number of Advertisements Number of Clients Deployed To Acrobat Professional 9 6 350 Seems like it should be possible, but I don’t know for sure. Thanks in advance! -Matt This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
