Sharing Learnings
Kimai Time-Tracking app is an open-source time-tracking app that can be hosted on your own to track time for your projects. For single sign-on integration via SAML, it does provide some documentation, however, the example is on Google. Theoretically, it is able to work on Azure, however, it is all up to exploration. By following … Read more
Embed PowerBI reports is one way to distribute reports to the clients without exposing the filters and able to control how the client views the reports based on their roles. The data can be further restricted using Row Level Security. The sample codes for python are available here. The different access levels and the details … Read more
Microsoft has announced that it will stop adding features to ADAL from 30 Jun 2020, and will only add security fixes through 30 Jun 2022. The recommended approach is to upgrade from ADAL to MSAL, which also support OAuth 2.0 endpoints, which support personal accounts. Microsoft provides a few guides to help this migration: Function … Read more
In my work, I need to obtain data from large databases with several highly normalized tables of at least 10 million records. I have been using INNER join queries with indexes to optimize the queries and reducing the execution speed. However, this does not work for large result sets. The time taken is simply too … Read more
Genesys Interactive Insights reports provide a lot of useful reports slicing and dicing into different segments of the Agent groups, resources, etc. It is also able to drill down into lower granular details and drill up. The report documentation is here. There is a good guide on how to customize the reports and the guide … Read more
Genesys Interactive Insights reports have been very useful in looking at trends and performance of the call centre, down to the individual resources. Some of the reports are daily based, and I have always been wondering how to get more detailed information. And I chanced upon the solution. Below are the steps to deep dive … Read more
Panda’s apply function is very versatile. It is able to run complex instructions on each row of records in the data frame. Take the data of column A and B for example: A B C Alex Dick False Alexandra Babylon True Alexis Baby True Boris Charlie False Michael Custom False The rules to get the … Read more
From Zabbix 4.4, notifications can be sent to Telegram messenger using Telegram Bot API and Zabbix webhook feature. The advantage of this approach is that it is simple and it is native to Zabbix, but the downside is that it cannot send colorful messages. The documentation here is good in setting up the telegram integration. … Read more
SELinux has been introduced into Linux kernel version 2.6 from 2003. However, for many years, the common thing to do on most installations is to disable the SELinux. The common reason cited was that it was too complex to set up the rules, or troubleshoot why it fail. To troubleshoot whether it is blocked by … Read more
django_auth_adfs is a good module to integrate Django with Azure AD authentication in the cloud. Although there is a detailed documentation on the setup, the user interface presented were using the legacy user interface. I am attempting to replicate it using the new interface. Web server URL: https://test.com API exposed in web application: https://test/com/test/testpage IdentifierURL … Read more