unique values of lines whose
(
    exists
    (
        it as trimmed string
    )
    whose
    (
        it does not end with ",%22Manufacturer%22" AND it does not contain ",%22Microsoft" AND it does not contain ",%22(Standard " AND it does not end with ",%22N/A%22"
    )    
)
of files "info_driverquery_signed.csv" of folders "Logs" of folders "__Global" of
(    
    (
        if
        (
            exists properties whose
            (
                it as string starts with "data folder of " AND it as string contains "client"
            )            
        )
        then
        (
            data folder of client
        )
        else NULL
    )
    |
    (
        folder "/var/opt/BESClient/__BESData"
    )
    |
    (
        folder "/Library/Application Support/BigFix/BES Agent/__BESData"
    )
    |
    (
        folder "__BESData" of parent folder of client
    )    
)

unique values of
(    
    (
        if item 0 of it contains item 1 of it then item 0 of it else item 2 of it
    )
    of
    (
        tuple string item 0 of it, tuple string item 3 of it, tuple string item 3 of it &" "& tuple string item 0 of it ) of concatenations "" of substrings separated by "%22" of concatenations ", " of substrings separated by "," of it
)
of
(
    it as trimmed string
)
of lines whose
(
    exists
    (
        it as trimmed string
    )
    whose
    (
        it does not end with ",%22Manufacturer%22" AND it does not contain ",%22Microsoft" AND it does not contain ",%22(Standard " AND it does not end with ",%22N/A%22"
    )    
)
of files "info_driverquery_signed.csv" of folders "Logs" of folders "__Global" of
(    
    (
        if
        (
            exists properties whose
            (
                it as string starts with "data folder of " AND it as string contains "client"
            )            
        )
        then
        (
            data folder of client
        )
        else NULL
    )
    |
    (
        folder "/var/opt/BESClient/__BESData"
    )
    |
    (
        folder "/Library/Application Support/BigFix/BES Agent/__BESData"
    )
    |
    (
        folder "__BESData" of parent folder of client
    )    
)

unique values of
(
    it whose
    (
        tuple string item 6 of it != "OK" AND tuple string item 6 of it != "Status"
    )
    of concatenations "" of substrings separated by "%22" of concatenations "%22, %22" of
    (
        if it does not contain "," then it else
        (
            concatenations "" of substrings separated by "," of it
        )        
    )
    of
    (
        it as trimmed string
    )
    of substrings separated by "%22,%22" of it
)
of
(
    it as trimmed string
)
of lines whose
(
    exists
    (
        it as trimmed string
    )
    whose
    (
        it does not end with ",%22Manufacturer%22" AND it does not contain ",%22Microsoft" AND it does not contain ",%22(Standard " AND it does not end with ",%22N/A%22"
    )    
)
of files "info_driverquery_verbose.csv" of folders "Logs" of folders "__Global" of
(    
    (
        if
        (
            exists properties whose
            (
                it as string starts with "data folder of " AND it as string contains "client"
            )            
        )
        then
        (
            data folder of client
        )
        else NULL
    )
    |
    (
        folder "/var/opt/BESClient/__BESData"
    )
    |
    (
        folder "/Library/Application Support/BigFix/BES Agent/__BESData"
    )
    |
    (
        folder "__BESData" of parent folder of client
    )    
)

unique values of
(    
    (
        tuple string item 1 of it; tuple string item 2 of it
    )
    of concatenations "" of substrings separated by "%22" of concatenations "%22, %22" of
    (
        if it does not contain "," then it else
        (
            concatenations "" of substrings separated by "," of it
        )        
    )
    of
    (
        it as trimmed string
    )
    of substrings separated by "%22,%22" of it
)
of
(
    it as trimmed string
)
of lines whose
(
    exists
    (
        it as trimmed string
    )
    whose
    (
        it does not end with ",%22Manufacturer%22" AND it does not contain ",%22Microsoft" AND it does not contain ",%22(Standard " AND it does not end with ",%22N/A%22"
    )    
)
of files "info_driverquery_verbose.csv" of folders "Logs" of folders "__Global" of
(    
    (
        if
        (
            exists properties whose
            (
                it as string starts with "data folder of " AND it as string contains "client"
            )            
        )
        then
        (
            data folder of client
        )
        else NULL
    )
    |
    (
        folder "/var/opt/BESClient/__BESData"
    )
    |
    (
        folder "/Library/Application Support/BigFix/BES Agent/__BESData"
    )
    |
    (
        folder "__BESData" of parent folder of client
    )    
)