Posts By: blog-kullanicisi

Dynamic Excel Files via Python.

In a website, I saw a request from a user, saying: I am creating xlsx for my clients based on dynamic information. When I am generating the xlsx file, I am using formula, cell coloring, row border coloring etc for 400 records, which makes the file creation time delay. So currently, its taking around 40

Read on »

Awk Fun!

Awk is a powerful toy linux users have. As explained in wiki The AWK language is a data-driven scripting language consisting of a set of actions to be taken against streams of textual data – either run directly on files or used as part of a pipeline – for purposes of extracting or transforming text,

Read on »

Prometheus & Grafana & Netdata

Before a while, I had written a post about monitoring single linux system. It was the magic of netdata that was supplying us those good visuals. You can look here. Netdata is good for basic info about a single system, but what about an enterprise infrastructure, mostly with lots of machines? Let’s broaden the concept

Read on »

My Ansible Journey

For a long time, I wanted to tick one of my most wanted job in my to-do list, but could not. At last, I did “learn ansible”. One of my colleagues had used it and that seemed so interesting and exited to me. However, it is work life, time is not easy to find most

Read on »

List Windows Logs

Powershell is really nice and useful. Although it requires a learning cost as most of the other languages, for windows admis it may make the life better and easier. In the sample below, all windows log file names are printed to the screen. By the way, if working with windows logs search or look automation,

Read on »

Modify Windows Registry via Reg File

Every windows system admin may need to work with registry for some purposes. At least, all group policies or most installed programs make modifications in it. To make changes in registry, “regedit” command is rather helpful. It also opens a gui if run without parameter. However, for bulk or repeating modifications, using a file can

Read on »

Monitor Single Linux System with Netdata

If the case is monitoring a single Linux system, netdata comes into play. It both supplies data about lots of crucial system metrics and is also so lightweight. What is more, event web server it is using was rewritten for best performance. Everyone monitoring a system must have a look at https://netdata.firehol.org Thanks to Costa

Read on »

DHCP Backup & Restore

Most organizations use DHCP (Dynamic Host Configuration Protocol) to provide IP addresses to their clients. If organization schema and network segments is not very dynamic, than DHCP server is not needed to be modifed so often and forgotten somewhere out there. However, there can be times to restore DHCP configuration when server, service or sth

Read on »

Windows Remote Computer Log

While managing or configuring windows servers from a management server, a log may be needed for servers being managed. For that purpose, following powershell command might be used. In this example, “RemoteComputerName” logs are displayed and filtered according to “Logname” and “EventID”. [code language=”powershell”] Get-WinEvent -ComputerName <RemoteComputerName> -Logname Microsoft-Windows-GroupPolicy/Operational` |where{$_.Id -eq 9999}|%{ $_.Message } [/code]

Read on »

DFSR Database Rebuild

While using DFS Replication, you may encounter problems or file is not replicated if file is in use. In this situation, we had to replicate files manually several times. We first killed all handles to the file and overwrote the file with the newer one. But this action has a side effect, keep reading. DFSR

Read on »