SQL Report - All Computers That Are Members Of A Specific Collection

Comments

1 comment

  • Colby Bouma
    1. This turns out to be a decent size query because multiple joins are required. I created an example SQL Report, but "PDQInventory.exe GetCollectionComputers" is WAY easier.
    2. Thank you for the feature request. It’s important, as we've been a customer-driven product since the beginning. I've made a note of the request, but cannot provide a timeline when, or if, the request will be approved or, if approved, with what version.
    SELECT
    Computers.ComputerId
    , Computers.Name
    FROM
    Computers
    INNER JOIN
    CollectionComputers ON Computers.ComputerId = CollectionComputers.ComputerId
    INNER JOIN
    Collections ON CollectionComputers.CollectionId = Collections.CollectionId
    WHERE
    Collections.Path = 'Collection Library\Applications\Imaging\GIMP\GIMP (Latest)'
    AND
    CollectionComputers.IsMember = 1
    AND
    <ComputerFilter>
    0
    Comment actions Permalink

Please sign in to leave a comment.