July 2020
M	T	W	T	F	S	S
	1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

Category: Software

Python – Check last file date in a folder and notify if there isn’t a new one after n days

On 7 June 2018 by aesquis

This week we had the need of monitoring a folder, specifically we need to know if after “n” days there isn’t any new file. For this reason I programmed a simple python script that sends us an email if this happen. Let’s do the example.

#! /usr/bin/python
# -*- coding: utf-8 -*-
import datetime
import glob
import os
import smtplib
import string
 
now  = datetime.datetime.today() #Get current date

list_of_files = glob.glob('c:/tmp/*') # * means all if need specific format then *.csv
latest_file = max(list_of_files, key=os.path.getctime) #get latest file created in folder

newestFileCreationDate = datetime.datetime.utcfromtimestamp(os.path.getctime(latest_file)) # get creation datetime of last file

dif = (now - newestFileCreationDate) #calculating days between actual date and last creation date

logFile = "c:/tmp2/log.log" #defining a log file

def checkFolder(dif, now, logFile):
	if dif > datetime.timedelta(days = 5): #Check if difference between today and last created file is greater than 5 days
		
		HOST = "192.16.0.1" #This must be your smtp server ip
		SUBJECT = "Alert! At least 5 days wthout a new file in folder xxxxxxx"
		TO = "yourmail@yourdomain.com"
		FROM = "noreply@yourdomain.com"
		text = "%s - The oldest file in folder it's %s old " %(now, dif) 
		BODY = string.join((
			"From: %s" % FROM,
			"To: %s" % TO,
			"Subject: %s" % SUBJECT ,
			"",
			text
			), "\r\n")
		server = smtplib.SMTP(HOST)
		server.sendmail(FROM, [TO], BODY)
		server.quit()
		
		file = open(logFile,"a") #Open log file in append mode
 
		file.write("%s - [WARNING] The oldest file in folder it's %s old \n" %(now, dif)) #Write a log
 
		file.close() 
		
	else : # If difference between today and last creation file is less than 5 days
				
		file = open(logFile,"a")  #Open log file in append mode
 
		file.write("%s - [OK] The oldest file in folder it's %s old \n" %(now, dif)) #write a log
 
		file.close() 

checkFolder(dif,now,logFile) #Call function and pass 3 arguments defined before

#! /usr/bin/python

# -*- coding: utf-8 -*-

import datetime

import glob

import os

import smtplib

import string

now = datetime.datetime.today() #Get current date

list_of_files = glob.glob('c:/tmp/*') # * means all if need specific format then *.csv

latest_file = max(list_of_files, key=os.path.getctime) #get latest file created in folder

newestFileCreationDate = datetime.datetime.utcfromtimestamp(os.path.getctime(latest_file)) # get creation datetime of last file

dif = (now - newestFileCreationDate) #calculating days between actual date and last creation date

logFile = "c:/tmp2/log.log" #defining a log file

def checkFolder(dif, now, logFile):

if dif > datetime.timedelta(days = 5): #Check if difference between today and last created file is greater than 5 days

HOST = "192.16.0.1" #This must be your smtp server ip

SUBJECT = "Alert! At least 5 days wthout a new file in folder xxxxxxx"

TO = "yourmail@yourdomain.com"

FROM = "noreply@yourdomain.com"

text = "%s - The oldest file in folder it's %s old " %(now, dif)

BODY = string.join((

"From: %s" % FROM,

"To: %s" % TO,

"Subject: %s" % SUBJECT ,

"",

text

), "\r\n")

server = smtplib.SMTP(HOST)

server.sendmail(FROM, [TO], BODY)

server.quit()

file = open(logFile,"a") #Open log file in append mode

file.write("%s - [WARNING] The oldest file in folder it's %s old \n" %(now, dif)) #Write a log

file.close()

else : # If difference between today and last creation file is less than 5 days

file = open(logFile,"a") #Open log file in append mode

file.write("%s - [OK] The oldest file in folder it's %s old \n" %(now, dif)) #write a log

file.close()

checkFolder(dif,now,logFile) #Call function and pass 3 arguments defined before

Thanks for all Read More

General . Javascript . Software . Sql . Tecnologia . Windows

Add SQLSRV driver support in EasyPHP Devserver

On 15 May 2018 by aesquis

Recently I had to develop a new project in php, jquery, ajax and javascript which needs a Microsoft SQL database connection. For developing purposes I like to use Easyphp Devserver , an all in one package like WampServer or XAMPP. I Prefer this one because it seems more lightly and less intrusive for my overweighted system. By Read More

General . Software . Tecnologia . Windows

Get Active Directory users expiration date

On 28 February 2018 by aesquis

If you need to know when your users passwords will expire in AD, you can execute this commands in Powershell, this will response with all the accounts and dates. Get-ADUser -filter {Enabled -eq $True -and PasswordNeverExpires -eq $False} –Properties “DisplayName”, “msDS-UserPasswordExpiryTimeComputed” | Select-Object -Property “Displayname”,@{Name=”ExpiryDate”;Expression={[datetime]::FromFileTime($_.”msDS-UserPasswordExpiryTimeComputed”)}} Output example: Displayname ExpiryDate ———– ———- John Doe 15/10/2018 18:45:29 Read More

Javascript . Software . Tecnologia

Javascript – Play with strings and arrays

On 13 February 2018 by aesquis

Last weekend I was playing with strings in Javascript and I made different exercises with them, so this is a good moment to write a remember post with this simple commands. Exercise 1: Discard first n characters of a string, in this case 3

var $myString = ("Hello world");
var $myStringCut = (($myString).substring(3)); //Output will be "lo world";

1 2	var $myString = ("Hello world"); var $myStringCut = (($myString).substring(3)); //Output will be "lo world";

Exercise 2: Get the string until certain character, in this Read More

General . Software . Tecnologia . Windows

Schedule a Servers reboot with email notification when are online

On 1 August 2017 by aesquis

Schedule a servers restart it’s a healthy practice, it’s good for apply systems updates and it helps to free up memory. Thera are a lot of ways to do this, in this reminder i’ll show you wath I did. This example it works with Windows 2003, 2008, 2008r2, 2012, 2012r2, 2016… First of all I Read More

General . Seguretat . Software . Tecnologia . Windows

Export certificate with private key when it’s not exportable

On 20 July 2017 by aesquis

Sometimes computer replacement could became a headache, especially if the old one have a certificate with not exportable key and we don’t have a copy of the original file (Who are going to need this?). This kind of certificates normally are important and difficult to obtain, for this reason maybe you want to avoid a Read More

1 2 3 4 »

Calendar

Archives

Categories