@JaredBusch You think those "877D.lnk" shortcuts open some kind of connection that is using all those: akamai, amazonaws, and cloudfront connections?

That reminds me of when I look at network activity when Outlook or something Microsoft is having trouble connecting online, and I open that up to see what's going on... I see a ton of Akamai connections.

I would think Akamai and Amazon at the very least prevent malware from using their services. Must be something else.

But I wouldn't yet rule out a possibility of both... perhaps there is a legit reason for those cloud content delivery services such as OneDrive or something... plus, something going on with those links in the startup folder.

Don't you have something like ESET running to help protect systems?

Trying to figure out how to study and type while holding my soon-3month old...

Took a second look and seen owncloud.exe running. Maybe it's that. Look at disk activity to see what owncloud.exe is doing.

Looks like some kind of cloud storage like OneDrive, DropBox, Google Drive, etc. Check for those on the system.

@scottalanmiller

Yeah I've always said sequel because that's how I learned it, not because I was aware of its original naming history.

Now that I do know, it just makes more sense to call it SQL instead of SEQUEL.

Maybe the creators should have checked existing names and been more clear about it before they called it that. Seems to me like they were well aware of the naming conflict but did it anyways for the pun and laughs.

I wouldn't be allowed to create a phone device and call it a Crapple because of a cranberry-apple theme or whatever. I'm sure Apple would would have a field day.

@scottalanmiller said in What is a Database Management System:

@RojoLoco said in What is a Database Management System:

@scottalanmiller said in What is a Database Management System:

@NerdyDad said in What is a Database Management System:

It was their rule, I simply obeyed it and carried it with me as a rule afterwards.

Even in graduate work I've gone to the dean and challenged using myself as a source and won

But how many others would take the time to batter the dean with semantics like you did until he just gave in? Very few.....

Cuz they be lazy

So, if it's no longer (for a VERY long time now) “Structured English Query Language” (SEQUEL), and has been, and is officially, “Structured Query Language” (SQL), where do you get the "sequel" pronunciation from now? I think if that is the case, nobody should use new product names if they have been changed in the past.

@JaredBusch Oh, is there a link to fill me in?

@RojoLoco said in Bootleg T-shirts for MangoCon 2017:

I'm totally thinking about ordering some of these... who would buy one at MC '17? Who's with me???

Actually, it's not!

http://patorjk.com/blog/2012/01/26/pronouncing-sql-s-q-l-or-sequel/

@scottalanmiller said in Do I need help desk system ?:

We normally have IT submit tickets because users often put in useless tickets without useful details.

Yes you'll have that. Our system automatically includes pc name and user name. So you'll have breadcrumbs at the very least to follow up with.

I think that's better than nothing at all. Also, IT generally doesn't have time to act as a ticket receptionist. Maybe not the case in big places where there's a team dedicated to it, but in smbs, IT is only 4 or less people.

The first thing about helpdesks is that your company policy may require record of all IT activities, whether it for legal reasons or for the sake of record keeping or other reasons like patterns. It may also serv as a way to remember how you resolved a past similar issue.

Whether or not you need a ticketing system depends on if it will benefit the company. If you are walking through the halls to do a specific task, and someone stops you for one of those "quick questions", you may forget what you are going to do or you may forget what the person in the hall just tasked you with. I suppose you could walk around everywhere with a pen and pad, but that isn't always the case.

Ticketing systems also help to stay organized and to help prioritize things closer to the money. I don't know anyone who can live from the list of 1000 things strictly in their head. Having it documented somehow will be best.

We require all users to submit tickets. If you don't know if you should make a ticket, make a ticket. If a user emails you, forward it to the ticketing system. Most systems will automatically turn them into a ticket.

If a user calls you and its more of a request than a question, kindly ask them to submit a ticket.

Depends completely on your environment of course, but those are my thoughts anyway.

Wrote this on my cell phone which is hard, so excuse my not so well thought out points and spelling errors.

We found a "Computers 2 Kids" charity that we donate all PCs, servers, etc to... that are at least in good enough condition to work or get working with minimal effort. Ex: new hard drive or RAM needed.

It's local to us here in San Diego... but there may be something similar near you.

@DustinB3403 Ahh I see, then yes a prompt for input script is best then.

Also, if you have a specific group of people, you can use a "get-" command instead of .csv list. I meant that lists like I said about above are best if it's not an easy grab using a get command.

I'm probably not explaining myself right, you know what I mean?

@DustinB3403

I usually make big lists in Excel and use that in PowerShell. You could output all users "sAMAccountName" to CSV... then on the first line in the next column type the @domain.com and drag it down to the end.

Then in the columns before and after it, do the same thing... type in the powershell commands you need, drag it down tot he bottom to copy it to each line, copy it into notepad++, replace all tabs with spaces, and call it a .PS1.

Sounds like a lot, but it really only takes literally 2 minutes to make a list of hundreds or thousands and turn it into a .ps1.

I wouldn't try to automatically use a capitalized "SMTP" as in the example you "had tried" at the end of your post. If you did then every entry you add in to a proxyAddress attribute would have a capitalized SMTP. Only the main login should have capital SMPT, the rest of them (aliases) should be lower case).

As for improving PowerShell skills, I bought this when it was released: https://www.amazon.com/Windows-PowerShell-Step-3rd/dp/0735675112
and I highly recommend it. I haven't gotten though much of it yet because I'm trying to finish up some MCSE's first, but I will be diving a lot more into it soon.

@DustinB3403 Yeah maybe I am paying $70 a year... I forget.

I'm not familiar with this scenario, but off the top of my head, I would verify with the company you work for to see if you would be able to export / backup your O365 account to a PST file for your mail, and backup the rest of your stuff on other services.

Then I would purchase a personal yearly subscription. I think i'm paying $99 per year, which allows for up to 5x 1tb storage accounts, the office suite, and skype time... among some other percs.

I'm not sure what you require, perhaps the personal subscription won't be enough for your needs, and you'll need to look in a business license or something.

It very well could be that the server had several network ports, and someone just figured they all aught to all be plugged in... just out of ignorance. I'd see what traffic is on them as I said above. Or what you said, just ask them why.

Open up resmon.exe, network tab.

TCP Connections section, then look at Local Address for the IPs, and see what's connecting to them.

Sometimes, the only way to find out what something does is to unplug it, then wait by the phone.

Haha, just kidding... but not really. Be careful!