Recent content by JEngles

Hi we're running Tomcat 6 and I can't find a way to find out who is logging into the site. Is there a log file I can check out, or enable? Thanks in advance.

Thanks fellow IT'ers. I agree with what your saying that router would be the best way. Couple this with USB\CD\Floppy access is restricted, should do it.

I need to setup a computer to only allow local network access. I was wondering if Petri's way is the best --> http://www.petri.co.il/block_internet_but_allow_intranet_with_ipsec.htm or perhaps is it better to block it at the firewall?

So were still running Windows XP in a 2003 AD enviroment and idealy we want to lock down the users to well just users. But due to dodgey programming or security reasons we need to add around 5% of users to a special group called LocalAdmins which is added to the local administrators group via a...

Cheers Pat, I was thinking along that line also.

Hi all, I've done a little bit of research into this, but I'm a bit pushed for time (I have to have a business proposal for Monday!!) Background: We are running Server 2003 and Exchange 2003 with a user base of 2500+ using Outlook 2003. Basically what the business wants is to have a standard...

The plan is to use an excel file with column A being what’s in the database table and Column B with whats to be replaced. Can someone please tell me how might go about doing something like this?? Thanks in advance

Thanks Skip, but UBound is actualy equal to 3. It's a strange one when I look at it in the Watch Window, it jumps to 4 and errors if I don't put an On Error Resume Next in, but if I do put that in it jumps to 4, and then a line later is jumps back to 3?? Anyway, I've got this working now by...

Hi Skip, The problem is here: For CCount = 1 To UBound(StringArray) For DCount = 1 To UBound(CompareArray) If StringArray(CCount) = CompareArray(DCount) Then HowMany = HowMany + 1 End If Next DCount Next CCount For reasons I'm not sure about, it's adding an extra loop in...

Hi all, I'm trying to create a macro that compares data from 2 tabs and sees if there is any matches. The problem is that the data is slightly different. Sheet1 contains 2800 of application names (e.g "Microsoft Office Visio Viewer 2003 (English)" and I have to try and find matches in Sheet2...

Unfortunately It's not all the numbers I'm looking to remove, just the version numbers. e.g 4.5, 5.5.1. I can appreciate that it's a lot more complicated.

Markros, you're a bloody legend. That worked perfectly!! :-)

Hi All, just wondering if you can help me out. Basically this is what I have so far. Sub StripOutVersionNum() Count = 2 Sheets("Sheet2").Select Do While Range("A" & Count) <> "" StringName = Range("A" & Count).Value FindDot = InStr(1, StringName, ".",) If FindDot > 0 Then...

So Name in Inv_AeX_OS_Add_Remove_Programs contains data like this: ActivePerl Build 622 ActualTests Exam Engine - VMWare VCP-410 Administration Tools for Print Management Adobe Acrobat 7.0 Elements APSoil ArcGIS (MWC License) ATI Problem Report Wizard Catalyst Control Center Graphics Full...

I know this should be a failt simple question, but I've been searching for days and I can't find the solution...and yes I'm a newbie to SQL. This is what I have so far: SELECT DISTINCT Publisher 'PUBLISHER', Name 'NAME' FROM Inv_AeX_OS_Add_Remove_Programs WHERE NOT EXISTS ( SELECT * FROM...