Quote:
Originally Posted by FrankMM
Thanks a lot for your solutions. They are very helpful. Would have been nice if i'd get not so much hits - but one cant have enough information. If you have any idea how to reduce this for insatance only to applications shown in 'Start-Settings-Control Panel-Software' it would be nice.
As you might have noticed i'm pretty new to this. Therefore info about good links/documentation regarding sql(xml)-queries (and how to learn) is very welcome.
Thanks again to both of you for your replies.
Frank
|
im fond of this bit o code...
Select a.Name, a.version,Count(a.name)
From [inv_aex_os_add_remove_programs] a
--Change below line to find app
Where [name] LIKE'%ITUN%'
Groupby a.Name, a.version
so guess what my task next week is!!!!!!!! 
example here
name version count of machines
iTunes 4.7.1.30 1
iTunes 6.0.2.23 1
iTunes 6.0.4.2 1
iTunes 7.1.1.5 3
iTunes 7.2.0.35 1
iTunes 7.3.2.6 1
iTunes 7.6.2.9 3
iTunes 7.7.0.43 1
iTunes 7.7.1.11 3
iTunes 8.0.0.35 4
iTunes 8.0.1.11 5
iTunes 8.0.2.20 12
iTunes 8.1.0.51 1
iTunes 8.1.0.52 1
iTunes 8.1.1.10 9
iTunes 8.2.0.23 5
