Tag Archives: microsoft
Updating Contact through powershell doesn’t reflect on Outlook
I’m creating a new mail-enabled external contact using New-MailContact, then fetching it using Get-Contact and updating using Set-Contact. First immediate update works and sets properties, but when I try to update it second time using Set-Contact, properties are updated in powershell (when I fetch it again using Get-Contact, properties are indeed changed), but in Outlook changes are not being reflected
I’m creating a new mail-enabled external contact using New-MailContact, then fetching it using Get-Contact and updating using Set-Contact. First immediate update works and sets properties, but when I try to update it second time using Set-Contact, properties are updated in powershell (when I fetch it again using Get-Contact, properties are indeed changed), but in Outlook changes are not being reflected Read More
Undeliverable Email
Hello
I am using bookings to create a desk booking system. I have created users in our account but they are not licensed (because they are desks and not real people) for example Desk 01. In the Staff section I have unticked the option to notify staff via email but I am receiving an Undeliverable email because the desk user does not have an inbox. I am the administrator on the account, but I have requested through IT Support to add an email only license onto the Bookings account email. What is the best thing for me to do to get these emails to either stop being sent (we do not have the budget to give every ‘desk’ an email account) or get them sent to another email?
Any help on this matter is great appreciated.
Hello I am using bookings to create a desk booking system. I have created users in our account but they are not licensed (because they are desks and not real people) for example Desk 01. In the Staff section I have unticked the option to notify staff via email but I am receiving an Undeliverable email because the desk user does not have an inbox. I am the administrator on the account, but I have requested through IT Support to add an email only license onto the Bookings account email. What is the best thing for me to do to get these emails to either stop being sent (we do not have the budget to give every ‘desk’ an email account) or get them sent to another email? Any help on this matter is great appreciated. Read More
I’m Trying to Sort 1500 Rows and 4 Columns: Please Help!
Hello,
I have a spreadsheet of data with 1500+ rows and 4 columns. I want to sort the spreadsheet alphabetically by the data in column A. The data in columns B, C, and D correlate to the data in the cell from the A column. I can’t figure out how to sort the spreadsheet while keeping the data associated correctly. I hope I’m explaining this well. I essentially want to take the info from each of the A, B, C, and D cells and sort it according to what is in cell A. If anyone can help me with this, I’d be very grateful, as I can’t find the how-to on Microsoft Help pages.
aylaGrace43
Hello,I have a spreadsheet of data with 1500+ rows and 4 columns. I want to sort the spreadsheet alphabetically by the data in column A. The data in columns B, C, and D correlate to the data in the cell from the A column. I can’t figure out how to sort the spreadsheet while keeping the data associated correctly. I hope I’m explaining this well. I essentially want to take the info from each of the A, B, C, and D cells and sort it according to what is in cell A. If anyone can help me with this, I’d be very grateful, as I can’t find the how-to on Microsoft Help pages.aylaGrace43 Read More
Κωδικός παραπομπής B I T G E T: qp29 (B I T G E T 1000 USDT μπόνους εγγραφής) | Νέος κωδικός προσφορ
Κωδικός παραπομπής B I T G E T: qp29 (B I T G E T 1000 USDT μπόνους εγγραφής) | Νέος κωδικός προσφοράς B I T G E T 2024
Αναζητάτε τον κωδικό παραπομπής B I T G E T; Το τελευταίο για το 2024 είναι το qp29. Με αυτόν τον κωδικό έχετε έκπτωση 30%. Επιπλέον, οι νέοι χρήστες BIT G E T που εγγράφονται με τον κωδικό προσφοράς “qp29” μπορούν να λάβουν μια αποκλειστική διαφημιστική ανταμοιβή αξίας έως και 1.000 $.
Τι είναι ο κωδικός παραπομπής B I T G E T;
Ο κωδικός “qp29” στο πρόγραμμα BIT G E T λειτουργεί ως κωδικός παραπομπής. Με την εισαγωγή αυτού του κωδικού θα λάβετε μόνιμη μείωση στις προμήθειες συναλλαγών καθώς και έκπτωση 30% στις συναλλαγές σας. Επιπλέον, αν μοιραστείτε τον κωδικό παραπομπής σας με τους φίλους σας, έχετε την ευκαιρία να κερδίσετε ένα γενναιόδωρο μπόνους 50%. Η χρήση αυτού του κωδικού παρέχει μια πολύτιμη ευκαιρία να μειώσετε τις χρεώσεις και ενδεχομένως να αυξήσετε τα κέρδη σας προσελκύοντας άλλους στην πλατφόρμα.
Ποιος είναι ο καλύτερος κωδικός παραπομπής B I T G E T 2024;
Ο ιδιαίτερα συνιστώμενος κωδικός παραπομπής B I T G E T είναι qp29. Εάν χρησιμοποιήσετε αυτόν τον κωδικό κατά την εγγραφή σας, θα λάβετε ένα γενναιόδωρο μπόνους $100. Αν μοιραστείτε τον κωδικό σας με τους φίλους σας, έχετε την ευκαιρία να κερδίσετε μια τεράστια προμήθεια 50%. Αυτό ουσιαστικά σας δίνει την ευκαιρία να λάβετε ένα μέγιστο μπόνους εγγραφής έως και $1.000 ως ανταμοιβή καλωσορίσματος. Αυτός είναι ένας πολύ καλός τρόπος για να επεκτείνετε την εμπειρία συναλλαγών σας με πρόσθετα προνόμια, ενώ παράλληλα ενθαρρύνετε άλλους να συμμετάσχουν και να κερδίσουν τις δικές τους ανταμοιβές.
Πώς να χρησιμοποιήσετε τον κωδικό παραπομπής B I T G E T
Ο κωδικός παραπομπής B I T G E T είναι διαθέσιμος σε νέους χρήστες που δεν έχουν ακόμη εγγραφεί στο χρηματιστήριο. Δυστυχώς, εάν έχετε ήδη λογαριασμό, δεν θα μπορείτε να χρησιμοποιήσετε τον κωδικό παραπομπής.
Ωστόσο, το B I T G E T προσφέρει αρκετούς άλλους τρόπους για να συμμετάσχετε σε προσφορές και να κερδίσετε ανταμοιβές. Ας δούμε αυτές τις εναλλακτικές λύσεις.
Για αρχάριους B I T G E T, ακολουθούν οδηγίες βήμα προς βήμα σχετικά με τον τρόπο υποβολής αίτησης για κωδικό παραπομπής:
Για να ξεκινήσετε, επισκεφτείτε το B I T G E T και κάντε κλικ στο μπλε κουμπί «Σύνδεση».
Δώστε ακριβή στοιχεία χρήστη καθώς θα ελεγχθούν για συμμόρφωση με τις διαδικασίες KYC και AML.
Όταν σας ζητηθεί ο κωδικός παραπομπής σας, πληκτρολογήστε qp29.
Ολοκληρώστε τη διαδικασία εγγραφής και ολοκληρώστε τυχόν απαιτούμενες επαληθεύσεις.
Μόλις πληρούνται όλες οι προϋποθέσεις, μπορείτε να λάβετε αμέσως το μπόνους καλωσορίσματος.
Αυτή η προσέγγιση διασφαλίζει ότι οι νέοι χρήστες μπορούν να ολοκληρώσουν εύκολα τη διαδικασία εγγραφής ακόμη και χωρίς κωδικό παραπομπής και να λάβουν ένα μπόνους καλωσορίσματος αφού πληρούν τις καθορισμένες απαιτήσεις.
Ποιος είναι ο συνιστώμενος κωδικός παραπομπής για B I T G E T;
Κωδικός παραπομπής B I T G E T – qp29. Για να λάβετε έκπτωση 30% στην προμήθεια B I T G E T, απλώς ακολουθήστε τα παρακάτω βήματα:
Εγγραφείτε νέο λογαριασμό στο B I T G E T.
Βεβαιωθείτε ότι χρησιμοποιείτε τον κωδικό αναφοράς B I T G E T qp29.
Πόσο είναι το μπόνους παραπομπής για B I T G E T;
Προσκαλέστε τους φίλους σας να συμμετάσχουν στο B I T G E T και κερδίστε μαζί ένα μερίδιο από το βραβείο παραπομπής! Κάθε φίλος που παραπέμπετε μπορεί να κερδίσει 50 $, έως και 1.000 $ ανά χρήστη. Οι χρήστες μπορούν να προσκαλέσουν φίλους να εγγραφούν στο B I T G E T. Εάν πληρούν όλες τις προϋποθέσεις, εσείς και οι φίλοι σας θα λάβετε μπόνους συναλλαγών ύψους $50 μέχρι το μέγιστο όριο.
Πώς παίρνω το μπόνους B I T G E T;
Κερδίστε πόντους καθημερινά και ανταλλάξτε τους με USDT. Ολοκληρώστε την πρόκληση εντός επτά ημερών για να ξεκλειδώσετε όλες τις ανταμοιβές. Εγγραφείτε για να λάβετε ένα πακέτο καλωσορίσματος αξίας 1.000 $. Καταθέστε τουλάχιστον $50 για να κερδίσετε 200 πόντους. Κάντε την πρώτη σας συναλλαγή αξίας τουλάχιστον 50 $ και κερδίστε 500 πόντους.
Οι εκπτώσεις προμήθειας συναλλαγών εφαρμόζονται αυτόματα;
Απολύτως. Μόλις εγγραφείτε με τον αποκλειστικό μας κωδικό παραπομπής B I T G E T qp29, η έκπτωση 30% θα εφαρμοστεί αυτόματα. Δεν απαιτείται περαιτέρω ενέργεια. Απλώς βουτήξτε στις συναλλαγές και επωφεληθείτε από μια μόνιμη έκπτωση 30% σε όλες τις προμήθειες.
Κωδικός παραπομπής B I T G E T: qp29 (B I T G E T 1000 USDT μπόνους εγγραφής) | Νέος κωδικός προσφοράς B I T G E T 2024Αναζητάτε τον κωδικό παραπομπής B I T G E T; Το τελευταίο για το 2024 είναι το qp29. Με αυτόν τον κωδικό έχετε έκπτωση 30%. Επιπλέον, οι νέοι χρήστες BIT G E T που εγγράφονται με τον κωδικό προσφοράς “qp29” μπορούν να λάβουν μια αποκλειστική διαφημιστική ανταμοιβή αξίας έως και 1.000 $.Τι είναι ο κωδικός παραπομπής B I T G E T;Ο κωδικός “qp29” στο πρόγραμμα BIT G E T λειτουργεί ως κωδικός παραπομπής. Με την εισαγωγή αυτού του κωδικού θα λάβετε μόνιμη μείωση στις προμήθειες συναλλαγών καθώς και έκπτωση 30% στις συναλλαγές σας. Επιπλέον, αν μοιραστείτε τον κωδικό παραπομπής σας με τους φίλους σας, έχετε την ευκαιρία να κερδίσετε ένα γενναιόδωρο μπόνους 50%. Η χρήση αυτού του κωδικού παρέχει μια πολύτιμη ευκαιρία να μειώσετε τις χρεώσεις και ενδεχομένως να αυξήσετε τα κέρδη σας προσελκύοντας άλλους στην πλατφόρμα.Ποιος είναι ο καλύτερος κωδικός παραπομπής B I T G E T 2024;Ο ιδιαίτερα συνιστώμενος κωδικός παραπομπής B I T G E T είναι qp29. Εάν χρησιμοποιήσετε αυτόν τον κωδικό κατά την εγγραφή σας, θα λάβετε ένα γενναιόδωρο μπόνους $100. Αν μοιραστείτε τον κωδικό σας με τους φίλους σας, έχετε την ευκαιρία να κερδίσετε μια τεράστια προμήθεια 50%. Αυτό ουσιαστικά σας δίνει την ευκαιρία να λάβετε ένα μέγιστο μπόνους εγγραφής έως και $1.000 ως ανταμοιβή καλωσορίσματος. Αυτός είναι ένας πολύ καλός τρόπος για να επεκτείνετε την εμπειρία συναλλαγών σας με πρόσθετα προνόμια, ενώ παράλληλα ενθαρρύνετε άλλους να συμμετάσχουν και να κερδίσουν τις δικές τους ανταμοιβές.Πώς να χρησιμοποιήσετε τον κωδικό παραπομπής B I T G E TΟ κωδικός παραπομπής B I T G E T είναι διαθέσιμος σε νέους χρήστες που δεν έχουν ακόμη εγγραφεί στο χρηματιστήριο. Δυστυχώς, εάν έχετε ήδη λογαριασμό, δεν θα μπορείτε να χρησιμοποιήσετε τον κωδικό παραπομπής.Ωστόσο, το B I T G E T προσφέρει αρκετούς άλλους τρόπους για να συμμετάσχετε σε προσφορές και να κερδίσετε ανταμοιβές. Ας δούμε αυτές τις εναλλακτικές λύσεις.Για αρχάριους B I T G E T, ακολουθούν οδηγίες βήμα προς βήμα σχετικά με τον τρόπο υποβολής αίτησης για κωδικό παραπομπής:Για να ξεκινήσετε, επισκεφτείτε το B I T G E T και κάντε κλικ στο μπλε κουμπί «Σύνδεση».Δώστε ακριβή στοιχεία χρήστη καθώς θα ελεγχθούν για συμμόρφωση με τις διαδικασίες KYC και AML.Όταν σας ζητηθεί ο κωδικός παραπομπής σας, πληκτρολογήστε qp29.Ολοκληρώστε τη διαδικασία εγγραφής και ολοκληρώστε τυχόν απαιτούμενες επαληθεύσεις.Μόλις πληρούνται όλες οι προϋποθέσεις, μπορείτε να λάβετε αμέσως το μπόνους καλωσορίσματος.Αυτή η προσέγγιση διασφαλίζει ότι οι νέοι χρήστες μπορούν να ολοκληρώσουν εύκολα τη διαδικασία εγγραφής ακόμη και χωρίς κωδικό παραπομπής και να λάβουν ένα μπόνους καλωσορίσματος αφού πληρούν τις καθορισμένες απαιτήσεις.Ποιος είναι ο συνιστώμενος κωδικός παραπομπής για B I T G E T;Κωδικός παραπομπής B I T G E T – qp29. Για να λάβετε έκπτωση 30% στην προμήθεια B I T G E T, απλώς ακολουθήστε τα παρακάτω βήματα:Εγγραφείτε νέο λογαριασμό στο B I T G E T.Βεβαιωθείτε ότι χρησιμοποιείτε τον κωδικό αναφοράς B I T G E T qp29.Πόσο είναι το μπόνους παραπομπής για B I T G E T;Προσκαλέστε τους φίλους σας να συμμετάσχουν στο B I T G E T και κερδίστε μαζί ένα μερίδιο από το βραβείο παραπομπής! Κάθε φίλος που παραπέμπετε μπορεί να κερδίσει 50 $, έως και 1.000 $ ανά χρήστη. Οι χρήστες μπορούν να προσκαλέσουν φίλους να εγγραφούν στο B I T G E T. Εάν πληρούν όλες τις προϋποθέσεις, εσείς και οι φίλοι σας θα λάβετε μπόνους συναλλαγών ύψους $50 μέχρι το μέγιστο όριο.Πώς παίρνω το μπόνους B I T G E T;Κερδίστε πόντους καθημερινά και ανταλλάξτε τους με USDT. Ολοκληρώστε την πρόκληση εντός επτά ημερών για να ξεκλειδώσετε όλες τις ανταμοιβές. Εγγραφείτε για να λάβετε ένα πακέτο καλωσορίσματος αξίας 1.000 $. Καταθέστε τουλάχιστον $50 για να κερδίσετε 200 πόντους. Κάντε την πρώτη σας συναλλαγή αξίας τουλάχιστον 50 $ και κερδίστε 500 πόντους.Οι εκπτώσεις προμήθειας συναλλαγών εφαρμόζονται αυτόματα;Απολύτως. Μόλις εγγραφείτε με τον αποκλειστικό μας κωδικό παραπομπής B I T G E T qp29, η έκπτωση 30% θα εφαρμοστεί αυτόματα. Δεν απαιτείται περαιτέρω ενέργεια. Απλώς βουτήξτε στις συναλλαγές και επωφεληθείτε από μια μόνιμη έκπτωση 30% σε όλες τις προμήθειες. Read More
Microsoft 365 Lighthouse Three-Part Webinar Series
Join us for a three-part webinar series about Microsoft 365 Lighthouse, your solution for managing and securing your Microsoft 365 customers. Learn how to grow your business, unlock efficiency, streamline your workflow, and scale your organization with this powerful tool. Sessions will take place April 25 (available on demand), May 22, and June 26.
See this post for more information:
Grow your Business with Microsoft 365 Lighthouse webinar series – Microsoft Community Hub
—
Advanced Support for Partners (ASfP) and Premier Support for Partners (PSfP) are paid partner offerings at Microsoft that provide unmatched value through a wide range of Partner benefits including account management, technical cloud enablement consultations, and an elevated technical support experience across the Microsoft Cloud (Azure, Microsoft 365, Dynamics 365, Power Platform).
Partners in ASfP have higher Microsoft AI Cloud Partner Program Capability Scores, attain more Solutions Partner designations, and see uplifts across Azure, M365, and D365. View the data and learn more on the new ASfP Impact slide below.
Please review these resources to learn more and consider booking a meeting to speak directly with our teams for a better understanding of the value-added benefits of ASfP and PSfP.
Book a meeting with an ASfP Evangelist
Book a meeting with a PSfP Specialist
Visit the ASfP Website
Visit the PSfP Website
Download the ASfP Fact Sheet
View the ASfP Impact Slide
Stop by the ASfP Partner Community
Join us for a three-part webinar series about Microsoft 365 Lighthouse, your solution for managing and securing your Microsoft 365 customers. Learn how to grow your business, unlock efficiency, streamline your workflow, and scale your organization with this powerful tool. Sessions will take place April 25 (available on demand), May 22, and June 26.
See this post for more information:
Grow your Business with Microsoft 365 Lighthouse webinar series – Microsoft Community Hub
—
Advanced Support for Partners (ASfP) and Premier Support for Partners (PSfP) are paid partner offerings at Microsoft that provide unmatched value through a wide range of Partner benefits including account management, technical cloud enablement consultations, and an elevated technical support experience across the Microsoft Cloud (Azure, Microsoft 365, Dynamics 365, Power Platform).
Partners in ASfP have higher Microsoft AI Cloud Partner Program Capability Scores, attain more Solutions Partner designations, and see uplifts across Azure, M365, and D365. View the data and learn more on the new ASfP Impact slide below.
Please review these resources to learn more and consider booking a meeting to speak directly with our teams for a better understanding of the value-added benefits of ASfP and PSfP.
Book a meeting with an ASfP Evangelist
Book a meeting with a PSfP Specialist
Visit the ASfP Website
Visit the PSfP Website
Download the ASfP Fact Sheet
View the ASfP Impact Slide
Stop by the ASfP Partner Community
Introducing organizational messages (preview) in the Microsoft 365 admin center
Effective communication plays a crucial role in empowering every person in your organization to achieve more. In the digital-first work environment, admins and organizational leaders need a growing variety of tools to reach the right people with the right messages through the right surfaces and at the right times.
To support your organization’s communication efforts, we’re excited to announce the public preview of organizational messages in the Microsoft 365 admin center. This new feature will enable your admins and communications professionals to reach others in your organization through native, branded, and customized experiences right within the Microsoft products they use every day.
What is organizational messages in Microsoft 365 admin center?
Organizational messages enables you to communicate with people in your organization using short form, branded and customized messages. Unlike email, organizational messages are delivered within the experiences your employees rely upon as they complete their workflows, such as Windows 11 or Microsoft 365 apps. Organizational messages provide a versatile way for you to drive various objectives, such as amplifying important leadership communications, driving product adoption and training, facilitating employee onboarding, delivering service health notices, encouraging sustainability best practices, and more. For example, your team can create a custom message for the Windows Spotlight channel that helps your employees understand new policies for staying energy efficient with company devices.
Within the experience in Microsoft 365 admin center, you will be able to manage your organization’s organizational messages made within various admin experiences as well as create new fully customized messages. For example, within the Microsoft 365 admin center, you’ll be able to configure a message’s objective, location, custom content (e.g., title, body, call-to-action URL, image logo, etc.), audience, timeframe and frequency. To ensure the right message is sent, your organization will also be able to go into the organizational messages experience in Microsoft 365 admin center to review and approve customized messages submitted by authors in your organization. Finally, you can also review the performance and activity of your organization’s messages, including information about the number of people in your organization who have seen and interacted with your organizational messages.
Who is organizational messages for?
Admins and comms professionals alike can use organizational messages in Microsoft 365 admin center to inform and enable their organizations.
For admins focused on service health monitoring, onboarding new products/ features, and/or driving Microsoft product value, organizational messages allows engagement that is noticeable and encouraging. For example, admins can help users build skills with the latest Microsoft 365 apps and features, as well as keep users aware of the latest service conditions that may affect their workday. Organizational messages works well alongside other Microsoft 365 admin center features (e.g., Usage reports, Adoption Score and Experience insights (Preview)), giving admins an easy mechanism for showing their organization features that are available to try and enjoy, such as Copilot in Teams.
Further, for company leaders, organizational messages provides a platform to deliver high-visibility comms that can drive top-level business objectives, build community and alignment, and inform broad employee audiences.
Key Features
Centralized management: Admins can create, manage, and review messages from a central location in the Microsoft 365 admin center.
Customization: Messages can be fully customized with objectives, surface locations, content including call-to-action URL, target groups, timeframes, and frequency.
Targeted delivery: Messages can be sent to specific user groups that define appropriate audiences.
Approval flows: Customized messages require multi-person participation to ensure an organization has proper review and approval before engaging users.
How It Works
Create: Craft your message using the intuitive wizard, choosing ‘Create your own’ to make fully-customized messages.
Target: Define your audience with group-based targeting options.
Schedule: Set your delivery schedule and frequency.
Approve: Submit your message for approval within your organization.
Review: Monitor the performance of your messages through detailed analytics.
Get Started
To begin using organizational messages in Microsoft 365 admin center, ensure your team satisfies the setup requirements, including the necessary admin roles and policy configurations. Then, explore the centralized experience in the Microsoft 365 admin center under Reports. To learn more about how to get started and licensing requirements, review the documentation on Microsoft Learn here.
Looking Ahead
As we roll out the Public Preview throughout May 2024, we’re excited to see how organizational messages will enhance communication within your organization. We’re committed to continuously improving this feature based on your feedback and usage.
Stay tuned for more updates, and thank you for being a part of this journey with us. Learn more at https://aka.ms/org-messages-docs.
Microsoft Tech Community – Latest Blogs –Read More
Introducing the new Defender for Identity Health Alert API
Microsoft Defender for Identity (MDI) is a cloud-based security solution that helps monitor and protect identities and infrastructure across your organization. MDI is a core component of Microsoft Defender XDR, leveraging signals from both on-premises Active Directory and cloud identities to help you better identify, detect, and investigate advanced cyberthreats directed at your organization.
Recently, Defender for Identity (MDI) introduced Graph based API to view Defender for Identity Health issues.
Understanding Health Alerts
MDI Health alerts notify you of any problems or issues within your Defender for Identity workspace and are essential for maintaining a secure environment.
MDI health alerts fall into two areas:
Domain-related or aggregated health issues, listed on the Global health issues tab in the Microsoft 365 portal.
Sensor-specific health issues, listed on the Sensor health issues tab in the Microsoft 365 portal.
For more information on MDI Health alerts see, https://learn.microsoft.com/en-us/defender-for-identity/health-alerts.
Benefits of the Health API
Dashboarding –Using this new API, customers can now pull/surface the MDI health alerts information to their dashboarding tool of choice.
Automation – For customers who use ticketing systems for IT support, this new API will allow for the automatic creation of tickets when a new health alert is opened. For example, a new IT help ticket would automatically be opened when an outdated sensor is detected.
Update the status of a health alert. MDI will automatically close a health alert when it detects that the issue has been resolved. You can also suppress the health alert for 7 days if you are aware of the issue that might last for a few days. For example, if a domain controller has been taken offline for maintenance, you will receive a Sensor stopped communicating health alert. As you have taken this domain controller offline this is expected, so you can use the API to change the status from open to suppress. After the sensor is brought back online you can change the status back to open and let MDI automatically close the health alert.
Getting Started with MDI Health Alerts APIs
Requirements:
Permissions: user requires at a minimum M365 role permission: Authorization and settings –> System Setting –> Read only (Defender for Office, Defender for Identity).
Entra ID Enterprise Application consent permissions for Graph Explorer.
SecurityIdenitiesHeath
SecurityIdentitiesHealth.Read.All
SecurityIdentitiesHealthRead Write.All (only required to update the status of a health alert.)
Sample API Queries:
The easiest way to start to use the MDI Health Alert API is using the Graph Explorer, Graph Explorer | Try Microsoft Graph APIs – Microsoft Graph.
Login in with a user who has the minimum permissions, copy a query from below and paste it in the query bar in Graph Explorer.
Note: If you are using a query that is based on DNSName or SensorDNSName make sure to change the text with the name of your domain DNS name.
See all open health alerts – https://graph.microsoft.com/beta/security/identities/healthIssues?$filter=Status eq ‘open’
See open Global health alerts – https://graph.microsoft.com/beta/security/identities/healthIssues?$filter=Status eq ‘open’ and healthIssueType eq ‘global’
See open sensor health alerts – https://graph.microsoft.com/beta/security/identities/healthIssues?$filter=Status eq ‘open’ and healthIssueType eq ‘sensor’
See open health alerts by severity –
https://graph.microsoft.com/beta/security/identities/healthIssues?$filter=Status eq ‘open’ and severity eq ‘medium’
https://graph.microsoft.com/beta/security/identities/healthIssues?$filter=Status eq ‘open’ and severity eq ‘low’
See open global health alerts that domain name ends with contoso.com –https://graph.microsoft.com/beta/security/identities/healthissues?$filter=Status eq ‘open’ and healthIssueType eq ‘global’ and domainNames/any(s:endswith(s,’contoso.com’))
See open global health alerts that sensor DNS name ends with contoso.com –https://graph.microsoft.com/beta/security/identities/healthissues?$filter=Status eq ‘open’ and healthIssueType eq ‘global’ and sensorDNSNames/any(s:endswith(s,’contoso.com’))
See open sensor health alerts with sensor DNS name ends with consoto.com –https://graph.microsoft.com/beta/security/identities/healthissues?$filter=Status eq ‘open’ and healthIssueType eq ‘sensor’ and sensorDNSNames/any(s:endswith(s,’contoso.corp’))
Keep your Defender for Identity deployment healthy and secure!
Microsoft Tech Community – Latest Blogs –Read More
What’s new in Outlook for personal use – May 2024
Over the past few months, the Outlook team has been hard at work continuing our mission to provide people worldwide with a world-class email and calendaring experience. Today we wanted to share the latest innovations from Outlook for personal use. We hope these innovations today and what we build tomorrow continue to help people communicate with confidence and live their best lives.
Here are just a few of the most recent innovations we’ve made available worldwide.
Copilot on Outlook Mobile –
Microsoft Copilot is now available to all Outlook mobile customers who have a Microsoft Copilot Pro subscription, including on their Android and iOS mobile devices. We hope people love the magic of Copilot and the ability to summarize long email threads with ease, create rich and personalized emails from scratch, and to get expert coaching on how to make their email drafts better. Copilot helps you put your ideas into the world anywhere you use Outlook.
1 Copilot in Outlook Mobile on iOS
Copilot on Outlook for Windows
For people who prefer the classic Outlook for Windows experience, we have released Copilot value, specifically Summarize – which enables you to summarize long email threads with a touch of a button. We have also begun to offer coaching by Copilot, which will give you input on emails you create, to ensure you’re hitting the right tone and reader sentiment. In the coming months we plan to also enable draft with Copilot, to help you create great emails from scratch quickly with just a few simple prompts.
2 Copilot Summarize on Classic Outlook for Windows
More on Copilot Pro can be found here.
Showing sender email in junk mail folder
We are constantly looking at ways to help keep our customers safe from bad actors and spammers. In service of this, we started showing sender email addresses in the Junk message list starting in February.
We did this based on common feedback from our customers who scan their Junk folder to check for legitimate mail. Now, when a person goes to their Junk Mail folder, they will see the sender’s name, email address, and subject line. This simple change helps people make better decisions on if they should open the mail or delete it instead of having to hover over the sender’s name or open the message. This is available currently on outlook.com, the new Outlook for Windows, iOS and Android. It will be available on Mac in May.
3 The full email of senders is now shown on mails in the Junk Folder
4 Showing full sender email addresses in Junk folder on mobile
Warning users before visiting malicious links in Junk Folder
Outlook also recently made changes to the Junk Email experience to help people stay more vigilant and protected as they search for mail that they want to keep and engage with. One change we made was a pop-up message warning users before visiting links in any messages they keep in their Junk Folder. We hope this helps customers truly think about the messages they are opening and ensure they are safe. This is available worldwide on Outlook.com, the new Outlook for Windows, iOS and Android, and Mac.
5 A pop up warning before visiting a link to a website from Junk Folder
IMAP / POP support in the new Outlook for Windows.
Over the past few months, our team has been working hard to ensure that every person with a PC can use the new Outlook on Windows for free. Until now, that has encompassed users with personal Microsoft accounts or accounts from major email providers including Gmail, Yahoo, and iCloud. But we also know that a wide variety of users also have IMAP accounts or POP accounts.
Recently, we finalized changes to help make sure that customers who had IMAP accounts can use the new Outlook for Windows. In addition, we are currently rolling out support for POP accounts and anticipate being done with that rollout in the coming weeks.
If you haven’t tried the new Outlook for Windows, learn more here.
As always, we’re extremely grateful to all our Outlook customers and look forward to hearing from them soon!
Microsoft Tech Community – Latest Blogs –Read More
Learn Live Series: Usando GitHub Copilot para Criar Uma Aplicação Node.js (Part III)
Na última terça-feira, dia 30 de Abril, dei continuidade no workshop. Nessa terceira parte que foi a última, aprendemos a criar testes para a aplicação Node.js com Azure Cosmos DB e App Service com ajuda do GitHub Copilot. E, durante essa live exploramos muitas coisas interessantes e legais que de fato o GitHub Copilot pode fazer por nós!
Vamos resumir essa última parte do Workshop agora mesmo!
O que foi abordado durante a Live?
Confira a live no vídeo abaixo!
Introdução
Durante a live, retomamos ao projeto iniciado nas sessões anteriores, demonstrando a praticidade e eficiência do GitHub Copilot para escrever códigos mais rapidamente e com menos erros. O foco da sessão foi na implementação de testes, usando o Jest, que é uma estrutura de teste de JavaScript.
E, claro quando falamos sobre teste, houve muita refatoração de código e aprimoramento de funcionalidades.
todo o material do workshop está disponível aqui
Desenvolvimento e Testes
Um ponto alto da sessão foi a demonstração de como realizar testes unitários no ambiente de desenvolvimento. Gláucia guiou os participantes através da criação de testes para validar a integração com o Azure Cosmos DB, enfatizando a importância de testes no ciclo de desenvolvimento de software.
Que seria o famoso conceito de TDD (Test Driven Development), que é justamente:
Escrever um teste que falha
Fazer o teste passar
Refatorar o código
Em vários momentos durante a live em que o teste falhava, o GitHub Copilot sugeriu correções e melhorias no código, facilitando a identificação de erros e aprimorando a qualidade do código.
Falando em desafios encontrados…
Desafios e Soluções no Código
Durante a live nos deparaemos com alguns desafios ao vivo, como problemas com perfis de configuração e execução de testes, mostrando como resolver esses problemas em tempo real. Esta abordagem não apenas ilustrou soluções para problemas comuns, mas também enfatizou a natureza dinâmica do desenvolvimento de software. Pois no mundo real, problemas acontecem e precisamos estar preparados para resolvê-los.
Deploy e Conclusão do Projeto (Como exercício de casa)
Como exercício final, deixei para que a audiência e fizesse o deploy da aplicação no Azure fazendo uso do Azure App Service e criando também uma esteira de CI/CD com o GitHub Actions.
Se você resolveu implantar a aplicação, não deixe de me marcar no LinkedIn com o projeto immplantado. Vou amar ver o que vocês fizeram e como foi a experiência de vocês com o GitHub Copilot com o Azure!
Conclusão da Live
A implementação dos testes demonstrou como o GitHub Copilot pode acelerar o desenvolvimento de software, permitindo a criação de testes de unidade de forma rápida e eficiente. A sessão refletiu o potencial do Copilot em facilitar o desenvolvimento de software moderno, destacando a importância de testes no ciclo de desenvolvimento.
Agora ningém tem mais desculpa para não escrever testes para suas aplicações Node.js! O GitHub Copilot está aí para nos ajudar!
Próxima Live
Na próxima live, começaremos um outro workshop! Porém dessa vez para ensinar:
“Como Criar uma Aplicação LOB com OpenAI, Azure Communication Services e Microsoft Graph Toolkit”
Link do workshop: Integrar o OpenAI, a comunicação e os recursos de dados organizacionais em um aplicativo de linha de negócios
Lembrando que, essa série de vídeos continuará até Julho de 2024! Então, fique ligado(a) para não perder nenhuma live! E, aproveite e se inscreva no Canal do YouTube do Microsoft Reactor para não perder nenhuma live!
E, a próxima live será no dia 08 de Maio às 14h (horário de Brasília). Então, não perca!
Recursos Adicionais
Sempre é muito importante ter acesso a recursos adicionais para aprimorar o conhecimento. Por isso, deixo aqui alguns links que podem ser úteis para vocês:
Documentação do Azure Cosmos DB
Documentação do Jest
Documentação do GitHub Copilot
Documentação do Azure App Service
Curso Grátis – Introdução ao GitHub Copilot
Curso Grátis – Introdução à engenharia de prompts com o Copilot do GitHub
Curso Grátis – Usando o GitHub Copilot com JavaScript
Curso Grátis – Introdução ao GitHub e ao Visual Studio Code
Curso Grátis – Criar um aplicativo Node.js para o Azure Cosmos DB Core (SQL) no Visual Studio Code
Curso Grátis – Hospedar um aplicativo Web com o Serviço de Aplicativo do Azure
Curso Grátis – Criar um serviço básico nativo de nuvem usando PostgreSQL e Node.js
Super Novidade!
Tá rolando um curso voltado para o público feminino que deseja se capacitar em tecnologia. Porém, focado em:
Python
Dados
Inteligência Artificial
GitHub
E, o melhor de tudo: É GRATUITO!
Haverá inúmeras mentorias e aulas práticas para que você possa aprender e se capacitar! Dê uma olhada na ementa dessa mentoria:
Mentoria em Inteligência Artificial (#ElasNaIA) – 5 mil bolsas de estudos
Mentoria em GitHub (#GitHub4Women) – 5 mil bolsas de estudos
Programa de Formação em Análise de Dados (Data Analytics) – 150 bolsas de estudos
Programa de Formação em Desenvolvimento Back-end Python – 70 bolsas de estudos
Então, se você é mulher e deseja se capacitar em tecnologia, não perca essa oportunidade! Para mais informações detalhadas sobre as bolsas de estudos, acesse o site do Cursos de Python, Dados, IA e GitHub para Mulheres
Como dempre digo, fiquem ligados nas novidades e eventos que a Microsoft tem para vocês! E, até a próxima live!
Até mais!
Microsoft Tech Community – Latest Blogs –Read More
Microsoft 365 Community Conference: Video in Microsoft 365 Stream and ClipChamp Better Together
Session: Video in Microsoft 365 Stream and ClipChamp Better Together
Speaker: Marc Mroz (Product Manager, Microsoft)
I’ll admit it. I came into this session with a modicum of curiosity but as a somewhat “hostile witness”. I’ve been using tools like Camtasia Studio for decades. And, more recently I’ve been learning Blackmagic’s Davinci. I’m not easily impressed by alternative solutions. We like what we’re used to, right?
Within minutes Marc lowered all my walls. He demonstrated how easy it is to work with ClipChamp and as he showed how the tool handled layering audio/video pieces, audio elements, adding effects and more, I really liked what I saw. It helped that he truly seemed to love the product he was demonstrating and that came through fully in his demo.
My favorite features included the Brand Kit and Stock Images. With the Brand Kit you can establish your logos and color scheme, something very helpful to persons like myself that create a LOT of video content and hate repetitive work when it’s unnecessary. Keep in mind many of the fancier features require the premium license so you may have to request an upgrade in your license to access it. That includes stock images. A must-have for video building.
Marc also took us on a tour of Stream features. Stream is a solid platform for in-house video sharing. The platform rests on top of SharePoint so access to the videos require proper permission settings for share and embed links to work properly. Marc demonstrated a Trim feature where you can eliminate the showing of pieces of the video (beginning, middle, ending pieces) that you might not feel are relevant to the viewers. Imagine a webinar where the recording captured 5 minutes of opening wait time or typical banter that you would prefer to cut from the final post. Trim will give you a soft cut in that the video is not really cut and reproduced, it just jumps the time frames you determine.
There was this one guy (it was me) who kept asking questions. Mind you it was only after he finished a section and asked for “any questions?” before moving on. I was never without a question. And he was never without a satisfying answer. As he demonstrated the transcription features in Stream I asked about the download of the transcript… what format it was in. Without skipping a beat he showed me the ability to download the transcript as both a document and as a .vtt file. Those are the exact formats I would need for my own platform, ClipTraining, to post video content, so needless to say, I was pleased.
Having the ability to create video content, share it in Stream, but also place it in Teams… this really empowers people within your organization to build quality, engaging content that doesn’t require you to be a video guru to create… or a SharePoint expert to share.
J. Peter Bruzzese (Microsoft MVP) is a journalist, tech author and speaker, and Chief Evangelist for ClipTraining.
Microsoft Tech Community – Latest Blogs –Read More
smarthost Exchange 2016
in the following scenario: DAG 2 Exchange server 2016 as smart host on external mailserver (register.it) all mailboxes regularly belong to users of the domain, except one which is consulted only on the external mailserver (register.it) and the user does not have a mailbox in the DAG.
if I send an email from an external domain (for example @gmail.com) to the disconnected mailbox AND to another regular mailbox , it arrives duplicated, from the external SMTP and from the internal one. How can I solve the problem?
in the following scenario: DAG 2 Exchange server 2016 as smart host on external mailserver (register.it) all mailboxes regularly belong to users of the domain, except one which is consulted only on the external mailserver (register.it) and the user does not have a mailbox in the DAG.if I send an email from an external domain (for example @gmail.com) to the disconnected mailbox AND to another regular mailbox , it arrives duplicated, from the external SMTP and from the internal one. How can I solve the problem? Read More
How to Fix QuickBooks Desktop Error code 6150 1006?
Troubleshooting Solutions: QuickBooks Desktop Error code 6150 1006
QuickBooks Desktop Error code 6150 1006 typically arises due to issues related to the company file or its components. Here are several troubleshooting solutions to resolve this error and get you back on track:
Update QuickBooks Desktop: Ensure your QuickBooks Desktop is updated to the latest version. Intuit frequently releases updates with bug fixes and patches that may address compatibility issues causing Error code 6150 1006.Run QuickBooks File Doctor: Intuit’s QuickBooks File Doctor tool is designed to diagnose and repair company file issues. Download and run this tool to scan your company file for errors and automatically fix them if possible.Rename .TLG and .ND Files: The .TLG (Transaction Log) and .ND (Network Data) files are essential for QuickBooks to function properly. Renaming these files can sometimes resolve data corruption issues. Navigate to the folder containing your company file, locate the corresponding .TLG and .ND files, and rename them by adding .old as a file extension (e.g., company_file.qbw.tlg.old).Use QuickBooks Auto Data Recovery: If you have created a backup using QuickBooks Auto Data Recovery, you can attempt to restore your company file from the backup copy. This feature automatically creates a backup of your company file and can help recover lost or damaged data.Recreate QuickBooks Desktop Company File: If the issue persists, you may need to recreate your company file. Before proceeding with this step, ensure you have a backup of your company file and all necessary financial data. Create a new company file and re-enter the data manually or restore it from a backup.Check for File Name Restrictions: QuickBooks Desktop imposes certain restrictions on file names, including special characters and length limitations. Ensure that your company file name adheres to these restrictions. Avoid using special characters or symbols in the file name.Repair QuickBooks Installation: Corrupted QuickBooks Desktop installation files can also trigger Error code 6150 1006. To repair the installation, navigate to the Control Panel on your computer, select “Programs and Features,” locate QuickBooks in the list of installed programs, and choose the option to repair the installation.Consult QuickBooks Support: If none of the above solutions resolve the issue, it may be necessary to contact QuickBooks Support for further assistance. They can provide personalized troubleshooting guidance based on your specific situation and help resolve the error promptly.
By following these troubleshooting solutions, you can effectively address QuickBooks Desktop Error code 6150 1006 and resume your accounting tasks without interruption. Remember to always backup your company file before attempting any major changes or repairs to avoid data loss.
Troubleshooting Solutions: QuickBooks Desktop Error code 6150 1006QuickBooks Desktop Error code 6150 1006 typically arises due to issues related to the company file or its components. Here are several troubleshooting solutions to resolve this error and get you back on track:Update QuickBooks Desktop: Ensure your QuickBooks Desktop is updated to the latest version. Intuit frequently releases updates with bug fixes and patches that may address compatibility issues causing Error code 6150 1006.Run QuickBooks File Doctor: Intuit’s QuickBooks File Doctor tool is designed to diagnose and repair company file issues. Download and run this tool to scan your company file for errors and automatically fix them if possible.Rename .TLG and .ND Files: The .TLG (Transaction Log) and .ND (Network Data) files are essential for QuickBooks to function properly. Renaming these files can sometimes resolve data corruption issues. Navigate to the folder containing your company file, locate the corresponding .TLG and .ND files, and rename them by adding .old as a file extension (e.g., company_file.qbw.tlg.old).Use QuickBooks Auto Data Recovery: If you have created a backup using QuickBooks Auto Data Recovery, you can attempt to restore your company file from the backup copy. This feature automatically creates a backup of your company file and can help recover lost or damaged data.Recreate QuickBooks Desktop Company File: If the issue persists, you may need to recreate your company file. Before proceeding with this step, ensure you have a backup of your company file and all necessary financial data. Create a new company file and re-enter the data manually or restore it from a backup.Check for File Name Restrictions: QuickBooks Desktop imposes certain restrictions on file names, including special characters and length limitations. Ensure that your company file name adheres to these restrictions. Avoid using special characters or symbols in the file name.Repair QuickBooks Installation: Corrupted QuickBooks Desktop installation files can also trigger Error code 6150 1006. To repair the installation, navigate to the Control Panel on your computer, select “Programs and Features,” locate QuickBooks in the list of installed programs, and choose the option to repair the installation.Consult QuickBooks Support: If none of the above solutions resolve the issue, it may be necessary to contact QuickBooks Support for further assistance. They can provide personalized troubleshooting guidance based on your specific situation and help resolve the error promptly.By following these troubleshooting solutions, you can effectively address QuickBooks Desktop Error code 6150 1006 and resume your accounting tasks without interruption. Remember to always backup your company file before attempting any major changes or repairs to avoid data loss. Read More
Removing policy from an iPhone from within Intune
Is it possible to remove this compliance policy that references the error message from a single device. We made a slight change and this policy got pushed to phones mistakenly. We corrected the matter but it was already sent. The other policies are fine but just hoping there was a way to remove this error to clean things up. Did not want to have to reenroll the device. Part of it is my OCD!!! LOL!
Is it possible to remove this compliance policy that references the error message from a single device. We made a slight change and this policy got pushed to phones mistakenly. We corrected the matter but it was already sent. The other policies are fine but just hoping there was a way to remove this error to clean things up. Did not want to have to reenroll the device. Part of it is my OCD!!! LOL! Read More
How to Create a Case Statement to Classify / Segment Data
Can someone show me how to create a case statement that will classify the sample data below to appear as follows:
At the moment the table in SQL looks like the following:
Sample data is as follows:
CREATE TABLE #tmpTable (
Channel nvarchar(50),
Months nvarchar(50),
Total Sales int)
INSERT #tmpTable VALUES
(N’Online’,N’Jan’,1427),
(N’Online’,N’Feb’,1486),
(N’Online’,N’Mar’,1325),
(N’Online’,N’Apr’,1065),
(N’Online’,N’May’,803),
(N’Online’,N’Jun’,661),
(N’Online’,N’Jul’,665),
(N’Online’,N’Aug’,912),
(N’Online’,N’Sep’,1444),
(N’Online’,N’Oct’,1689),
(N’Online’,N’Nov’,1763),
(N’Online’,N’Dec’,1440),
(N’Social Media’,N’Jan’,1025),
(N’Social Media’,N’Feb’,925),
(N’Social Media’,N’Mar’,769),
(N’Social Media’,N’Apr’,555),
(N’Social Media’,N’May’,412),
(N’Social Media’,N’Jun’,325),
(N’Social Media’,N’Jul’,341),
(N’Social Media’,N’Aug’,495),
(N’Social Media’,N’Sep’,949),
(N’Social Media’,N’Oct’,1126),
(N’Social Media’,N’Nov’,1273),
(N’Social Media’,N’Dec’,1067),
(N’Outlet’,N’Jan’,125),
(N’Outlet’,N’Feb’,96),
(N’Outlet’,N’Mar’,73),
(N’Outlet’,N’Apr’,88),
(N’Outlet’,N’May’,65),
(N’Outlet’,N’Jun’,53),
(N’Outlet’,N’Jul’,45),
(N’Outlet’,N’Aug’,66),
(N’Outlet’,N’Sep’,145),
(N’Outlet’,N’Oct’,199),
(N’Outlet’,N’Nov’,202),
(N’Outlet’,N’Dec’,181),
(N’Stores’,N’Jan’,639),
(N’Stores’,N’Feb’,641),
(N’Stores’,N’Mar’,418),
(N’Stores’,N’Apr’,398),
(N’Stores’,N’May’,329),
(N’Stores’,N’Jun’,306),
(N’Stores’,N’Jul’,258),
(N’Stores’,N’Aug’,398),
(N’Stores’,N’Sep’,701),
(N’Stores’,N’Oct’,879),
(N’Stores’,N’Nov’,961),
(N’Stores’,N’Dec’,818)
SELECT * FROM #tmpTable
Thank you
Can someone show me how to create a case statement that will classify the sample data below to appear as follows: At the moment the table in SQL looks like the following: Sample data is as follows: CREATE TABLE #tmpTable (Channel nvarchar(50),Months nvarchar(50),Total Sales int)INSERT #tmpTable VALUES(N’Online’,N’Jan’,1427),(N’Online’,N’Feb’,1486),(N’Online’,N’Mar’,1325),(N’Online’,N’Apr’,1065),(N’Online’,N’May’,803),(N’Online’,N’Jun’,661),(N’Online’,N’Jul’,665),(N’Online’,N’Aug’,912),(N’Online’,N’Sep’,1444),(N’Online’,N’Oct’,1689),(N’Online’,N’Nov’,1763),(N’Online’,N’Dec’,1440),(N’Social Media’,N’Jan’,1025),(N’Social Media’,N’Feb’,925),(N’Social Media’,N’Mar’,769),(N’Social Media’,N’Apr’,555),(N’Social Media’,N’May’,412),(N’Social Media’,N’Jun’,325),(N’Social Media’,N’Jul’,341),(N’Social Media’,N’Aug’,495),(N’Social Media’,N’Sep’,949),(N’Social Media’,N’Oct’,1126),(N’Social Media’,N’Nov’,1273),(N’Social Media’,N’Dec’,1067),(N’Outlet’,N’Jan’,125),(N’Outlet’,N’Feb’,96),(N’Outlet’,N’Mar’,73),(N’Outlet’,N’Apr’,88),(N’Outlet’,N’May’,65),(N’Outlet’,N’Jun’,53),(N’Outlet’,N’Jul’,45),(N’Outlet’,N’Aug’,66),(N’Outlet’,N’Sep’,145),(N’Outlet’,N’Oct’,199),(N’Outlet’,N’Nov’,202),(N’Outlet’,N’Dec’,181),(N’Stores’,N’Jan’,639),(N’Stores’,N’Feb’,641),(N’Stores’,N’Mar’,418),(N’Stores’,N’Apr’,398),(N’Stores’,N’May’,329),(N’Stores’,N’Jun’,306),(N’Stores’,N’Jul’,258),(N’Stores’,N’Aug’,398),(N’Stores’,N’Sep’,701),(N’Stores’,N’Oct’,879),(N’Stores’,N’Nov’,961),(N’Stores’,N’Dec’,818)SELECT * FROM #tmpTable Thank you Read More
Shared PC’s in Intune vs Intune For Education
My school district has about 40,000 students and instead of assigning PC’s directly to each student, each class has a cart of PC’s that the student logs in with his / her Office 365 account and uses the pc. We are currently in the process of moving off of Active Directory and into Intune to manage our pc’s. However, due to our naming conventions, the pc’s will all be hybrid ad joined machines. With all this being said, is it better for us to set up the pc’s as Kiosk mode, and use a devices license for each, set them up as a Shared PC with the current users’ credentials deleted when they sign off, and the new user signs in, or to follow the procedures in Intune for Education, which is what we are currently following.
M thought would be the Shared PC route, and to have each cart be represented as though it was a lab setting. Does this make sense?
I am open to any and all suggestions and feel free to be as detailed as possible.
My school district has about 40,000 students and instead of assigning PC’s directly to each student, each class has a cart of PC’s that the student logs in with his / her Office 365 account and uses the pc. We are currently in the process of moving off of Active Directory and into Intune to manage our pc’s. However, due to our naming conventions, the pc’s will all be hybrid ad joined machines. With all this being said, is it better for us to set up the pc’s as Kiosk mode, and use a devices license for each, set them up as a Shared PC with the current users’ credentials deleted when they sign off, and the new user signs in, or to follow the procedures in Intune for Education, which is what we are currently following. M thought would be the Shared PC route, and to have each cart be represented as though it was a lab setting. Does this make sense? I am open to any and all suggestions and feel free to be as detailed as possible. Read More
filtering OUT positions loop (Vba)
i assume i would need multiple loops but Im a newb lol
highlighted are the pairs of offsetting positions (the different colors indicate the offsetting pairs)
how do i know they’re offsetting?
1) one has a”C” in column E, the other is BLANK
2) one is “B”, the other is “S” in column D (“bought/sold” indicator)
3) they’ll have OPPOSITE SIGNS (one positive, the other negative) in column A (“bought/sold AMT”)
4) they’ll have the same TAG code in column H
the other challenge is that these offesets won’t always be next to each other; one could be in row 2 and the other could be in row 100.
then I’d like the code to CUT and paste these offsetting positions to another sheet ..i want it to be CUT so that they’re no longer in the original sheet as they’r
e cancelled positions
i assume i would need multiple loops but Im a newb lol highlighted are the pairs of offsetting positions (the different colors indicate the offsetting pairs) how do i know they’re offsetting? 1) one has a”C” in column E, the other is BLANK 2) one is “B”, the other is “S” in column D (“bought/sold” indicator) 3) they’ll have OPPOSITE SIGNS (one positive, the other negative) in column A (“bought/sold AMT”) 4) they’ll have the same TAG code in column H the other challenge is that these offesets won’t always be next to each other; one could be in row 2 and the other could be in row 100. then I’d like the code to CUT and paste these offsetting positions to another sheet ..i want it to be CUT so that they’re no longer in the original sheet as they’re cancelled positions Read More
How to deploy a production-ready AKS cluster with Terraform verified module
Do you want to use Terraform to deploy an Azure Kubernetes Service (AKS) cluster that meets the production standards? We have a solution for you!
We recently created a Terraform verified module for AKS that allows customers to deploy a production standard AKS cluster along with a Virtual Network and Azure container registry. It provisions an environment sufficient for most production deployments for AKS.
The module is available on the Terraform registry and can be found here.
You don’t have to deal with the complexity of setting up an AKS cluster from the ground up. The module offers opinionated choices and reasonable default settings to deploy an AKS cluster ready for production.
What are Azure Verified Modules?
Azure Verified Modules enable and accelerate consistent solution development and delivery of cloud-native or migrated applications and their supporting infrastructure by codifying Microsoft guidance (WAF), with best practice configurations. For more information, please visit Azure Verified Modules.
What does the module do?
The module provisions the following resources:
Azure Kubernetes Service (AKS) cluster for production workloads
Virtual Network
Azure Container Registry
To view the full list of resources and their configurations, please visit the module page.
How to use the module
To use the module, you need to have Terraform installed on your machine. If you don’t have Terraform installed, you can download it from their website here.
Once you have Terraform installed, you can create a new Terraform configuration file and add the following code:
module “avm-ptn-aks-production” {
source = “Azure/avm-ptn-aks-production/azurerm”
version = “0.1.0”
location = <region>
name = <cluster-name>
resource_group_name = <rg-name>
rbac_aad_admin_group_object_ids = [“11111111-2222-3333-4444-555555555555”]
}
To understand more about the variables and options available, have a look at the GitHub README.
Running the module will provision the resources in your Azure subscription. You can view the resources in the Azure portal.
How we built the module
This module is very opinionated and forces the user into a design that is ready for production. From the experience of supporting users deploying AKS with Terraform with the module “Azure/aks/azurerm“, we proposed a much simpler module to help customers deploy scalable and reliable clusters.
Here some of the important opinionated choices we made.
Create user zonal node pools in all Availability Zones
When implementing availability zones with the cluster autoscaler, we recommend using a single node pool for each zone. The use of the “balance_similar_node_groups” parameter enables a balanced distribution of nodes across zones for your workloads during scale up operations. When this approach isn’t implemented, scale down operations can disrupt the balance of nodes across zones.
Leverage AKS automatic upgrades to keep the cluster secure and supported
AKS has a fast release calendar. It is important to keep the cluster on a supported version, and to get security patches quickly. We enforce the “patch” automatic channel upgrade and the node image “node_os_channel_upgrade” to keep the cluster up to date. It is a user’s responsibility to plan Kubernetes minor version upgrades.
Use Azure CNI Overlay for optimal and simple IP address space management
There are many options when it comes to AKS networking. In most customer scenarios, Azure CNI Overlay is the ideal solution. It is easy to plan IP address usage and it provides plenty of options to grow the cluster.
Use Private Kubernetes API endpoint and Microsoft Entra authentication for enhanced security
We use a layered security approach to protect your Kubernetes API from being hacked. We keep the Kubernetes API safe by putting it in a private network, and we allow Microsoft Entra identities to authenticate (optional: and we turn off local accounts).
Bring your own network and force a User Assigned identity
Customers scenarios often involve more than one single AKS cluster. The Azure VNet where these clusters exist should be part of a resource group controlled by the customer. Reusing the same User Assigned identity across a fleet of clusters, simplifies the role assignment operations. We wrote this module considering the integration in a real-world customer subscription, rather than considering the AKS cluster as a single isolated entity.
Don’t use any preview features
To prevent breaking changes during production, we avoided the use of any preview features.
Development of the module from a Terraform perspective
The Azure Verified Module team worked to create effective pipelines for module development. For initial development you will need to fork an already prepared template and use that to develop your module. The template is available on GitHub here. This ensures that all module developers are following the same standards and best practices. It also makes it easier to review and approve modules for publication and make any updates to the templates.
The pipeline has in built checks to ensure that the module is following the best practices and standards. It provides a Docker container with all the necessary tools to run the checks locally and as well on GitHub Actions. The pipeline runs the following checks:
Checks linting standards that are set and best practices set by the AVM community.
Validates that the Terraform code is valid using “terraform validate“.
Run checks to update the readme if any changes are detected so that you don’t have to manually update them.
The e2e tests only need you to give examples of the module’s functionality and set up a test environment using GitHub to start them. You can see the steps on how to do this here.
For an end-to-end review of the contribution flow and how to setup your module for development using AVM scripts have a look at the Terraform Contribution Guide.
Lessons learned
The AVM team provides the initial module template and GitHub actions pipeline to develop a new module. Using those resources and attending their office hours meeting enabled us to move faster. When building a new Terraform module for Azure, following the procedure to implement an AVM module saves you a lot of time, ensuring quality and avoiding common mistakes.
It adds a lot of value to join the AVM team community calls or look out for the changes mentioned in AVM GitHub repo, to get updates on the latest changes, and to ask any questions you may have.
When writing the design document, before starting development, make sure you address all edge cases. For example, not all Azure regions have availability zones, and the module must work in all Azure regions. Dealing with the details before starting the implementation helps to find good solutions without having to make bigger changes in the implementation phase.
How can you contribute back
Have look at the AVM team blog for updates from the AVM team.
Help build a module.
Share your learnings with the AVM team.
Join the regular external community calls.
Conclusion
If you face any challenges, please raise an issue on the repo – https://github.com/Azure/terraform-azurerm-avm-ptn-aks-production
We would also like to thank Zijie He and Jingwei Wang for their huge contributions and collaboration whilst building this module.
Microsoft Tech Community – Latest Blogs –Read More
OKR model configuration missing in Viva Goals Admin Center
We miss in our Viva Goals Admin Portal the section “OKR Model Configuration”, as it is written under bullet point 2 in https://learn.microsoft.com/en-us/viva/goals/configure-okr-model
How to configure your OKR rules
On the left panel in Viva Goals, select Admin.In the Admin Dashboard section, select the OKR Model Configuration tab.Define your objectives and key results (OKRs) and initiatives as described in the following sections.
I have a Viva Goals license assigned, as well as I have the Viva Goals Administrator Role and I am Owner of the Organization.
We miss in our Viva Goals Admin Portal the section “OKR Model Configuration”, as it is written under bullet point 2 in https://learn.microsoft.com/en-us/viva/goals/configure-okr-modelHow to configure your OKR rulesOn the left panel in Viva Goals, select Admin.In the Admin Dashboard section, select the OKR Model Configuration tab.Define your objectives and key results (OKRs) and initiatives as described in the following sections. I have a Viva Goals license assigned, as well as I have the Viva Goals Administrator Role and I am Owner of the Organization. Read More
Question
Hello
How do you empty cells based on a particular value entered in another cell?
Example if cell A1 = NA
Cells A2:D6 are emptied?
Thanks
Thierry
HelloHow do you empty cells based on a particular value entered in another cell?Example if cell A1 = NACells A2:D6 are emptied?ThanksThierry Read More
UDF and SP what is difference
Hi SQLGurus, might someone explain me with simple words
I created on SQL UDF – quite complex – containing 3-level CTE inside – but single query (RETURNS TABLE AS RETURN(….)
and I created exact same as SP
comparision (I executed together both – select * from UDF and EXEC SP with same parameters goves me that SP runs 5 time quicker than UDF
What is tehnical difference of them and is there some way (SCHEMABINDING or Execute as or something else) to speed up the UDF
Create UDF with EXEC SP inside I’ve not yet tested 🙂
any comment are welcome
Henn Sarv
Hi SQLGurus, might someone explain me with simple wordsI created on SQL UDF – quite complex – containing 3-level CTE inside – but single query (RETURNS TABLE AS RETURN(….)and I created exact same as SPcomparision (I executed together both – select * from UDF and EXEC SP with same parameters goves me that SP runs 5 time quicker than UDFWhat is tehnical difference of them and is there some way (SCHEMABINDING or Execute as or something else) to speed up the UDFCreate UDF with EXEC SP inside I’ve not yet tested :)any comment are welcomeHenn Sarv Read More