Author: joe

Silent Install of Java 7 Update 40

September 13, 2013 /

1. Download the Java update from java.com.

2. The file you download will be an EXE. To get silent installations with some additional features you will need to pull the MSI from within the EXE.

To accomplish this, run the EXE on a test computer. (Just double click the EXE and move to the next step).

When the installation wizard starts, DO NOT proceed. By starting the installation wizard you have caused the Java MSI to be extracted to a special directory on you workstation.

To find this directory open your run command and type in %LOCALAPPDATA% and hit enter. This will open a window to your appdata\local directory. Go back one level and go into LocalLow. Inside this directory you’ll see a subdirectory called Sun. Drill down into the Sun\Java directory until you see the jre1.7.0_40 directory. This directory contains the Java .msi and .cab files needed for the Java installation.

3. Copy the jre1.7.0_40 directory  to another directory on your computer. After the copy you can cancel out of the Java install wizard that you started a minute ago.

4. Assuming you copied the jre1.7.0_40 folder to c:\temp, issue the following commands:

cd c:\temp
msiexec /i c:\temp\jrel.7.0_40.msi allusers=1 /q /norestart ju=0 javaupdate=0 rebootyesno=no

ONE VERY BIG note. If you receive an error 1603 when deploying to some computers, that’s a sign that the computers may have had some Java applets running. This is usually the case when they have browsers that are running.

If you hit errors on your deployment you may want to try adding addtional steps to kill browser sessions.

Java installation errors (1603, 1618)

If you get errors (1603, 1618) then you will want to consider removing older Java entries. This is done by removing the keys in the registry. It’s an involved process that sys admins love to hate.

Active Directory Users & Computers Snap-in for Windows 7

September 12, 2013 /

Remote Server Administration Tools for Windows 7 with SP1 enables IT administrators to manage roles and features that are installed on computers that are running Windows Server 2008 R2, Windows Server 2008, or Windows Server 2003, from a remote computer that is running Windows 7 or Windows 7 with SP1.

The first thing to do is download and install the tool kit from Microsoft:

http://www.microsoft.com/en-us/download/details.aspx?id=7887

Next, from your control panel, turn on the Windows features as shown below:

ADUC-1

ADUC-2

Print Multiple Files At Once With Drag And Drop

September 12, 2013 /

MultiplePrinting

If you need to print a large number of files at once, having to open each one individually and then print them can be a nuisance. Speed the process up by dragging the files you need onto the printer.

To do this in Windows 7, open up the printer from the Devices and Printers option on the Start menu (or search for your printer by name). Drag the relevant files onto the printer window, and you’ll see a dialog box asking if you want to print multiple files. Click ‘Yes’ and they’ll all be opened and printed in their entirety, with the default settings.(You can also copy and paste the files if you want a more keyboard-centric approach.) If there’s a large number of files this may take a while, but you won’t need to intervene.

This might not be new advice to you, but it’s an approach I had never considered before a colleague asked me if there was a speedy way to print multiple PDF files from a single directory. Googling suggests it also works on Macs.

Inserted from <http://www.lifehacker.com.au/2011/06/print-multiple-files-at-once-with-drag-and-drop/>

Can’t open CHM file or CHM topics are blank

September 12, 2013 /

Issue:
After opening a CHM documentation file, a topic may not appear when you click a link from the Table of Contents. Also, when you try to use a Universal Naming Convention (UNC) path to open a .CHM file that exists on a network shared folder, topics in the .chm file may not appear.

Reason:
You are using Microsoft Windows XP and have installed Security Update 896358 from Microsoft, which prevents the features of some web applications to work properly.

Solution:
On Windows XP (with the security update applied) you can also simply right-click on the CHM file, select Properties, and click on the “Unblock” button. Click “Apply” and the content should be visible.

This will only work on local files.

SQL Date Range Examples

September 12, 2013 /

Today

SELECT EventTime, Event, AppTitle, AppVersion
FROM LOG_AutomatedApplicationRunTime
WHERE EventTime >= DATEADD(d, 0, DATEDIFF(d, 0, GetDate()))
ORDER BY EventTime

Past 30 Days

SELECT EventTime, Event, AppTitle, AppVersion
FROM LOG_AutomatedApplicationRunTime
WHERE EventTime < DATEADD(day, – 30, GETDATE())
ORDER BY EventTime