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.
