Solved

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

Posted on 2010-08-23
5
17,781 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
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

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
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.​
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

861 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

30 Experts available now in Live!

Get 1:1 Help Now