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.
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?
Ah - let me try that again. I'm not sure the query will be efficient, but it's below.
I just tested with the below query and it seemed to function as expected. I based it off the AntiVirus query.
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.