Jump to content

Missing Patches - Filter Duplicate Entries

Recommended Posts

Is there any way to filter the missing patches dataview so that an agent will only show up once in the list if it has any missing patches at all, rather than multiple times (once for each missing patch)?

Share this post

Link to post
Share on other sites

I'll assume that you are comfortable with the thought of manually manipulating a Dataview definition in SQL.. There is no way to do it though the UI.

The only way to have the agent only show on one line would be to get all the patch information to show in a single field. That won't work properly if you have a column for the patch KB, a column for the hotfix id, a column for the support URL, a column for the name, the description, the OS, etc..... 

BUT, if you had a dataview that permanently did not include any extra fields unique to the patch except the name or KBID, you could replace that field (something like 'hotfix.kbid AS `KBID`' now probably) with "GROUP_CONCAT(CONCAT('KB',hotfix.KBID) SEPARATOR ',') AS `KBIDList`"  ... That isn't exact, and probably won't work right, but the GROUP_CONCAT function is the key.. See https://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_group-concat for more information on it.

If you aren't familiar/comfortable with SQL, then it might be best to forget I said anything.. Dataviews are complicated and easy to break.  BUT, what you asked about just might be possible...


Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...