Short post on how to get you dev environment ready for authoring scom reports.
You have installed SCOM 2012 on SQL 2008. You want to author a custom report using Visual studio 2010. When you open visual studio you will notice that NO BI project template is shown. Normally you selected this project template and selected the new report project to make your custom report. How now to continue ?
Grab a SQL 2012 ISO (YES 2012) and startup the setup.
1) Select installation:
2) New sql or add features
3) Select SQL features Install
4) Now the important step. Select the 3 options here. Most important is the “SQL Server Data Tools”. This features contains the VS BI project template.
5) Step though the install windows.
And now open Visual studio 2010 and create a new project. And what do we see ?
Yes the BI template
Now you can create the new SCOM reports. Notice also the NEW chart types !!!
Remember that if you use custom report code components you must copy the correct .dll assemble to the directory:
C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies