About paultech

paultech · 02-05-2021

There is a chart report Last Windows Update Chart QueryAnd the SQL query is:Select Top 1000000 Case When LastPatchDate.lastPatchDate >= DateAdd(day, -7, GetDate()) Then '1. less than a week' When LastPatchDate.lastPatchDate < DateAdd(day, ...

paultech · 05-27-2015

Hi all,I have put a report together which tells me all of the machines which have 'Event ID 7023'.The report has worked and I can see all the machines, but unfortunately it's showing the each PC multiple times in the report (as each machine has multi...

paultech · 07-08-2014

Hi all,I have put together a quick query to find the DNS server search order, which works ok generally speaking however each PC in the results has 9 additional duplicatesI was wondering if anyone knows how I can remove those duplicate rows with no va...

paultech · 07-02-2013

Hi all,I need to create a report on some machine in an OU in AD which has certain software installed (java/flash/shockwave - to name a few).Annoyingly, I have done this before, but someone deleted the report and I can't remember for the life in me ho...

paultech · 02-05-2021

Thank you for your reply RC62N and my apologies as I didn't explain it very well in my original post so I have just edited it to be more specific.

paultech · 05-28-2015

Thank you RC62N! That's just what I needed - much appreciated.

paultech · 07-08-2014

Thank you very much RC62N, that has worked perfectly

User Statistics

User Activity

Last Windows Update

Remove Duplicate entries from report

Duplicated results in report

Report on installed software based on OU

Re: Last Windows Update

Re: Remove Duplicate entries from report

Re: Duplicated results in report