Video Screencast Help

Need SQL query

Created: 17 Mar 2013 • Updated: 23 Apr 2013 | 5 comments
This issue has been solved. See solution.

Hello,

Currently i am using symantec managemant 7.1 ,I need one sql query to find the installed sofware.

Eg - Microsoft Office

Please provide that type sql query

 

Comments 5 CommentsJump to latest comment

zafar1907's picture

 

 

Hello

Check the DouglasDunphy comment on below pasted forum

https://www-secure.symantec.com/connect/forums/installed-software-query

Thanks and Regards,

Mohammad zafar

Please Mark as solution if this comment solved your Issue....

consoleadmin's picture

Check it. May be it can help you. Try it.

SELECT vc.Guid, vc.Name AS ComputerName, arp.DisplayName, arp.DisplayVersion, vu.Name AS UserName, vu.Department

FROM vComputer vc
RIGHT JOIN (SELECT DISTINCT Name FROM vComputer) AS vc1
ON vc1.Name = vc.Name
INNER JOIN Inv_AddRemoveProgram arp ON vc.Guid = arp._ResourceGuid
INNER JOIN vUser vu ON vc.[User] = vu.Name
WHERE arp.DisplayName LIKE 'Microsoft Office Proffesional Plus 2010%' AND arp.InstallFlag=1
 
 
Note : You can Change Software name Like :'Microsoft Office'
 
 
Forum for your help

https://www-secure.symantec.com/connect/forums/creating-software-installed-report

https://www-secure.symantec.com/connect/forums/how-get-report-altiris-71

Thanks.

SOLUTION
Sachin Sawant's picture

SELECT
vc.Guid,vc.Name, arp.DisplayName,arp.DisplayVersion
FROM
vComputer vc
JOIN
Inv_AddRemoveProgram arp ON arp._ResourceGuid=vc.Guid
WHERE
DisplayName LIKE 'Microsoft Office%' AND arp.InstallFlag=1
 

Ambesh_444's picture

Hi,

Please check with this...

You can Change Software name Like :'outlook or any software....

 

 

SELECT vc.Guid, vc.Name AS ComputerName, arp.DisplayName, arp.DisplayVersion, vu.Name AS UserName, vu.Department

FROM vComputer vc
RIGHT JOIN (SELECT DISTINCT Name FROM vComputer) AS vc1
ON vc1.Name = vc.Name
INNER JOIN Inv_AddRemoveProgram arp ON vc.Guid = arp._ResourceGuid
INNER JOIN vUser vu ON vc.[User] = vu.Name
WHERE arp.DisplayName LIKE 'Microsoft Office%' AND arp.InstallFlag=1

 

 

Thank& Regards,

Ambesh

"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."

Sumit G's picture

Find Machines with Software - Add Remove

SELECT DISTINCT dbo_Inv_AeX_AC_Identification.Name, dbo_Inv_AeX_OS_Add_Remove_Programs.Name, dbo_Inv_AeX_AC_Identification.[_ResourceGuid], dbo_Inv_AeX_AC_Identification.[System Type]
FROM dbo_Inv_AeX_AC_Identification INNER JOIN dbo_Inv_AeX_OS_Add_Remove_Programs ON dbo_Inv_AeX_AC_Identification.[_ResourceGuid] = dbo_Inv_AeX_OS_Add_Remove_Programs.[_ResourceGuid]
WHERE (((dbo_Inv_AeX_OS_Add_Remove_Programs.Name) Like [Program Name]) AND ((dbo_Inv_AeX_AC_Identification.[System Type]) Like "win*"));

Regards

Sumit G.