Solved

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

Posted on 2010-08-23
5
17,646 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
  • 3
5 Comments
 
LVL 29

Accepted Solution

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

Author Closing Comment

by:raddermant
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

The question has been asked on multiple occasions as to how best to do printing in a remote desktop or terminal services environment.   It seems that this particular question has plagued several people and most especially as Terminal Services, as…
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 is around source server preparation. No migration is an easy migration, there is a…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now