Hi All,
I am hoping someone can help me out.
What I am trying to achieve is to limit the existing "Software: All installed software" report that already exists on Lansweeper, to assets only "Last seen" within the last 4 months (120 days or so).
I've tried to do this a few different ways but have ended up with the pretty much the same error over and over again: "Column 'tblAssets.Lastseen' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."
Any assistance would be very much appreciated.
Thanks
