• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 18762
  • 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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

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