FrankMM

Hi,
i tried to find a report where only the software listed in add/remove programs is shown with reference to the computers - needless to say - without success.
Do i have to create a record on my own? - How would it look like?

Thanks for your assisstance.
Frank

seabrig29

how detailed do you want your report? I was sure there was an add remove program report but anyway, I've attached a report in XML. I cant remember where I got it from but its been around a while. Just download and import to the folder you want. if the import doesnt work you should be able to tweak the code to your liking.

Attached Files

Add_Remove Programs Search.xml (9.1 KB, 50 views)

FrankMM

Thank you very much for your reply and attachement. Application Name+Version, Manufacturer and Computername would be absolutely sufficient for now. Sadly i could not import your query, so i have to take a closer look at it. I'm using NS ver6.5. Maybe that's where the problem comes from.

PWenham

Something like this? (edit out the where clause if you want to see all computers, beware - this will be large!)

seabrig29

Dont know why my report didn't import. It also am using 6.5 so this is the quick and dirty list, no frills. But I think between this and the other report you can build something that is to your liking as a working report.
copy this into a new report

--start sql
select t1.name as 'computer name', t0.name, t0.version, t0.publisher as 'manufacturer' from Inv_AeX_OS_Add_Remove_Programs t0
inner join vcomputer t1 on t0._resourceguid = t1.guid
--end sql

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

JeffreyJRiggs

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

__________________
SQL Fundamentals 101:
SELECT * FROM dbo.User WHERE Clue > '0'
Query batch completed, 0 rows

FrankMM

Hi,

thanks to all you. This three solutions make good work for me. I get the information i need (and more) and can focus on the software i'm up to.

@Jeffrey: Hope you were successful with your deployment. I'm at the beginning - guess what i am up to

abrezina

@Mr. Riggs

That query is awesome! I am just starting to get back into SQL, and this is the first time I ever used Altiris and that code will help me figure out so many reports! Thank you!

Vladko

Here's one with a dropdown menu:


SELECT DISTINCT T1.[NAME] AS 'Workstation', %PName% as 'Product Name'
FROM [vResource] T0
INNER JOIN [Inv_AeX_AC_Identification] T1 on T0.[Guid] = T1.[_ResourceGuid]
WHERE T0.[GUID] IN
(SELECT _ResourceGuid
FROM [Inv_AeX_OS_Add_Remove_Programs] T2
WHERE T2.[Name] LIKE %PName%)