Hi Stefanie, I would do it this way instead leaving the software file component
piece out of it and using gs_installed_software instead.
SELECT dbo.v_R_System.Name0 AS ComputerName,
dbo.v_GS_INSTALLED_SOFTWARE.ARPDisplayName0 AS SoftwareName,
dbo.v_GS_INSTALLED_SOFTWARE.InstallDate0 AS InstallDate,
dbo.v_GS_INSTALLED_SOFTWARE.ProductVersion0 AS SoftwareVersion
FROM dbo.v_GS_INSTALLED_SOFTWARE INNER JOIN
dbo.v_R_System ON dbo.v_GS_INSTALLED_SOFTWARE.ResourceID =
dbo.v_R_System.ResourceID
WHERE (dbo.v_GS_INSTALLED_SOFTWARE.ARPDisplayName0 = 'google chrome')
Using v_Add_Remove_Programs is a 32 bit client only query…
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of stefaniebur...@verizon.net
Sent: Thursday, December 05, 2013 4:24 PM
To: mssms@lists.myitforum.com
Subject: [mssms] SQL Query Help
When I run this query I have about 10000 records
Select DISTINCT NetBios_Name0, DisplayName0, Version0
From v_Add_Remove_Programs arp
join v_R_System sys on arp.Resourceid = sys.resourceid
--full join v_GS_SoftwareFile SF on SYS.ResourceID = SF.ResourceID
Where DisplayName0 like '%Google Chrome%'
When I run this query I have about 7000 records
Select DISTINCT NetBios_Name0, DisplayName0, Version0, SF.FileName,
SF.FileDescription, SF.FileVersion
From v_Add_Remove_Programs arp
join v_R_System sys on arp.Resourceid = sys.resourceid
full join v_GS_SoftwareFile SF on SYS.ResourceID = SF.ResourceID
Where DisplayName0 like '%Google Chrome%' and SF.FileName like 'Chrome.exe%'
Is there a way to run the first query where it will show me all 10000 records
and just fill in the information for SF.FileName, SF.FileDescription,
SF.FileVersion if it exist and leave it blank
if it does not.
Thanks
Any Help will be highly appreciated.
This message and any files transmitted with it may contain legally privileged,
confidential, or proprietary information. If you are not the intended recipient
of this message, you are not permitted to use, copy, or forward it, in whole or
in part without the express consent of the sender. Please notify the sender of
the error by reply email, disregard the foregoing messages, and delete it
immediately.
P Please consider the environment before printing this email...
