LGarvin

Now, just to be sure I am pulling the data from the correct dates, is there a way to post the @StartDate, and @EndDate in the report, either in the title of the report, or in a column? Yes. You could force it into additional columns of the report on every row, such as DECLARE @StartDate DATETIME, @EndDate DATETIME SET…

in my SQL 2008 R2 environment, when using the final calculation WHERE DateTime >= DATEADD(month, DATEDIFF(month,0,GETDATE()), -1) + 15 AND DateTime < DATEADD(month, DATEDIFF(month,0,GETDATE()), 0) + 15 It does not return any results... Any ideas? Argh.. a transcription error when I copied the DATEDIFF() function calls.…

It also occurred with the Java 7 update 45 packages from Solar Windows from last week. A WindowsUpdate.log showing this installation/restart event would be helpful. For the Java packages and the one from yesterday (Google Apps Sync for Microsoft Outlook) the packages within Package Manager were configured with “Normal” for…

The WSUS console on the 2003r2 Shows version 3.2.7600.274 for this Server, but in the programs/software list (programs and Features in Server 2008 r2) the KB2720211 is listed as removed (and this isn't removable). Okay.. first note. If the WSUS server is 3.2.7600.274, then it no longer has KB2720211 (v3.2.7600.251)…

This option I found for Removal within WSUS appears to working. I'm pleasantly surprised to hear that this is working. First, I'm near shocked that an OS update actually supports removal, but I'm intrigued that the WUA is capable of removing an expired update. If this hadn't worked then I would have scripted something like…

You can either extract it from the MSI directly, or search the registry in HKLM\Software\Microsoft\Windows\CurrentVersion\Uninstaller. Detailed instructions for both of these methodologies are available from several sources via a web search. If you have Patch Manager, you can also use the Computer Explorer -> Installed…

Generally speaking, if you're using Configuration Manager (with a Software Update Point) to deploy updates then Patch Manager is not really a tool that provides functionality in that environment. There are a couple of special-case scenarios that Patch Manager can contribute to an SCCM/WSUS scenario, and these blog posts…

Bundle them as a single MSI which calls them as subordinate MSIs, somewhat how Office does an installation. Is there instructions on how to do this Probably... somewhere... likely on the Microsoft TechNet or MSDN site. I'm not a Windows Installer subject matter expert, just a user of the end product. :-) Script their…

The hotfix question has come up on several occasions, and there are actually several methodologies that can be used. The thread you cited is probably the most comprehensive overview of the options available. PackageBoot is really your friend in this endeavor, and one way to approach this problem is by packaging the MSU in…

However, installing now gives a different error: Code 80070667 I have a feeling it has to do with the msiexec syntax. The /qn /norestart and /i flags should come after msiexec and before the package name, Actually, the /qn and /norestart flags should not be included at all. They are implicit when calling MSIEXEC from the…

Is there any possibility to take a look at the included rules of a MSP? If you can, it would be discussed in the MSDN Library at Patching (Windows) Regarding the SHA1 Digest in the update summary: digest of what? That's the SHA1 digest of the CAB file attached to the package as published to WSUS. Regarding the provided…

There does appear to have been a change in behavior introduced into the product at some recent point. Historically, selecting "Schedule Inventory" would launch the "Inventory Configuration Wizard" to allow you to select or configure a template for that particular inventory task. To customize the default template, or create…

Aha! The tables are there to hold cached data from the Patch Manager server for display in the web console. I don't even know that any of those tables would have a complete set of data, as their only purpose is to provide sufficient data to populate the resources displayed on the web page.

My apologies for the misunderstanding. I will check on that capability.

The licensing (eval vs full) does not impact how Air, Flash, Shockwave, or Java files are downloaded. This is a limitation of those respective vendors (Adobe, Oracle), and the Package Download Assistant is designed to assist in complying with the licensing requirements of those vendors, while still allowing you to obtain…

The 0x0643 error code is a generic MSI failure code -- it means "the installation failed". Why it failed is the key question. There are two approaches you should take: First, run the installer from the CLI of the client system using exactly the same command line parameters you specified in the package, and observe the…

Thank you for the details. So, first, let's clarify a few things. Your client is not pulling any updates from Patch Manager at all; in fact Patch Manager has no role in this process whatsoever. The client (Windows Update Agent) always pulls updates from the WSUS server. Patch Manager provides two tools (Update Management;…

Then that leaves us with the rules... Can you post your rulesets?

My apologies for the delay in responding. The packaging team did some testing of this back on the 16th, and I've had it on my to-do list to post back, but got sidetracked by some other activities. This is what was found: Using a package that currently evaluates as NotInstalled on a Windows 7 x86 system (the test was done…

It's a Great Question, Andrew, and now I'm somewhat disconcerted at the situation... FileVersionPrependRegSz Hive="HKEY_LOCAL_MACHINE"Subkey="SOFTWARE\JavaSoft\Java Runtime Environment\1.7" Value="JavaHome "RegType32="false" Path="bin\java.dll" Comparison="LessThan" Version="7.0.110.21" If the registry key…

Ahhh. because you have the wrong type of "domain" rule specified. The "Directory request only override" rule is only used for performing *LDAP* queries against the Domain Controller (i.e. enumerating the domain tree). To authenticate with a domain-member computer, you must use the "Domain or Workgroup" rule or the…

Okay. That content is produced by Adobe. Any questions concerning applicability logic or diagnosing why a package reports as NotApplicable when that's not expected would need to be directed to Adobe, as they are solely responsible for that content and its behavior. But, in short, I've rarely seen a package reported as…

I've emailed you the download link for the Web Console Installer. Also, you can engage with a interactive demonstration of the console at http://oriondemo.solarwinds.com/Orion/PM/Summary.aspx

Hmmmm.. The downstream servers should not have a WSUS store. The fact that they do suggests that at one time a publishing certificate was created for them. Typically the publishing certificate is only created for the upstream server. Redistributing the cert (from USS to DSS) copies the USS cert (from the WSUS store) into…

That's your only rule? Where are the Prerequisite Rules and Applicability Rules? The version number in the field is in an invalid format. All version numbers used in packages must be four-part dotted decimal numbers. Assuming you have WMI operational on this target system, if you browse to the Computer Explorer ->…

The only requirement for any of the functionality in the WSUSChangeUSS utility is that it be run from a machine with .NET3 and the WSUS API. Functionally you can run it from any WSUS v3 server or any machine with a WSUS v3 console. You could also run it from a WSUS v6 system, but this would require you to install the .NET3…

Okay, thank you for the clarification. To be frank, you're way outside the scope of Patch Manager, WSUS, or the Windows Update Agent. What TeamView does or does not do with its icons and/or start menu items during an unattended installation would be a question for TeamViewer. However, were I to make an educated guess, my…

Just to clarify, the certificate must be installed in both the Trusted Root Certificate Authorities store and the Trusted Publishers store. In addition, we have a step-by-step guide that will guide you through the entire process of configuring the GPO to distribute the certificate.…

Strictly speaking, the authentication request comes from the Automation Role server as a function of building the WMI connection.

Some clarification may be helpful here... WSUS Target Groups can be nested, e.g. All Apps - Dev App1 - Dev App2 - Dev App3 - Dev Patch Manager Computer Groups cannot be nested; there is no heirarchical capability, just a flat list of computer groups. You can still create the four groups, as above, and you can place all of…