Finally the help of IT is here

Blog of computer solutions.

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"

 

$ Report = @ ()

 

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"

$ Report = @ ()

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 »

How to make a SQL query from a command line in WSUS.

Posted by Xaus Xavier Nadal 28th on February 2010

Good.

Following the above 3 items ...

As for me it is not enough to make a SQL query from the WSUS server for missing patches for teams going to do to send me an email with the list of patches installed equipment.

To do this I need to do the query from the command line to automatically generate me a file and send it to me by email.

SQLWSUS_13

First of all we need the utility Microsoft SQL Server Native Client y Microsoft SQL Server Command Line Query Utility 2005.

Megacrack read »

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