Office
88 TopicsPrinter Driver not found in DriverStore even though the file is there
I have a script that installs printer drivers onto a machine. It has worked perfectly for years up until yesterday. This is the script: # This script works on Windows 8 or newer since the add-printer cmdlets are't available on Windows 7. # Download the HP Univeral Printing PCL 6 driver. # To find\extract the .inf file, run 7-zip on the print driver .exe and go to the folder in Powershell and run this command: get-childitem *.inf* |copy-item -destination "C:\examplefolder" Otherwise it's hard to find the .inf files. $driversrc="\\10.1.1.21\sysprep\Printer Drivers\ApeosC2570\ffac7070pcl6220420w636iml\Software\PCL\amd64\Common\001\FFSOBPCLA.inf" Write-Host "Reading from here: $driversrc" $driver = "FF Apeos C2570 PCL 6" $address = "10.1.1.31" $portnamesuffix = "_1" $portname = "$address$portnamesuffix" $name = "Admin Apeos C2570" $sleep = "3" # The invoke command can be added to specify a remote computer by adding -computername. You would need to copy the .inf file to the remote computer first though. # This script has it configured to run on the local computer that needs the printer. # The pnputil command imports the .inf file into the Windows driverstore. # The .inf driver file has to be physically on the local or remote computer that the printer is being installed on. Invoke-Command {pnputil.exe -a $driversrc } Add-PrinterDriver -Name $driver Start-Sleep $sleep #Get the infos of all printer $Printers = Get-WmiObject -Class Win32_Printer $PrinterPorts = Get-PrinterPort $PrinterName = $name # This creates the TCP\IP printer port. It also will not use the annoying WSD port type that can cause problems. # WSD can be used by using a different command syntax though if needed. Try { Write-Verbose "Get the specified printer info." $Printer = $PrinterPorts | Where{$_.Name -eq "$portname"} If (! $Printer) { Write-Verbose "Adding printer port." Add-PrinterPort -Name $portname -PrinterHostAddress $address Write-Host "$portname has been successfully added." } Else { Write-Warning "Port already exists." } } Catch { $ErrorMsg = $_.Exception.Message Write-Host $ErrorMsg -BackgroundColor Red } start-sleep $sleep Try { Write-Verbose "Get the specified printer info." $Printer = $Printers | Where{$_.Name -eq "$PrinterName"} If (! $Printer) { Write-Verbose "Adding printer." Add-Printer -DriverName $driver -Name $name -PortName $portname Write-Host "$PrinterName has been successfully added." } Else { Write-Warning "$PrinterName is already installed!." } } Catch { $ErrorMsg = $_.Exception.Message Write-Host $ErrorMsg -BackgroundColor Red } Start-Sleep $sleep #Update the infos of all printer $Printers = Get-WmiObject -Class Win32_Printer Try { Write-Verbose "Get the specified printer info." $Printer = $Printers | Where{$_.Name -eq "$PrinterName"} If($Printer) { Write-Verbose "Setting the default printer." $Printer.SetDefaultPrinter() | Out-Null Write-Host "$PrinterName has been successfully set as the default printer." } Else { Write-Warning "Cannot find $PrinterName, can't set it as the default printer." } } Catch { $ErrorMsg = $_.Exception.Message Write-Host $ErrorMsg -BackgroundColor Red } Try { If($Printer) { Write-Verbose "Setting printer defaults." Set-PrintConfiguration -PrinterName $PrinterName -Color $false -DuplexingMode TwoSidedLongEdge | Out-Null Write-Host "$PrinterName has printing defaults set." } Else { Write-Warning "Cannot find the specified printer, can't set printer defaults." } } Catch { $ErrorMsg = $_.Exception.Message Write-Host $ErrorMsg -BackgroundColor Red } Get-PrintConfiguration -PrinterName $PrinterName # This prints a list of installed printers on the local computer. This proves the newly added printer works. Write-Warning "You must manually set the printer Output Color Preference to Black and White. Do it now!" get-printer |Out-Printer -Name $name Write-Host "If all went well a page should be printing out on the printer now." When I run the commands manually, the error persists. This is the error: Add-PrinterDriver : The specified driver does not exist in the driver store. dd-PrinterDriver -Name "[Name]" -InfPath "[Path]" PS C:\Windows\System32] At line:1 char:1 + Add-PrinterDriver -Name "[Name]" -InfPath "[Path]" + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (MSFT_PrinterDriver:ROOT/StandardCimv2/MSFT_PrinterDriver) [Add-PrinterDri ver], CimException + FullyQualifiedErrorId : HRESULT 0x80070705,Add-PrinterDriver I want to know if there is a reason that the driver is not getting found in the DriverStore despite my being able to locate it. And whether others have this issue, it appears as if it's a windows issue.786Views0likes9CommentsCombining two Functions
=COUNTIF(B2:B15,"Cooking Dinner") Returns all count Cooking Dinners =SUMPRODUCT(1*(YEAR(A2:A15)=2023)) Returns all count of year 2023 I would like to count how many times “Cooking Dinners” is in the year 2023. Or count all “Cooking” in the year 2024 no matter of if it is lunch or dinner.232Views0likes1CommentHow to grant permissions on behalf of the organization Script
Hello everyone! We generated a necessary Script to create a Principal API/APP/Service in Entra ID, and assign some delegated and application permissions. However, I need to consent to these permissions on behalf of the organization, during the Script itself. I have tried several times, in different ways, but all without success. Does anyone know how this can be done? If it can be done? And could you help me with this? Thank you all. Best regards307Views0likes1CommentUsing powershell to create folders within users onedrive
Hi all, I'm experiencing several issues with different PowerShell versions when trying to create folders in OneDrive for users in bulk. PowerShell 5.1 does not recognize Connect-PnPOnline. PowerShell 7 does not recognize Connect-SPOService. I have been following the instructions from this guide, which worked on my previous device. However, I’m unable to get it to work on my new device. My goal is to create folders within specific users' OneDrive accounts. Could you please assist me in resolving this? Thank you!2.5KViews0likes26CommentsWill Organization Asset Libraries be available for GCC?
Anyone in GCC have success with org asset libraries? Is there a place to provide feedback to Microsoft to enable this for GCC clients? Create an organization assets library - SharePoint in Microsoft 365 | Microsoft Docs Alternatively, can anyone provide information why Microsoft is prohibited to providing this to GCC accounts?1.6KViews0likes5CommentsWhat Causes 🅠🅤🅘🅒🅚🅑🅞🅞🅚🅢 Online Error Code 101 and How Can It Be Fixed?
🅠🅤🅘🅒🅚🅑🅞🅞🅚🅢 Online Error Code 101 typically occurs due to a problem connecting to your bank account. Causes include incorrect bank login credentials, outdated browser settings, or connectivity issues. To fix it: Verify Login Information: Ensure your bank login credentials are correct. Update Browser: Use the latest version of your web browser. Clear Cache and Cookies: Clear your browser's cache and cookies. Check Bank's Website: Verify there are no issues with the bank's website. Reconnect Account: Disconnect and reconnect your bank account in 🅠🅤🅘🅒🅚🅑🅞🅞🅚🅢. If the issue persists, contact 🅠🅤🅘🅒🅚🅑🅞🅞🅚🅢 support.602Views0likes1CommentPowerShell script to change font of office apps
Hi, We are using Microsoft 365 for Enterprise for delivery office apps to users via Microsoft Intune. Currently the default font for all office apps is Calibri and now users want that it should change to Arial, 11 font. Is there a way in Powershell to make that change. I have been suggested ways to do it with .net objects or Interop. Can someone please share a sample PowerShell script or a full script to make that change. Thanks, Ashish Arya31KViews0likes18CommentsError - Connect-ExchangeOnline Error Acquiring Token: System.Net.Http.HttpRequestException
Error Connect-ExchangeOnline Error Acquiring Token: System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: Remote name could not be resolved: 'server.proxy.local'553Views0likes1CommentHow to update Microsoft 365 Apps for Enterprise (aka Office) on WVD?
I have built a custom image that was originally based on the "Windows 10 multi-session + Microsoft 365 Apps" image in the Azure gallery. As far as I can tell, the Office apps are installed on this image using the settings specified inInstall Office on a master VHD image - Azure | Microsoft Docs. One of those settings puts Office on the Monthly Enterprise channel, but it also disables updates. I understand that you don't want end users triggering the updates themselves, and maybe the typical sysadmin doesn't even want the updates getting installed during off-hours when nobody is logged in. But I can't figure out how to install the updates, period, even on a new image meant to replace the one in production. And I can't find this documented anywhere. I feel stupid. Help. 🙂17KViews1like13CommentsHOW-TO : Use VAMT 3.1 for Windows Server activation 2016 through 2022 and license management
VAMT looks like legacy, albeit being updated and tremendously helpful: Do you use VAMT to manage your Office and Windows Server licensing, modern Windows Server or Office ADBA, traditional KMS or MAK? License assignment and reporting at scale? You should. In many cases it can also assist to get rid of KMS Server altogether and making it super easy to determine activation methods, migrate to other keys or from KMS to ADBA where appropriate. Whatever your usecase is, VAMT 3.1 is still being updated with every release of Windows ADK. One reason is the appearance of new OS or Office LTSC releases, but also added support to manage your Windows Client and Windows Server ESU at scale. WS 2012 / 2012 R2 ESU will be next. The issue: If you are using it, you might be currently on a release that may not allow to add Windows Server 2019 GVLK, or otherwise one that does not allow to add Windows Server 2022 GVLK. How to adress this: I found a workaround for this, without fiddling in the files. - Install ADKWindows 10 before 22H2 > VAMT - Install all neededGVLK keys in VAMT 3.1. - Windows Server 2008-2019, Windows 7-10 - uninstall ADK. - installWindows 11 ADK (currently latest 22H2) > VAMT - run VAMT, choosing the same database, - add Windows Server 2022 GVLK keys to VAMT. - now is a good time to backup the database using the latest SQL Management Studio (SMSS) Hint: Preferably place the VAMT database into an appropriate central SQL Standard instance, instead of the default SQL Express 2019 or later (e. g. Citrix Studio / PVS / License DB instance). The VAMT DB is a quite compact, mostly static database. Running an SQL Express instance for just this matter increases RAM and management overhead, even though SQL Server (Express) 2017 - 2022, can now be directly and automatically patched via WU / WSUS / Azure Update Manager etc.9.5KViews0likes4Comments