Recent content by cjkenworthy

Cheers mate! Seems to work, I see why the apostrophes would interfere with results, as the '' in the sub queries would make TotalRecords a comlun that can be called by the outer query. So the outer query does not need the apostrophes. Thanks again. Chris.

I'm trying to return a list of distinct attributes, and a COUNT of the number of rows with that distinct attributes, this is from 2 tables with the same schema: Results e.g. (PackReference, Total) ABC123 2 DEF678 1 GHI901 6 SELECT PackReference, SUM('TotalRecords') AS...

Providing each T-1 gateway has a different IP address, it should not matter. I presume, like us, you have a router as a gateway at the connection with the T-1 circuit. We use an ADSL modem router as the gateway. It sits there exposing an IP address (public, but could be private), the firebox...

I got a response of our reseller and found out that it may be possible to 'reverse' the flow of traffic over the 'Optional' port on the firebox, using NAT and some clever rules. The reseller told me that this is not explicitly supported by Watchguard. I have however put down a few of my ideas...

Has anyone had any experience of using multiple internet connections (in our case 2 ADSL lines) with a Watchguard Firebox? At the moment, we have a firebox III/700, and a single ADSL router hanging off the External port and want to add another ADSL connection. Is it possible to maintain the...

I've created a logon script to remove local profiles. I have assigned it to the 'Startup' Scripts in the Group policay object, for Computers: Set WshShell = WScript.CreateObject("WScript.Shell") Set WSNetwork = CreateObject("WScript.Network") Dim CommandString commandString =...

Thanks for all your help, The records only go into seconds, not milliseconds, and aren't generated al that quickly (about 10 a minute). Chris.

I've used that before, but: a) it requires me to run it interactively (unless I can have it run at logoff - is this possible? I thought a profile could only be deleted after they are completely logged out? b) it does not work reliably, and will not always remove all local profiles, plus it...

We have records in the following manner: Record CreatedBy TimeCreated 1 Chris 13:30 2 Chris 12:12 3 Chris 13:31 4 Chris 12:14 5 Chris 09:34 I want to run a query that will fetch all records for a user where the...

We have hundreds of users, all of whom do not require a profile/their settings preserved - they do not have roaming profiles. However, when they logon Windows automatically creates a local profile in the C:\Documents and Settings\... folder. This happens at each computer the user logs into, so...

Thanks, I'll give it a try.

Is there anyway of getting the values of an attribute (across several rows) into one single row? If I have: Company Date Surname Notes ------------------------------------------------ IBM 01/04 Smith Here are some notes IBM 07/09 Smith This person also made some...

I'm trying to delegate control of users to some members of our staff (they are non-administrators). I am using GPO to deploy the adminpak.msi (from Windows 2000 Server CD) to them when they log on to a station. I have delegated control of the relevent objects (in Active Directory Users &...

Hi, I've got a PPP multilink connection active on my windows 2000 server (4 modems connecting as a bundled 180kbps connection) which appears as one connection. When I do an ipconfig to display all adapters, it only shows a LAN connection, no PPP adapter. Surely it should show a PPP conenction...

Can anyone recommend any software which can achieve the following. We have a server with 4 Dialup networking accounts. Clients on our internal network use this as an Internet gateway. I want to setup some sort of rule which specifies that certain computers use dialup account 1, others use...