Finally the help of IT is here

Blog of computer solutions.

Archive for the 'Windows Update Services' Category

How to upgrade hundreds of computers from one centralized console

Move ServicePack files directory

Posted by sjgasca 14th on August 2012

If you ever you have found that you have little space available on the drive Operating System of a server, there are some maintenance tasks that can be performed to remove unnecessary files (delete folders that begin with C: \ Windows \ system32 \ $ *, run a cleaning utility like CCleaner, etc. ..).

In this case I will give a small tip to get rid of the space occupied by the c: \ windows \ ServicePackFiles \ which by default is saved in the system unit. This little trick only works if we have an additional partition (D :). Megacrack read »

tags: , , , , , , , , ,
Posted by microsoft, Windows, Windows Update Services | No Comments »

Solution to Slow to open Excel remotely.

Posted by Xaus Xavier Nadal 10th on August 2011

Good,

Today I found that several teams that had installed them KB2501584 They had problems opening excel remote causing the crash and finally opening the excel file.

This only happens with Excel 2003.

The problem in this patch (Microsoft Office File Validation).

To solve the problem of slowness you must follow this procedure:

1. Excel salt.

2. Home, Click on Run, writes regedit and then click ACCEPT.

3. Place yourself in HKEY_CURRENT_USER \ Software \ Policies \ Microsoft \ Office \ 11.0 \

4. After you select the key that is specified in step 3, select New -> Key.

5. Writes Excel, And then press ENTER.

6. XNUMX. Selecciona Select Excel, Select New -> Key.

7. Writes Security, And then press ENTER.

8. XNUMX. Selecciona Select Security, Select New -> Key.

9. Writes FileValidation, And then press ENTER.

10. XNUMX. Selecciona Select FileValidation, Select New -> DWORD value.

11. XNUMX. Tipo Type EnableOnLoad, And then press ENTER.
Note: The default is 0, which disables validation.

12. XNUMX. En el In the Archive menu, click Logoff to exit the Registry Editor.

Excel test again and now it will be opened up as fast as before applying the patch.

You can also make an export entry after creating it and store it. Reg that you will perform in the devices with the same problem.

Until next time.

tags: , , , , , , , ,
Posted by Windows Update Services | 1 Comment »

How to list approved patches and necessary equipment WSUS in Powershell

Posted by Xaus Xavier Nadal 21st on October 2010

Good,

Today in Article Powershell script to get Listed below patches in WSUS I showed you a script that makes us a list of all the patches needed for equipment and today I show a small modification by Albert Fortes in the code that manages to get this same list but approved patches.

That is, a list of patches Approved needed.

With this we get to see the patches that are missing from the equipment and we have previously approved for distribution from wsus.

[Reflection.assembly] :: LoadWithPartialName ( "Microsoft.UpdateServices.Administration")

 

$ Wsus = [Microsoft.UpdateServices.Administration.AdminProxy] :: GetUpdateServer ( "localhost", $ false);

$ Computers = $ wsus.GetComputerTargets ()

$ Path = \ \

$ Computername =gc env: computername

$ FileOutput =get-date -uformat "ReportWsus_% d_% m_% Y_ $ computername.html"

 

[Email protected]()

 

Total = $ $ Computers.Count

 

$ I = 0

 

clear host

 

foreach ($ computer in $ Computers)

{

$ UpdateScope = new-object Microsoft.UpdateServices.Administration.UpdateScope;

$ UpdateScope.UpdateApprovalActions = [Microsoft.UpdateServices.Administration.UpdateApprovalActions] :: Install `

-Bor [Microsoft.UpdateServices.Administration.UpdateApprovalActions] :: Uninstall

 

$ UpdateSummary = $ {computer}. GetUpdateInstallationSummary ($ UpdateScope)

 

$ Count = $ UpdateSummary.NotInstalledCount + $ UpdateSummary.DownloadedCount + $ UpdateSummary.FailedCount

$ Report_element = new-object psobject

$ Report_element | add-member NoteProperty "Computer" $ {computer} .FullDomainName

$ Report_element | add-member NoteProperty "NeededUpdates" $ Count

$ Report_element | add-member NoteProperty "LastUpdateSync" $ {computer} .LastSyncTime.ToString ()

$ Report + = $ Report_element

$ I = $ i + 1

$ Percent = ($ i / $ total * 100)

 

Write-Progress -Activity "WSUS query ..." `

-Status "Wait a little more." -CurrentOperation ( "Complete $ i / total $") -PercentComplete ($ i / $ Total * 100)

}

 

Clear host

 

$ Report | sort NeededUpdates | ConvertTo-Html | Out-File -FilePath "$ Path $ FileOutput"

If you have any question please make a comment and I will solventaré delighted.

See you soon MegaCracks.

tags: , , , , , , , , , ,
Posted by PowerShell, Windows Update Services | 1 Comment »

Powershell script to get listed by HTML patches in WSUS.

Posted by Xaus Xavier Nadal 20th on October 2010

Go longest title not ???.

Here you have a script created by Albert Fortes and modified by me that does the following:

This script is connected locally to our WSUS server and performs a query and a sum of the result of NotInstalled patches, and Failed Downloaded from each team and generates a .html file with the team name, patches sorted by the result of required patches and last contact and stores it in a file called ReportWsus_dia_mes_año_NombredeServidor.html located in a network folder that you indicate in the variable $ path.

The script is as follows:

[Reflection.assembly] :: LoadWithPartialName ( "Microsoft.UpdateServices.Administration")

 

$ Wsus = [Microsoft.UpdateServices.Administration.AdminProxy] :: GetUpdateServer ( "localhost", $ false);

$ Computers = $ wsus.GetComputerTargets ()

$ Path =\\ <Servidor_donde_guardar_el_report>

$ Computername =gc env: computername

$ FileOutput =get-date -uformat "ReportWsus_% d_% m_% Y_ $ computername.html"

[Email protected]()

Total = $ $ Computers.Count

$ I = 0

 

clear host

 

foreach ($ computer in $ Computers)

{

$ UpdateSummary = $ {computer} .GetUpdateInstallationSummary ()

$ Count = $ UpdateSummary.NotInstalledCount + $ UpdateSummary.DownloadedCount + $ UpdateSummary.FailedCount

$ Report_element = new-object psobject

$ Report_element | add-member NoteProperty "Computer" $ {computer} .FullDomainName

$ Report_element | add-member NoteProperty "NeededUpdates" $ Count

$ Report_element | add-member NoteProperty "LastUpdateSync" $ {computer} .LastSyncTime.ToString ()

$ Report + = $ Report_element

$ I = $ i + 1

$ Percent = ($ i / $ Total * 100)

Write-Progress -Activity "WSUS query ..." `

-Status "Wait a little more." -CurrentOperation ( "Complete $ i / total $") -PercentComplete ($ i / $ Total * 100)

}

 

Clear host

 

$ Report | sort NeededUpdates | ConvertTo-Html | Out-File -FilePath "$ Path $ FileOutput"

This script can save it in a file . Ps1 within the WSUS server and run from powershell. You can even create a scheduled task to run this program and generate the file on a network path every day for your security team can have a report where you can see how many teams are missing patches.

Curiosities of the script:

How to get the computer code in powershell ?: Use the command gc env: computername

 

How to create a file with the formatted date?: $ FileOutput -uformat = get-date "text% d% m% Y" get with it get "text 20 10 2010" to make a pipeline of Out-File to a new variable called $ such as parameter passing and Report - FilePath "$ FileOutput" get to have a file formatted as we want.

If you have any problem or something you doubt please send me a comment and I solventaré enchanted.

See you soon MegaCracks

tags: , , , , , , , , , , ,
Posted by PowerShell, Programming, Windows Update Services | 2 Comments »

How to resolve duplicate ID problem in WSUS clients

Posted by Xaus Xavier Nadal 21st on March 2010

Good.

In many cases within a corporate environment where you have a lot of clones assembled from teams we find that there are duplicate ID's of programs such as antivirus agent or even the WSUS client.

In this article I show how to solve a problem that causes that not all computers in the domain to which we have included in the WSUS server to be displayed correctly. This may be because several teams have the same WSUS client ID appears sometimes causing only one team from each 10 because of this duplication of ID.

Megacrack read »

tags: , , , , , ,
Posted by VbScript, Windows Update Services | No Comments »