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 Chriss Miller 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 mhshane

  1. mhshane

    Is this the best way to do this query?

    I streamlined the design down to one subquery (qryEmpFullName) and my main query (qryEmpInfo) And I relearned how to use table aliases qryEmpFullName SELECT EmpID, FirstName, LastName, PhoneNumber, FirstName & " " & LastName AS FullName FROM Contact_List; qryEmpInfo...
  2. mhshane

    Is this the best way to do this query?

    Headcount and Contact_List are spreadsheets created by other people in HR. 3rd party just means, I am not the author and don't have control over the data that is published. Sorry for the confusion. In my situation, manager name is what I have to work with to ID manager. Not ideal at all being...
  3. mhshane

    Is this the best way to do this query?

    It absolutely breaks if the person who makes the headcount spreadsheet misspells a name. Free text fields are always a bad field to work from, but it is the only one I have in this case. The EmpID is my own. Headcount feed doesn't actually contain EmpID and I don't want to ask the author to...
  4. mhshane

    Is this the best way to do this query?

    Hello, hope you are doing well. It has been a while since I built a DB, so my skills are a bit rusty. I am curious if there is a more elegant way to create this query. Two Tables involved: Contact_List has phone numbers Headcount has manager FULL name Both come from other sources on a...
  5. mhshane

    New to NEC PBX, need help with VM pw reset and some general questions

    After posting my initial post I found the link on the Home page called "Configure In-skin Voice Mail Tada! That opened the web interface to manage the voicemail system. Once I found that resetting the mailbox password, etc was easy to find. Thank you to gbtac3 and NEC Tech for your assistance...
  6. mhshane

    New to NEC PBX, need help with VM pw reset and some general questions

    Hello. Hope you are doing well. I have experience with Avaya and Nortel but now work at a place that has a NEC SV9100. I have the MAN and SA level accounts. Most of it seems pretty straight forward. PBX contains: SV9100 GCD-CP10 Single Line Int GCD-4LCF VM/App Server GCD-VM00 Application...
  7. mhshane

    NEC 9100, call forward to cell phone, user wants to transfer back to another extension

    Hello. Hope you are doing well. Our customer care team is about to get T-Mobile phones with Movius business lines. I am wondering if this scenario is possible: Call reaches Sue in customer care. Call forwards on no answer to her cell phone. Sue answers. During the call she needs to transfer...
  8. mhshane

    Query to find keywords in description field and give count

    Hello. Hope you are doing well. Trying to analyze helpdesk tickets based on keywords such as "install" I want to get a count of how many tickets involve user needing to install something Example: Keyword: install Need to count the records where "install" is in the description but not...
  9. mhshane

    Having some issues with Wireless IPT phones (7921) after replacing APs

    Hello. Hope you are doing well. We recently redirected our 3702 APs to a new WLC. They were connected to a CT5508. Now they are on a CT8510. Everything seems to be working fine except for Wireless IPT phones Model 7921 Using WPA2 Enterprise Short Issue description: 1. Intermittently...
  10. mhshane

    Mod Msging ringing busy, Denial 1192 & SysMgr Login failure

    Found my mistake...but I am still stuck. At the kvm on the computer rack root/root01 gets me into [root@HPDom0] But I need to be in [root@smgr] I used Putty to SSH to SMGR and found that root/root01 doesn't work. So that explains why the steps on the CLI worked but the steps for the...
  11. mhshane

    Mod Msging ringing busy, Denial 1192 & SysMgr Login failure

    use the CLI admin credentials to login in using the local-login page That is where I am stuck. The admin credentials do not work at the local-login page Example: I use root/root01 at the CLI I am at the # prompt and can execute all the required commands on the CLI When I open the local-login...
  12. mhshane

    Mod Msging ringing busy, Denial 1192 & SysMgr Login failure

    Aura SMGR 6.3 MM 5.2 So my problems started when the vm began ringing busy List trace sta shows denial event 1192 Googled that Rebooted MSS and MAS1, MAS2...it was time No resolution Got into the Sysmgr and tried to reboot the Session Mgr System said it could not reboot Session Mgr because it...
  13. mhshane

    H.323 between Avaya and Cisco, Cisco calls fail, Avaya calls work

    I found the answer...and it's rather humorous. I finally reached the phone guy on site at Bogota and he said they don't use voicemail. Said all calls route to the receptionist. Well, 70% of the users have hu 99 as the first point of their coverage path so that isn't not correct. And the other...
  14. mhshane

    H.323 calls from Cisco fail when routed to Audix

    I found the answer...and it's rather humorous. I finally reached the phone guy on site at Bogota and he said they don't use voicemail. Said all calls route to the receptionist. Well, 70% of the users have hu 99 as the first point of their coverage path so that isn't not correct. And the other...
  15. mhshane

    Mod Messaging Secondary Extension problem

    Hello, Hope you had a great weekend. Equipment: S8800 w/ CM 6.0 Modular Messaging 5.2 (MSS and dual MAS) Calls to ext 4051 and 6473 need to go to the same mailbox at subscriber 4051. So I added 6473 as a Secondary Extension to Subscriber 4051. System said changes were successful. I verified...
See more

Part and Inventory Search

Back
Top