Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DROFNUD

  1. DROFNUD

    Including a "count" filter in query.

    Hi, I have a table of products that includes column for "Model", "Colour" and "Size" etc. The customer wants to display a filter on the site where you can Tick a Colour and/or size and it displays the amount of records for each. Something like this: Products (27) Colour: - Red (15) - Blue (8)...
  2. DROFNUD

    Migrating Layer 2 network to VRF

    Hi Speedline: We've rolled out option 2 and moved Voice traffic into the Client VRF. This part of the project is nearly complete with only a couple more user areas to do during an evening next week. The logic behind the final choice was that Lync traffic is already in the Data VLAN so adding...
  3. DROFNUD

    Smartcenter Dashboard - Searching for "Any" keyword

    Our new security manager wanted a list of all rules that use the keyword "Any" in them. As there are 500+ rules, I could simply go through them but I found an easier way. In Smartdashboard the query syntax "includeany" can be used to find the keyword "Any", but it needs to be used with a source...
  4. DROFNUD

    Migrating Layer 2 network to VRF

    Hi, We are in the process of merging a couple of networks into one and using VRF's to separate the client zones. The core is a pair of Nexus 5762's with Fabric extenders and we are moving connections from a 6500 over to it. My question is in regards to Client VLANS. Currently we have a Data...
  5. DROFNUD

    Routing issue over dual path firewall...

    I have an issue that I cannot find a solution for, so I thought I would post here. The scenario: Data center #1: Two IP560 firewalls. Interface eth-s1p1c0 configured on both devices with 28 bit mask. VRRP configured. Data center #2: Two IP297 firewalls. Interface eths1c0 configured on both...
  6. DROFNUD

    INTERNET object

    Ignoring the (now realised as stupid) NAT negation idea... What I am trying to achive is an object that I can use in the rulebase for the Internet instead of using ANY. ---------------------------------------- www.itspeedway.net
  7. DROFNUD

    INTERNET object

    Hi, Until now, we've been Negating All_Internal_Networks group in the rulebase to refer to the internet, however you cannot negate a NAT rule... So I have created an INTERNET group that contains the following IP-range objects: Internet_Addressing1 = 0.0.0.1 to 9.255.255.255...
  8. DROFNUD

    WSC Shell Extension

    Hi, Does anyone know if WSC can be used to implement Shell Extensions using IDropTarget, IPropertySheet etc? These are COM handlers and WSC has a COM interface so I cannot see any reason why it couldn't, however I've done a lot of searching and cannot find any examples. Previously I've only...
  9. DROFNUD

    SET amount=(SELECT COUNT... problem..

    Thanks, I got it in the end: UPDATE table1 SET amount=DCOUNT('[rec]','table2','[rec]='&table1.id) I'm not actually storing the result in the real application, this was just an example that showed the problem. I'm using the result of DCOUNT in a calculation based on the number of entries in...
  10. DROFNUD

    SET amount=(SELECT COUNT... problem..

    I think I'm approaching this problem wrong; I simply want to update the count of records in one table with the number of records in another. TABLE1: ID, amount TABLE2: ID, rec I've tried... UPDATE table1 SET amount=(SELECT COUNT(rec) FROM table2 WHERE table1.id=table2.rec); and I tried...
  11. DROFNUD

    NT4 to NT4 Trusts

    Thanks Andrew. I've treid manually addeding WINS entries for FD01 and the FD domain in the WINS used by CL01, and also changed the WINS on CL01 to point to the WINS used at FD but they didn't work. Something strange though: If I use the wrong password it says "Incorrect Password", but the...
  12. DROFNUD

    NT4 to NT4 Trusts

    I am using User manager for Domains to create the trust. Thats when I get the message "Cannot find domain controller". Si...
  13. DROFNUD

    NT4 to NT4 Trusts

    It's been a while since I created an NT4 trust, I just need to run this by some-one cos I'm stuck. Domain CL needs to Trust domain FD. I have added the following to LMHOSTS (yuk) on CL01 (PDC for CL domain) Making sure the domain name and spaces add up to 15 chars in the second lines...
  14. DROFNUD

    Does FLOOR() function in shapesheet use inches?

    John, Thanks for the help, I wasn't aware of the second parameter. I'll give it a go... Si...
  15. DROFNUD

    Is it possible to script the first-time setup of Outlook during login?

    Thanks very much. I've seen the wizard since posting this, but havn't got around to completing the task yet. It's good to know that a solution is in sight. Cheers, Si... ------------------------------------------ Far too busy to be enjoying myself - Lol..
See more

Part and Inventory Search

Back
Top