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: Tecnologia

Powershell Scripting – Automatic upload files to remote FTP

On 30 January 2019 by aesquis

Yesterday we had a needed, we needed to transfer every n minutes all the xml files located in a folder to a remote ftp location. There’s a lot of ways to do this and some of them include a payment softwares. In our case files were xml created by a SAP server in a Windows Read More

Persistent connection to Windows shared folder using Linux Ubuntu

On 4 January 2019 by aesquis

This is how you can connect to a windows shared folder as persistent using Linux Ubuntu, in this case we will connect to a Windows server using a domain user for connection credentials At first step we must create a now dir in media location, in ths case we will use testfolder

sudo mkdir /media/testfolder

1	sudo mkdir /media/testfolder

Then we Read More

General . Python . Software . Tecnologia

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

Sql . Tecnologia . Windows

Query Active directory form SQL server

On 24 April 2018 by aesquis

A couple of weeks ago we had the needed to get some users data and our best option was querying directly to Active directory from an SQL server, this could be the best option in some cases, taking in mind that a healthy AD with a good maintainment is allways our best shot. Microsoft Active 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

1 2 3 … 7 »

Calendar

Archives

Categories