Latest Windows Update Report - one entry per node

Try this for a custom report

Data source is Windows Nodes

Add the columns you need, but set the install date to use Max aggregation

Thanks for the response but this did not work. 

I'm curious in what way did it "not work" since it will absolutely show you the most recent date that solarwinds knows of for the updates on each windows node on a single line per node.

Here's my column page:

Result (I have roughly 100 nodes so I'm looking for 100 entries, 1 per node.  This result set has 22,000+ rows.):

The columns you added break it since you mix aggregated and non-aggregated data.

Cut it down to just what I showed and it will show the most recent update, you won't be able to include details because there is no meaningful way to max() those strings

If you get into fancy SQL you can correlate the max timestamp with whatever update happened at that time, but that's not going to happen with just the GUI options.

WORKS!  Yup, this will work.  I wished I could get more detail but I have no access to any SQL experts.  I can get by on this for now.  THANKS!!!