Posts made by Sparkum

Currently running Plasma at home

Hey guys.

So just doing some more reading on Branch Office Direct Printing just kinda finding mixed opinions.

So all of our computers are Windows 7 (and prob will be for a good while)

Can I use branch office direct printing? I assume thats my best option right? Alot is saying Windows8+ only with a fall back to legacy,

Rather will I see a benefit to using it now versus just future proofing.

Thanks

@Dashrender

Haha sorry ya thats what I meant.

@Grey

That sounds awesome, I can only imagine how much time my lower tier spends on installing these stupid things.

@Dashrender

Hmm very interesting and awesome!

Thanks guys, looks like I have my project for tomorrow.

@Grey

I assume this isnt actually the case?

"The Active Directory Domain Services (AD DS) schema must use a Windows Server 2003 R2 or Windows Server 2008 schema version."

Additionally if I go this option and the server dies tomorrow does that mean no one can print?

Or the server is simply giving permission to install and serving up the drivers, and everything else simply becomes local?

@Dashrender said in Allow non administrator users to install printers:

@Grey said in Allow non administrator users to install printers:

@Dashrender said in Allow non administrator users to install printers:

As @JaredBusch mentioned - I do this.

I have print queues setup for all of my printer types on the server. This then has the drivers installed on the server. When you create the printers in your GPO, you can set them up as IP direct printers, but you still point them to the print server to get the driver. This has worked very well for my remote locations where I don't have a print server. The machine gets the GPO, then adds the printer and downloads the driver from the remote print server, but after that, prints IP direct.

It will only print 'direct' if you have enabled Branch Office Direct Printing.
https://technet.microsoft.com/en-us/library/jj134156(v=ws.11).aspx

I'll look at that post in a min, But I haven't intensionally done anything regarding Branch Office Direct Printing and it's working just fine.

My GPO Printer objects have the IP address for the printers in them. The Print Queues setup on the server have IPs for printers in my main location, and know nothing about the IPs of the printers in the remote location - so I'm not sure how it would be flowing through the server, if that's being implied here.

Here is the setup page from GP
https://i.imgur.com/90e0Fqa.png

And you just set all printers to static IP's I assume?

Hey all.

So for the drivers for GPO I assume I'm going...

User configuration>Policies>Software Settings>Published Applications> then add my printer driver.

Then for permissions I would go

Computer configuration>Policies>Window Settings>Security Settings>Local Policies>Devices>>Devices:Prevent user from installing printer drivers: Disabled

And

Computer configuration>Policies>Administrative Template>Printers>>

Users can only point and print to these servers: Disabled
Enter fully qualified server names separated by semicolons
Users can only point and print to machines in their forest Disabled

Security Prompts:
When installing drivers for a new connection: Do not show warning or elevation prompt
When updating drivers for an existing connection: Do not show warning or elevation prompt
This setting only applies to:
Windows Vista and later

Is there anything else that would need to be added?
Or something I should remove?

And some of you are suggesting a printer server, so would you esentially do one server that has upwards of 50+ printers on it?

Thanks

Hey all.

I've tried once or twice before (and failed) to allow non administrators to install printers with all the management being done at the main office (~36 locations all on a MPLS)

So my question is, whats my best way? I'll start googling my options right now too but figured I'd check with the brain trust first

Thanks!

Awesome thanks guys, I'll wait for the next computer to go down then I'll report back with results!

Oh shoot, sorry I meant DHCP
(Sorry fighting a cold, not really head strong right now)

Hey there.

I was hoping some of you would be able to help me diagnose a strange DNS issue I am having at work.

So roughly every 2 days, typically 1 computer will have this issue, and its been going on for a few months now but havent had 30 seconds to look at it until post xmas, then higher priority projects etc.

So to begin it will "typically" appear that external internet access is lost, the user will reboot their computer, and upon reboot will have lost internal and external access.

Once at this state the only resolution appears to be to do an ipconfig /release /renew,

I would say out of an office of roughly 50 people, this has only ever affected maybe...7 people, for a total of....maybe 40 times in the past 4-5 months.

Its definitely nothing 911 critical however; it has started to affect our President a few times now so that obviously jumps it up in the priority que.

Would anyone happen to have any suggests on where to start going down this rabbit hole.

Thanks!

@FiyaFly
Hey

Ya one of the largest points of re-doing everything is to get it to a point where we can schedule it (we currently run it 2 times a week and then enter some information)

So we are also trying to get all the cells that we would manually add information to populate.

There are alot of one off reports (using this report) that people want, for example we currently run it on Monday and Thursday, but people also want then different time frames etc so while scheduling it eliminates the time problem it only really half eliminates it.

I was actually able to make a few changes and got the report down to 27 minutes, so I'm back on track for optimizing the report!

Thanks

@scottalanmiller

For sure, and I am definately going to take SUMINDEXING to our developer.

So that would explain the 45-60 minutes jump (since we got the 3 hours back down to 60 minutes)

But the fact that it jumped from 60 minutes to 120 minutes is ENTIRELY on me since my previous version still runs in 60 minutes.

@scottalanmiller

Oooh, sorry I didnt catch that.

@scottalanmiller

So we upgraded from Nav05 to Nav2016

Database side shrunk by ALOT

So it immediately jumped to 3 hours.

We contacted Jet, he found thousands of #REF under the Name manager, cleared those out and it shot it back down to an hour (origionally 45 minutes) so thats awesome, esentially back to where we were.

Then he suggested to do alot of things saying it will speed it up

So I started on the 61 page report, doing his suggestions and then adding/changing things like adding more logic like if(cell=0)hide or iferror="-" kinda thing

Which apparently was the wrong decision because it shot up to an hour.

Now the easy answer is to undo the "Make it look pretty" changes I added, but fuck its an ugly report filled with #VALUE and #0/DIV that I would love to clean up

@scottalanmiller

Esentially as long as EVERYTHING looks the same I can do it.

So it has to still be Jet, formatted the same way etc.

So formula's changing is alright as long as the numbers come out the same

@scottalanmiller

Well the fact that in the last 2 months its gone from 45 minutes, to 3 hours, to 1 hour and now back up to 2 hours means there's obviously stuff that can be changed and optimized.

Thats fine I'll just keep googling and reading in the Jet Forums

@Sparkum To me, it sounds like you are running something that should not be done in Excel in the first place. You need a SQL developer to come in and help your rewrite that.

I get how you are at the point you are, but honestly it should have been rewrote years ago if it takes 45 minutes to execute before.

I dont disagree with you; however, its simply not an option.

You know how higher ups work. This report has been "the report" for over 10 years, no ifs ands or buts.