ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login
    1. Topics
    2. gjacobse
    3. Posts
    • Profile
    • Following 2
    • Followers 5
    • Topics 713
    • Posts 9,626
    • Groups 1

    Posts

    Recent Best Controversial
    • RE: Rack / Table For Tower Servers

      Better then what I have / had.

      Last office was a folding table with a HP ML350 on it... The other new Dell PE2900 was on the floor,.. the firewall - same place.. floor. With the 2 APC UPS 1500s.

      Oh - the sprinkler head was right above it all.. Poor design / placement for the network infrastructure.

      New office has 2 buildings in a H floor plan. End of each main hall is a utility closet, half with the HVAC, other half....well. stuff.

      Of the 12 closets I have 7 servers sitting in them,.. no real ventilation on each.. It's a plan to deal with it, and a rack is planned...

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: Bundled Patch Cables for Cable Management

      @scottalanmiller said:

      I'd use velcro instead.

      Good point. If you had to remove just one cable you're in for a bit of work to pull it out of the spiral stuff.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: Bundled Patch Cables for Cable Management

      Interesting concept,.. but something you can easily do after a trip to ACE Hardware, LOWEs or Home Depot..

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: Excel 2007 vs 2010

      @ajstringham said:

      @g.jacobse said:

      I'm not sure how much I can offer - it's a protected sheet, we are only allowed to enter some data. But there are 4 date fields and a day calculated from that.

      Start Date; Release Date; First date of month, last date of month.

      Here is the formula which is in column "K":

      =IF(ISBLANK(H5),"",IF(ISBLANK(G5),"Enter START DATE to calculate",IF(AND(MONTH(EOMONTH($A$2,1))>MONTH(G5),MONTH(G5)>=MONTH($A$2)),IF(ISBLANK(F5,EOMONTH($A$2,0)-G5+1,H5-G5),"START DATE MUST BE >= "&TEXT($A$2,"mm/dd/yyyy"))))

      Column Fields:
      e= Arrival Date
      f= Release Date
      g=Start date
      h= end date
      k=#of days formula above

      Based on what I've tried,.. the formula works as long as you don't enter anything in the Release date. Once you enter the release date, the #of days drops by 1.

      I'm told it works 'correctly' on one computer. I've tried two computers here one with 2010 and one with 2007 and get the same result. count is off by 1 (30 days rather than 31).

      I believe the MONTH variable is 30 days. That's probably where the issue is.

      I can see that being the case. However: Why would it work on one computer and not on any other.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: Excel 2007 vs 2010

      Something I might should have done (it's more advanced Formulas than I know) - is copy the formula into a new clean workbook.

      I do get an error: You've entered to many arguments for this function.

      I also see that the formula in row 5 calls Row2 Col 1 which is current begin date of the month.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: Excel 2007 vs 2010

      I'm not sure how much I can offer - it's a protected sheet, we are only allowed to enter some data. But there are 4 date fields and a day calculated from that.

      Start Date; Release Date; First date of month, last date of month.

      Here is the formula which is in column "K":

      =IF(ISBLANK(H5),"",IF(ISBLANK(G5),"Enter START DATE to calculate",IF(AND(MONTH(EOMONTH($A$2,1))>MONTH(G5),MONTH(G5)>=MONTH($A$2)),IF(ISBLANK(F5,EOMONTH($A$2,0)-G5+1,H5-G5),"START DATE MUST BE >= "&TEXT($A$2,"mm/dd/yyyy"))))

      Column Fields:
      e= Arrival Date
      f= Release Date
      g=Start date
      h= end date
      k=#of days formula above

      Based on what I've tried,.. the formula works as long as you don't enter anything in the Release date. Once you enter the release date, the #of days drops by 1.

      I'm told it works 'correctly' on one computer. I've tried two computers here one with 2010 and one with 2007 and get the same result. count is off by 1 (30 days rather than 31).

      posted in IT Discussion
      gjacobseG
      gjacobse
    • Excel 2007 vs 2010

      Would there be any differences in how formulas are processed between 2007 and 2010?

      I've got a spreadsheet which I'm guessing was created in 2010 and being used in 2007. It's saved in .xlsx format, but the formula isn't calculating correctly in 2007. And for <me> in either 2007 or 2010....

      posted in IT Discussion excel
      gjacobseG
      gjacobse
    • RE: Deepin 2014

      It looks like a sweet setup.

      reading the About page triggers a voice in my head - is it safe / secure?

      I know that question smacks of complete distrust and such, I'm not a real conspiracy nut; but i/m generally cautious of software....

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: Twenty Old Tech Sounds

      I imaging with the progression of things, that the Click of a hard drive head crash will be one we add to that list some time in the next 10 - 20 years. As SSHD increase in capacity... we'll use SATA less.

      *click, click whir; click, click whir"

      posted in IT Discussion
      gjacobseG
      gjacobse
    • (xx)HD Test / Wipe tool(s)

      My brother asked me about how I would test and wipe a hard drive..,.. Any type. He has some old SCSI type, as well as PATA and SATA drives.

      Other then spending hours with only one computer going from back and forth with a drive or spending upwards to $1800, is there a way to test a drive to see if it's still 'trustworthy' or toast,.. and then wiping them.

      This is a personal level thing - he's picked up a stack of drives and want to be able to either use them or destroy them with no or little cost.

      posted in IT Discussion sshd hdd sata scsi
      gjacobseG
      gjacobse
    • RE: O365 Migration: Push

      Just deleted the script and created it again - it works,.. but extra steps.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: UniFi: Admin panel

      @JaredBusch said:

      In the system tab there is a button to download/export the current config.

      Do that for the one you want to keep. Then reinstall on the new hardware. When you first open the webpage on the new controller there is an option to import a backup. Do that. You will retain all settings from that config.

      That has been done. I don't know the version I'm running currently, but I'll check. In the meantime,.. I'll pre-download the newest version and go from there.

      Thanks Jared.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • UniFi: Admin panel

      I've managed to end up with two laptops with UniFi data on them, and for different sites. This is because of "I need to do this and my laptop won't' having to loan out this one.

      I want to start fresh,.. and not kill my configs, but if I have to that's okay too. My goal is to set all the APs with the same information, and at some point controllable from my main office (via vpn).

      Where are the config files? Looking on this system, they aren't where I would expect. My Docs or in the PGM folder.

      posted in IT Discussion unifi ubiquiti
      gjacobseG
      gjacobse
    • RE: O365 Migration: Push

      @JaredBusch

      Sadly - not everyone has gotten started in O365 yet... we are still in transition.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: O365 Migration: Push

      @JaredBusch said:

      coming from pop3 what is there to migrate? this is used to migrated from another exchange server.
      When you import a PST locally it ups everything.

      I guess I am confused on what you are migrating.

      While we can setup as POP, Seems that many are setup as iMAP. Anyone I set up has been as iMAP since many moved around to different computers.

      Many only us the webmail interface, so all their mail is still abled to be pulled.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: O365 Migration: Push

      @JaredBusch
      Pretty much. There was - or at least so I thought a 'triangle' in the options ( Add, Edit, Delete, Refresh). To 'push start' or manually start it.

      Seems one of my items hasn't run since Saturday, I've not had new mail in two days now.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • RE: O365 Migration: Push

      @Dominica; I am doing this from the GUI. I haven't had the time, interest, or motivation to consider Powershell.

      It just seemed interesting that I was able to do the manual start last week via the GUI, and this week I can't seem to locate it.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • O365 Migration: Push

      Last week I manually pushed a migration script to run. This week I don't seem to be able to do so.

      Is there another way to push it? it doesn't seem to have run in almost 36 hours.

      posted in IT Discussion 0ffice 365 migration
      gjacobseG
      gjacobse
    • RE: The Countdown

      Interesting that I can't seem to get to the last page..... Only going to about a month

      Logged out/in didn't seem to help.

      posted in Water Closet
      gjacobseG
      gjacobse
    • RE: Biz hub 600: HDD location

      Back to searching.... going through that document,.. it may not have a hard drive at all.. But I have to make sure.

      posted in IT Discussion
      gjacobseG
      gjacobse
    • 1
    • 2
    • 476
    • 477
    • 478
    • 479
    • 480
    • 481
    • 482
    • 478 / 482