Introduction to Windows Log Analytics
Windows Analytics is a set of solutions for Azure Portal that provide you with extensive data about the state of devices in your deployment. There are currently three solutions which you can use singly or in any combination
Device Health
Device Health provides the following:
Identification of devices that crash frequently, and therefore might need to be rebuilt or replaced.
Identification of device drivers that are causing device crashes, with suggestions of alternative versions of those drivers that might reduce the number of crashes.
Notification of Windows Information Protection misconfigurations that send prompts to end users
Update Compliance
Update Compliance shows you the state of your devices with respect to the Windows updates so that you can ensure that they are on the most current updates as appropriate. In addition, Update Compliance provides the following:
1.Dedicated drill-downs for devices that might need attention.
2.An inventory of devices, including the version of Windows they are running and their update status.
3.The ability to track protection and threat status for Windows Defender Antivirus-enabled devices.
4.An overview of Windows Update for Business deferral configurations (Windows 10, version 1607 and later)
5.Powerful built-in log analytics to create useful custom queries.
6.Cloud-connected access utilizing Windows 10 diagnostic data means no need for new complex, customized infrastructure.
Upgrade Readiness
Upgrade Readiness offers a set of tools to plan and manage the upgrade process end to end, allowing you to adopt new Windows releases more quickly. With new Windows versions being released multiple times a year, ensuring application and driver compatibility on an ongoing basis is key to adopting new Windows versions as they are released. Upgrade Readiness not only supports upgrade management from Windows 7 and Windows 8.1 to Windows 10, but also Windows 10 upgrades in the Windows as a service model.
Navigation and permissions in the Azure portal
Go to the Azure portal, select All services, and search for Log Analytics workspaces. Once it appears, you can select the star to add it to your favorites for easy access in the future.
Export query from Log Analytics
Start by creating a log query that returns the data that you want to populate the Power BI dataset. You then export that query to Power Query (M) language which can be used by Power BI Desktop.
1.Create the log query in Log Analytics to extract the data for your dataset.
2.Select Export > Power BI Query (M). This exports the query to a text file called PowerBIQuery.txt.
3.Open the text file and copy its contents.
Export query from Log Analytics Workspace to Power BI
When Log Analytics report is already being built in Azure portal itself, and we must migrate all the report to Power BI.
Click the link below to explore this topic in more detail.
https://www.rayminds.com/post/windows-log-analytics-using-power-bi
