Category: Microsoft
Category Archives: Microsoft
How to calculate all used OneDrive space consumed by individual users?
Hi,
when using “Get-SPOGeoStorageQuota -AllLocations” it is lacking the usage of OneDrive Space consumed by individual users.
How do I get these used space accumulated from allusers?
Hi, when using “Get-SPOGeoStorageQuota -AllLocations” it is lacking the usage of OneDrive Space consumed by individual users. How do I get these used space accumulated from allusers? Read More
Cross referencing if the cell is blank.
Hello All, this is my first post here. I hope to explain my question properly.
I need to run a Macro on a column.
The cell should display a name. This name is linked to an order number.
When I pull the report, sometimes the name is missing but I have another sheet matching all names with order numbers.
So my idea is the following, If the cell is blank, I want to get the name from another sheet using the order number as a reference.
IF the cell is not blank, then nothing is required as the name is already there.
The name should be displayed in column B, and the order number is in column C.
any help is much appreciated.
Thanks in advance.
Hello All, this is my first post here. I hope to explain my question properly. I need to run a Macro on a column. The cell should display a name. This name is linked to an order number. When I pull the report, sometimes the name is missing but I have another sheet matching all names with order numbers. So my idea is the following, If the cell is blank, I want to get the name from another sheet using the order number as a reference. IF the cell is not blank, then nothing is required as the name is already there. The name should be displayed in column B, and the order number is in column C. any help is much appreciated. Thanks in advance. Read More
Retaining Downloaded Application source folder in IME Cache
Hi All,
We are deploying applications via Intune, and we have few apps in which the shortcut self-heals during first launch. But due to source file missing in IME cache it failing to launch. Is it possible to retain or avoid the removal of application source folder from cache similar to SCCM in Intune.
Thanks,
Nathan.
Hi All, We are deploying applications via Intune, and we have few apps in which the shortcut self-heals during first launch. But due to source file missing in IME cache it failing to launch. Is it possible to retain or avoid the removal of application source folder from cache similar to SCCM in Intune. Thanks,Nathan. Read More
Windows Server 2022 Hyper-V Cluster: S2D Disk Add question
Hello,
We have a Healthy three node Windows server 2022 HCI build using a Three-way S2D Mirror using SSDs.
We initially built the server with only SSDs (4x 2GiB SSDs) per node. We would like to add SAS HDD to the disk pool so we can get a bigger bang for the buck for space (a lot of our VMs are calling for 1TB partitions)
My question is that if we add HDDs (equal number, type, and capacity on each node) to the already built SSD only pool, will S2D automatically reconfigure the pool across all nodes to allow the HDDs in the pool to so can expand our Volumes.
Hello, We have a Healthy three node Windows server 2022 HCI build using a Three-way S2D Mirror using SSDs. We initially built the server with only SSDs (4x 2GiB SSDs) per node. We would like to add SAS HDD to the disk pool so we can get a bigger bang for the buck for space (a lot of our VMs are calling for 1TB partitions) My question is that if we add HDDs (equal number, type, and capacity on each node) to the already built SSD only pool, will S2D automatically reconfigure the pool across all nodes to allow the HDDs in the pool to so can expand our Volumes. Read More
ASUS Update Check Removal Tool
NOTE: Right-click on the following batch files after saving them, and click “Run as administrator”.
Use Notepad to create this file on your desktop or another folder: ASUS_Update_Check_Remove.bat
@ECHO OFF
SETLOCAL
REM WHEN THE NETWORK STACK IS DISABLED IN UEFI / BIOS, AND ARMORY CRATE IS ENABLED, THE UEFI WILL LEAVE BEHIND AN UPDATE SERVICE, WHICH CANNOT BE REMOVED WITH THE ARMORY CRATE UNINSTALL TOOL, AND HAS TO BE REMOVED MANUALLY, WITH THE ASUS ARMORY CRATE BEING DISABLED IN UEFI / BIOS BEFOREHAND
CD /D “%~dp0”
SET ASUS_UPDTCHK_RMV_RSTRT_VAL=0
IF [%1]==[] GOTO ASUS_UPDTCHK_RMV_RSTRT_LBL_
IF %1==ASUS_UPDTCHK_RMV_RESTART (SET ASUS_UPDTCHK_RMV_RSTRT_VAL=1)
:ASUS_UPDTCHK_RMV_RSTRT_LBL_
IF %ASUS_UPDTCHK_RMV_RSTRT_VAL% EQU 0 GOTO ASUS_UPDTCHK_RMV_END_LBL_
IF %Processor_Architecture%==ARM64 SET SDEL_EXT_=SDELETE64A
IF %Processor_Architecture%==AMD64 SET SDEL_EXT_=SDELETE64
IF %Processor_Architecture%==x86 SET SDEL_EXT_=SDELETE
NET STOP AsusUpdateCheck
TASKKILL /IM AsusUpdateCheck.exe /T /F
SC DELETE AsusUpdateCheck
PowerShell -NoProfile -ExecutionPolicy Bypass -Command “& {Remove-Item -Path ‘HKLM:SYSTEMControlSet001ServicesAsusUpdateCheck’ -Recurse -Force}”
IF EXIST “%SystemRoot%System32%SDEL_EXT_%.EXE” %SDEL_EXT_% -ACCEPTEULA -Q -R -NOBANNER “%SystemRoot%System32AsusDownLoadLicense.exe” “%SystemRoot%System32AsusUpdateCheck.exe”
IF NOT EXIST “%SystemRoot%System32%SDEL_EXT_%.EXE” DEL /Q “%SystemRoot%System32AsusDownLoadLicense.exe” “%SystemRoot%System32AsusUpdateCheck.exe”
:ASUS_UPDTCHK_RMV_END_LBL_
IF %ASUS_UPDTCHK_RMV_RSTRT_VAL% EQU 0 (CALL ASUS_Update_Check_Remove.bat ASUS_UPDTCHK_RMV_RESTART >nul 2>&1)
ENDLOCAL
MOVE NUL 2>&0
NOTE: Right-click on the following batch files after saving them, and click “Run as administrator”. Use Notepad to create this file on your desktop or another folder: ASUS_Update_Check_Remove.bat@ECHO OFF
SETLOCAL
REM WHEN THE NETWORK STACK IS DISABLED IN UEFI / BIOS, AND ARMORY CRATE IS ENABLED, THE UEFI WILL LEAVE BEHIND AN UPDATE SERVICE, WHICH CANNOT BE REMOVED WITH THE ARMORY CRATE UNINSTALL TOOL, AND HAS TO BE REMOVED MANUALLY, WITH THE ASUS ARMORY CRATE BEING DISABLED IN UEFI / BIOS BEFOREHAND
CD /D “%~dp0”
SET ASUS_UPDTCHK_RMV_RSTRT_VAL=0
IF [%1]==[] GOTO ASUS_UPDTCHK_RMV_RSTRT_LBL_
IF %1==ASUS_UPDTCHK_RMV_RESTART (SET ASUS_UPDTCHK_RMV_RSTRT_VAL=1)
:ASUS_UPDTCHK_RMV_RSTRT_LBL_
IF %ASUS_UPDTCHK_RMV_RSTRT_VAL% EQU 0 GOTO ASUS_UPDTCHK_RMV_END_LBL_
IF %Processor_Architecture%==ARM64 SET SDEL_EXT_=SDELETE64A
IF %Processor_Architecture%==AMD64 SET SDEL_EXT_=SDELETE64
IF %Processor_Architecture%==x86 SET SDEL_EXT_=SDELETE
NET STOP AsusUpdateCheck
TASKKILL /IM AsusUpdateCheck.exe /T /F
SC DELETE AsusUpdateCheck
PowerShell -NoProfile -ExecutionPolicy Bypass -Command “& {Remove-Item -Path ‘HKLM:SYSTEMControlSet001ServicesAsusUpdateCheck’ -Recurse -Force}”
IF EXIST “%SystemRoot%System32%SDEL_EXT_%.EXE” %SDEL_EXT_% -ACCEPTEULA -Q -R -NOBANNER “%SystemRoot%System32AsusDownLoadLicense.exe” “%SystemRoot%System32AsusUpdateCheck.exe”
IF NOT EXIST “%SystemRoot%System32%SDEL_EXT_%.EXE” DEL /Q “%SystemRoot%System32AsusDownLoadLicense.exe” “%SystemRoot%System32AsusUpdateCheck.exe”
:ASUS_UPDTCHK_RMV_END_LBL_
IF %ASUS_UPDTCHK_RMV_RSTRT_VAL% EQU 0 (CALL ASUS_Update_Check_Remove.bat ASUS_UPDTCHK_RMV_RESTART >nul 2>&1)
ENDLOCAL
MOVE NUL 2>&0 Read More
Inserting Row results in misaligned formulas
Recently I’ve experienced the following:
– When a row is inserted (using keyboard shortcut Alt-I-R), some existing formulas on the sheet would not shift down accordingly, resulting in misaligned formulas.
– I’m using Office 365, and this has happened across multiple spreadsheets.
Has anyone else also run into this issue?
Edit: might have something to do with frozen panes.
Recently I’ve experienced the following:- When a row is inserted (using keyboard shortcut Alt-I-R), some existing formulas on the sheet would not shift down accordingly, resulting in misaligned formulas. – I’m using Office 365, and this has happened across multiple spreadsheets. Has anyone else also run into this issue? Edit: might have something to do with frozen panes. Read More
Tài xỉu Hit Club – Tải Game Bài Đổi Thưởng HitClub Ios/Apk/Android
Tài xỉu Hit Club , cái tên đang “gây bão” trong thế giới game bài đổi thưởng, không chỉ là một cổng game bài đẳng cấp mà còn là điểm đến của sự đổi mới và sáng tạo. Cổng game Hit Club đẳng cấp nhất năm 2024 với nhiều trò chơi cờ bạc sáng tạo và hấp dẫn. Địa chỉ cá độ này đã được Isle Of Man và đơn vị cá cược PAGCOR cấp giấy chứng nhận. Hitclub – Khám phá thế giới giải trí bất tận. Hitclub100 là một trong những nhà cái uy tín và được yêu thích nhất hiện nay.
Tài xỉu Hit Club , cái tên đang “gây bão” trong thế giới game bài đổi thưởng, không chỉ là một cổng game bài đẳng cấp mà còn là điểm đến của sự đổi mới và sáng tạo. Cổng game Hit Club đẳng cấp nhất năm 2024 với nhiều trò chơi cờ bạc sáng tạo và hấp dẫn. Địa chỉ cá độ này đã được Isle Of Man và đơn vị cá cược PAGCOR cấp giấy chứng nhận. Hitclub – Khám phá thế giới giải trí bất tận. Hitclub100 là một trong những nhà cái uy tín và được yêu thích nhất hiện nay. Read More
SQL Server Config Manager Error “MMC could not create the snap-in”
Hi, I have seen this error elsewhere online. I have gone to mmc to enable the snap in and I still have had no fix. My computer is running Windows Server 2022, SQL Server Express 2022, and SSMS. I have reinstalled, repaired, and all of the other tricks. Help!
Hi, I have seen this error elsewhere online. I have gone to mmc to enable the snap in and I still have had no fix. My computer is running Windows Server 2022, SQL Server Express 2022, and SSMS. I have reinstalled, repaired, and all of the other tricks. Help! Read More
Sorting from a template
I downloaded a check register template, and after entering a few things to test it out, I want to sort it by date. I grab what I want to sort, but it will not let me uncheck ‘my data has headers’. Any ideas why not?
I downloaded a check register template, and after entering a few things to test it out, I want to sort it by date. I grab what I want to sort, but it will not let me uncheck ‘my data has headers’. Any ideas why not? Read More
SharePoint list with calculated column to work out SLA based on days and hours
SLA = 4 hours, 1-2 days, 2-5 daysExpected Completion Date = =[Date Received]+SLA+ROUNDDOWN(SLA/5,0)*2+IF(WEEKDAY([Date Received])+MOD(SLA,5)>=7,2,0)-ROUNDDOWN(WEEKDAY([Date Received])/7,0)+IF(AND(MOD(SLA,5)=0,WEEKDAY([Date Received])=1),-2,0)+IF(AND(MOD(SLA,5)=0,WEEKDAY([Date Received])=7),-2,0)Result = =IF([Date Completed]=””,””,IF([Expected Completion Date]>[Date Completed],”Pass”,”Fail”))
The problem is that I am not able to add 4 hours to the “Date Received” and not able to populate correct date under “Expected Completion Date” Also, not able to include public holidays in the calculation. Is there a way to include public holidays while calculating the “Expected Completion Date”?
Your assistance is greatly appreciated.
Regards
Dear Team, I am trying to figure out how to calculate SLAs based on the data captured in the SharePoint list. I have a basic understanding of the lists. I have captured the SLA numbers in SLA column where I used 0.5 to show 4 hour SLA. Details:SLA = 4 hours, 1-2 days, 2-5 daysExpected Completion Date = =[Date Received]+SLA+ROUNDDOWN(SLA/5,0)*2+IF(WEEKDAY([Date Received])+MOD(SLA,5)>=7,2,0)-ROUNDDOWN(WEEKDAY([Date Received])/7,0)+IF(AND(MOD(SLA,5)=0,WEEKDAY([Date Received])=1),-2,0)+IF(AND(MOD(SLA,5)=0,WEEKDAY([Date Received])=7),-2,0)Result = =IF([Date Completed]=””,””,IF([Expected Completion Date]>[Date Completed],”Pass”,”Fail”))Issue:The problem is that I am not able to add 4 hours to the “Date Received” and not able to populate correct date under “Expected Completion Date” Also, not able to include public holidays in the calculation. Is there a way to include public holidays while calculating the “Expected Completion Date”? Your assistance is greatly appreciated. Regards Read More
Catch all rule
Can anyone suggest a rule that would basically capture and alert for any File copied to removable media?
We have people approved to use external storage but I want to get a log of anything copied to removable media, not just specific file.
Can anyone suggest a rule that would basically capture and alert for any File copied to removable media? We have people approved to use external storage but I want to get a log of anything copied to removable media, not just specific file. Read More
Search people feature on Quick Access Toolbar
When I use this feature, it brings up an abbreviated version of the contact card for this person. In past verisons of Outlook, it would bring up the full contact card as if I had gone into contacts and entered the name of th person.
How can I have the search pull up the full contact card?
When I use this feature, it brings up an abbreviated version of the contact card for this person. In past verisons of Outlook, it would bring up the full contact card as if I had gone into contacts and entered the name of th person.How can I have the search pull up the full contact card? Read More
Power query apply formula to mixed data column
Hi
I imported a table of students marks, and the columns have either marks written or ‘Absent’.
Now I want to create another custom function column with 50% of the marks. But if I input the formula such as: 0.5 * [column], it gives error because there’s text also.
How can I go around this?
Thanks.
Hi I imported a table of students marks, and the columns have either marks written or ‘Absent’.Now I want to create another custom function column with 50% of the marks. But if I input the formula such as: 0.5 * [column], it gives error because there’s text also.How can I go around this?Thanks. Read More
How to Resolve QuickBook𝙨 Error 6000 When Opening a Company File in Windows 11
When attempting to open a company file in QuickBook𝙨, I encounter Error 6000. This error prevents me from accessing the company file and continues to occur despite several attempts to resolve it.
I’m open to any suggestions or insights you might have. Thank you in advance for your help!
When attempting to open a company file in QuickBook𝙨, I encounter Error 6000. This error prevents me from accessing the company file and continues to occur despite several attempts to resolve it.I’m open to any suggestions or insights you might have. Thank you in advance for your help! Read More
SharePoint Tables – Attachments
Hello
Is there any way I can add attachments in a Modern SharePoint table.
Thanks in advance.
HelloIs there any way I can add attachments in a Modern SharePoint table.Thanks in advance. Read More
DDL Syntax
I am attempting to use the following DDL statement from within Access:
ALTER TABLE MyTableName ADD CONSTRAINT NOT NULL ( MyFieldName1, MyFieldName2 )
and I get a syntax error. Can someone please tell me what the issue is?
Also, I want to do something like the following
ALTER TABLE MyTableName ADD CONSTRAINT Check ( ( MyfieldName > 0 ) AND ( MyFieldName < 3500 ) )
But this doesn’t work either.
I am doing this from the Query functionality within Access. I have another DDL statement that worked fine:
ALTER TABLE MyTableName ADD CONSTRAINT NoDupes UNIQUE ( MyFieldName1, MyFieldName2, MyFieldName3 )
Any/All help would be appreciated.
I am attempting to use the following DDL statement from within Access: ALTER TABLE MyTableName ADD CONSTRAINT NOT NULL ( MyFieldName1, MyFieldName2 ) and I get a syntax error. Can someone please tell me what the issue is? Also, I want to do something like the following ALTER TABLE MyTableName ADD CONSTRAINT Check ( ( MyfieldName > 0 ) AND ( MyFieldName < 3500 ) ) But this doesn’t work either. I am doing this from the Query functionality within Access. I have another DDL statement that worked fine: ALTER TABLE MyTableName ADD CONSTRAINT NoDupes UNIQUE ( MyFieldName1, MyFieldName2, MyFieldName3 ) Any/All help would be appreciated. Read More
DPM 2022 UR2 build 10.22.197 console crashes after MARS install
I have frequent DPM console crashes after installing and configuring MARS. I have used solely on-premise storage for many years, but I want to explore the possibility of using Azure storage for long term use. However, the frequent DPM MMC console crashes after installing MARS makes it virtually impossible to use and configure with virtually anything I try to do. What is going on?
Event info below:
The description for Event ID 999 from source MSDPM cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
An unexpected error caused a failure for process ‘mmc’. Restart the DPM process ‘mmc’.
Problem Details:
<FatalServiceError><__System><ID>19</ID><Seq>0</Seq><TimeCreated>7/23/2024 11:42:16 PM</TimeCreated><Source>DpmThreadPool.cs</Source><Line>169</Line><HasError>True</HasError></__System><ExceptionType>DlsException</ExceptionType><ExceptionMessage>Exception of type ‘Microsoft.Internal.EnterpriseStorage.Dls.Utils.DlsException’ was thrown.</ExceptionMessage><ExceptionDetails>Microsoft.Internal.EnterpriseStorage.Dls.Utils.DlsException: Exception of type ‘Microsoft.Internal.EnterpriseStorage.Dls.Utils.DlsException’ was thrown.
at Microsoft.Internal.EnterpriseStorage.Dls.UI.UICommon.CmdLetWrapper.HandleError(Pipeline pipeline)
at Microsoft.Internal.EnterpriseStorage.Dls.UI.UICommon.CmdLetWrapper.Invoke()
at Microsoft.Internal.EnterpriseStorage.Dls.UI.Dpw.ExclusionManager.AddObjectToExclusion(TreeNode node)
at Microsoft.Internal.EnterpriseStorage.Dls.UI.Dpw.SelectionPage.UpdateSelection(TreeNode node)
at Microsoft.Internal.EnterpriseStorage.Dls.UI.Dpw.SelectionPage.treeView_AfterCheck(Object sender, TreeViewEventArgs e)
at System.Windows.Forms.TreeView.OnAfterCheck(TreeViewEventArgs e)
at System.Windows.Forms.TreeView.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
*** Mojito error was: GenericOMPlaceHolderError; 0; None</ExceptionDetails></FatalServiceError>
The message resource is present but the message was not found in the message table
I have frequent DPM console crashes after installing and configuring MARS. I have used solely on-premise storage for many years, but I want to explore the possibility of using Azure storage for long term use. However, the frequent DPM MMC console crashes after installing MARS makes it virtually impossible to use and configure with virtually anything I try to do. What is going on? Event info below: The description for Event ID 999 from source MSDPM cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.If the event originated on another computer, the display information had to be saved with the event.The following information was included with the event:An unexpected error caused a failure for process ‘mmc’. Restart the DPM process ‘mmc’.Problem Details:<FatalServiceError><__System><ID>19</ID><Seq>0</Seq><TimeCreated>7/23/2024 11:42:16 PM</TimeCreated><Source>DpmThreadPool.cs</Source><Line>169</Line><HasError>True</HasError></__System><ExceptionType>DlsException</ExceptionType><ExceptionMessage>Exception of type ‘Microsoft.Internal.EnterpriseStorage.Dls.Utils.DlsException’ was thrown.</ExceptionMessage><ExceptionDetails>Microsoft.Internal.EnterpriseStorage.Dls.Utils.DlsException: Exception of type ‘Microsoft.Internal.EnterpriseStorage.Dls.Utils.DlsException’ was thrown.at Microsoft.Internal.EnterpriseStorage.Dls.UI.UICommon.CmdLetWrapper.HandleError(Pipeline pipeline)at Microsoft.Internal.EnterpriseStorage.Dls.UI.UICommon.CmdLetWrapper.Invoke()at Microsoft.Internal.EnterpriseStorage.Dls.UI.Dpw.ExclusionManager.AddObjectToExclusion(TreeNode node)at Microsoft.Internal.EnterpriseStorage.Dls.UI.Dpw.SelectionPage.UpdateSelection(TreeNode node)at Microsoft.Internal.EnterpriseStorage.Dls.UI.Dpw.SelectionPage.treeView_AfterCheck(Object sender, TreeViewEventArgs e)at System.Windows.Forms.TreeView.OnAfterCheck(TreeViewEventArgs e)at System.Windows.Forms.TreeView.WndProc(Message& m)at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)*** Mojito error was: GenericOMPlaceHolderError; 0; None</ExceptionDetails></FatalServiceError>The message resource is present but the message was not found in the message table Read More
How to resolve QuickBook𝙨 BEX Error on Windows 11?
I am reaching out for help regarding a persistent issue I am facing with QuickBook𝙨 on my Windows 11 system. Every time I try to open QuickBook𝙨, I encounter a BEX (Buffer Overflow Exception) error, which causes the application to crash. Has anyone else encountered this issue on Windows 11? If so, how did you resolve it? Are there any specific settings or patches that I might be missing? Any advice or suggestions would be greatly appreciated as this issue is significantly impacting my work.
Thank you in advance for your assistance!
I am reaching out for help regarding a persistent issue I am facing with QuickBook𝙨 on my Windows 11 system. Every time I try to open QuickBook𝙨, I encounter a BEX (Buffer Overflow Exception) error, which causes the application to crash. Has anyone else encountered this issue on Windows 11? If so, how did you resolve it? Are there any specific settings or patches that I might be missing? Any advice or suggestions would be greatly appreciated as this issue is significantly impacting my work. Thank you in advance for your assistance! Read More
July V1 Title Plan out now!
Hello, everyone —
MPN Partner Portal Learning Resources page resources page for Training Services Partners
Thank you!
Hello, everyone —
The July Monthly Title Plan V1 is attached to this forum.
This Monthly Title Plan is also shared in:
MPN Partner Portal Learning Resources page resources page for Training Services Partners
MCT Lounge Tech community Lounge for MCTs
Please ensure to download the additional document included in this post. It will provide you additional information for NEW ILT Courses, coming soon. See snapshot below:
Thank you! Read More
How to Reset Your QuickBook𝙨 Password on Windows 10
Recently, I have been unable to access my QuickBook𝙨 account due to persistent password problems. Has anyone experienced similar issues with QuickBook𝙨 on Windows 10? If so, how did you resolve them? Any advice or troubleshooting steps would be greatly appreciated.
Recently, I have been unable to access my QuickBook𝙨 account due to persistent password problems. Has anyone experienced similar issues with QuickBook𝙨 on Windows 10? If so, how did you resolve them? Any advice or troubleshooting steps would be greatly appreciated. Read More