Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Help with query

Created: 26 Jun 2013 • Updated: 28 Jun 2013 | 4 comments
This issue has been solved. See solution.

WITH Installations (Guid) AS

(SELECT DISTINCT ar.[_ResourceGuid]

from RMV_AddRemove ar

where

(ar.[Product Name]='Websense Endpoint' AND ar.[Version]='7.6.1106')

OR

(ar.[Product Name]='Websense Endpoint' AND ar.[Version]='7.6.1126')

)

SELECT vc.[Guid]

,vc.[User] [Primary User]

, vc.[Name] [Computer Name]

, vc.[OS Name]

, vc.[OS Revision]

, vc.[Domain]

, cs.[Manufacturer]

, cs.[Model]

, cs.[Identifying Number] [Serial Number]

, p.[Processor Name] [Processor]

, cs.[Total Physical Memory (Bytes)] / 1048576 [RAM (MB)]

, vi.[Name] [Location]

FROM vComputer vc

LEFT OUTER JOIN ResourceAssociation loc

ON (loc.ChildResourceGuid = vc.Guid OR loc.ParentResourceGuid = vc.Guid) AND loc.ResourceAssociationTypeGuid = '05DE450F-39EA-4AAE-8C5F-77817889C27C'

LEFT OUTER JOIN vItem vi

ON loc.ChildResourceGuid = vi.Guid

LEFT OUTER JOIN Inv_HW_Processor_Name_Windows p

ON vc.Guid = p._ResourceGuid

LEFT OUTER JOIN vHWComputerSystem cs

ON vc.Guid = cs._ResourceGuid

LEFT OUTER JOIN Installations i

ON i.Guid = vc.Guid

WHERE i.[Guid] IS NULL

and vc.[IsManaged] = 1 AND vc.[OS Name] not like '%server%'

ORDER BY vc.[user]

If I change these lines:

where

(ar.[Product Name]='Websense Endpoint' AND ar.[Version]='7.6.1106')

OR

(ar.[Product Name]='Websense Endpoint' AND ar.[Version]='7.6.1126')

to:

where

(ar.[Product Name]='Websense Endpoint' AND ar.[Version]='7.6.1138')

The results returned are incorrect. I am assuming this is an easy fix? Can someone help?

Thanks.

Operating Systems:

Comments 4 CommentsJump to latest comment

HighTower's picture

Is this a new version of the software you've deployed?  If so, did the software inventory run on all of your computers yet?

SOLUTION
Villem's picture

I'm assuming the number of rows is incorrect, thus the amount of clients shown as having this version is incorrect. I agree with HighTower- make sure software inventory has been gathered. You can check this from resource manager- take any client you expect to see when running the query and see when was the last time inv_addremoveprogram (as this is the table your view is using) was updated.

SOLUTION
Briandr88's picture

Software that has yet to be deployed. I thought about this after the fact. So the query is probably correct.

Thanks.

HighTower's picture

Also, do you use targeted software inventories?

If not the idea is to build those so you get an earlier sense of the results of your software deployment without having to wait for your regular software inventory to run. You'd use the same detection rule that you have built into your software resource.