tutorial on how to create custom reports in SCCM 2007R2
- does anyone know of any website that will give me a tutorial on how to create custom reports in SCCM 2007R2 and are there any SQL query builders using a GUI interface. I believe that is wiat SCCM 2007 reports use.
모든 응답
There are no website or tutorial or tools that will show you how to create reports specific to ConfigMgr, except for what is within the ConfigMgr course 6451.
This article will give you a good start http://myitforum.com/articles/18/view.asp?id=5694 on how to create custom reports within either SMS or ConfigMgr.
http://www.enhansoft.com/- 답변으로 제안됨Tom Watson 2009년 9월 7일 월요일 오후 1:45
- My 2 cents: When I first started out, I cloned existing reports and customized them. Also asked lots of questions. In addition to the above, 3 things:
- Learn what a "subselect" query is. It's powerful and extraordinarily useful.
- For basic reports, check out the reports on Garth's blog. Many of them are a direct result of people's queries in the forums. So often if you need a custom query, Garth may have already posted one in response to a similar request. http://smsug.ca/blogs/garth_jones/default.aspx
- For reports that will make your brain twist, check out http://www.number2blog.com Most of the time it takes me several read-throughs to understand what #2 is doing.
(PS: before Garth somehow twists my words and teases me for calling his reports 'basic', I only mean in comparison to the complex things #2 does! Your reports are great.)
Standardize. Simplify. Automate.- 답변으로 제안됨Tom Watson 2009년 9월 7일 월요일 오후 1:44
- Just want to say thank you for everyone's help and sugguestions. I never used SCCM 2007 R2 before and I was given the task to use SCCM 2007 R2 to create custom reports.
Guess you can call me a newbie to custom reports for SCCM 2007 R2.
I will post more question to ask all the experts.
Thank you - Hi Sherry thanks for the information. Can you tell me what is the clone the existing report? How do I use this feature?
Thank you How to clone: In your console, the +Reporting section, you'll see all of the reports. Pick one you are interested in, right-click and Clone the report. Make sure to give it a unique name.
Now start messing with the new cloned report. Since it's a clone and you're not touching the original, you'll have zero guilt if you mess it up so badly it doesn't even run anymore. :-)
For fun, because the window is small-ish in the report editing section, you may want to copy/paste the SQL code out of that window into at least notepad. If you are more adventurous, you could open up SQL Management Studio, connect to your database, and create a new query, and drop the copied SQL query in there for playing with. Some people find that easier to use/visualize.
Standardize. Simplify. Automate.- 답변으로 제안됨Tom Watson 2009년 9월 9일 수요일 오후 1:58
- Hello Sherry or anyone who can help me.
was wondering how would I make this typecustom report that will list out these software titles from one specific collection. One separate collection name is 00-Regional-Southeast Computers
I only found this SQL statement online which was pretty close. I don't want the report to prompt me for the information. I'm new at SCCM 2007 and don't have much experience with SQL.
Here is the SQL statement in the Report SQL Statement window
Select distinct sys.Netbios_Name0, fcm.SiteCode, sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0
FROM v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE DisplayName0 = @displayname and fcm.CollectionID=@CollID
ORDER BY sys.Netbios_Name0
In the Report display SQL after I click on the prompt button here is the Report SQL statement. These are the software tiles I want listed.
begin
if (@__filterwildcard = '')
Select DISTINCT DisplayName0 FROM v_Add_Remove_Programs
where DisplayName0 in ('Microsoft Office Visio Standard 2003','Microsoft Office Visio Standard 2007',
'Microsoft Office Visio Professional 2007','Microsoft Office Visio Professional 2003',
'Microsoft Office Project Professional 2003', 'Microsoft Office Project Professional 2007',
'Microsoft Office Project Standard 2003','Microsoft Office Project Standard 2007',
'Microsoft SQL Server 2005','Microsoft SQL Server 2008',
'Microsoft SQL Server 2005 (64-bit)','Microsoft SQL Server 2008 (64-bit)','Adobe InDesign CS3','Adobe Photoshop Elements','FAS 100 Asset Accounting','Dreamweaver 4','Keyboard Express 3','QuickBooks Pro 2007', 'Macromedia Dreamweaver MX 2004','CNDDB RareFind3','Traffix for Windows 8.0','ANOMS 8','Microsoft Office SharePoint Designer 2007','Microsoft Office SharePoint Server 2007',
'Microsoft Office Professional Edition 2003','Microsoft Office Enterprise 2007','Microsoft Office Professional Plus 2007')
or DisplayName0 like ('%Adobe% %Acrobat% %Standard%')
or DisplayName0 like ('%Adobe% %Acrobat% %Professional%')order by DisplayName0
else
Select DISTINCT DisplayName0 FROM v_Add_Remove_Programs
WHERE DisplayName0 like @__filterwildcard
order by DisplayName0
end
Seems like the report does prompts only. Is it possible to make a report I wanted or I can only do the report with prompts.
Thank you - I'm confused with that one. It looks like the Prompt is looking for a collection ID (fcm.CollectionID=@CollID ), but the prompt's SQL statement is listing a bunch of apps, matching certain applications.
Is it the prompt for collection you don't want?
Regards,
Tom Watson,
E-Mail: Tom_...@...
Blog: http://myitforum.com/cs2/blogs/tom_watson - Hello Tom
basically the report has to show all licensed software for the entire company. I want to run the report without any prompts.
The colums on the report has to show Netbios name,Site code, Username, Operating system,Display name (which is the name of the product) Unfortunately I don't know any SQL to make these reports so I need outside help to show me step by step on how to create a custom report.
Here is the list of the only software titles that needs to be on the report.
Microsoft Office 2007
Adobe Acrobat 7.0 Professional
Adobe Acrobat 7.0 Standard
Adobe Acrobat 7.0.5 Professional
Adobe Acrobat 7.0.9 Professional
Adobe Acrobat 7.1.0 Professional Standard
Adobe Acrobat 8 Professional
Adobe Acrobat 8 Professional
Adobe Acrobat 8.1.0 Professional
Adobe Acrobat 8.1.1 Professional
Adobe Acrobat 8.1.2 Professional
Adobe Acrobat 8.1.3 Professional
Adobe Acrobat 8.1.4 Professional
Adobe Acrobat 8.1.6 Professional
Adobe Acrobat 8.1.7 Professional
Adobe InDesign CS3
Adobe Indesign CS 3
Adobe Photoshop Elements
FAS 100 Asset Accounting
Keyboard Express 3
Macromedia Dreamweaver MX 2004
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 Professional 2003
Microsoft Office Visio Professional 2007
Microsoft Office Visio Standard 2003
Microsoft Office Visio Standard 2007
Quickbooks Pro 2007
Traffix for Windows 8.0
- Is there a report that is already on SCCM 2007 that I can clone for my customizaiton report. What SQL statement can I use.
Microsoft has created a tutorial on how to created custom reports. It is chock full of information including SQL table schematic. Go here young man: http://www.dario.co.il/blog/?p=366 Download the msi and get busy!
- Hey Garth, check out this link skippy. http://www.dario.co.il/blog/?p=366 download the msi.
Hey Garth, check out this link skippy. http://www.dario.co.il/blog/?p=366 download the msi.
Thanks but I acutally help write the excel sheet and it should be donwload from the MS site directly as it does get updated from time to time. http://www.microsoft.com/downloads/details.aspx?FamilyId=87BBE64E-5439-4FC8-BECC-DEB372A40F4A&displaylang=en
http://www.enhansoft.com/
