Nice! Good to know. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: Friday, January 24, 2014 1:58 PM To: [email protected] Subject: RE: [mssms] Create custom report in SCCM 2012
They just released the 2012 views on TechNet. http://technet.microsoft.com/en-us/library/dn581954.aspx Daniel Ratliff -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Rich Coulter Sent: Friday, January 24, 2014 2:35 PM To: [email protected] Subject: RE: [mssms] Create custom report in SCCM 2012 It's good practice to create reports based on SQL views only. The challenge is to get a good overview of all the views and how they are related. CM07 has a pretty useful tool that can assist you. Albeit, the views in CM12 are not 100% identical, it's still a pretty good way to get started. Download the and install the CreatingCustomReportsByUsingSQLViews.msi file Once you have this installed open C:\Program Files (x86)\Configuration Manager 2007 Documentation\Creating Custom Reports by Using Configuration Manager 2007 SQL View - note you have a Visio document and Excel spreadsheet. If you open the Visio document and select the Discovery tab, notice all the views. Next, look at Hardware Inventory. Another thing you can do is open SQL Management Studio connect to the CM_XXX database and create a new query like this: select distinct table_name,COLUMN_Name from Information_Schema.columns where table_name LIKE ('v_&') Order by table_name Take a look at all the views returned. This will give you an idea of the possibilities. If you want to create custom reports do some digging on using...SQL Server Data Tools - Business Intelligence Settings and start Visual Studio. I'm sure there's some resources available some place to get you going on creating custom reports from there. Rich C. ________________________________ From: [email protected] To: [email protected] Subject: [mssms] Create custom report in SCCM 2012 Date: Fri, 24 Jan 2014 23:51:45 +0530 Hi all, Can you guide me, how to create custom(SQL) report in SCCM 2012 server? Regards Rajan K CONFIDENTIALITY NOTICE: This electronic mail transmission (including any accompanying attachments) is intended solely for its authorized recipient(s), and may contain confidential and/or legally privileged information. If you are not an intended recipient, or responsible for delivering some or all of this transmission to an intended recipient, be aware that any review, copying, printing, distribution, use or disclosure of the contents of this message is strictly prohibited. If you have received this electronic mail message in error, please delete it from your system without copying it, and contact sender immediately by Reply e-mail, or by calling 913-307-2300, so that our address records can be corrected. Although this e-mail and any attachments are believed to be free of any virus or other defect that might negatively affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by the sender for any loss or damage arising in any way in the event that such a virus or defect exists. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. CONFIDENTIALITY NOTICE: This electronic mail transmission (including any accompanying attachments) is intended solely for its authorized recipient(s), and may contain confidential and/or legally privileged information. If you are not an intended recipient, or responsible for delivering some or all of this transmission to an intended recipient, be aware that any review, copying, printing, distribution, use or disclosure of the contents of this message is strictly prohibited. If you have received this electronic mail message in error, please delete it from your system without copying it, and contact sender immediately by Reply e-mail, or by calling 913-307-2300, so that our address records can be corrected. Although this e-mail and any attachments are believed to be free of any virus or other defect that might negatively affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by the sender for any loss or damage arising in any way in the event that such a virus or defect exists.
