Sometimes things you expect to log do not log. I am not sure if for you logging is actually not working period, or just some logging is not working as expected. - I have another video for Power Apps Monitor I did recently you may want to check that too ruclips.net/video/7PdkVjqgTZI/видео.html Things to double back and check if its not working at all: 1) Make sure you have enough capacity to LOG else you cant log if full / perhaps purge if or as needed 2) Make sure you have enough administratve permissions in or on the environment
3) *Enable Auditing for the ORG under SETTINGS > SYSTEM > AUDITING > "Global Audit Settings", or under SETTINGS > SYSTEM > ADMINISTRATION "System Settings" & "Audit Tab" (*NOTE: this is in the OLD backend Dynamics 365 UI/UX) aka then "Advanced Settings" in the Power Platform UI on the Make.PowerApps.com experience. Be sure to enable Start Auditing and optionally Audit User Access if you want to also capture that detail. 4) Enable auditing for the table(s)/entit(y/ies) Be sure to enable single record Auditing and optionally multiple record auditing (**extreemly verbose) 5) view the logs
@@DavidSoden Thanks for reply. All the settings are already done mentioned id steps 3 to 5. I can see logs for standard entity but not for custom table.
@@rahulnalavade664 Seems to me like you have some "filter" applied on the Audit Summary View screen. *Aside I see that in the "Power Platform admin center " under settings for an environment, There is now and Auditing and logs section. THis will likely negate the need to visit the legacy Dynamics 365 UI experience to manage logging.
if you have enabled auditing prior, and for the fields in the record your most concerned about you can look at the logs to see both the OLD and NEW values. The only other option is to restore your environment from backup and I suggest not overwriting the existing one. Make a new environment and then restore to this new environment so you can safely play. You can then get access to the data and record and perhaps manually re-key the data or use SSMS and the TDS connector to write a TSQL query to put the data back.
Thats one option yes. See docs.microsoft.com/en-us/power-platform/admin/add-storage#add-storage-capacity-for-your-tenant The other option is to try and clean up space - start here docs.microsoft.com/en-us/power-platform/admin/free-storage-space The topic in its entirety is covered from this point forward docs.microsoft.com/en-us/power-platform/admin/whats-new-storage and additional reading can be found here docs.microsoft.com/en-us/power-platform/admin/view-manage-resources
It is possible. I showed a canvas app in the video, and that app was based on a table in Dataverse. The audit settings I show apply to the Dataverse data. if you're using Excel, SharePoint, SQL or some other data source other than Dataverse your gonna have to use thier alternative methods for those data sources or manually write auditing functionality yourself in the canvas app using PowerFX to write it to capture the audit data you need... or upgrade / migrate to Dataverse to use what I show here. Regarding Power BI - you can extract the audit logs then base your report based on that. If it were me, I would look at Power Automate Desktop RPA and www.xrmtoolbox.com/plugins/AuditHistoryExtractor/ to automate this, then pump the extracted data into an audit table or move the data to a place that PowerBI can access and create a data model that the report visualizations are based on.
@@DavidSoden Thanks for your reply, but I need to display auditing for specific tables ex( account, contact and custom table) so where I can find this auditing history saved to look on it in my app.
Seams you're not actually trying anything I've suggested. Give the Audit History Extractor an **actual look** and chance to address your needs before dismissing the suggestion as a non sequitur to your challenge. When you open this, you will see 1st you must select a table/entity to extract from, hence addressing your concern. www.xrmtoolbox.com/plugins/AuditHistoryExtractor/
In the new UI, go to edit your modle driven app, for navigation, click new page, for content type chose URL then use this url /tools/audit/audit_summary.aspx replace with yours from the admin center backend for said environment this will make a menu item and that item unfortunatly will open in a new tab
Наука
Nice video! Thank you!
Glad you liked it and thanks for the subscribe!
Hi David ,
How are you?Thanks for Video
I have turned on auditing for my custom table .However not able to see in audit summary log the custom table
Sometimes things you expect to log do not log. I am not sure if for you logging is actually not working period, or just some logging is not working as expected.
- I have another video for Power Apps Monitor I did recently you may want to check that too ruclips.net/video/7PdkVjqgTZI/видео.html
Things to double back and check if its not working at all:
1) Make sure you have enough capacity to LOG else you cant log if full / perhaps purge if or as needed
2) Make sure you have enough administratve permissions in or on the environment
3) *Enable Auditing for the ORG under SETTINGS > SYSTEM > AUDITING > "Global Audit Settings", or under SETTINGS > SYSTEM > ADMINISTRATION "System Settings" & "Audit Tab"
(*NOTE: this is in the OLD backend Dynamics 365 UI/UX) aka then "Advanced Settings" in the Power Platform UI on the Make.PowerApps.com experience.
Be sure to enable Start Auditing and optionally Audit User Access if you want to also capture that detail.
4) Enable auditing for the table(s)/entit(y/ies)
Be sure to enable single record Auditing and optionally multiple record auditing (**extreemly verbose)
5) view the logs
@@DavidSoden
Thanks for reply.
All the settings are already done mentioned id steps 3 to 5. I can see logs for standard entity but not for custom table.
@@rahulnalavade664 Seems to me like you have some "filter" applied on the Audit Summary View screen.
*Aside I see that in the "Power Platform admin center
" under settings for an environment, There is now and Auditing and logs section. THis will likely negate the need to visit the legacy Dynamics 365 UI experience to manage logging.
I need to show all the previous version of records for a dataverse table data. How to implement that?
if you have enabled auditing prior, and for the fields in the record your most concerned about you can look at the logs to see both the OLD and NEW values.
The only other option is to restore your environment from backup and I suggest not overwriting the existing one. Make a new environment and then restore to this new environment so you can safely play. You can then get access to the data and record and perhaps manually re-key the data or use SSMS and the TDS connector to write a TSQL query to put the data back.
If the log reaches the maximum capacity, do I need to buy more space?
Thats one option yes. See docs.microsoft.com/en-us/power-platform/admin/add-storage#add-storage-capacity-for-your-tenant
The other option is to try and clean up space - start here docs.microsoft.com/en-us/power-platform/admin/free-storage-space
The topic in its entirety is covered from this point forward docs.microsoft.com/en-us/power-platform/admin/whats-new-storage and additional reading can be found here docs.microsoft.com/en-us/power-platform/admin/view-manage-resources
Thanks for video
But I need to show this auditing view on canvas PowerApps and on Power Bi report, Is this possible?
It is possible. I showed a canvas app in the video, and that app was based on a table in Dataverse. The audit settings I show apply to the Dataverse data. if you're using Excel, SharePoint, SQL or some other data source other than Dataverse your gonna have to use thier alternative methods for those data sources or manually write auditing functionality yourself in the canvas app using PowerFX to write it to capture the audit data you need... or upgrade / migrate to Dataverse to use what I show here.
Regarding Power BI - you can extract the audit logs then base your report based on that. If it were me, I would look at Power Automate Desktop RPA and www.xrmtoolbox.com/plugins/AuditHistoryExtractor/ to automate this, then pump the extracted data into an audit table or move the data to a place that PowerBI can access and create a data model that the report visualizations are based on.
@@DavidSoden Thanks for your reply, but I need to display auditing for specific tables ex( account, contact and custom table) so where I can find this auditing history saved to look on it in my app.
Seams you're not actually trying anything I've suggested. Give the Audit History Extractor an **actual look** and chance to address your needs before dismissing the suggestion as a non sequitur to your challenge. When you open this, you will see 1st you must select a table/entity to extract from, hence addressing your concern. www.xrmtoolbox.com/plugins/AuditHistoryExtractor/
Hey how to add this audit history in sitemap of model driven apps
In the new UI, go to edit your modle driven app, for navigation, click new page, for content type chose URL then use this url
/tools/audit/audit_summary.aspx
replace with yours from the admin center backend for said environment
this will make a menu item and that item unfortunatly will open in a new tab