Creating Configuration Manager 2007 Reports – Part II Creating the first report

In this part I will walk you through the creation of a report in SQL Server Managmenet Studio. The report will show all clients with SMS 2003 Toolkit installed.

	Open SQL Server Management Studio and log on to the server.
	Navigate to the Configuration Manager database. The name is most likely SMS_<Sitecode>.
	Right click Views and select New View
	Select the Views tab.
	Add V_R_System and V_GS_Add_Remove_Programs Note: V_R_System contains the basic discovery data.
	Now when we have the views we must create an Inner Join.From V_R_System drag the column RessourceID onto the RessourceID column onto the V_GS_Add_Remove_Programs view
	Select Netbios_Name() from V_R_System and DisplayName() from V_GS_Add_Remove_Programs.
	In the Criteria pane type SMS 2003 Toolkit and press enter in the Filter cell for the DisplayName() column.Notice that SQL automatically will replace the text with =’SMS 2003 Toolkit’ – Nice 🙂
	Let’s view the result before we copy the statement to Configuration Manager.Make sure that the SQL and Results panes are visible. If not right click, select Pane and enable them.
	If everything looks OK; copy the entire SQL statement.
	Open the Configuration Manager console and navigate to Reporting. Click New in the Actions pane.
	In name type: All Computers with SMS 2003 Toolkit installedIn Category type: <Company name> SoftwareIn comment type the date, your name and a short description of the content.
	Click Edit SQL Statement. Highlight the default SQL statement, right click and Paste your SQL statement into the Window.
	Click OK.
	Click Next.
	Click Next.
	Click Next.
	Click Next.
	Click Close.
	Click Close – Congratulations you survived the wizard 🙂
	Highlight your report and click Run in the Actions pane.
	You have now created your first report – it’s time to go impress management 🙂

In the 3 part we will take a closer look at some of the conditionals and aggregate functions.

Om forfatteren: Kent Agerlund

Microsoft Regional Director, Enterprise Mobility MVP. Microsoft Certified Trainer and Principal consultant. I have been working with Enterprise client management since 1992. Co-founder of System Center User Group Denmark in 2009. Certified MCITP: Enterprise Administrator, MCSA+Messaing, and much more. Member of: Microsoft Denmark System Center Partner Expert Team The Danish Technet Influencers program System Center Influencers Program.

7 kommentarer

chungb marts 18, 2009 af 2:52

Hi Kent,

this article is really useful for newbie like me, just a question on it.Can i add new column inside the existing table?
The purpose i want to do this is to generate extra information like asset tag, department, etc. This will making life more easier for user to gain information. Please advise.

Thanks in advanced.
Chungb
Amnon november 20, 2009 af 6:07

I do not think you can, as these are pre-built tables. I think you can connect create your table and tie it to the database using a third party like MSACCESS or so.
Kent Agerlund november 20, 2009 af 9:59

Hi Amnon,

It’s not a problem creating reports this way. We are not messing up the database only working with the views. Having said that, you can also use other methods like Microsoft Access.
Andrew december 8, 2009 af 3:08

WIth the example of creating the report is there a way to make a report with these software titles and include the Netbios name for the systems that have these programs. Microsoft only. Microsoft Office Enterprise 2007, Microsoft Office Professional Edition 2003,Microsoft Office Professional Plus 2007,Microsoft Office Project Professional 2003,Microsoft Office Project Professional 2007,Microsoft Office Visio Professinal 2003,Microsoft Office Visio Professional 2007,Microsot Ofice Visio Standard 2003,Microsot Ofice Visio Standard 2007.
I tried the example above and was able to get a report for one title but how do I make a report for multiple titles.
karen maj 11, 2011 af 15:57

trying to create the report or a query to make a report with these software titles and include the Netbios name/workstations, etc. for the systems that have these programs. Microsoft only. Microsoft Office Enterprise 2007, Microsoft Office Professional Edition 2003,Microsoft Office Professional Plus 2007,Microsoft Office Project Professional 2003,Microsoft Office Project Professional 2007,Microsoft Office Visio Professinal 2003,Microsoft Office Visio Professional 2007,Microsot Ofice Visio Standard 2003,Microsot Ofice Visio Standard 2007. Please help. Thanks!!!!
como ganhar dinheiro december 22, 2013 af 1:07

I like the valuable info you provide in your articles.

I’ll bookmark your weblog and check again here frequently.
I’m quite sure I will learn many new stuff right here!
Best of luck for the next!
diningsen.com april 24, 2014 af 12:25

Now we visit the most important part of planning a caravan holiday ‘
the budget. Next occasion the thing is a signal saying ‘high end caravans available’ stop and have a
peek. A category of five at the static caravans sale will be looking for a static
that’s capable of sleeping five people.

Der er lukket for kommentarer.

Creating Configuration Manager 2007 Reports – Part II Creating the first report

Share This Story, Choose Your Platform!

Om forfatteren: Kent Agerlund

Beslægtede indlæg

Create fake SCCM Clients with Hardware Inventory

Requirements Not Met ~ Program Rejected (wrong platform)…What Witchery is This?

Identifying Azure AD users with ConfigMgr

SCCM: Improved MDT – “Execute Runbook” Script

Disabling LEDBaT on Your Windows 2016/2019 Server

7 kommentarer