Script for a Customized Inventory List

Download JSON Download Python

Ratings

(0)

Release Time

04/20/2020

Downloads

481 times

Update Time

11/20/2024

Views

777 times

Share-it:

Tags

script

Description
Screen Shots

Computer Name

Model

PC or LAPTOP

CPU

Serial Number

RAM

Disk

Operating System

Installed Office Program Version

Hi,

This script will create an inventory like the above, that will show Computer Name (Windows Name), Model of the computer, if the computer is desktop PC or Laptop PC, CPU usage, Serial Number, RAM usage, Disk usage, O.S info and installed office program version info(If office program not installed , it will show not installed ) .

Procedure's Instructions

#To define a particular parameter, replace the 'parameterName' inside itsm.getParameter('parameterName') with that parameter's name

emailto=itsm.getParameter('EmailTo')  ## Provide an To email address where the mail need to be sent.
emailfrom=itsm.getParameter('EmailFrom')  ## Provide the From Email address from which the mail to be send
password=itsm.getParameter('Password')               ##Provide password for from email
smtpserver=itsm.getParameter('smptserver') #Default 'smtp.gmail.com'
port=itsm.getParameter('portnumber') #Default port number 587

import os,sys,shutil,re,sys,socket,_winreg,random,getpass
import socket
import smtplib
import mimetypes
from email.mime.multipart import MIMEMultipart
from email import encoders
from email.message import Message
from email.mime.audio import MIMEAudio
from email.mime.base import MIMEBase
from email.mime.image import MIMEImage
from email.mime.text import MIMEText
import ctypes
from subprocess import PIPE, Popen

def computername():
    return os.environ['COMPUTERNAME']

def ipaddress():
    return socket.gethostbyname(socket.gethostname())

subject='%s %s INV Report!!!!!'%(computername(), ipaddress())

message_body="The report has been attached."

def emailreport(subject, emailto,emailfrom,password,smtpserver,port,msgbody,fileToSend):
	os.chdir(os.environ['TEMP'])
	fileToSend=fileToSend.split('\\')[-1]
	msg = MIMEMultipart()
	msg["From"] = emailfrom
	msg["To"] = ",".join(emailto)
	msg["Subject"] = subject
	msg.preamble = subject
	body = MIMEText(msgbody)
	msg.attach(body)    
	
	attachment=open(fileToSend,"rb")
	p = MIMEBase('application', 'octet-stream') 
	p.set_payload((attachment).read())
	encoders.encode_base64(p)
	p.add_header('Content-Disposition', 'attachment', filename='report.csv')
	msg.attach(p)

try:
		server = smtplib.SMTP(smtpserver,port)
		server.ehlo()
		server.starttls()
		server.login(emailfrom, password)
		server.sendmail(emailfrom, emailto, msg.as_string())
		server.quit()
		return " \nThe email report has been sent to "+emailto
	except Exception as e:
		return e

ls_col=['Computer Name','Model','Pc/Laptop','CPU','S.Number','RAM','Disk','OS','Installed Office Program Version']

def invlist():
    import subprocess as sp

ls_row=[]

#Host name 
    HostName=((sp.Popen('hostname',stdout=sp.PIPE)).communicate()[0]).strip()
    ls_row.append(HostName)
    
    #Model Name
    #computer mother board name
    computername=sp.Popen('WMIC CSPRODUCT GET NAME',stdout=sp.PIPE)
    brand=computername.communicate()[0].strip().splitlines()[-1]
    ls_row.append(brand)
    
    sys_info=sp.Popen('systeminfo',stdout=sp.PIPE)
    sys_info=sys_info.communicate()[0].splitlines()
    
    #pc/Laptop
    pc_laptop=sys_info[14].split()[-1]
    ls_row.append(pc_laptop)
    
    #CPU Usage
    cpu_usage=sp.Popen('wmic cpu get loadpercentage',stdout=sp.PIPE)
    cpu_usage=cpu_usage.communicate()[0].split()[1]+"%"
    ls_row.append(cpu_usage)
    
    #Serial Number 
    s_no=sp.Popen('wmic bios get SerialNumber',stdout=sp.PIPE)
    s_no=(s_no.communicate()[0]).replace('SerialNumber','').strip()
    ls_row.append(s_no)
    
    #Ram Usage
    
    ram_total=sp.Popen('systeminfo | findstr /C:"Total Physical Memory"',stdin=sp.PIPE,shell=True,stdout=sp.PIPE)
    ram_total=ram_total.communicate()[0]

if len(ram_total.split()[3]) <=3 :
        ram_total=int(ram_total.split()[3])
    else:
        ram_total=int(ram_total.split()[3].replace('.',''))
    ram_avail=sp.Popen('systeminfo | findstr /C:"Available Physical Memory"',stdin=sp.PIPE,shell=True,stdout=sp.PIPE)
    ram_avail=ram_avail.communicate()[0]
    if len(ram_avail.split()[3]) <=3 :
        ram_avail=int(ram_avail.split()[3])
    else:
        ram_avail=int(ram_avail.split()[3].replace('.',''))
    ram_usage=str(int(ram_total)-int(ram_avail))+' MB Used'
    ls_row.append(ram_usage)
    
    #Disk Usage
    harddisk=sp.Popen('wmic logicaldisk get size,freespace',stdout=sp.PIPE)
    harddisk=harddisk.communicate()[0].split()
    harddisk_size,harddisk_free=int(harddisk[-1]),int(harddisk[-2])
    harddishused=harddisk_size-harddisk_free
    harddisk_used=convert_bytes(harddishused)
    ls_row.append(harddisk_used)
    
    #os Info
    os_info=sys_info[2:4]
    os_info_name=(os_info[0].replace('OS Name:                   ',''))
    os_info_ver=(os_info[1].replace('OS Version:                ',''))
    os_info_name_ver=os_info_name+'-'+os_info_ver
    ls_row.append(os_info_name_ver)
    
    #ofc ver
    ofc_ver=sp.Popen('powershell reg query "HKEY_CLASSES_ROOT\Word.Application\CurVer"',stdout=sp.PIPE)
    
    try :
        o_ver=ofc_ver.communicate()[0].splitlines()[-2].split()[-1]
        ls_row.append(o_ver)
    except:
        ls_row.append('Not Installed')
    return ls_row

def convert_bytes(size):
    for x in ['bytes', 'KB', 'MB', 'GB', 'TB']:
        if size < 1024.0:
            return "%3.1f %s" % (size, x)
        size /= 1024.0

return size

ls_row=invlist()

import csv
import io
import os
fileToSend=os.path.join(os.environ['TEMP'], 'report.csv')

with open(fileToSend, 'wb' ) as file:
    writer = csv.writer(file, delimiter=',', quotechar='"', quoting=csv.QUOTE_MINIMAL)
    writer.writerow(ls_col)
    writer.writerow(ls_row)

emailreport(subject, emailto,emailfrom,password,smtpserver,port,message_body,fileToSend)

Comments

No Comments.

Script for a Customized Inventory List

Comments

Leave a Comment