SevenTier IT Solutions

2011-10-13T12:01:00.000-07:00

Separating and Merging PDF’s for free

Download PDF Editor here: http://www.pdfill.com/download.html

Choose one of the orange buttons that say download now:

Download and install it.
After it is installed start the program and navigate to “Tools” and then to PDF Tools (No Watermark):

Then click on “Split or Reorder pages”:

A dialog box will pop up for you to go find your file:

Choose the file to open, then the following box will pop up, telling you how many pages it found and asking you what to do, I chose “split pages” and then typed in “1 to 17” so that it will look at all 17 pages, then I clicked on the checkbox saying “Extract pages as separate files” – (this will create 17 separate PDF’s):

Then click on “Save As” It will then prompt you to “save as:” – choose a directory that you want them to be saved in and then choose a name (here I choose “JJ” which will create 17 separate files called: jj1.pdf, jj2.pdf, jj3.pdf, etc):

Then Hit “Save” button and it will create the 17 separate files in the chosen directory:

You are done, now merging files is just as easy – choose “Merge PDF Files”, go find the separate files you want to merge and then save as the name you want and you are done.

jquery treeview toggle button submitting form

2011-08-16T07:13:00.000-07:00

Came across this issue after copying some code from a jquery treeview demo. Once I put the code into a form, it would keep submitting the form before it could drop down the tree.

Found that the sample code had: <button id="add"> This makes the aspx page assume it is of type "submit". I needed to add <button id="add" type="button"> to make it stop submitting on click.

Creating Windows 7 OEM image for deployment

2011-07-27T08:56:00.000-07:00

Create winpe boot cd
· Download and install WAIK
· Choose deployment tools command prompt from start menu
· copype x86 c:\winpe_x86
· copy c:\winpe_x86\winpe.wim c:\winpe_x86\iso\sources\boot.wim
· copy “c:\program files\windows aik\tools\x86\imagex.exe” c:\winpe_x86\iso\
· oscdimg –n –bC:\winpe_x86\etfsboot.com c:\winpe_x86\iso\ c:\winpe_x86\winpe_x86.iso
· Verify the iso has been created, and then burn to CD

Configure template machine (oem)
· Install windows, do not enter anything when prompted for product key – puts you into 30 day trial
· Install other applications, configure desktop background, ip configuration, mapped drives, etc
· Install office 2010 but *do not activate*
· Run all updates on office and windows
· HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Registration Delete the whole "Registration" key

Acquire image
^* build answer file first - blog to follow
· Run Sysprep from c:\ windows\system32\sysprep directory
· Choose: oobe
· Choose: Generalize
· Choose: Shutdown
· Choose: OK
· Machine shuts down
· Insert winpe boot cd
· Start machine (have external drive installed)
· Verify drive assignments (find out what is where)
· imagex /compress fast /check /capture e: d:\win7img.wim “Windows 7 Professional” “win7and office 2010”

Applying image
· Insert boot PE disk
· diskpart
· select disk 0
· clean
· create partition primary size 12000 (this is megabytes)
· format quick fs=ntfs label=”Windows 7”
· active
· assign letter=C
· list disk
· list volume
· exit
· imagex /apply d:\win7img.wim 1 c:\
· bcdboot c:\windows /l en-us
· Restart machine into windows welcome mode

Working with GnuCash

2011-06-23T14:36:00.000-07:00

GNUCash - great OpenSource replacement for Quicken and even Quickbooks;

.gnucash file is gzipped xml file which you can peek into for info that may not be available in the front end like vendor list, delete invoices (unfortunately the only way), etc

C:\Program Files\gnucash\share\gnucash\guile-modules\gnucash\report contains the .scm files (text files coded in Scheme - a form of LISP) to manipulate invoices' look, etc.

These scheme scripts (.scm) will need to be re-edited (more likely saved then re-imported) when upgrading GNUCash

Quickly remove background using Gimp

2011-06-21T13:33:00.000-07:00

The more I use GIMP the more I have come to understand it can do everything I thought I needed PhotoShop to do.

Removing background (creating transparent file)
Open file
Tools -->Paths
Use zoom to get real defined if needed
Once path completed, click Shift-V to make selection
Control-I to select inverse
Go to Layer -->Transparency--> Add alpha channel
Hit "delete" key; now your background is deleted

very easy !

Re-set Fedora root password

2010-04-12T10:20:00.001-07:00

Came across the need to re-set my forgotten root password on my Fedora 11 box. The alarmingly simple solution makes it very evident that physical access to machines is extremely important to safeguard.

I am using GRUB so the trick was to show the choice of kernals it wanted to boot to, choose "e" to edit one of them and add "single" at the end of the kernal boot command, then choose "b" to boot that kernal, it will push you into single mode with root priveleges

type in "passwd" and choose a new root password.

apparently LILO is just as easy; booting with: "linux single" gives you the same result.

Linux Mint Partition Problem

2010-04-10T06:22:00.000-07:00

I came upon this problem installing Linux Mint 8. This is a great looking Linux distribution based on Ubuntu. Definitely would recommend this to users of Windows who want to try a Linux that acts much like Windows

After starting up with the iso disk into the live cd, when you go through the "install mint" wizard, there will be no partitions that show up at the 4th step and you can't continue. Starting the OEM install at the CD boot has the same results.

The trick to getting the partition table to show up is to run this command from the terminal once in the live cd screen:

sudo apt-get remove dmraid

Then run the wizard and the partitions will show up so you can continue.

Task scheduler issues on Server 2008

2010-03-25T04:27:00.000-07:00

Microsoft has changed the task scheduler pretty drastically since windows XP and it is very hard to get used to. I had a recent issue where I couldn’t tell if my .bat file I use for backups had really run – the bat file is supposed to write to 3 separate log files while running so I can view any problems and verify what it did. Well, the task seemed to run however, the log files were not updating. After investigating I found that the following steps should be carefully run through when creating a task in 2008:

• Make sure that the task is set to "configure for Windows Vista or Windows 2008" on the first page of the task properties (under the "general" tab)
• Very important when writing to log files --> Make sure that the task is set to "start in" the folder that contains the batch file: open the task properties, click on the "actions" tab, click on the action and then the "edit" button at the bottom. In the "Edit Action" Window there is a field for "start in (optional)" that you set to the path to the batch file.
• Make sure that the task is running as an account that has explicit "Full access" permissions to all these things: The .bat file itself, the folder containing the .bat file, and the target files/folders that are affected by the .bat script.
• Make sure that the account running the task is a member of the local "administrators" group for this machine
• Make sure that the task is set to "run whether logged on or not"

Delete hiberfil.sys hibernation file in Vista

2010-01-28T07:21:00.000-08:00

File is as large as your physical memory which is very large.
Can easily do this is in XP by disabling hibernation however Vista it is more difficult. Do it via command line: powercfg -h off

batch file to backup and encrypt to disk

2010-01-27T21:11:00.000-08:00

There are times when backing up files to a USB drive is the only method that a client has chosen to perform their backups on their Windows machines. The best way to ensure that that USB is not stolen or lost, and then read, is to encrypt the files. Anyone who knows me knows that I love creating my own scripts and using open software to avoid high priced vendor solutions. Here is a quick process to give the backups some decent security.

Download and install Truecrypt (Excellent open source on-the-fly encryption tool).
Create encrypted volume inside USB (call it "backups" for this exercise)
Make sure you use strong password and remember it or keep it somewhere you can access it again
Download Robocopy (or Rsync)
Batch script:

"c:\program files\truecrypt\truecrypt.exe" /q /s /v e:\backups /lj /a /p password
robocopy C:\Users\Administrator\Documents j:\ *.doc
"c:\program files\truecrypt\truecrypt.exe" /q /dj

(here I create volume j, using weak password called "password" silent mode, don't show GUI, automount volume, then call robocopy to do the backup of .doc files in the Documents directory to the encrypted volume, then unmount volume)

There you have it, a USB thumbdrive with your encrypted files out of view.

Cannot copy file access is denied windows XP

2010-01-13T12:11:00.000-08:00

Came across this one today; bought 4 new Dell computers and was setting them up. Ok first thing I have to do is copy a directory over from the old computer to thenew machine, half way through the copy and I get cannot copy access is denied.
I try everything, I disable file sharing, turn off firewall and a few other things. I notice that at every reboot Norton asks me to sign up for their trial. Being a new computer and I won't be using it, I just click on "remind me later". Well, could it possibly be Norton stopping this file (I notice it is a .exe file); this could be possible but why since I have told it I don't want to install it.
So I click to uninstall Norton trial offer (which I never accepted) and now everything works. I guess I don't know why Dell puts this on yet it indicates that it is not installed and you have the option to install it when you want. I guess this is incorrect.

Simple way to prevent printing of web page

2009-12-16T11:51:00.000-08:00

Basically, there is no way to prevent a user who really wants to print a web page out, it is a simple as them hitting their "Print Screen" button, etc...

But for intranet purposes, letting your users know that some pages are not to be printed, you can add the following code to the head section:

{{Code is changed slightly by removing "<" in front of tags for display here:}}

head>
style type="text/css" media="print">
body { visibility: hidden; display: none }
/style>
/head>

This will only print out a blank page when the user goes to "file"--> "print" (print conventionally)

A user can still print out by unconventional methods but, by doing so, is understanding the company does not want it printed, and he is behaving improperly.

Enable thumbnail view and photo editor in Windows Server 2008

2009-12-16T10:58:00.000-08:00

When trying to use Server 2008 more like a desktop, you will find some options need to be enabled so that it behaves more like a workstation.

Two things that come to mind are thumnail view which is disabled and Microsoft Windows Photo and Fax viewer (so that you can view the pictures with something other than "Paint")

For Thumbnails:
Click on "start" --> "run", then type in "SystemPropertiesPerformance" Check off "show thumbnails instead of icons and then "OK"

For "Photo and Fax viewer", you need to enable the "Desktop Experience" in the Server Manager, go to "Features" --> "Add Features" and choose "Desktop Experience". the Windows Photo and Fax viewer will then be enabled.

Sharing HP Deskjet 5600 series (HPA) on Windows 7

2009-12-09T18:32:00.000-08:00

Just finished sharing my HP 5850 printer on my home network in Windows 7 with my Windows XP machine. Sounds easy yes?. Well it took me a while to do this, here is what I went through.

USB connection to the 5850 from Windows 7 machine, whoops, no real driver for this so you need the 5600 Series (HPA) driver for it to function. Ok now sharing it out, well you have to enable sharing for people who do not have an account on that machine; (hey, this is a home network) another step. now to add additional drivers (like, for XP but nope, can't do that cause it asks for .inf file and I can't find it 0k didn't really investigate if it was there, but i am fairly sure the lay-person won't find it)

Now, going to the XP machine I point to the windows 7 machine and low and behold it says "driver is not installed on that machine, so browse to it on your own machine", but then it is nowhere to be found on the machine (or I couldn't find the driver as I checked every $win inf$ file there was)...and also guess what, you won't find that HPA driver anywhere at HP.com either.

So... I installed a 5800 series printer on my xp machine, pointed it to the local port and said just install the driver even though the it cannot find the printer. Then I went to the newly created printer and changed the port; created new port and called it \\(windows7machine)\(sharedprintername)

Now I can print to the shared printer on the Windows 7 machine.

Anybody got a better way?

Remove User Account Control warning from Windows Vista

2009-12-02T06:09:00.000-08:00

Vista allows you to turn off the UAC via -->Control Panel -->User Accounts -->"Turn off User Account Control" but then creates an annoying "warning User Account Control Turned off" pop-up balloon which you then can't shut off. I'd like to someday create a poll on which is more annoying....the User account control or the warning that it is turned off.

Anyway, turn it off in the registry by HKey_LOCAL_MACHINE\SOFTWARE\Microsoft\SecurityCenter
Add this value:
Data Type: DWORD
ValueName: UACDisableNotify
Value: 1 (dec)

Restart

install command line ssh client on Windows

2009-11-18T08:10:00.000-08:00

It is necessary when communicating with Linux and Unix machines that it is done securely and no longer with telnet, so every Windows user should have a ssh client on their machines. I prefer a command line client and find that the Cygwin environment is almost a must for Windows users.

Go to http://www.cygwin.com/ and download the setup to install a "Linux-like" shell and make sure you choose "openssh". Now you will have a free ssh client to communicate with you Linux and Unix machines. Don't forget to put the directory path to the Cygwin bin directory in your Windows path statement so you don't have to "cd" to the right directory.

Windows 7- Windows Search Service does not start

2009-11-16T08:35:00.000-08:00

If you have trouble searching for files, then your Search Service might not be on.
Follow these steps to rebuild your index and start up the service.

1/2 Go to :
Open Control Panel > System & Maintenance > Indexing Options. In the Advanced Options, Click on Restore Defaults and also Rebuild Index. Click OK.

2/2 Next go to :
Control Panel\All Control Panel Items\Administrative Tools\Services
Scroll down until you find windows search service.
Right click and choose start

Hope this helps you.

ASP code to guard against SQL injection

2009-10-29T19:06:00.000-07:00

It is necessary whenever you are writing a SQL query in your ASP code, to guard against SQL injection, here are examples to use when in production mode:

If the field dEmployeeNumber in the DB is *NOT* a number:

Code:
SQL = "SELECT tEmployeeNumber, tTopic, tDepartment, tTime FROM tblSurvey "
& " WHERE tEmployeeNumber='" & Replace(dEmployeeNumber,"'","''") & "'"

If it *IS* a number:

Code:
SQL = "SELECT tEmployeeNumber, tTopic, tDepartment, tTime FROM tblSurvey "
& " WHERE tEmployeeNumber=" & CLNG(dEmployeeNumber)

with proper credit to Bill W from 4guysfromrolla

function to format phone number field in form

2009-10-09T10:18:00.000-07:00

Needed to format a phone number field as soon as the person typed it into the form, I like this solution:

(tag) script (endtag)
function formatPhone(fld)
{
var ph = fld.value.replace(/[^\d]/g, "" ); // zap all except digits
// if user entered the leading 1, just zap it
if ( ph.length == 11 && ph.charAt(0) == "1" ) ph=ph.substring(1);
if ( ph.length != 10 )
{
alert("Sorry, '" + fld.value + "' is not valid phone number");
return false;
}
fld.value = "(" + ph.substring(0,3) + ") " + ph.substring(3,6) + "-" + ph.substring(6);
return true;
}
(endtag)script(tag)

and it is called by:
onchange="formatPhone(this);" - or it could be used during validation....

Sending email using CDO and ASP on IIS7

2009-10-07T12:33:00.000-07:00

Struggled with this one for a while, so I am posting here to remember the method.

Dim objMail, objMailConf
Set objMail = Server.CreateObject("CDO.Message")
Set objMailConf = Server.CreateObject("CDO.Configuration")

objMailConf.Fields.item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 '2 for web server (1 is to sit in the pickup directory)
objMailConf.Fields.item("http://schemas.microsoft.com/cdo/configuration/smtpserverpickupdirectory") = "c:\inetpub\mailroot\pickup"
objMailConf.Fields.item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "postoffice.test.com"
objMailConf.fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
objMailConf.Fields.item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 10

objMailConf.Fields.Update

Set objMail.Configuration = objMailConf
objMail.From = "webemail@somewhere.com"
objMail.To = "somemailbox@somewhere.com"
objMail.Cc = "someccuser@somewhere.com"
objMail.Subject = "Company Web Input"
objMail.htmlBody = EmailMessage
objMail.Fields.Update
objMail.Send
Set objMail = Nothing

Link Excel spreadsheet to SQL Server 2005

2009-09-21T12:42:00.000-07:00

Create "New Linked Server" in the linked servers tree
* Name it
* Provider: Microsoft Jet 4.0 OLE DB Provider
* Product Name: Excel
* Data Source: c:\xxxx\xxxx\xx.xls
* Provider String: Excel 8.0

Then choose OK - make sure you have the file in the proper directory.

display all fields from one database record

2009-09-17T19:15:00.001-07:00

Here is a quick way, when debugging, to display all fields from one record
(courtesy of Bill W from 4GuysfromRolla)

strSQL = "SELECT * FROM requests WHERE ID = " & rID & ";"
Set RS = yourAlreadyOpenConnectionObject.Execute( strSQL )
For fnum = 0 TO RS.Fields.Count-1
Set fld = RS.Fields(fnum)
Response.Write fld.name & "=" & fld.value & "(begin tag)br/(end tag)" & vbNewLine
Next

Displaying all form fields submitted from page

2009-09-17T18:55:00.001-07:00

I like this simple code when debugging or starting a new project where I need to see all the form fields submitted at once:

For Each fld In Request.Form
Response.Write fld & "=" & Request.Form(fld) & "(begin tag)br/(end tag)>" & vbNewLine
Next
Response.Write "(begin tag)hr(end tag)"

IDC Servco SCAM

2009-09-11T12:33:00.001-07:00

Administrator at the office got a call on the phone today from someone claiming to be from Hewlett Packard and "needed to talk about the problem with the HP printer" The administrator sent me the call and when I picked up, the person on the line said "I'm calling for Hewlett Packard, this is about your HP2015 printer, we're sorry we were supposed to call about the price change on the toner it is going up to 748 dollars from its regular price of 698 dollars, we didn't get this information to you out in time." I'm thinking hmmm I don't even have a HP2015 printer and anyway, this is a lot of money for toner so I said "how much toner?", she said "a box" I am thinking this must be a carton of about 6 or something, I said "one box?" and she said "yes, now we will complete the order and ship it out at the lower cost" I said "what company are you?" and she said "IDC Servco", then I said "how come I have never heard of you and why are you quoting prices to me as if you were shipping it out?", the next thing she did was hang up.

I checked on the internet and found this is a common scam attempt from this company:
http://www.complaints.com/2007/september/14/IDCSERVCO_152345.htm That is a post from 2007 so this stuff has been happening for a long time.

Please tell your people in charge of the printing supplies to watch out for this, they are fast talkers....

Free pdf OCR solution using Microsoft tools

2009-08-05T07:27:00.000-07:00

Came across an issue where I had to convert a poorly scanned pdf document to word. The steps I took were to print the pdf to the "Microsoft Office Document Image Writer", saved as a .mdi file, then open it up in Microsfot Office Document Imaging (in the tools section), then choose to OCR the document and save text to Word. Worked fairly nicely and simply had to clean up the text.

loop through dates, skip days

2009-07-29T19:44:00.000-07:00

Had an issue where I needed to loop from a start date to an end date but for certain weekdays, (like fridays or mondays, information coming from a series of checkboxes; 1 for each weekday) I needed to skip whichever the user checked off....

Solution:

For dt = StartDate To EndDate
If InStr( shiftdays, CStr(Weekday(dt)) ) > 0 Then
... process this dt ...
End If
Next

COALESCE

2009-07-28T11:12:00.001-07:00

This function was hard for me to first understand, but I have found it very useful:
COALESCE(expression1,expression2)
means if expression1 is null, then expression2

This was useful when a column originally contains null values and I needed to concatenate a value to it, not knowing if the value was still null

COALESCE(column1,'') means if column1 is null, then blank, otherwise column1

Taking on Nagios

2009-07-24T11:13:00.000-07:00

OK,
I have been searching for an easy way to try out Nagios, even going to VMWare for a virtual machine, there is only 1 link worthwhile and it is dead, it is the same link that everyone in Google refers to as well, so I am convinced there is no easy way.

Maybe when I finish, I'll post the virtual machine at VMware or keep it at my site for visitors...

I am going to start from scratch; download Fedora 11, then the Nagios tarball. Then configure....

1. Downloaded Fedora 11 and installed to 15G hard drive
2. Download Nagios: nagios-3.0.6.tar.gz
3. un-tar Nagios: tar xzf nagios-version.tar.gz
4. add user nagios: adduser nagios
5. make installation directory: mkdir /usr/local/nagios
6. chown the directory: chown nagios.nagios /usr/local/nagios
7. creat a new group: /usr/sbin/groupadd nagcmd
8. add the web and nagios user to that group:
/usr/sbin/usermod -G nagcmd apache
/usr/sbin/usermod -G nagcmd nagios
9. run configure (include command group nagcmd):
./configure --with-command-group=nagcmd
10. now compile: make all
11. post init file to /etc/rc.d/initd:make install-init
12. now edit httpd.conf with the following 2 aliases so that the web pages get diverted to correct directories:

ScriptAlias /nagios/cgi-bin /usr/local/nagios/sbin

Options ExecCGI
AllowOverride None
Order allow,deny
Allow from all
AuthName "Nagios Access"
AuthType Basic
AuthUserFile /usr/local/nagios/etc/htpasswd.users
Require valid-user

Alias /nagios /usr/local/nagios/share

Options None
AllowOverride None
Order allow,deny
Allow from all
AuthName "Nagios Access"
AuthType Basic
AuthUserFile /usr/local/nagios/etc/htpasswd.users
Require valid-user

13. restart the web server: /etc/rc.d/init.d/httpd restart
14. OK - now trying to log into nagios via website, I get AVC denials all over the place, after searching, I find my best answer for now is to just disable SELinux - kind of like disabling the junk I don't like in Vista - this is not a recommendation, just something I do to move forward, I can enable SELinux later when I get everything running
15. Great, now a "Whoops" error, After fruitless "googling" I get nowhere so as a last resort, I actually read the error carefully, first, I run a nagios -v {config-file] command like they say: ./nagios -v /usr/local/nagios/etc/nagios.cfg
everything shows fine, so now I run it without the -v and I see that I get a weird error about not finding the nagios.cmd in the usr/local/nagios/var/rw directory. Understood, cause I don't even have an rw directory. So I go ahead and create it and set ownership and group to "nagios". Run the command again and yes, nagios now starts..... Log into the webpage and can now see everything. Next step will be to learn everything it can do and try the plugins...

OK - update 2 weeks later, I have configured nagios to monitor LAN servers as well as a few off-site servers. Had to work with windows.cfg, commands.cfg in the /usr/local/nagios/etc/objects directory and the nagios.cfg, cgi.cfg in the /usr/local/nagios/etc directory. Needed to download nsclient++ and install on all windows servers, configure the .ini file and poke holes for the listening port of choice in the .ini file.

Next was fighting with the horrible email notification documentation. Finally had to yum install ssmtp and configure the conf file to my email server and fight with the command line to get the correct user from, to and subject. Funny how important the alerting is, yet the documentation is a joke for this issue and don't try to go on the forums, all you get is some pompous advice to RTFM - hmmm I did read the manual and it was written horribly, that is what the forum is for; to help interpret the poorly written stuff that techies write and think is incredibly clear....

Well, after getting it all running, have to say it is pretty cool, and I even tracked back to re-enable all the security that I removed to get this up and runing.

Installing New Open-Source SSL VPN

2009-07-20T13:59:00.001-07:00

Here I will document the complete installation of a new SSL VPN - Completely OpenSource and Free as in beer.

Download Adito
Download latest Java Development Kit
Download Apache ANT

Decompress ANT to c:\ANT
Change Environment Path to add c:\ant\bin

Issue 1. After issuing "ant install" in command prompt it could not find the tools.jar file because it was looking in the jre directory and not the jdk directory - I issued "set JAVA_HOME=c:\program files\java\jdk1.6.0_14" in command prompt. This allowed ant to find the tools.jar file and copy it back to the Adito home directory. Has to do this for legal reasons - Adito cannot package tools.jar into their install.

Great, everything starts to install and brings me first to a certificate creation or install - I create new cert with passphrase and company info.

Fill in info, decide whether to use Active Directory or built-in database, creae super user, decide port/protocols/ip addreses outside names, etc

Configure proxy

Finished install - now to keep it running between re-boots: go back to adito directory and issue "ant install-service" in command prompt

Now start the service and login at https://localhost

Adito doesn't seem to have any ready-made extensions so I copied RDP from old SSL-Explorer application - has to be a zipped file, complete with application.xml file. Went to extension store and uploaded it, failed twice before actually uploading, now it is there and I can choose it when I go to "create application".

Now I can't connect through the firewall - seems NAT is working fine however the windows firewall even though is set to allow https traffic, still blocks it. Added a rule to allow port 443 and now it allows Adito to work - can't understand why that is....

Well, now I have a complete functioning SSL VPN, available from anywhere.

I will experiment with Adito agent and maybe creating web folders, etc. - maybe a little later

Checklist for re-installing operating system on user's computer

2009-07-20T13:03:00.001-07:00

Reinstalling Operating system:

Copy over folders:
• C-Drive
• My Documents
• Desktop

Get IP address and all network information

Get computer name, and user log-in and password (any other profiles?)

Get LAN card driver info
Get Video card driver info
Get mapped drives info

Get printer info
• IPaddress
• Driver

Get email info complete:
• PST file
• .nk2 file
• Signature
• Print out mail settings
• Get email password
• Contacts / address book

Get experience
• Display setting
• Default home page
• Favorites

Java download needed – most likely
AVG Free

What versions of software – office, etc.

MS Access - filter email addresses by domain name

2009-07-20T07:25:00.000-07:00

The following will give me the information to the right of the "@" sign so that I can filter by domain name

Mid([address],InStr([address],'@')+1)

check my open ports

2009-07-16T13:12:00.001-07:00

netstat -o

Then to see what the PID is doing:

TaskList /FI "PID eq 4072" /FO LIST /V

SQL Server error converting nvarchar to float

2009-07-16T10:22:00.000-07:00

Had numbers in my column like "1,298.05" when I was expecting 1298.05 So to get around this, whenever I refer to the column for calculations I use:

convert(money,REPLACE(t1.[TOTAL_AMOUNT_PAID],'"', ''))

Disable DEP for good

2009-07-14T17:28:00.000-07:00

Don't bother posting the question on a forum, 90% of the time you will get answers like "why do you want to do that - here is a better way...." or " right-click on my computer, properties, advanced, performance,settings then Data Execution Protection tab.."

To shut it off completely from bothering you, which it eventually will (especially if you use legacy programs), edit your boot.ini file and add /noexecute=AlwaysOff at the end. Reboot, problem solved.

New ThinkMate Quad Core Xeon Server

2009-07-14T14:57:00.001-07:00

Just took delivery on Server, now to install operating system, and configure:

Step 1 - Thank you ThinkMate, upon plugging it in and installing the CD, the machine found the 15K SAS drive and began to install.

Step 2 - Turn off Internet Explorer Enhanced Security Configuration: Go to server manager and click on Configure IE ESC. Turn it off there

Step 3 - disable hibernate - are you kidding me? hibernation on by default?
powercfg.exe /hibernate off

Gradient Background

2009-07-08T07:05:00.000-07:00

This is only for microsoft IE browsers - good tip for captured audience intranets.

body style="filter:progid:DXImageTransform.Microsoft.Gradient(endColorstr='#C0CFE2', startColorstr='#FFFFFF', gradientType='0');"

For other browsers, best to create a 5 pixel wide by 800 height file using PhotoShop then the gradient tool - save as a gif or jpeg and use in css like this:

{
background-image:url(images/jjgradient.gif);
background-repeat:repeat-x;
background-position: top;

}

Open Source Changes

2009-07-01T19:24:00.000-07:00

Just found out that Adito has merged with OpenVPN to create OpenVPN ALS. Adito has been a fantastic Open Source SSL VPN; totally replacing my Cisco PIX solutions I used to pitch (more on that later) Open VPN was also a great solution when I needed access to a whole network. The fact that these 2 have converged is fantastic news and I will be deploying this solution immediately to clients wishing for secure, opensource, inexpensive VPN's