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:
vbscript:
Policy
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:
Enjoy
Jeffrey J. Riggs
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.
updated file.. try again.. should be working now...
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!
you are correct.. not working for me either... let me take a stab at it...
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
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.
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.
Where can the output of this script be found once it is ran against an existing filter?
i will help ya out in a bit...
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!!!
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