Recent content by Lukey

I have an ASA 5520 setup to receive VPN connections using AD authentication which works fine. The problem is, although the user is authenticated to the ASA, this is not passed onto the Domain so that when they go to access a restricted share that they should have access to, they get 'Access...

Hi, I am sure that I have seen something about this before but can't find it. We have a NAT rule for a server that we are using mapping the external to the internal address. For testing purposes, I need to be able to access the box using the external IP from the internal network. Without...

Thanks, just taking a copy of the config now. I have added the NAT and the security entry but it's like the ASA isn't listening on that IP as nothing shows up in the logs when I try to access it.

Hi I have inherited an ASA 5520 and need to setup a NAT entry. We have external IPs allocated and the modem is working in transparent mode so should be passing all traffic to the ASA. There is an existing rule setup which works for another server. I have copied this but still no joy. There is...

In theory it shouldn't be possible unless something is dropping the connection periodically. If she is based in the office you could try turning cached mode off and then see if the problem persists.

Hi, I have a requirement to forward mail to an alternate SMTP host based on the senders domain or the prefix of the email address ie test****@mydomain.com The **** could be a random number so I wondered whether this could be done with either a wildcard or based on the fact that they should all...

Genius Ken ! That works a treat. Apologies again for the poor sheet design but it was dumped on me and I hope to get rid of it soon. Any light on the 99^99 function would be great, at least I'd kind of know what it does... Thanks again Luke

Unfortunately those columns are only filled in with the date once there is something in the column to the left. Cheers for that though

Hi, Thanks for the prompt replies. DirkStruan - The other columns have coresponding dates in but I don't really need those. Skip - Tell me about it, unfortunately it is inherited and it is too old to start changing it... Any ideas ? Cheers

Any help would be greatly appreciated. I have an excel sheet with products on and the columns track the movement of those products. I have a final column that is filled in when the product has been returned. I would like a formula to get the data in the last filled in column (in order) and...

Thanks very much, it's all been a great help and seems to be working a lot more efficiently now !

Thanks for all your help, it's given me loads of options to try. I know what you mean about the original data but it is an import so I wanted to try and do as much as I can with the raw data. Cheers

Cheers Rofeu, problem is that I have about 60 different departments so I really just wanted it to match the prefix to the full dept. name and then ignore the user name.

Couldn't see the wood for the trees, good idea ; ) Do you know the easiest way to split a column using anyting before the '-' sign ? Thanks

Hope someone can help as I am not 100% sure what function I need. I have been using a VLookup for some other items on a sheet and think that it may be appropriate here. I have a list of computers, each with a 3 or 4 character department prefix and I want to match these up with the full...