Video Screencast Help

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


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.


Comments 2 CommentsJump to latest comment

Zac H's picture

This should get you what you want.

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%'