Costin Stefan

This is a quick one, I had to get the SN of my external screens recently and I thought I should share the powershell command I used for this task. This works only on your local machine, for AD nodes there are other options out there on the internet. Get-WmiObject WmiMonitorID -Namespace root\wmi |Select-Object @{l="Manufacturer";e={[System.Text.Encoding]::ASCII.GetString($_.ManufacturerName)}},@{l="Model";e={[System.Text.Encoding]::ASCII.GetString($_.UserFriendlyName)}},@{l="SerialNumber";e={[System.Text.Encoding]::ASCII.GetString($_.SerialNumberID)}} This should return something like this: PS C:\Users\costin> Get-WmiObject WmiMonitorID -Namespace root\wmi |Select-Object @{l="Manufacturer";e={[System.Text.Encoding]::ASCII.GetString($_.ManufacturerName)}},@{l="Model";e={[System.Text.Encoding]::ASCII.GetString($_.UserFriendlyName)}},@{l="SerialNumber";e={[System.Text.Encoding]::ASCII.GetString($_.SerialNumberID)}} Manufacturer Model SerialNumber ------------ ----- ------------ HPN HP E243i 6CM90XXXX HPN HP E223 3CQXXXXX

In case you want to run a quick performance test (in simple terms of access to DB) on a PostgreSQL server, this can be done quickly through a python module called psycopg2. This is the python script I’ve used: #!/usr/bin/python3 import psycopg2 from psycopg2 import Error import time def create_connection(): """ create a database connection to a PostgreSQL database """ try: conn = psycopg2.connect( database="postgres", user="postgres", password="postgres", host="1.2.3.4", port="5432" ) print('Successfully Connected to PostgreSQL') return conn except Error as e: print(e) def check_table_exists(conn): """ check if a table exists in the PostgreSQL database """ cur = conn....

Recently I had to fix a vCenter Server that was stopped working. The webpage displayed the following error, and the automated backup jobs stopped working. Could not connect to one or more vCenter Server systems: https://$VCENTER_FQDN:443/sdk The version is rather old and end of life (6.7), so VMware support was out of the question. Which means I had to do it all by myself. Great… After checking the logs for obvious errors, I’ve noticed that most services were stopped....

This one will be a quick one. Recently I had to move several hundred artefacts from a Jfrog repo folder up one level. Easy peasy, right? But the problem was that manual work from GUI would take forever and my work time is limited so I had to find a different way. For this I’ve used an API call because I didn’t have access to jfrog cli tool. But the API call works for one file, not for a bulk move....

Since I’ve transformed this website in a Blogging as a Service (BaaS) thing with the help of Github Actions and Github Pages my life was much easier. Let me help you do the same. First thing you’ll need is a domain. For this domain you will need a NS, and for this you can use CloudFlare for free. They offer a great service, btw.  ~/ dig in NS costinstefan.ro +short nola....