Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Query Builder - Hardware specific

Created: 14 Oct 2012 • Updated: 15 Oct 2012 | 2 comments
This issue has been solved. See solution.

Hi all I am trying to convert the following query from NS6.5 to NS7.1.

When we had NS6.5 I used to create a package for a specific driver then use a query on the collection for the models that required the driver.

Example Below:

Filters by:

Inv_aex_hwSerial_number - computer model = Latitude E6520

Inv_AeX_OS_Operating_System - OS name= Windows 7

Inv_Aex_Operating_Architecture=64

The trouble is I cannot convert this in NS7.1 the sql code from ns6.5 does not work in NS7.1 and I am really finding the query builder in NS7.1 difficult to get correct - especially for finding the models!!!

Any help appreciated.

Catherine

Comments 2 CommentsJump to latest comment

Zac H's picture

This should get you what you want.

SELECT *
FROM vComputer vc
INNER JOIN vHWComputerSystem hw
ON vc.Guid = hw._ResourceGuid
WHERE hw.Model LIKE '%Latitude E6520%'
AND vc.[OS Name] LIKE '%Windows 7%'
AND vc.[System Type] LIKE '%64%'
SOLUTION