[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 18628
  • Last Modified:

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

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
raddermant
Asked:
raddermant
  • 3
1 Solution
 
matrixnzCommented:
Why not just use Report: Computers with a specific file?  with iexplore.exe as the File name?
0
 
raddermantAuthor Commented:
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
 
matrixnzCommented:
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
 
ssnetworkCommented:
this report will ONLY show IE7 and up....IE6 was included in the winxp and doesn't show up in Add/Remove programs
0
 
matrixnzCommented:
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now