Posts

Showing posts from July, 2025

Excel

Formula for matches =IF(A1=B1, "Match" , "No Match" ) =IF(A1=B1, "Sama" , "Beda" ) Formula for difference =ABS(A1-B1) =IF(A1<>B1, "No Match" , "Match" ) Formula for sum =SUM(A1:A10) Formula for average =AVERAGE(A1:A10) Formula for count =COUNT(A1:A10) Formula for maximum =MAX(A1:A10) Formula for minimum =MIN(A1:A10) View Excel-View-Freeze-panes-freese top

Outlook

Spent 20 min to play your day/Week Outlook do a daily planning & Do a weekly planning Search from: to: from: < mail-id > subject: < subject > < keyword > hasattachment: yes folder: inbox Set your Calander work hours and Location Setting -> Calander Create shortcut Ctrl +1 Mail Ctrl +2 Calander Ctrl +3 People Ctrl +4 To do Views Conditional Forwarding View View settings conditional forwarding Add new (Give Name) Select Font size/format(Bold)/Colour(Red)/Bigger Check Sample and click ok Condition when it will apply from < Name > View-> message privew -> 3 lines view -> show as conversation (All Mail Folder) Mail -> select mail -> Drag and drop in task /calander Outlook -> mail -> followup(icon) select time to follow-up New Outlook Click follow-up (icon) Right click mail-> snooze -...

Mac Tricks

cmd + tab and press q, it will quit the app cmd + tab and use UP arrow key, then use left and right key and press enter to select Google Chrome Function + shift + delte To delete the saved/listing user names listing Enable Touch ID (iterm) # vi /etc/pam.d/sudo auth sufficient pam_tid.sp FN + E to enable emoji 😁

VScode Tips & Tricks

 VS Code  Settings cmd + shift + p => Command Palette Cmd+Shift+p => Install Extension Wrap Tabs settings => Search for "workbench.editor.wrapTabs" and enable it Remove settings => Search for "editor.minimap.enabled" and disable it "Enable Telemetry" Themes Cmd+Shift+p => Product Icon Themes Window cmd+n => Open New Tab ctrl+tab => To switch between Tab cmd+b => Toggle SideBar cmd+w Close Current tab cmd +shift+t Reopen the last close tab cmd+p open the file from project directory Navigate cmd + shift + ] To switch between the open files cmd + shift + [ To switch between the open files cmd + shift + o => Go to Symbol in File ctrl+ ~ => In built terminal cmp+p :<no> # navigate to that line option + up (or) down arrow key # move the line up or down cmd+p search button cmd+ [ => Indent the line cmd+ ] => outdent the line ctrl + d => select the word cmd + d => select the next occurrenc...

Ansible Plugin

 Plugins are pieces of code that augment(அதிகப்படுத்து) Ansible’s core functionality. Ansible uses a plugin architecture to enable a rich, flexible and expandable feature set. Ansible ships with several handy plugins, and you can easily write your own. This section covers the various types of plugins that are included with Ansible: Action plugins Become plugins Cache plugins Callback plugins Cliconf plugins Connection plugins Docs fragments Filter plugins Httpapi plugins Inventory plugins Lookup plugins Modules Module utilities Netconf plugins Shell plugins Strategy plugins Terminal plugins Test plugins Vars plugins Action Plugins Action plugins act in conjunction with modules to execute the actions required by playbook tasks. They usually execute automatically in the background doing prerequisite work before modules execute. The ‘normal’ action plugin is used for modules that do not already have an action plugin. If necessary, you can create custom action plugins. You can enable a...

DevOps Linux Troubleshooting Process Management

  To find the top 10 CPU-consuming processes # ps -e --sort=-pcpu -o pid,pcpu,comm   # ps -e --sort=-pcpu -o pid,pcpu,comm | head -n <noumber> # ps -eo pid,comm,%mem,%cpu --sort=-%cpu | head -n <number> To find the top 10 memory-consuming processes # ps -e --sort=-pmem -o pid,pmem,comm # ps -e --sort=-pmem -o pid,pmem,comm | head -n <number> # ps -eo pid,comm,%mem,%cpu --sort=-%mem | head -n <number> To find the uptime of the process   # ps -eo comm,lstart,etime,user   # ps -eo comm,lstart,etime,user | grep -i <service-name>

DevOps Key words

  Multitenancy Multitenancy in the cloud means using shared services and resources for multiple clients. (eg) It's a pattern where a single application instance is utilized by multiple customers at the same time.   Confluence (சங்கமம்/பெருங்கூட்டம்) Confluence is a web-based corporate wiki developed by Atlassian. Confluence is a collaborative documentation tool. Conflunece is a team workspace where knowledge and collaboration meet. JIRA Jira is a software product developed by Atlassian that allows bug tracking, issue tracking, and agile project management Jira is primarily a project management and issue-tracking software.

CDN => Content Delivery Network

  CDN makes your website faster.   Increase in speed, which is achieved by reducing the amount of distance between the user and the content or the servers providing the content. The users can retrieve the content directly from their closest geographical location. Indirect benefit: We are reducing the load, or the reduction in the amount of capacity that you need to serve all these users.   Increase in Security through obscurity (the state of being unknown) CDN are geographically distributed networks of Proxy servers, serving content to users more quickly

Observability/Monitoring

Image
  Observability is a property of your system that helps you understand what's going on with it. Monitoring ·     Looking at what happened a long time ago ·     Looking at the past ·     Monitoring is passive watching. ·     Monitoring is slightly delayed.   Observability Observability is active. Observability is asking questions right now.   ·     How the system is acting ·     What is the state of the system, and reacting fast Three Pillars of Observability 1.       Metrics 2.       Logs 3.       Traces You need to be able to understand what's going on, and really, that is what observability is all about.

Linux Journalctl for DevOps Support

  journalctl To show you all of the journal entries that have been collected since the most recent reboot. # journalctl -b To Save Past boots, Some distro/version savves them by default   # mkdir -p /var/log/journal # vi /etc/systemd/journald.conf Under the [Journal] section, set the Storage= option to “persistent” to enable persistent logging: . . . [Journal] Storage=persistent # journalctl --list-boots journal from the previous boot, use the -1 # journalctl -b -1 journalctl --dmesg journalctl -u chronyd -b Display kernal messages # journalctl -k # journalctl -k --since today. # -S for Since   # journalctl -k --since "2025-06-17 12:00:00" Time Window (YYYY-MM-DD HH:MM:SS) # journalctl --since "2025-06-17 12:00:00" # journalctl --since "2015-01-10" --until "2015-01-11 03:00" # -U for Until # journalctl --since yesterday If you received reports of a service interruption starting at 9:00 AM and continuing until an hour ago, you could type: # journa...