→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bocsg
Engaged Sweeper
Hi,

May I know is there a way to collect all the MS Patches for all the PCs in our network?

Thanks and Regards,
8 REPLIES 8
bocsg
Engaged Sweeper
Hi there,
any suggestion ? appreciated.
bocsg
Engaged Sweeper
Hi there,
How do i get the report updated. there're some PCs which I phsically checked found that they had installed with patches. but these PCs are not shown in the report. I've checked the PC last seen status which is the latest date. I had also redo the output but to no avail.

Thanks.
Hemoco
Lansweeper Alumni
bocsgit01 wrote:
Hi there,
How do i get the report updated. there're some PCs which I phsically checked found that they had installed with patches. but these PCs are not shown in the report. I've checked the PC last seen status which is the latest date. I had also redo the output but to no avail.

Thanks.

Did you also check the last scanned date for "quickfixengineering"?
Most likely the waittime is set to a couple of days.
bocsg
Engaged Sweeper
Hi there,
Thank you for your prompt reply. It works like a charm.
Hemoco
Lansweeper Alumni
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Userdomain, tblComputers.Username
From tblComputers
Where
tblComputers.Computername Not In (Select tblQuickFixEngineering.Computername
From tblQuickFixEngineering
Where tblQuickFixEngineering.HotFixID = 'KB2544893')
bocsg
Engaged Sweeper
Hi there,
I've based on the tblquickfixengineering to build a report, but it doesn't show what I want.Would that be possible to say list out only those computers which does not have the patch 'kb2544893' installed ?

Please reply asap as I need this urgently.

Thanks.
bocsg
Engaged Sweeper
Can you tell me the detail steps ?

thanks and regards
Hemoco
Lansweeper Alumni
You need a report based on table "tblquickfixengineering"