MS PROJECT 2019 UPDATE and Purchasing Options
HI We are currently using Microsoft Project Professional 2019 desktop version, but we are facing challenges with its reporting limitations. Specifically, the software can only display a maximum of 75 rows in its reports. As our weekly reports often exceed this limit, we find ourselves spending considerable time on manual entries. For our monthly reports, we can manage the filtering process to avoid this limitation, but the weekly reports require a hierarchical structure to display task statuses, and unfortunately, there is no workaround for this constraint. While researching this issue, I found discussions indicating that the 2025 version of Microsoft Project can display up to 150 rows, which would help us address our challenges. I have a couple of questions: 1. Does the new version of Microsoft Project 2025 indeed support the display of up to 150 rows? 2. What is the best approach for upgrading: subscription or standalone? 3. Could you provide pricing information and tell us where we can obtain it? Thank you! Best regards, Teshome HPU PMO OfficeCreate historical reports using Azure Log Analytics and Microsoft Intune diagnostic data
By: Janusz Gal – Sr Product Manager | Microsoft Intune Azure Log Analytics gives Intune admins a flexible way to create custom reports from diagnostic data, especially when you need longer history or tailored calculations that go beyond what the Microsoft Intune admin center’s built-in reports provide. By using the Intune diagnostic data you’re already collecting, you can customize reporting for your organization’s unique requirements. In this post, you’ll walk through the steps to create a 30-day device compliance trend report. The resultant report can be run automatically, used in dashboards, or even further customized for a longer period or with additional data. Before we begin, if you haven’t configured a Log Analytics workspace in your tenant, review the following detailed information on the pre-requisites and costs on Microsoft Learn: Route logs to Azure Monitor using Microsoft Intune. In the Microsoft Intune admin center, navigate to Reports > Diagnostic settings, and add a new Diagnostic setting policy to send data to a Log Analytics workspace. Figure 1 Reports > Diagnostic settings, used to configure new or existing diagnostic settings. For a device compliance trend report, ensure the Devices log category is selected: Figure 2 Reports > Diagnostic settings > Selected configuration; Devices log selected. After configuring the setting, navigate to Reports > under Azure monitor, Log Analytics. Figure 3 Reports > Log Analytics; used to query log Analytics workspaces. In the New Query window, enter the following query: IntuneDevices | where TimeGenerated > ago(30d) | summarize Total = count(), Compliant = countif(CompliantState == "Compliant"), NonCompliant = countif(CompliantState == "Noncompliant"), InGracePeriod = countif(CompliantState == "InGracePeriod"), NotEvaluated = countif(CompliantState == "Not Evaluated" or CompliantState == ""), ConfigManager = countif(CompliantState == "ConfigManager") by bin(TimeGenerated, 1d) | extend ComplianceRate = round(100.0 * Compliant / Total, 2) | order by TimeGenerated asc This query will return daily device compliance trends over the past 30 days, from the IntuneDevice table. Figure 4 Reports > Log Analytics; results after running query. Select Chart > Chart type > Stacked Area to show a visual of the trending device state over time. Figure 5 Reports > Log Analytics > Chart > Stacked Area. If you’d like to create other reports but aren’t sure of the schema, one trick you can use is to run the following query in the above Log Analytics workspace to get all the column names: IntuneDevices | getschema Then to get all the values from those columns, you can modify the query to return the distinct values from a specific column such as CompliantState: IntuneDevices | distinct CompliantState Now that you have the query created in Log Analytics, you can save it to run anytime, pin it to a dashboard, or even create a new alert rule to let you know if compliance has gone below a certain threshold. To pin it as a dashboard, on the Query pane select the ellipsis (…) > Pin to > Azure dashboard. Figure 6 Reports > Log Analytics; pin query to dashboard flow. Then select the dashboard you’d like to use. Figure 7 Reports > Log Analytics; select dashboard to pin. Once pinned, simply navigate to Dashboard within the Intune admin center, and you’ll see the query pinned on the selected dashboard. Figure 8 Dashboard showing Log Analytics query. To show more than the past 24-hours, select the Customize Tile button and select Override the dashboard time settings at the tile level, with Timespan set to Past 30 days. Figure 9 Dashboard > Selected Query > Customize Tile button. If you’d like to always see the data in a chart form, select the edit icon on the pinned dashboard item and append the following to the end of the query: | render areachart with (kind=stacked) Figure 10 Dashboard > Selected query > Edit > modified query to show chart. After clicking Apply, the dashboard shows the following: Figure 11 Dashboard showing updated historical device compliance query as a stacked area chart. You’ve now seen end-to-end how to turn Intune diagnostic data into a 30-day device compliance trend report with diagnostic data and Log Analytics. From here, the next step is to operationalize it - save the query, extend the timeframe, join in additional diagnostic tables, or set an alert so you’re notified when compliance drops below your threshold. Better yet, see if you can pick one reporting gap your team is living with today and build it using this pattern. With the right tooling, Intune data can be shaped into views and insights that reflect your organization’s unique needs. Let us know if you have any questions by leaving a comment below or reach out on X @IntuneSuppTeam!
Regarding Existing Microsoft Applications for End-to-End Operational Management
I would like to inquire whether Microsoft offers any pre-built, production-ready applications—preferably within the Dynamics 365 ecosystem—that are currently in use by customers and proven to be stable, which support the following functionalities: Work Order Management Operational Management Production Planning and Control Resource Management Asset Management Quality Management Inventory Management Barcode Scanning for real-time job tracking (start/finish) Profitability and Financial Reporting Hours Variation Analysis( Planned Vs Actual) Cost Variation Analysis( Planned Vs Actual) We are seeking a solution that integrates these capabilities into a unified platform, ideally with real-time data capture and reporting features. If such a solution exists, we would appreciate details regarding its availability, deployment options, licensing, and customer success stories. Looking forward to your guidance
Project Online - Business Drivers matrix table in Power BI
Hi! After classifying our ongoing projects we could get to this matrix table in Project Online: There are 6 Business Drivers where each project contributes on a rating scale (None, Low, Moderate, Strong, Extreme) I am stuck on Power BI to find the relation between each Project, the rating scale and each Business Driver to be able to build the same matrix table in Power BI: Any help would be much appreciated!
Track equipment capacity in MS Project
Hello, I have decent experience using MS Project desktop but currently struggling with how or if MS project is able to track equipment capacity in terms of quantity/units. Ideally, I would like project to alert/show capacity for an equipment based on task start/end date show capacity for future planning. For example, I have 70 samples to run on the equipment but capacity is 40 samples. I know that the 70 samples can't go through, but how can I set the equipment capacity in project to call this out? I have been tinkering with resource sheets, names, %, but don't understand how to manipulate it so that if I set an equipment capacity at 40 units (not %), it will show me capacity alerts. I also want to enter in tasks that are happening months out and would like capacity alerts to be called out in this situation too. This is how I'm tracking it in project. I don't want to put each sample as it's own line item as there are many projects with X samples so I keep it as a high level task with the project and associated sample count. Maybe it's how I am tracking that doesn't allow for tracking capacity in units? Any suggestions are appreciated. Thank you.Project web app- No up to date data via OData feed
Hi all, we are working with the project web app. The Data stored in the project web app is pulled via the OData feed connector into a PowerBI report. The project web app is hosted on https://company.sharepoint.com/sites/pwa, the data is pulled from https://thoenigroup.sharepoint.com/sites/pwa/_api/projectdata The connection and data refresh was working for months without an issue, last week I have added two enterprise custom fields in the PWA and made some changes to the Enterprise Global. When opening the enterprise global a cache limit error appeared in Project Desktop, which was resolved by deleting the cache. I had to do a forced check in of the enterprise global in the PWA settings. I also got an error when loading the "Tasks" table in Power BI, an issue with one of the newly added enterprise custom fields was reported. This issue just appeared once, seems now to be resolved. Since then, I have not gotten any up to data from the PWA via the OData feed into PowerBI. When looking directly in the PWA the data gets updated, but gets not submitted via the OData feed anymore, some "old" versoin of the data gets submitted, I can run the data refresh against the OData feed without any issue but returns only "old" data. I also have 2 "Project Save from Project Professional" jobs under "Manage queue jobs" with job type "Cancelled" which I cannot remove / cancel from the list. How can I solve this? Thanks in advance
