?
Solved

SCCM Custom Report to show all Internet Explorer versions in one report

Posted on 2010-08-23
5
Medium Priority
?
18,299 Views
Last Modified: 2013-11-21
I'm looking for a custom report to return the version of Internet explorer installed on each workstation. I have a standard query that returns what I want, but I don't know how to convert it to a report. The canned SCCM reports allow gathering a separate report for each version of IE, like v5, v5.5, v6, v7, v8, but I need one report. The Standard SCCM query I have that returns what I want is:

select SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_G_System_SoftwareFile.FileName, SMS_G_System_SoftwareFile.FileVersion, SMS_G_System_SoftwareFile.FilePath from  SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FilePath = "C:\\Program Files\\Internet Explorer\\" order by SMS_R_System.Name

I need a custom report to return this information.

Thanks very much.
0
Comment
Question by:raddermant
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 29

Accepted Solution

by:
matrixnz earned 1000 total points
ID: 33509721
Why not just use Report: Computers with a specific file?  with iexplore.exe as the File name?
0
 

Author Closing Comment

by:raddermant
ID: 33510621
LOL You're right. Why not? Works fine and a simple solution thanks! (Only complaint is it returns results for all systems. I'd like to be able to limit it to a collection.)
0
 
LVL 29

Expert Comment

by:matrixnz
ID: 33515017
Hi Raddermant

To return results from a specific collection, clone the report "Computers with a specific file" for example "Collections with a specific file".
Edit the Report
Click Prompts
Add New Prompt
Enter Name: CollID
Enter Prompt Text: CollectionID
Check Provide a SQL statement
Paste the code below
Click OK x 2 to go back to the Report SQL Statement
Add the following information after join v_R_System SYS on SYS.ResourceID = SF.ResourceID

join v_FullCollectionMembership fcm on SF.ResourceID=fcm.ResourceID
where SF.FileName LIKE @variable and fcm.CollectionID = @CollID
Order by Sys.Netbios_Name0

You should now be able to run the report and select both the filename and collection.

Cheers
begin
if (@__filterwildcard='')
select CollectionID, Name from v_Collection order by Name
else
select CollectionID, Name from v_Collection
where CollectionID like @__filterwildcard
order by Name
end

Open in new window

0
 

Expert Comment

by:ssnetwork
ID: 34706301
this report will ONLY show IE7 and up....IE6 was included in the winxp and doesn't show up in Add/Remove programs
0
 
LVL 29

Expert Comment

by:matrixnz
ID: 34747160
ssnetwork the report above doesn't refer to Add/Remove Programs at all, it's using the version of the file iexplore.exe which is gathered during file inventory.

Cheers
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip Migration Tip #1 – Source Server Health can be found here: http://www.experts-exchang…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question