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!

Search results for query: *

  1. octavian10

    Temp CME Setup Question

    Hello all, I need to setup a temporary Call Manager Express system while the Call Manager system is being built. I have the the CME system just about complete but reached and area that is really kicking my butt. I understand Call Manager Call Flow but with CME I am just not grasping it. In CM I...
  2. octavian10

    Auto QOS for Call Manager Switch Port?

    I think this may be a silly question that came about from configuring a switch for Auto QOS for ip cameras. The debate was, should the recording server switch ports be programmed with "auto qos video ip-camera"? What does this have to do with CM? Well, I was under the impression that CM...
  3. octavian10

    Query by number of characrers in a data column?

    No but that worked! Thanks so much "I hear and I forget. I see and I remember. I do and I understand." - Confucius (551 BC - 479)
  4. octavian10

    Query by number of characrers in a data column?

    Hello, is there a way to query a sql database by the amount of characters? I am trying to find account numbers longer than 12 characters. Thanks "I hear and I forget. I see and I remember. I do and I understand." - Confucius (551 BC - 479)
  5. octavian10

    VG202 MGCP CallManager 4 Registration Issue

    I am trying to setup a VG202 as an MGCP gateway with CallManager. I cannot get the FXS ports to register with the CM. When I run show ccm-manager on the gateway it says Registered but the History Error Log shows: voice-port 1/0 no shut voice-port 1/0 signal loopstart It seems like the CM is...
  6. octavian10

    Issue with VG202 and CallManager 4

    I am trying to setup a VG202 as an MGCP gateway with CallManager. I cannot get the FXS ports to register with the CM. When I run show ccm-manager it says Registered but the History Error Log shows: voice-port 1/0 no shut voice-port 1/0 signal loopstart It seems like the CM istrying to no shut...
  7. octavian10

    Convert INT to DATETIME

    I have tried this: select (datetimeorigination - DATEDIFF(s,0,getutcdate() - getdate())) Which does the EST change in seconds but I cant get it work with conversion you showed me. I have also tried other variations of the above but cant seem to get any of them to work. It seems that some how I...
  8. octavian10

    Convert INT to DATETIME

    One last question I swear! This works great but it returns a UTC/GMT time. I need to convert this to EST time. Cant seem to do it with out messing up the query. Thank you "I hear and I forget. I see and I remember. I do and I understand." - Confucius (551 BC - 479)
  9. octavian10

    Multi Server Trigger Help

    Hello all, I need to see if something I have been tasked with is possible and if it is any help on how to code it would be much appreciated. Here goes, Two servers SERVER-A and SERVER-B. SERVER-A HAS DATABASE-A with TABLE-A with COLUMNS 1 2 3. SERVER-B has the exact same scenerio DATABASE-B...
  10. octavian10

    Convert INT to DATETIME

    A little more help with this please. I need to use the above SELECT statement on a table but only for the current date. I am not sure how to accomplish this with this conversion. In other words the above SELECT statement needs to have a WHERE clause that asks only for the current date. Not the...
  11. octavian10

    Convert INT to DATETIME

    It is a UNIX second number and your reply is exactly what I was looking for. Thanks a bunch again! "I hear and I forget. I see and I remember. I do and I understand." - Confucius (551 BC - 479)
  12. octavian10

    Convert INT to DATETIME

    Hello, I need help converting a column that is set up as an integer to date time. My current query - SELECT dateTimeConnect FROM dbo.CallDetailRecord - returns 1284149324. I need to convert this number into datetime for some custom reporting. This conversion needs to be part of this query as...
  13. octavian10

    3 location site to site vpn configuration

    Hello all, Can someone please help me with either a link or sample configuration for a 3 site VPN configuration. I am familiar with a site to site configuration but have never programmed this for 3 locations. In other words I have a customer that needs to set up a site to site VPN to two of his...
  14. octavian10

    Quick VPN NAT Question

    Hi All, I am having a problem with an ASA 5505 setup to as an Easy VPN Server. All works well except that the device acts as a DHCP server for the local lan and issues ip addrsses in the 192.168.1.0 network (default). The problem I am having is some vpn users home routers issue address to their...
  15. octavian10

    Aironet 1300 No Configure Terminal Question

    Here is a stupid question, why is there no Config T option on a brand new Aironet 1300. I starts up OK, I enter Enable OK, it asks for a password I enter Cisco OK, I type Configure Terminal it says Configure is an invalid input. In the list of available commands configure terminal is not there...
  16. octavian10

    Cisco 3529's GBIC not working??

    NegreteH, This is what I had to do to get these to work, Power down the switch (hopefully you can), insert the GBIC's, attatch something to the GBIC (another switch, router, computer, some form of ethernet, power up the switch and they should be there. The biggest thing is to have something...
  17. octavian10

    Quick data conversion question using CAST?

    Cool, thanks again. "I hear and I forget. I see and I remember. I do and I understand." - Confucius (551 BC - 479)
  18. octavian10

    Quick data conversion question using CAST?

    SELECT ID, ACTIVATE, DEACTIVATE, CAST(ACTIVATE AS VARCHAR) AS [Activate Date], CAST(DEACTIVATE AS VARCHAR) AS [Deactivate Date] FROM VENDOR In the above statement how do you keep the original ACTIVATE and DEACTIVATE from being returned in the result set? In other words, I only want to see the...
  19. octavian10

    Where Can I Download SQL Server 2000?

    Hello all, I lost my SQL server 2000 Disks, does anyone know where I can download this media? I have the license, SP3a and 4 and Reporting Services but no SQL installation disks. I need to do some testing in a virtual lab and am limited on time so it would be great if I can find some place to...
  20. octavian10

    Cisco 3529's GBIC not working??

    Also the switches are running 12.0(5)WC17 IOS and the GBIC's are G5483 which according to Cisco there is no compatibility issues. And like I said the switch detects the them. "I hear and I forget. I see and I remember. I do and I understand." - Confucius (551 BC - 479)

Part and Inventory Search

Back
Top