Client Management Suite

 View Only

Custom Inventory for IE Version 

Apr 02, 2014 04:03 PM

Due to XP EOL and Patches not being distributable via Altiris I had to come up with a way to patch IE as we will be receiving the XP updates for one more year (paid service).

I have not learned how to do detection rules or applicability rules yet but it is on my to do list. Hopefully this will help someone.

OS side is easy to do but IE is more difficult as Add Remove Programs does not contain ALL machines with IE versions.

You need to create a custom data class:

  1. All Settings> Discovery and Inventory> Inventory Solution> manage Custom Data Classes
  2. Name MUST BE AeX OS Internet Explorer (or you need to edit the vbs to reflect your name)
  3. Attribute: Version
  4. Data type: String
  5. Size: 50 (left default but you can change)
  6. Key: No
  7. Required: No

DataClass.jpg

vbscript:

  1. Copy in AexOSIE.vbs to your software repository
  2. Add new software item to the catalog
  3. Command line: wscript.exe aexosie.vbs

software.jpg

Policy

  1. Target your machines and schedule to run

 

After the inventories start coming in you then can target. I am planning on doing a dynamic filter that will utilize machines in a specific version of IE then also use the " NOT IN " AddRemove table for the KB

example:

select Guid from vResource where ResourceTypeGuid in 
(select ResourceTypeGuid from ResourceTypeHierarchy 
where BaseResourceTypeGuid='493435f7-3b17-4c4c-b07f-c23e7ab7781f')
and GUID IN
(
Select t2.[ResourceGUID]
FROM [vCollection] t1 inner join
[CollectionMembership] t2 on t1.GUID = t2.CollectionGUID inner join
[Inv_Aex_AC_Identification] t3 on t2.ResourceGUID = t3._resourceGUID
WHERE t1.[Name] = 'Windows XP Computers'
and t2.[ResourceGUID] NOT IN 
( 
select t1._ResourceGuid
from [Inv_AddRemoveProgram] t1
where t1.DisplayName like '%(KB2718523)%'))

That is it. I hope it helps someone else out. I understand this may not be the easiest but it does work. Since I am reading that Patch does the detection rules, that maybe the best approach but until I learn that, this will have to do.

 

Files:

  • AexOSIE.doc - rename to .vbs as this is the custom inventory vbs
  • Internet Explorer Version by Machine.xml - custom report showing machine name and IE version - right click enabled
  • Internet Explorer Version Count.xml - custom report with a simple IE Version and count

Enjoy

Jeffrey J. Riggs

Statistics
0 Favorited
1 Views
3 Files
0 Shares
1 Downloads
Attachment(s)
doc file
AexOSIE.doc   1 KB   1 version
Uploaded - Feb 25, 2020
xml file
Internet Explorer Version by Machine.xml   9 KB   1 version
Uploaded - Feb 25, 2020
xml file
Internet Explorer Version Count.xml   8 KB   1 version
Uploaded - Feb 25, 2020

Tags and Keywords

Comments

May 18, 2016 12:55 PM

I know this is an old thread but I was wondering if anyone could modify the report to show the counts for the major versions? 

 

IE11

IE10

IE9

IE8

etc

 

If anyone can help I would be grateful.

Jul 29, 2014 03:44 PM

updated file.. try again.. should be working now...

 

Jul 29, 2014 03:03 PM

well it is very easy on the report... 

it may have broken when I edited it to remove our server name, acct names... so try this..

 

1. new sql report

2. paste in

select t0.Version, Count(t0.version) as 'Count'
from inv_aex_os_Internet_Explorer t0
Where t0.Version <> ''
group by t0.Version
order by t0.Version

3. give name "Internet Explorer Version Count"

4. save

 

should do it...

let me know and sorry for delay i was on vacation!

Jul 29, 2014 03:00 PM

you are correct.. not working for me either... let me take a stab at it...

 

Jul 17, 2014 11:32 AM

Oops, just realized the question on the same for Chrome was an old question.  Oh well, I already created a report query so here it is in case someone else finds it useful.

SELECT DISTINCT

     ARP.DisplayName AS 'Software Name',

     ARP.[Publisher] AS 'Publisher',

     ARP.[DisplayVersion] AS 'Version',

     COUNT(DISTINCT ARP.[_ResourceGuid]) AS 'Quantity'

FROM [Inv_AddRemoveProgram] ARP

WHERE

ARP.[DisplayName] = 'Google Chrome' and ARP.InstallFlag = 1

GROUP BY

     ARP.[DisplayName],

     ARP.[Publisher],

     ARP.[DisplayVersion]

ORDER BY ARP.[DisplayName] asc, arp.DisplayVersion asc

Jul 17, 2014 10:20 AM

Hey TeleFragger.

Thanks for this, its exactly what I am looking for.  However when I try to import the Computer Count report, I get a error message that is is not a valid XML file.  The report by machine imports and works perfectly.  I looked at the .XML and it looks good to me.  Can you download it and try it to see if you get the same.  If you don't do you have any idea what my problem would be with just that one report?

Thanks again for your time.

 

 

Jun 30, 2014 10:02 PM

I think I may have found where I lost you.. I tell you how to set this up but not how to distribute it..so I will add that later as im at home on a tablet and unable too at this time.

 

do you know how to create a policy to distribute? you specify what machines to target. Personally I would setup a new policy to use the software as listed... and for target I would choose the ALL COMPUTERS filter. Then you got them all..

I guess I missed that step so will add it... try to do tomorrow and I will walk through this to make sure it flows.. sorry for the missed step.

 

Jun 30, 2014 04:01 PM

Where can the output of this script be found once it is ran against an existing filter?

Jun 06, 2014 07:43 AM

i will help ya out in a bit...

May 13, 2014 03:01 AM

Hi TeleFragger!

I am looking for this kind of report too but for google chrome.... Hope you can assist a stranger for this matter.

Thank you in advance!!!

Apr 03, 2014 07:58 AM

Here is the end result in a report. I am very happy with this as now I can target my machines for patches when we receive them (although only IE8 and above will be getting patched!!!) so need to upgrade to at least IE8

 

IECount.jpg

Related Entries and Links

No Related Resource entered.