1
0
-1

I would like to display all devices that DO NOT have a value associated with it. An example of this would be to find all devices that do not have KB4012215 in their list of installed software.

  1. Rick Wegner

    I've looked at the Installed-AntiVirus query and I have attempted to search for the Microsoft update KB entries against the software.name. So I created a new queary based off Installed-AntiVirut with the only change I made was to substitute the '%virus%' etc. with '%KB4012212%' but nothing is found, the Software Name column is empty . Are the KB entries stored in a different table/field than software.name?

CommentAdd your comment...

2 answers

  1.  
    1
    0
    -1

    Ah - let me try that again. I'm not sure the query will be efficient, but it's below.

      CommentAdd your comment...
    1.  
      1
      0
      -1

      I just tested with the below query and it seemed to function as expected. I based it off the AntiVirus query.

      1. Rick Wegner

        I replaced the Select statement from the Installed-AntiVirus query with the one provided but I am still getting a report with the Software Name column blank with all computers listed. In the AntiVirus query the Software Name column is a linked to /report/specific_software/$group_id and a column secondary equal to software.id. I tried it with column_type equal to text with the link and secondary blank but Software Name remains blank. I'm sure I am missing something basic.

      CommentAdd your comment...