Client Management Suite

 View Only

  • 1.  Query Builder - Hardware specific

    Posted Oct 14, 2012 06:51 PM

    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



  • 2.  RE: Query Builder - Hardware specific
    Best Answer

    Posted Oct 15, 2012 11:17 AM

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


  • 3.  RE: Query Builder - Hardware specific

    Posted Oct 16, 2012 12:24 AM

    Thanks Zac - works perfectly