Query Altiris Database for Installed Applications
Nathan Felton
September 25th, 2009
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!
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
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'.
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
Would you like to reply?
Login or Register to post your comment.