Skip to content

Instantly share code, notes, and snippets.

View palashkulsh's full-sized avatar
🍓
delusion of reprieve

palash kulshreshtha palashkulsh

🍓
delusion of reprieve
View GitHub Profile
@palashkulsh
palashkulsh / medispace fsm
Created January 31, 2025 12:43
medispace fsm requirements
what is going to be the backup and restoration plan for the data?
What downtime sla is being provided in annual maintenance plan?
Im sure the solution is going to be multi tenent. so that i can onboard my multiple companies with separate and independent workforces?
-- 1 company employees cannot interfere and accessd data from another company.
Hierarchy of organisation employees has to be created. so that when delivering a report, we can send the service report automatically to customer,service engineer and service engineer's manager.
Hierarchy permission can be created so that manager can see performance of his reporting employees.
will application source files be provided?
yearly maintenance plan will include
1. os and language upgrades every year?
@palashkulsh
palashkulsh / sample ids for medispace
Last active January 8, 2025 14:41
sample ids for medispace
A1-A1
A1-A2
A1-A3
A1-A4
A1-A5
A1-A6
A1-A7
A1-A8
A1-A9
A1-A10
@palashkulsh
palashkulsh / ebs snapshot data
Last active March 18, 2024 08:49
ebs snapshots
aws ec2 describe-snapshots --region ap-south-1 --query 'Snapshots[*].[SnapshotId,StartTime,VolumeSize,VolumeId,StorageTier,State,Tags[?Key==`Techteam`].Value | [0],Tags[?Key==`Project`].Value | [0],Description]' --output json | jq -r '.[] | @csv'
@palashkulsh
palashkulsh / Calculating network bandwidth usage
Last active February 2, 2024 07:33
how to check network bandwidth usage of a port via tcpdump
# documented in https://superuser.com/questions/356907/how-to-get-real-time-network-statistics-in-linux-with-kb-mb-bytes-format-and-for
Your application is probably sending packets to a specific UDP or TCP port number or to a specific IP-address.
You can therefore use something like TCPdump to capture that traffic.
TCPdump doesn't give you the real-time stats you desire but you can feed it's output to something that does (I'll try to update this answer with an answer later).
Update:
If you want to find last value of the column
K1 is start of upper header, U6 is end of current row
we want to find header of last non empty column in a row (for K to U columns)
=ifna(index(filter($K$1:U6,not(ISBLANK(K6:U6))),1,counta(K6:U6)),"TBD")
This selects subset of non empty cells from K1 to U6 (from first row to current row)
FILTER AREA
=filter($K$1:U6,not(ISBLANK(K6:U6)))
@palashkulsh
palashkulsh / excel option generator
Created November 20, 2022 14:27
generate excel worksheet with merged cell for each option
import xlsxwriter
from functools import reduce
# Create an new Excel file and add a worksheet.
workbook = xlsxwriter.Workbook('merge1.xlsx')
worksheet = workbook.add_worksheet()
# Create a format to use in the merged range.
merge_format = workbook.add_format({
@palashkulsh
palashkulsh / ebs snapshot
Created September 8, 2022 12:15
ebs snapshot
aws ec2 describe-snapshots --filters Name=tag:Techteam,Values=mall-cart | jq '.Snapshots[] | "\(.SnapshotId),\(.VolumeId),\(.StartTime),\(.VolumeSize),\(.Tags[] | select(.Key=="Hostname") | .Value),\(.Description)"'
@palashkulsh
palashkulsh / org2png
Last active September 4, 2022 20:26
org file to plantuml mindmap or work break down structure wbs diagram creator
#!/bin/bash
#identify is part of imagemagick suite
echo "@startmindmap" > /tmp/.org2file.uml
cat $1 >> /tmp/.org2file.uml
echo "@endmindmap" >> /tmp/.org2file.uml
#if -DPLANTUML_LIMIT_SIZE=18192 is not provided then image gets cropped off
java -jar /home/palashkulshreshtha/bin/plantuml.jar -DPLANTUML_LIMIT_SIZE=18192 -o /tmp/ /tmp/.org2file.uml
@palashkulsh
palashkulsh / jq_map_creation
Last active July 30, 2022 18:46
jq new usages
[{pincode:1,value:1},{pincode:2,value:2}]
to
{1:{pincode:1,value:1},2:{pincode:2,value:2}}
jq '.| map({(.pincode|tostring): .}) | add' IN.json > pincode_wise.json
@palashkulsh
palashkulsh / jq without cross product
Created May 9, 2022 15:30
extracting from jq without creating cross product
https://stackoverflow.com/questions/69973010/how-do-i-avoid-creating-a-cross-product-when-extracting-multiple-sub-elements-fr
cat /tmp/jira.txt | jq '.[] | {key} + (.changelog.histories[] | {created} + (.items[] | {field,fromString,toString})) | select (.field=="status")'