Month: November 2024
LOOKUP QUERY
I have a problem with a lookup table whereby we have a series of part numbers all starting with the same numeric value but then end with a different alpha numeric value. When we run the Lookup it wont return a value:
=LOOKUP(B14,Data!A5:A404,Data!E5:E404)*AN5
I have a problem with a lookup table whereby we have a series of part numbers all starting with the same numeric value but then end with a different alpha numeric value. When we run the Lookup it wont return a value: =LOOKUP(B14,Data!A5:A404,Data!E5:E404)*AN5 Read More
Configuration Manager Client v2403 Error with Autopilot
Hi All,
I have a test Autopilot environment setup with just one laptop.
It’s in an hybrid environment with SCCM.
The laptop has been built and configured with SCCM for a few months now. (no issues)
However after a refresh of the laptop I now get this error when CCM try’s to install,
“This installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer package. (0x80070653)”
No changes have been made on the Intune side of things, has anyone else seen this error?
On the laptop, a notification pops up and advises the software will be download and installed, shortly after a failed message appears. No CCM folder is created.
Any help is appreciated.
Thanks
Hi All, I have a test Autopilot environment setup with just one laptop.It’s in an hybrid environment with SCCM.The laptop has been built and configured with SCCM for a few months now. (no issues)However after a refresh of the laptop I now get this error when CCM try’s to install, “This installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer package. (0x80070653)” No changes have been made on the Intune side of things, has anyone else seen this error? On the laptop, a notification pops up and advises the software will be download and installed, shortly after a failed message appears. No CCM folder is created. Any help is appreciated. Thanks Read More
how to get excel print the way i type. Let me choose.
I have a problem with excel. if i type ie. 04.11.2024 it converts it to 0,197731481481481
or if i type 3692.1 it wants to bad to change it to 3692.01.00 and so on.
How to get excel to print out just the way i type. work in notepad. works even here!
I have a problem with excel. if i type ie. 04.11.2024 it converts it to 0,197731481481481or if i type 3692.1 it wants to bad to change it to 3692.01.00 and so on. How to get excel to print out just the way i type. work in notepad. works even here! Read More
Azure NetApp Files | Azure cli command to suspend/resume backup at volume level
I’m looking for the corresponding azure cli for the following action
suspend a backup policy for a specific volume
I do see a cli (at policy level)
az netappfiles account backup-policy update, which has got the following parameter
[–enabled {0, 1, f, false, n, no, t, true, y, yes}]
The property to decide policy is enabled or not. Accepted values: 0, 1, f, false, n, no, t, true, y, yes
Is there a cli for this action at Volume level in the Configure Backups dialog box > Policy State { Suspend/Resume}, how shall we achieve this if we have programmatically do this step.
I’m looking for the corresponding azure cli for the following actionsuspend a backup policy for a specific volumeI do see a cli (at policy level)az netappfiles account backup-policy update, which has got the following parameter[–enabled {0, 1, f, false, n, no, t, true, y, yes}] The property to decide policy is enabled or not. Accepted values: 0, 1, f, false, n, no, t, true, y, yes But this is at the netapp account > policy level I’m unable to find the azure cli to do this at specific volume level. Is there a cli for this action at Volume level in the Configure Backups dialog box > Policy State { Suspend/Resume}, how shall we achieve this if we have programmatically do this step. Read More
Hide data records collected via Microsoft forms based on user account or group membership?
We have a Microsoft form where people from different departments need to log things. But for privacy reasons, it should not be possible for person A using the form for logging things for department A to read the items logged by person B working for departement B.
Person A and person B need the same view when filling out the form (they need to see the samen fields, among them the field “department”). But when the form is filled out and submitted, when looking at the data collected by the form, person A should only see the data records where department = department A en person B should only see the data records where department = department B.
How can this be achieved in Microsoft Forms?
We have a Microsoft form where people from different departments need to log things. But for privacy reasons, it should not be possible for person A using the form for logging things for department A to read the items logged by person B working for departement B.Person A and person B need the same view when filling out the form (they need to see the samen fields, among them the field “department”). But when the form is filled out and submitted, when looking at the data collected by the form, person A should only see the data records where department = department A en person B should only see the data records where department = department B.How can this be achieved in Microsoft Forms? Read More
Analyzing Microsoft 365 Copilot Interactions Using Compliance Records
Every time Microsoft 365 Copilot interacts with a user, the Microsoft 365 substrate captures the Copilot interaction as a compliance record in the user’s mailbox. By fetching and analyzing the compliance records, we can understand how the user interacts with Copilot. This article discusses how to retrieve and analyze the records with the Microsoft Graph PowerShell SDK.
https://practical365.com/copilot-interactions/
Every time Microsoft 365 Copilot interacts with a user, the Microsoft 365 substrate captures the Copilot interaction as a compliance record in the user’s mailbox. By fetching and analyzing the compliance records, we can understand how the user interacts with Copilot. This article discusses how to retrieve and analyze the records with the Microsoft Graph PowerShell SDK.
https://practical365.com/copilot-interactions/ Read More
OneDrive container cTag property stopped changing
Hi,
According to the docs:
DriveItem – OneDrive API – OneDrive dev center | Microsoft Learn
“The cTag value is modified when content or metadata of any descendant of the folder is changed. “
I am using graph Api to monitor changes in one of my folders. Indeed this used to work as described but suddenly cTag property remains constant.
It will not respond to changes in sub folder files, adding files, deleting files or modifying fild in sub folders no longer causes the parent folder cTag to change.
Thanks,
Gary
Hi,
According to the docs:
DriveItem – OneDrive API – OneDrive dev center | Microsoft Learn
“The cTag value is modified when content or metadata of any descendant of the folder is changed. “
I am using graph Api to monitor changes in one of my folders. Indeed this used to work as described but suddenly cTag property remains constant.
It will not respond to changes in sub folder files, adding files, deleting files or modifying fild in sub folders no longer causes the parent folder cTag to change.
Thanks,
Gary Read More
फ्लिपकार्ट की शिकायत कैसे करें?
फ़्लिपकार्ट ग्राहक सेवा अधिकारी से बात करने के लिए 6369×240×293 या O636~9240~293 ▪︎डायल करें । आपको अपनी समस्या को स्पष्ट और संक्षिप्त तरीके से बताना होगा। आधिकारिक शिकायत दर्ज करने के लिए अधिकारी आपसे आपकी ऑर्डर आईडी, पंजीकृत मोबाइल नंबर..
फ़्लिपकार्ट ग्राहक सेवा अधिकारी से बात करने के लिए 6369×240×293 या O636~9240~293 ▪︎डायल करें । आपको अपनी समस्या को स्पष्ट और संक्षिप्त तरीके से बताना होगा। आधिकारिक शिकायत दर्ज करने के लिए अधिकारी आपसे आपकी ऑर्डर आईडी, पंजीकृत मोबाइल नंबर.. Read More
gas bill online check by name
Here is the complete Process of Checking Sui gas bills or sngpl bill with very easy steps.
Step 1 : Visit the website suigasebills.pk
Step 2 : When you enter the website you will see a search Box, You will enter your Account ID or Consumer Number or Reference Number of your bill and press enter button below.
Step 3 : After entering on button, you will see your sui gas bill or sngpl.
Step 4 : Click on the ‘View Full Bill‘ to check complete bill and you can save and also you can take a print of your bill any time.
Special Notice: After entering your sngpl bill, If you see an error of ” Not Found ” Its mean you put your bill number wrong. Please check your consumer number and enter your Account ID correctly.
Here is the complete Process of Checking Sui gas bills or sngpl bill with very easy steps.Step 1 : Visit the website suigasebills.pkStep 2 : When you enter the website you will see a search Box, You will enter your Account ID or Consumer Number or Reference Number of your bill and press enter button below.Step 3 : After entering on button, you will see your sui gas bill or sngpl.Step 4 : Click on the ‘View Full Bill‘ to check complete bill and you can save and also you can take a print of your bill any time.Special Notice: After entering your sngpl bill, If you see an error of ” Not Found ” Its mean you put your bill number wrong. Please check your consumer number and enter your Account ID correctly. gas bill online check by name Read More
Microsoft Graph Command Line Tools Blocked by CA
Hi All
I hope you are well.
Anyway, I recently turned ON a Conditional Access Policy Template, “Require MDM-enrolled and compliant device to access cloud apps for all users (Preview)” this seems to work fine until our IT Admins try to use the AutoPilot script which gets blocked based on:
Microsoft Graph Command Line Tools
Any ideas on how to allow AutoPilot / Microsoft Graph Command Line Tools through CA?
Info appreciated
Hi All I hope you are well. Anyway, I recently turned ON a Conditional Access Policy Template, “Require MDM-enrolled and compliant device to access cloud apps for all users (Preview)” this seems to work fine until our IT Admins try to use the AutoPilot script which gets blocked based on: Microsoft Graph Command Line Tools Any ideas on how to allow AutoPilot / Microsoft Graph Command Line Tools through CA? Info appreciated Read More
पेटीएम का पैसा कैसे रिकवर करें?-
पेटीएम का पैसा कैसे रिकवर करें?”ट्रांजेक्शन” ((,+91-629O-348-172) या “इतिहास” सेक्शन में जाएं। रिले लेन-डेन चुनें। “वापस लें” या “वापस लेने के लिए भुगतान करें” विकल्प चुनें। अगर पुराना नहीं है अर्थात, तो अपने बैंक से संपर्क करें.
पेटीएम का पैसा कैसे रिकवर करें?”ट्रांजेक्शन” ((,+91-629O-348-172) या “इतिहास” सेक्शन में जाएं। रिले लेन-डेन चुनें। “वापस लें” या “वापस लेने के लिए भुगतान करें” विकल्प चुनें। अगर पुराना नहीं है अर्थात, तो अपने बैंक से संपर्क करें. Read More
जियो में शिकायत कैसे करें?
जियो के खिलाफ शिकायत दर्ज करने के लिए, आप इन चरणों का पालन कर सकते हैं:198 जियो ग्राहक सहायता से संपर्क करें:(0983✓122✓4914 ) एयरटेल वेबसाइट पर जाएँ या अपने मोबाइल डिवाइस पर जियो खोलें।
जियो के खिलाफ शिकायत दर्ज करने के लिए, आप इन चरणों का पालन कर सकते हैं:198 जियो ग्राहक सहायता से संपर्क करें:(0983✓122✓4914 ) एयरटेल वेबसाइट पर जाएँ या अपने मोबाइल डिवाइस पर जियो खोलें। Read More
Project Server OLAP problem
Using Project Server subscription edition and sql server Standard 2019.
When generating the olap cubes, we get the error “SQLNCLI11 is not registered in the local machine”
But sql server 2019 does not support SQLNCLI11…
¿How can we solve this?
Thanks
Using Project Server subscription edition and sql server Standard 2019.When generating the olap cubes, we get the error “SQLNCLI11 is not registered in the local machine”But sql server 2019 does not support SQLNCLI11…¿How can we solve this? Thanks Read More
Problem with task reminders and alarms
Hi,
I’ve been using Microsoft To-Do for a long time.
Problem: Whenever there is a time change (like “savings” time to standard time or vice-versa), recurring task reminders occur 1 hour before/after the time that I appointed them.
For example. I have a recurring task reminder every night at 11:30pm to take some medication. Because of the recent time change, I’m starting to get those reminders at 10:30 p.m. even though the reminder time is still set to 11:30 p.m. nightly.
The only remedy that I think works, is to disable the reminder and set a new one. This problem has existed for quite a while. I was just wanting to officially report it per se. Thank you in advance for fixing this.
Hi, I’ve been using Microsoft To-Do for a long time. Problem: Whenever there is a time change (like “savings” time to standard time or vice-versa), recurring task reminders occur 1 hour before/after the time that I appointed them. For example. I have a recurring task reminder every night at 11:30pm to take some medication. Because of the recent time change, I’m starting to get those reminders at 10:30 p.m. even though the reminder time is still set to 11:30 p.m. nightly. The only remedy that I think works, is to disable the reminder and set a new one. This problem has existed for quite a while. I was just wanting to officially report it per se. Thank you in advance for fixing this. Read More
फोनपे में गलत ट्रांजेक्शन कैसे रिफंड करें? –
फ़ोनपे से पैसे कट जाने पर, ये कदम उठाए जा सकते ग्राहक सहायता से संपर्क(8590^504√862) है फ़ोनपे ऐप में जाकर, “ट्रांज़ैक्शन” या “इतिहास” सेक्शन में जाएं. असफल लेन-देन चुनें. “वापस लें” या “वापस लेने के लिए अनुरोध करें” विकल्प चुनें.
फ़ोनपे से पैसे कट जाने पर, ये कदम उठाए जा सकते ग्राहक सहायता से संपर्क(8590^504√862) है फ़ोनपे ऐप में जाकर, “ट्रांज़ैक्शन” या “इतिहास” सेक्शन में जाएं. असफल लेन-देन चुनें. “वापस लें” या “वापस लेने के लिए अनुरोध करें” विकल्प चुनें. Read More
Data validation
Hi
currently I am using google sheet. I need a function do the following case:
I have data validation in the range (F9:F18) of the attached file. I need a function or formula to set all the values of range (F9:F18) to “P” if the value of F5 is “True” is it possible to do that?
Thanks
Hicurrently I am using google sheet. I need a function do the following case:I have data validation in the range (F9:F18) of the attached file. I need a function or formula to set all the values of range (F9:F18) to “P” if the value of F5 is “True” is it possible to do that?Thanks Read More
पेटीएम में शिकायत कैसे करें?
पेटीएम के खिलाफ शिकायत दर्ज करने के लिए, आप इन चरणों का पालन कर सकते हैं:198 पेटीएम ग्राहक सहायता से संपर्क करें:(0983✓122✓4914 ) एयरटेल वेबसाइट पर जाएँ या अपने मोबाइल डिवाइस पर पेटीएम खोलें।
पेटीएम के खिलाफ शिकायत दर्ज करने के लिए, आप इन चरणों का पालन कर सकते हैं:198 पेटीएम ग्राहक सहायता से संपर्क करें:(0983✓122✓4914 ) एयरटेल वेबसाइट पर जाएँ या अपने मोबाइल डिवाइस पर पेटीएम खोलें। Read More
SSRS report sum on visible expression value on Table
Hi Experts,
I am trying to sum of visible expression Total days diff = 136+15+13=164
Total days diff expression is =DateDiff(“d”,Fields!PRWFDate.Value,Fields!POWFDate.Value)
Total days diff expression for last row is =SUM(IIf(DateDiff(“d”, Fields!PRWFDate.Value, Fields!POWFDate.Value) <= 0,
DateDiff(“d”, Fields!POWFDate.Value, Fields!PRWFDate.Value),
DateDiff(“d”, Fields!PRWFDate.Value, Fields!POWFDate.Value)))
giving value 43596446.
I am trying to sum Total days diff = 136+15+13=164 than divide number of PO Id which is 3 than Average = (164/3)=54.66
The value 17.67 = 53/3
Thanks,
Faiz
Hi Experts, I am trying to sum of visible expression Total days diff = 136+15+13=164Total days diff expression is =DateDiff(“d”,Fields!PRWFDate.Value,Fields!POWFDate.Value)Total days diff expression for last row is =SUM(IIf(DateDiff(“d”, Fields!PRWFDate.Value, Fields!POWFDate.Value) <= 0, DateDiff(“d”, Fields!POWFDate.Value, Fields!PRWFDate.Value), DateDiff(“d”, Fields!PRWFDate.Value, Fields!POWFDate.Value))) giving value 43596446. I am trying to sum Total days diff = 136+15+13=164 than divide number of PO Id which is 3 than Average = (164/3)=54.66The value 17.67 = 53/3 Thanks,Faiz Read More
Allocating manhours to a month-to-month from a construction schedule
Good day,
I need assistance with separating manhours by month from a construction schedule. The schedule includes a start date, a finish date, and the total man-hours for the duration of each activity. I want to divide these manhours among the specified months for each activity so that I can create a Bell Curve for manhours for each month of the year.
While this can be accomplished using the Excel Macros Developer program, I am unsure how to perform the extraction and separation correctly. Could someone please help me with this process?
Thank you!
PS: The full version has over 2,000 activities
| Start | Finish | Manhours |
| 22 February 2026 | 17 May 2026 | 1871 |
| 11 March 2026 | 23 May 2026 | 250 |
| 17 December 2026 | 25 February 2027 | 5988 |
| 23 May 2026 | 08 August 2026 | 4790 |
| 08 August 2026 | 25 August 2026 | 250 |
| 25 August 2026 | 30 September 2026 | 1248 |
| 30 September 2026 | 10 October 2026 | 524 |
| 10 October 2026 | 14 November 2026 | 2994 |
| 21 July 2026 | 30 September 2026 | 5988 |
Good day, I need assistance with separating manhours by month from a construction schedule. The schedule includes a start date, a finish date, and the total man-hours for the duration of each activity. I want to divide these manhours among the specified months for each activity so that I can create a Bell Curve for manhours for each month of the year. While this can be accomplished using the Excel Macros Developer program, I am unsure how to perform the extraction and separation correctly. Could someone please help me with this process? Thank you! PS: The full version has over 2,000 activities StartFinishManhours22 February 202617 May 2026187111 March 202623 May 202625017 December 202625 February 2027598823 May 202608 August 2026479008 August 202625 August 202625025 August 202630 September 2026124830 September 202610 October 202652410 October 202614 November 2026299421 July 202630 September 20265988 Read More
How to Get a Unified View of Virtual Machines and VMSS in Azure Portal?
Hi everyone,
I’m currently managing both Virtual Machines and Virtual Machine Scale Sets (VMSS) in the Azure Portal. While I have good visibility over these resources individually, they’re displayed separately, which makes it a bit confusing when I want to see the total number of VMs across my entire environment.
I’m wondering if there’s any way to get a more unified view that consolidates both standalone Virtual Machines and VMSS instances for easier management. If anyone has suggestions or knows of any features that could help, I’d be grateful for the advice.
Thanks in advance for your help!
Hi everyone, I’m currently managing both Virtual Machines and Virtual Machine Scale Sets (VMSS) in the Azure Portal. While I have good visibility over these resources individually, they’re displayed separately, which makes it a bit confusing when I want to see the total number of VMs across my entire environment. I’m wondering if there’s any way to get a more unified view that consolidates both standalone Virtual Machines and VMSS instances for easier management. If anyone has suggestions or knows of any features that could help, I’d be grateful for the advice. Thanks in advance for your help! Read More
