Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Query Altiris Database for Installed Applications

Updated: 21 May 2010 | 3 comments
Nathan Felton's picture
0 0 Votes
Login to vote

Hello,

Does anyone have an SQL script to query the database to get a list of the software installed on a client? If not, does anyone know which table in the database houses this information so that I can make my own query?

Any help would be appriciated. Thanks!

Comments

kpjernigan's picture
25
Sep
2009
2 Votes +2
Login to vote

Try this.... This will

Try this.... This will list all the software under "Add/Remove Programs" 

Replace the _your_pc_name_here_ with whatever computer name your looking for. 

You could also create a parameter in a report and put that there as well, so anytime you ran the report you could have it prompt for a computer name.

-----------------------------------------------------------------------------------------------------------------------------------------------------

SELECT DISTINCT
vc.[Name],
vc.[User],
vc.[OS Name],
arp.[Name] 'Software Name',
arp.[Version],
arp.[Publisher],
arp.[Install Path]

FROM
vComputer vc
JOIN Inv_Aex_OS_Add_Remove_Programs arp ON vc.[GUID] = arp.[_ResourceGuid]

WHERE
vc.[IsManaged] = '1'
AND vc.[Name] = '_your_pc_name_here_'
-----------------------------------------------------------------------------------------------------------------------------------------------------

-Kev

bhawver's picture
28
Sep
2009
0 Votes 0
Login to vote

Error with above query

Not sure if I am doing something wrong, but I just tried the query above and got the following error:

Msg 208, Level 16, State 1, Line 1
Invalid object name 'vComputer'.

Brian Hawver
Systems Engineer
Yaskawa America, Inc.

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

kpjernigan's picture
28
Sep
2009
2 Votes +2
Login to vote

Sounds like your not running

Sounds like your not running it against the Altiris Database.

put a USE Altiris at the begining, assuming you left the default name for the DB.

-Kev