Tag Archives: microsoft
Design a discussion page
Dear all,
Please guide me to design a discussion page in power pages like this powerpoint discussion page.
Thanks,
Dear all,Please guide me to design a discussion page in power pages like this powerpoint discussion page.Thanks, Read More
No active Leases in Windows DHCP gui , but when check over Command Shell there are active Leases
Hello ,
We want to Monitor active Leases in DHCP with CheckMK.
It works so far .
We create an own Scope . In this Scope there are two IP Adresses .
When an Server becomes one of this both IP Adresses the we become an active Lease .
This Lease brings the Monitoring Software to an Alarm .
We setup an Leasetime for this Lease under the Scope Settings to 5 minutes.
The Target should be that the Monitoring Software brings an Alarm when one of this two Leases or both are aktive.
But we want to become back an green ( good ) Monitoring Message , when the Server who becomes the IP Address is shut down and the Lease Time from 5 Minutes are gone .
Means then there are no active Leases at all .
But now our Problem .
We shut down the Server and after 5 Minutes aktive leases under DHCP Server was empty .
BUT
When i put in this command : “netsh dhcp server show mibinfo” then i become back this info :
C:>netsh dhcp server show mibinfo
MIBCounts:
Discovers = 5167.
Offers = 5167.
Delayed Offers = 0.
Requests = 246250.
Acks = 246422.
Naks = 7.
Declines = 0.
Releases = 63.
ServerStartTime = Freitag, 5. Juli 2024 23:00:21
Scopes = 24.
Scopes with Delay configured= 0.
Subnet = x.x.x.x.
No. of Addresses in use = 1.
No. of free Addresses = 1.
No. of pending offers = 0.
Means the System think that there is already an active IP but the GUI dont show it .
How is it possible to bring back the No. of Addresses in use back to zero ?
Thanks
Michael
Hello ,We want to Monitor active Leases in DHCP with CheckMK.It works so far .We create an own Scope . In this Scope there are two IP Adresses .When an Server becomes one of this both IP Adresses the we become an active Lease .This Lease brings the Monitoring Software to an Alarm .We setup an Leasetime for this Lease under the Scope Settings to 5 minutes.The Target should be that the Monitoring Software brings an Alarm when one of this two Leases or both are aktive.But we want to become back an green ( good ) Monitoring Message , when the Server who becomes the IP Address is shut down and the Lease Time from 5 Minutes are gone .Means then there are no active Leases at all .But now our Problem .We shut down the Server and after 5 Minutes aktive leases under DHCP Server was empty .BUTWhen i put in this command : “netsh dhcp server show mibinfo” then i become back this info :C:>netsh dhcp server show mibinfoMIBCounts:Discovers = 5167.Offers = 5167.Delayed Offers = 0.Requests = 246250.Acks = 246422.Naks = 7.Declines = 0.Releases = 63.ServerStartTime = Freitag, 5. Juli 2024 23:00:21Scopes = 24.Scopes with Delay configured= 0.Subnet = x.x.x.x.No. of Addresses in use = 1.No. of free Addresses = 1.No. of pending offers = 0.Means the System think that there is already an active IP but the GUI dont show it .How is it possible to bring back the No. of Addresses in use back to zero ?ThanksMichael Read More
WHY: Edge Canary crashes after opening it
Hi.
Version 128.0.2690.0 (Official build) canary (64-bit)
This is SO frustrating. It started about a week ago. Edge on my computer, is not affected and works perfectly.
I have read almost everything about a fix from turning off sync and deleting AppData/Local/Microsoft/Edge SxS/User Data and rebuilding it from scratch … NOTHING helps, and it is very frustrating.
Is there a fix for this?
Hi.Version 128.0.2690.0 (Official build) canary (64-bit)This is SO frustrating. It started about a week ago. Edge on my computer, is not affected and works perfectly.I have read almost everything about a fix from turning off sync and deleting AppData/Local/Microsoft/Edge SxS/User Data and rebuilding it from scratch … NOTHING helps, and it is very frustrating.Is there a fix for this? Read More
Workspace & DCR Transformation Simplified
In this blog, I’m going to focus on a common yet very important use case: transformation (workspace and DCR) transformation.
With transformations in Azure Monitor, you can filter or modify incoming data before it’s sent to a Log Analytics workspace. Transformations are performed in Azure Monitor in the data ingestion pipeline after the data source delivers the data and before it’s sent to the destination. The data source might perform its own filtering before sending data but then rely on the transformation for further manipulation before it’s sent to the destination.
The following diagram illustrates the transformation process for incoming data and shows a sample query that might be used.
Before we begin, it’s important to understand why to use transformation and the supported tables for the same.
Our focus in this blog is going to be around workspace transformation and DCR transformation. Let’s delve into the use cases for both:
Workspace transformation
It’s recommended to use workspace transformation for platform logs (collected via diagnostic settings) and logs collected using MMA (legacy agent).
The workspace transformation data collection rule (DCR) is a special DCR that’s applied directly to a Log Analytics workspace. The purpose of this DCR is to perform transformations on data that does not yet use a DCR for its data collection, and thus has no means to define a transformation.
Prerequisites for creating workspace transformation:
A Log Analytics workspace where you have at least contributor rights.
Permissions to create DCR objects in the workspace.
A table that already has some data.
The table can’t be linked to the workspace transformation DCR.
I recommend going through our public documentation for step by step guidance to create workspace transformation.
In my use case, I’ve created a transformation rule on DeviceEvents table to keep only those records where ActionType contains “Antivirus”
Once the transformation is configured from the Azure Portal, it creates a workspace transformation DCR (if not present) & appends the ARM template of the DCR with the transformation logic.
To validate this transformation logic, we can browse to the respective log analytics workspace > Logs and run a KQL query to check if DeviceEvents table and the ActionTypes it’s capturing. In my use case, it’s retaining only those records where ActionType contains “Antivirus” as shown below:
DCR Transformation
This transformation technique is best suited for the logs collected via AMA. It’s recommended to update “transformKql” with relevant KQL logic under data flow.
I recommend going through our public documentation which talks about structure of transformation. Also, check our public documentation for step by step guidance on creating the transformation logic.
In my use case, I’ve created a DCR transformation logic to drop those records from Syslog table where ProcessName contains “Kernel”.
I already have a Linux VM which is sending Syslog to my log analytic workspace via AMA.
Let’s browse to the DCR associated with this VM and then browse to Automation > Export Template > Deploy > Edit Template as shown below:
The template should have all the required facility names defined for Syslog (under data sources). Once it’s validated, check the “dataFlows” section and update the “transformKql” logic and “outputSteam” as shown below:
Here we’ve defined a steam for Microsoft-Syslog to discard the rows if ProcessName contains “kernel”. Once the ARM template is updated, Save the changes and hit Review and Create so that changes could take effect.
Check our public documentation on the structure of single destination and multiple destination DCR examples.
To validate this transformation logic, go to the respective log analytics workspace and run a KQL query to check if there are any rows in Syslog table where ProcessName contains “kernel”
Transformation may incur some additional charges, check our public documentation on the same.
Microsoft Tech Community – Latest Blogs –Read More
Sharepoint Calendar view formatting
Hello, I am looking to add an icon to an item in a calendar view of a SharePoint list. In my list, a choice made in the category column adds to the content of the object column. It works quite well, I took inspiration from this page : https://alexanderhenkel.dk/post/010224-formatting-add-different-icons-to-a-choice-column/
I would like the same icon to display in calendar view mode. I made several attempts (JSON) without success.
Do you know if this is possible? Thank you for your response and for your help,
Stef
Hello, I am looking to add an icon to an item in a calendar view of a SharePoint list. In my list, a choice made in the category column adds to the content of the object column. It works quite well, I took inspiration from this page : https://alexanderhenkel.dk/post/010224-formatting-add-different-icons-to-a-choice-column/I would like the same icon to display in calendar view mode. I made several attempts (JSON) without success.Do you know if this is possible? Thank you for your response and for your help,Stef Read More
Incoming Webhook Doesnt seem to be working
Hi, i have recently tried to add the incoming webhook to my channel but encounter the something went wrong error that indicated little about what is failing.
Although the error message popped up there is still an entry in the configured webhooks. And when removing it for reconifiguring it yielded this error.
Will anyone be able to advise how i can troubleshoot and fix the issue?
Hi, i have recently tried to add the incoming webhook to my channel but encounter the something went wrong error that indicated little about what is failing. Although the error message popped up there is still an entry in the configured webhooks. And when removing it for reconifiguring it yielded this error.Will anyone be able to advise how i can troubleshoot and fix the issue? Read More
Oracle Datetime stamp conversion to SQL Server in SSIS
I have date like this in oralce 14-SEP-19 02.21.02.902547000 PM
getting below err
Inputs[OLE DB Destination Input]. The column status returned was: “Conversion failed because the data value overflowed the specified type.”.
I am trying to insert this into datetime data type in sqlserver table
What conversion I need to apply to make this data pass and store in to SQL server table.
Versions: Sql server version 2016 and VS 2017 SSDT 2015
I have date like this in oralce 14-SEP-19 02.21.02.902547000 PMgetting below err Inputs[OLE DB Destination Input]. The column status returned was: “Conversion failed because the data value overflowed the specified type.”. I am trying to insert this into datetime data type in sqlserver table What conversion I need to apply to make this data pass and store in to SQL server table. Versions: Sql server version 2016 and VS 2017 SSDT 2015 Read More
Copilot Studio plugins are not showing up in Copilot for M365 in Teams
I have created a conversation plugin in Copilot studio using add actions in Copilot for M365 and published the plugin. I have added the user in settings of M365 – integrated app section – available apps (Enabled plugins to specified user) and also deployed the Copilot Studio app (user has been added for specified user/ group).
I am not able to see any Copilot studio plugins in the Copilot for M365 in Teams. I have waited for more than 24 hours. Am I missing any other settings?
I have created a conversation plugin in Copilot studio using add actions in Copilot for M365 and published the plugin. I have added the user in settings of M365 – integrated app section – available apps (Enabled plugins to specified user) and also deployed the Copilot Studio app (user has been added for specified user/ group). I am not able to see any Copilot studio plugins in the Copilot for M365 in Teams. I have waited for more than 24 hours. Am I missing any other settings? Read More
Power Apps and Okta Verification
Hi,
We use Okta for identity management for our O365 accounts and I’m interested in using it from within my apps as an additional level of authentication – perhaps an Okta login or MFA screen before a user can interact with the app:
I’ve seen other posts asking this but haven’t seen any recent ones. Does anyone know if this is possible? Could this be accomplished by using creating a custom connector in Power Automate?
Hi,We use Okta for identity management for our O365 accounts and I’m interested in using it from within my apps as an additional level of authentication – perhaps an Okta login or MFA screen before a user can interact with the app: I’ve seen other posts asking this but haven’t seen any recent ones. Does anyone know if this is possible? Could this be accomplished by using creating a custom connector in Power Automate? Read More
What Are the Latest Updates for Fixing Q.B Pay-roll Error PS038?
I’m running across the PS038 Quick-Books Pay-roll problem. How can I resolve this problem so that my pay-roll processing goes without a hitch?
I’m running across the PS038 Quick-Books Pay-roll problem. How can I resolve this problem so that my pay-roll processing goes without a hitch? Read More
regain access to my outlook for my emails
My ICON for outlook suddenly stopped opening – I contacted support and the QR code they sent never openened either Help
My ICON for outlook suddenly stopped opening – I contacted support and the QR code they sent never openened either Help Read More
What are common causes and solutions for Quick-Books Pay-roll error PS038?
I’m encountering Quick-Books error PS038 while trying to update my pay-roll. What could be causing this issue, and how can I resolve it quickly?
I’m encountering Quick-Books error PS038 while trying to update my pay-roll. What could be causing this issue, and how can I resolve it quickly? Read More
Purview and Snowflake
we are trying to create scans connecting to Snowflake. I successfully created snowflake subscription, established connection creating new data source in Purview and created new scan details following the documentation Microsoft provided. When I try run the scans, I am getting the below error. Can please help what I am missing here. When I look at the log file, I can see the connection is successfully establishing but Metadata Discovery is getting failed.
Error: Snowflake Internal Error: Unable to connect. Invalid URI: The hostname could not be parsed. SqlState: 08006, VendorCode: 270001, QueryId:
Errorcode : FailToConnect
OperationItem : snowflake://abcdefg.snowflakecomputing.com/databases/SNOWFLAKE_SAMPLE_DATA/schemas/TPCDS_SF100TCL/tables/CALL_CENTER
Purview successfully establishing the connection and Ingesting successfully but failing at Metadata Discovery state.
Please help how to we resolve this issue.
Sincerely,
Krishna.
we are trying to create scans connecting to Snowflake. I successfully created snowflake subscription, established connection creating new data source in Purview and created new scan details following the documentation Microsoft provided. When I try run the scans, I am getting the below error. Can please help what I am missing here. When I look at the log file, I can see the connection is successfully establishing but Metadata Discovery is getting failed. Error: Snowflake Internal Error: Unable to connect. Invalid URI: The hostname could not be parsed. SqlState: 08006, VendorCode: 270001, QueryId:Errorcode : FailToConnectOperationItem : snowflake://abcdefg.snowflakecomputing.com/databases/SNOWFLAKE_SAMPLE_DATA/schemas/TPCDS_SF100TCL/tables/CALL_CENTER Purview successfully establishing the connection and Ingesting successfully but failing at Metadata Discovery state. Please help how to we resolve this issue. Sincerely,Krishna. Read More
Microsoft Tech Community Update: July 2024
Today, we are excited to announce a new update for the Microsoft Tech Community that brings some important changes and enhancements to the platform. In this blog post, we will explain what these changes are and why they matter for you as a community member.
Display Names without Spaces
One of the most noticeable changes in this update is that we have begun asking affected users who have spaces in their display name to change them. This means that if you still have a display name that contains spaces, such as John Doe or Jane Smith, you will need to update it to a single word, such as JohnDoe or Jane_Smith. You can change your display name at any time from your profile settings.
Why did we make this change? There are two main reasons. First, we wanted to fix some user experience issues with the @mention feature, which allows you to tag other users in your posts and comments. It was previously not possible to tag users with spaces in their names. Now, you can simply type @ followed by the display name, like this: @JohnDoe. This is much easier and consistent, and it also makes the @mentions more visible and clickable.
Second, we wanted to prepare for a new user interface that we are planning to launch in the early fall. This new UI will have a more modern and streamlined look and feel, and it will also introduce some new features and functionalities which don’t work if the display name has a space in it. We will be sharing more about this update in the coming weeks and months.
We understand that this change may require some adjustment for some of you, and we appreciate your understanding and cooperation. We believe that this change will improve the overall user experience and prepare the platform for the future.
We will approach this update in two phases, between now and end of August 2024 we will present affected users with a pop up and ask them to update their display name. This pop up can be dismissed.
Phase 2, starting from September 1st , we will require all affected users to make this change.
Registration Experience
Another change that we have made in this update is to improve the registration experience for new users. Previously, when you signed up for the Microsoft Tech Community, you had to choose a display name. The process for doing this was confusing and we observed some users would leave before selecting a display name. Now, we have simplified the process by suggesting a display name for you based on your first name. You can then change this if you want or keep it as it is.
For example, if your first name is John, we will suggest JohnS123 as your display name. You can then change it to something else, like JohnDoe or JoDoe, or keep it as john_doe. You can also change it later by going to your settings.
We hope that this change will make the registration process easier and faster for new users, while still allowing users to choose their own display name if they wished to do so.
Bug Fixes
Finally, we have also fixed some bugs and issues that were affecting the platform. Here are some of the most notable ones:
We fixed an issue where images on the events pages would break out of the box on the page, causing the layout to look messy and distorted. Now, the images are resized and cropped to fit the box.
We fixed an issue where there was no accessible text for screen readers on the ‘Accepted Solution’ check icon. This icon indicates that a post has been marked as the best answer by the original poster or a moderator. Now, the icon has text that says, ‘Go to Accepted Solution’, which can be read by screen readers.
We are always working to improve the Microsoft Tech Community platform and make it the best place for you to learn, share, and connect with other Microsoft enthusiasts and experts. We welcome your feedback and suggestions, and we thank you for your continued support and participation.
Microsoft Tech Community – Latest Blogs –Read More
Power Query Data Sources Cannot Be Refreshed in Excel for the Web
I am trying to build an Excel report that uses power query to connect to Sharepoint lists. The workbook is also stored on the same SharePoint site. I have the required permissions.
When viewing the report in Excel for the web, I receive this message when clicking Data/Refresh All, I receive this message:
COULDN’T REFRESH DATA This workbook contains Power Query queries using data sources that can’t be refreshed in Excel for the Web.
Originally, I loaded the query to the Data Model only. Still could not refresh in Excel for the web.
Changed the query to load to a pivot table report – same error message.
Is there any way to refresh power queries connected to a SharePoint list?
I am trying to build an Excel report that uses power query to connect to Sharepoint lists. The workbook is also stored on the same SharePoint site. I have the required permissions.When viewing the report in Excel for the web, I receive this message when clicking Data/Refresh All, I receive this message:COULDN’T REFRESH DATA This workbook contains Power Query queries using data sources that can’t be refreshed in Excel for the Web.Originally, I loaded the query to the Data Model only. Still could not refresh in Excel for the web.Changed the query to load to a pivot table report – same error message. Is there any way to refresh power queries connected to a SharePoint list? Read More
New Outlook: Plain Text Until Proven Innocent?
I used to turn off Rich Format emails and just view them plain text in old Outlook; but I have been forced to upgrade to new Outlook and I do not see the option listed anymore.
Where has it been moved? Also, is there a way to turn it on network wide?
Also, how stupid and irresponsible is it of Microsoft to bury a setting like that when so many people’s jobs rely on the computer systems of their livelyhood not being encrypted by malware?
It makes me feel like Microsoft is trying to rid the world of additional companies.
I used to turn off Rich Format emails and just view them plain text in old Outlook; but I have been forced to upgrade to new Outlook and I do not see the option listed anymore.Where has it been moved? Also, is there a way to turn it on network wide?Also, how stupid and irresponsible is it of Microsoft to bury a setting like that when so many people’s jobs rely on the computer systems of their livelyhood not being encrypted by malware?It makes me feel like Microsoft is trying to rid the world of additional companies. Read More
MS Access Report with tab characters in content cannot be exported as PDF/A file
PDF files are created without problems if the PDF/A-compatible option is not activated. The problem is reproducible with VBA code (Error 2501) and manually with export as PDF or XPS from the menu (see below).
If I remove all tab stops from the text content of the report pages, I can save the PDF file even if the PDF/A-compatible option is set (e.g. via HKCUSoftwareMicrosoftOffice16.0CommonFixedFormatLastISO19005-1 = 1 or AD Office 365 Group Policy).
I made a small Access DB with the string “ABC DEF” (whitespace is a tab) in Table1, which is displayed in Report1.
In my environments Win 11, Win 10, and Win 2022 Datacenter with Locale de-DE it reproduces this bug in 32-bit and 64-Bit Versions of Access 365 MSO Version 2406.
I’ve reported this problem to the german Microsoft Support (TrackingID#2407051410001308), but they couldn’t reproduce it. They recomeded to report instead to the Windows Feedback-Hub, but this software seem to send my reports to /dev/null. I can post, but the posts never show up.
Any ideas?
PDF files are created without problems if the PDF/A-compatible option is not activated. The problem is reproducible with VBA code (Error 2501) and manually with export as PDF or XPS from the menu (see below). If I remove all tab stops from the text content of the report pages, I can save the PDF file even if the PDF/A-compatible option is set (e.g. via HKCUSoftwareMicrosoftOffice16.0CommonFixedFormatLastISO19005-1 = 1 or AD Office 365 Group Policy). I made a small Access DB with the string “ABC DEF” (whitespace is a tab) in Table1, which is displayed in Report1.Export via “PDF or XPS” with PDF/A-compliant option setIn my environments Win 11, Win 10, and Win 2022 Datacenter with Locale de-DE it reproduces this bug in 32-bit and 64-Bit Versions of Access 365 MSO Version 2406.After print dialog finishes normaly, but before file is created, this error message shows.I’ve reported this problem to the german Microsoft Support (TrackingID#2407051410001308), but they couldn’t reproduce it. They recomeded to report instead to the Windows Feedback-Hub, but this software seem to send my reports to /dev/null. I can post, but the posts never show up.Any ideas? Read More
Macro to copy rows to sheet2 based on value in row
Hello,
Hoping someone can help with a formula or macro to copy data in rows to sheet2 based on the value in the row (column F). Column F does not need to come over to sheet 2 but the other column headings should. Using the example below, row 2 would duplicate 17 times and row 3, 106 times.
I am using Excel365
Thanks in advance!
Ryan
Hello, Hoping someone can help with a formula or macro to copy data in rows to sheet2 based on the value in the row (column F). Column F does not need to come over to sheet 2 but the other column headings should. Using the example below, row 2 would duplicate 17 times and row 3, 106 times.I am using Excel365 Thanks in advance!Ryan Read More
Macro or formula to analyze data in a range for similar data in another range
Hi,
I’m not even sure if this is possible but I’m hoping to find a way to have excel make a best guess and return the value in a dataset. Using the example below Excel would read the values in column D and enter the closest match from column F next to it in column E. So FACBK*3VCAQ3YFL2 would result “Facebook” in cell E2. I’m not looking for perfection, just a head start.
Thank you in advance!
Ryan
Hi,I’m not even sure if this is possible but I’m hoping to find a way to have excel make a best guess and return the value in a dataset. Using the example below Excel would read the values in column D and enter the closest match from column F next to it in column E. So FACBK*3VCAQ3YFL2 would result “Facebook” in cell E2. I’m not looking for perfection, just a head start. Thank you in advance!Ryan Read More
What troubleshooting steps can resolve Q.B Error PS038?
I’m encountering Quick-Books Pay-roll error PS038. How can I fix this issue and ensure my pay-roll processing runs smoothly?
I’m encountering Quick-Books Pay-roll error PS038. How can I fix this issue and ensure my pay-roll processing runs smoothly? Read More