blog.atwork.at

news and know-how about microsoft, technology, cloud and more.

How to filter entries with Null value in Azure Table Storage Explorer

Azure storage accounts are a great and inexpensive way to store lots of data. I am using Azure Table storage to store large amounts of structured data for various tools. I needed to filter all rows that have a specific field that shows Null. While this sounds simple, it is a bit tricky. Here's how.

Identify guest users and their status with Graph

Working with Microsoft Azure and Microsoft 365, Azure Active Directory as an identity and management system becomes more and more important. Like Active Directory, Azure AD grows throughout time with guest accounts, cloud accounts and synchronized accounts. From a governance and lifecycle point of view - and also for security reasons - it is therefore important to clean up Azure AD from time to time. The cleanup process supports a healthy lifecycle management. In this article we describe how to quickly identify guest users in your own Azure AD with on-board resources.

The quick way to work with SharePoint Lists and permissions

SharePoint (or Microsoft) lists provide a good storage for not too extensive structured data. Sometimes administrators want to restrict access to certain items or lines. This approach shows how you, as an administrator, can do this without using item permissions, but with simpler and easier-to-manage views and permissions.

Ways to work with Power BI licenses

I recently wanted to share a Microsoft Power BI report with other users who only have the "Power BI (Free)" license. Well, with a "Power BI Pro" license, a report can be shared with other users. But I noticed that there are stumbling blocks when it comes to licensing. Here are my findings.

Trust the box? Working with the Relevance Score in Microsoft 365

In the Microsoft 365 platform, productivity and recommendations are created to inform users about their relevant data. For example, Microsoft Delve is an app showing such information to a user. Another service is Microsoft Viva Insights (formerly MyAnalytics) that sends out statistics according to the motto "Work smarter with personal productivity insights in Microsoft 365". While this can be very useful for users to quickly find and discover relevant data, works councils are often sensitive to personal data in a company. So how can we explain what is happening here and invalidate what data is visible to individual users and what data is visible to other users? Well, here is some information about the Microsoft 365 "works with" features.

atwork launched Cloud Hub - the first Microsoft Teams App that lets you receive important news directly from your Microsoft Tenant

The atwork-team is beyond excited to inform you that we recently launched our first Microsoft Teams App and the second one in Austria – Cloud Hub, which lets you receive important news from your Microsoft tenant. Get it now!

Power Platform Environments and Governance Tips

The Microsoft Power Platform enables individual solutions to be developed and business processes to be easily automated. When it comes to controlling the solutions, it is important to establish an IT governance in the organization. There are many areas and details about it. For this reason, I've put together a summary here with some news and helpful tips.

When to use what Azure monitoring service

The well-known Scott Hanselman has been producing the recurring Azure Friday series for a long time. Last Friday, Scott interviewed Azure Barry (Barry Luijbregts) about "What to use for monitoring your applications in Azure". Barry did a great overview about the main monitoring services. See the recording and a kind of summary transcript here.

Azure Logic Apps Toolbox 6-Work with items in Apply to each

Automation of small tasks is helpful for many recurring processes. Unless you regularly use Power Automate (Flow) or Azure Logic Apps, it is often not that easy to remember the correct syntax for accessing items in a loop. Here is the quick help.