Archive

Tag Archives of : query

Bandwidth usage report per IP address

I created a simple python script for collecting data from mikrotik accounting (documetation) feature. Here is my “mik_collector.py” script: all you need to change is router_ip variable to match your router IP after that you can run this script simply with this command: python mik_collector.py this will collect data from...

BGInfo – Script for Local IP, Public IP and ISP Name

I recently created 3 scripts for BGInfo … If you need it, use it ;) Local IP.vbs I found this script at ardamis.com and adapted to my needs. I removed VMware local IP, because I don’t need it strMsg = "" strComputer = "."   Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\"...

Get current db2 database size

Today I needed to get database size for one of my databases. I find a partial solution here. My first choice was this stored procedure, which needs to be called from command line: