• SQL Server Maintenance Task Failing

    7
    1 Votes
    7 Posts
    2k Views
    JaredBuschJ

    My co-worker wrote a quick stored procedure to make searching the command logs easier also.

    You can execute this proc with no parameter to see everything, or you can pass a search string. Remember it is a string and use the % wildcard appropriately.

    exec AA_CmdsExecPast24Hrs '%tablename%'
    exec AA_CmdsExecPast24Hrs '%Jared%'
    etc.

    /****** Object: StoredProcedure [dbo].[AA_CmdsExecPast24Hrs] Script Date: 10/08/2015 11:02:42 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Bill Russell - Bundy & Associates -- Create date: 6/29/2015 -- Description: Returns a list of queries run over the past 24 hours. -- ============================================= CREATE PROCEDURE [dbo].[AA_CmdsExecPast24Hrs] @ContainsLIKE varchar(300) AS BEGIN SET NOCOUNT ON; SELECT execquery.last_execution_time AS ExecTime, ExecSQL.text AS [Script] FROM sys.dm_exec_query_stats AS ExecQuery CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS ExecSQL WHERE @ContainsLIKE='' OR (@ContainsLIKE <> '' AND ExecSQL.text LIKE @ContainsLIKE) ORDER BY ExecQuery.last_execution_time DESC END
  • OpenFire Server

    31
    1 Votes
    31 Posts
    6k Views
    scottalanmillerS

    @bbiAngie said:

    My biggest deal was that when I took the class, my book was a few versions behind the OS version they gave us. All of my homework was explaining what it should do and why it wasn't doing it. It was a huge turn off for me.

    The turn off should have been for the educational process 😉 That's where the problem was.

  • How Do You Leave a Group in Skype

    9
    0 Votes
    9 Posts
    2k Views
    dafyreD

    @scottalanmiller opens eyes wider Ah, so you did. Sorry, lol.

  • Connecting MS Office to Flickr

    14
    3 Votes
    14 Posts
    3k Views
    scottalanmillerS

    @Carnival-Boy said:

    I would certainly never call it amazing or wonderful!

    They had some dark years. System is returning to glory now, I think.

  • IT Asset Tool

    10
    0 Votes
    10 Posts
    2k Views
    scottalanmillerS

    @meghal said:

    @dafyre Yes i am looking for that kind of tool.

    Spiceworks would be the obvious place to start. At least check it out as a starting point.

  • Surface Pro 4

    18
    2 Votes
    18 Posts
    4k Views
    Minion QueenM

    I use my Ipad all the time. I can work from it in a pinch.

  • 1 Votes
    12 Posts
    5k Views
    scottalanmillerS

    Good way to think of it. Clean install is a little extra work today in exchange for a "known" or nearly known environment. An in place upgrade means carrying risk with you, maybe a little, but some that might bite you later.

    Or maybe the next IT guy, just leave the headaches for him 😉

  • Windows 8.1 to Windows 10: Mistake?

    33
    1 Votes
    33 Posts
    8k Views
    gjacobseG

    I would think it should be close enough - like you said,.. assuming it is like most companies.

    I do have another fall back option.. just a matter of coordinations.. Former co-worker has the same laptop (it's his fault I bough this thing).. so push comes to the last line,..I might be able to get it from him.....

    Maybe.

  • Stop Buying Hardware Before You Have Designed the System

    45
    4 Votes
    45 Posts
    13k Views
    scottalanmillerS

    @Dashrender said:

    Are you saying that I would skip ever talking to a sales person (until I'm actually read to buy) because the expectation is that I would get everything I would need from the forums consultants?

    I'm saying that salespeople are not part of this process until you are past your design stage. Period. They do not add value but add risk and confusion. No matter what process you use to get your information (research, forums, hiring a consultant...) doesn't matter. What does matter is that salespeople and others who don't have a reason to help you or don't have the resources to help you should not be engaged.

    There isn't an expectation that you will ever get everything that you need. That is a red herring. What matters is salespeople are not where you find what you need and you should never expect them to lead you in that direction. You should get advice from people whose interest is to help you, not from people with the explicit task of misleading you!

  • Weird laptop problem

    5
    1 Votes
    5 Posts
    880 Views
    scottalanmillerS

    @Brett-at-ioSafe said:

    The power brick is definitely the place to start but, the fact the fan runs continuously, makes me think it may not be the problem.

    I would agree. Seems likely that it is something other than the power supply if the fan is part of the issue.

  • CISCO IP PHONE SPA502G

    27
    1 Votes
    27 Posts
    3k Views
    DustinB3403D

    Celery, yes that stuff for rabbits and me it would seem.

    Thank you for the recommendation @Dashrender

  • Office 365 and Access

    22
    2 Votes
    22 Posts
    5k Views
    J

    We don't allow access. It requires a written letter signed by the employee and their boss to be submitted to the board for approval. we have 2 users across a very large company as well. we also don't support anything users make with formulas or macros in excel.

  • Hyper-V and deleting Snapshots

    41
    1 Votes
    41 Posts
    9k Views
    dafyreD

    @scottalanmiller I think of Snapshots as a quick point-in-time view... if something breaks, I can restore that snapshot in mere seconds, and I'm good to go.

    If I have to pull a full image from a backup, it could take minutes - hours to restore that backup...

  • The Linux Jumpbox: How to

    18
  • ESXi and Proliant Weekend Woes

    12
    1 Votes
    12 Posts
    3k Views
    DustinB3403D

    It certainly wouldn't hurt to grab an older system and set it up to be your remote logging server for your ESXi infrastructure. It would at least give you something to look through while researching this issue.

    Have you asked on the ESXi forums if anyone has any input on this?

  • Data Transfer of Daily Internet Usage

    15
    0 Votes
    15 Posts
    2k Views
    StrongBadS

    I don't understand what you want to know.

  • How does the routing for calls on a Elastix PBX System work?

    8
    1 Votes
    8 Posts
    2k Views
    JaredBuschJ

    @Mike-Ralston abbreviated a bit, but hit the basics.

    Before you can do any routing, you define the trunk. Once you have that up, then you can worry about routing.

    For Inbound routing, you have a few choices.

    First you have to know if you need to even care about the DID the called dialed. If you do not, things get easy. You just create or edit the any/any inbound route and scroll to the bottom as noted to set the destination.

    If you have to be more specific, then you need to first know how the number is being passed into your system. Using US dialing as an example, numbers come in the format NPANXXXXXX and the country code is 1.

    Depending on the SIP carrier, the call may be presented to your PBX with or without the 1.
    VoicePulse sends the DID with the 1 while VoIP.ms does not.

    This can be important depending on how you want your routing to go.

    You specify in the inbound route what inbound DID it will match on.
    img

    You can additionally specify the the route matches on the CID of the inbound caller if desired for very fine grained routing. Somehow that annoying person also seems to get routed to Time and Temp? What? 🙂

    You have a few other choices to make on the way down the screen, then you pick the destination for the calls that match the above two criteria.
    In this case an IVR.
    img

  • 0 Votes
    3 Posts
    659 Views
    scottalanmillerS

    Sure, but it would depend on your system in question. Which resource are you lacking? If you don't have enough CPU, then CPU will be your bottleneck. If you don't have enough RAM, then memory will be, etc.

    PBXs handle whatever loads you design them to handle. With enough resources a PBX can handle millions of calls.

  • Fedora Server

    10
    1 Votes
    10 Posts
    2k Views
    scottalanmillerS

    @johnhooks said:

    @scottalanmiller said:

    @johnhooks said:

    I knew the workstation version was, I just didn't understand why they have a "server" version.

    Server and workstation are just different sets of packages. Not different products. Server is the actual proving ground, the workstation isn't really a big deal since no one actually uses CentOS or RHEL as a desktop, that would be pretty silly in general. Fedora Workstation is the product that is actually used as a workstation. It is Fedora Server that is the actual proving ground for CentOS and RHEL.

    I actually did use CentOS 7 as a desktop for a while, just to try it. It wasn't bad. I don't use anything strange, and was able to compile everything else I needed. Their gnome theme is pretty nice.

    Thing is, if you used CentOS 7 that means that it was pretty new. But CentOS 7 will be one painfully old desktop by the time that CentOS 8 is getting close. Fedora updates every six to eight months, so their desktops are always current. So you are never looking at something outdated. CentOS 7 will be many years out of date when it is time to replace it.

  • Raspberry Pi Usage

    6
    1 Votes
    6 Posts
    884 Views
    MattSpellerM

    RPi's are freaking awesome for learning linux or programming or electronics. When I see one my mind boggles at all the possibilities they contain. Like below, they're nothing special as far as a computer goes, but if they ignite your passion then I would consider that valuable and worth pursuing.