Can you recommend any resources/tutorials to learn Autosys R11? I have to learn how to create autosys jobs including jil files.

Hi All,

Greetings...

According to my work, I need to zip files present in a folder using batch script without using any 3rd party software.

I tried with below code ,but getting the error.error also attached below.

Any help regarding this would be highly appreciated.

'Get command-line arguments.
Set objArgs = WScript.Arguments
Set FS = CreateObject("Scripting.FileSystemObject")
InputFolder = FS.GetAbsolutePathName(objArgs(0))
ZipFile = FS.GetAbsolutePathName(objArgs(1))

'Create empty ZIP file.
CreateObject("Scripting.FileSystemObject").CreateTextFile(ZipFile, True).Write "PK" & Chr(5) & Chr(6) & String(18, vbNullChar)

Set objShell = CreateObject("Shell.Application")

Set source = objShell.NameSpace(InputFolder).Items

objShell.NameSpace(ZipFile).CopyHere(source)

'Required!
wScript.Sleep 2000

Select all Open in new window

This code is present in zip.vbs file. We have to zip the files into Outputfile.zip file.
in command prompt  , I have entered below command

C:\Users\abc>Cscript zip.vbs input path  output path\OutputFile.zip

While executing this ,I got below error. " Path not found error" for both the input and output file path.

It will be helpful if anyone corrects me the mistake which I made in this script.

I have a simple script to check up down of ips. I have it displaying the way I would like, I would also like to save all of those up/downs to a text file. ( I have to send the results to someone else.) When I try to pipe it after the write-hosts are done, I get "An empty pipe element..."
Is there a simple way to get both?

Get-content c:\path\names.txt | %{
	If (Test-Connection $_ -Quiet -Count 2){
	write-host -foregroundcolor black -backgroundcolor green "$_ is UP"
	}
	Else{
	write-host -foregroundcolor black -backgroundcolor red "$_ is Down"
	}
}
|Out-File c:\path\result.txt

Select all Open in new window

Thanks!

So I have this script, but when I run it, it's not working, it doesn't delete the files.
So I had someone write this for me, and it's supposed to keep 150 files, and delete the files from the directory listed, and delete all etl files. Am I missing something?

@echo off (need to change the below to the locations needed and file types)

call :delolder 150 "E:\ms\Output_On_08-10-2017__Time_17-12-31PM" "etl"
exit /b

:delolder
set type=%~3
set thedir=%~2
set keep=%~1
for /f "delims=" %%D in ('dir "%thedir%" /ad /b /s') do (
  echo Working on dir %%~fD
  for /F "skip=%keep% delims=" %%a in ('dir "%%~fD\*.%type%" /a-d /o-d /b 2^>NUL') do DEL "%%~D\%%~a"
)
echo Working on root dir %thedir%
for /F "skip=%keep% tokens=* delims=" %%a in ('dir "%thedir%\*.%type%" /a-d /o-d /b 2^>NUL') do if "%%~nxa" NEQ "%~nx0" DEL "%thedir%\%%~a"
exit /b

Select all Open in new window

There is  a form with "post" that in the action it says:

(I run it with get and the line reads http://domain.com/test/?(variables))

http://domain.com/test

It doesn't specify the script that takes the form data to process and returns a result

I dont know in what language it is programmed in

I tried index.php (domain.com/test/index.php

the same for index.asp, default.php and default.asp but those scripts dont exist in the server.

I use chrome developers tools but it only returns  (index) which could be anything

Any ideas?

Is it possible to block a state via htacess?  Hypothetical, I am not allowed to business in CA so I want to block the state of CA?
Are there instructions on how to block all countries except the USA via htaccess?

I have a script that is not working, perhaps I'm doing something wrong.
So I've changed the variables below, but it's not actually deleting the files.
Any ideas what I'm doing wrong?


@echo off (need to change the below to the locations needed and file types)

call :delolder 7 "E:\mailflow backups" "*"
exit /b

:delolder
set type=%~3
set thedir=%~2
set keep=%~1
for /f "delims=" %%D in ('dir "%thedir%" /ad /b /s') do (
  echo Working on dir %%~fD
  for /F "skip=%keep% delims=" %%a in ('dir "%%~fD\*.%type%" /a-d /o-d /b 2^>NUL') do DEL "%%~D\%%~a"
)
echo Working on root dir %thedir%
for /F "skip=%keep% tokens=* delims=" %%a in ('dir "%thedir%\*.%type%" /a-d /o-d /b 2^>NUL') do if "%%~nxa" NEQ "%~nx0" DEL "%thedir%\%%~a"
exit /b

People,

I need some help to query all domain controller for certain Security Event ID like: 4740, 4771 and 4776.
My goal is to know which location of the Locked AD account.

This is the script that I have and been working:

$LogonType = @{
	[uint32]2 = 'Interactive'
	[uint32]3 = 'Network'
	[uint32]4 = 'Batch'
	[uint32]5 = 'Service'
	[uint32]7 = 'Unlock'
	[uint32]8 = 'NetworkCleartext'
	[uint32]9 = 'NewCredentials'
	[uint32]10 = 'RemoteInteractive'
	[uint32]11 = 'CachedInteractive'
}
Get-ADComputer -LDAPFilter "(&(objectCategory=computer)(userAccountControl:1.2.840.113556.1.4.803:=8192))" | ForEach-Object {
    "Processing $($_.DNSHostName) ..." | Write-Host
	Get-WinEvent -ComputerName $_.Name -FilterHashTable @{LogName="Security"; ID=4624; Data="John.Wick"} -MaxEvents 200 | ForEach-Object {
		New-Object PSObject -Property ([ordered]@{
			MachineName = $_.MachineName
			TimeCreated = $_.TimeCreated
			User = $_.Properties[5].Value
			Domain = $_.Properties[6].Value
			LogonType = $_.Properties[8].Value
			LogonTypeString = $LogonType[$_.Properties[8].Value]
			SourceIP = $_.Properties[18].Value
			SourceName = (Resolve-DnsName -Name $_.Properties[18].Value -ErrorAction SilentlyContinue).NameHost
			Keywords = $_.KeywordsDisplayNames -join ";"
		})
	}
} | Export-Csv -Path C:\TEMP\John.csv -NoTypeInformation -UseCulture

Select all Open in new window

and this is the second PowerShell script:

get-eventlog -logname "security" | where {($_.eventID -eq 4771) -or ($_.eventID -eq 4776) -or ($_.eventID -eq 4625) } | select timegenerated,message

Select all Open in new window

Any help would be greatly appreciated.

So long story short I think it MAY have something to do with my shebang in my python. I know on our server we have a few different versions of Python and I installed my modules (paramiko and pysftp) in the correct place I believe. Honestly I have researched and am having trouble understanding how exactly the shebang works and knowing what interpreter it is pulling from or why the cron job is failing for that script (is there a log file perhaps to help determine the cause?)

Cron listing:
* * * * * /usr/local/mlb_cdt_download_newv2.py > /dev/null 2>&1
(Yes for testing purposes I am trying to have it run every minute just to see if it runs)

Script:

#!/usr/local/lib/python2.7
import os
import pysftp
import os.path
import paramiko

HOST=""
USER=""
PASSWORD=""
SUFFIX_TO_FETCH__AND_DELETE=".csv"
DESTINATION_PATH="/mnt/sas/ftp_mlb"

srv = pysftp.Connection(host=HOST, username=USER, password=PASSWORD)

def do_nothing(fname):
        return  " "

def fetch_and_remove(fname):
    if not fname.endswith(SUFFIX_TO_FETCH__AND_DELETE):
        return # skip files with wrong suffix
    dst_fname = os.path.join(DESTINATION_PATH, fname)
    dst_dirname = os.path.dirname(dst_fname)
    if os.path.isfile(dst_fname):
        return " "
    else:
        srv.get(fname, dst_fname)
        srv.remove(fname)

srv.walktree('.', fetch_and_remove, do_nothing, do_nothing)

srv.close()

Select all Open in new window

For the record, running this script from the commando line works instantly and perfectly. But when trying to automate it through the cron I have no luck.

Any help trying to understand which interpreter my cron is trying to use and the location of such would be greatly appreciated.

Hi,

Any idea why the following is not ignoring hidden rows? I've tried ".hidden", ."SpecialCells(xlVisible)". Nothing seems to work.

Sub CountOffSpecs(sheet, col, status, row_)
    Dim i As Long
    Dim LastRow As Long
    Dim rarray() As Variant, dict As Object
    Dim v As Variant
    ReDim Preserve rarray(0 To 1)
    t = 0
    Set dict = CreateObject("Scripting.Dictionary")
    LastRow = sheet.Range("A" & Rows.Count).End(xlUp).Row
    For i = 2 To LastRow
        If InStr(1, sheet.Cells(i, status), "|") And Cells(i, status).EntireRow.Hidden = False Then
            resarray = Split(sheet.Cells(i, status), "|")
            lNumElements = UBound(resarray) - LBound(resarray)
            For l = 0 To lNumElements
                ReDim Preserve rarray(LBound(rarray) To UBound(rarray) + lNumElements)
                rarray(UBound(rarray)) = resarray(l)
            Next l
        ElseIf sheet.Cells(i, status) <> "" And Not InStr(1, sheet.Cells(i, status), "|") And Cells(i, status).EntireRow.Hidden = False Then
            resarray = sheet.Cells(i, status)
            ReDim Preserve rarray(LBound(rarray) To UBound(rarray) + 1)
            rarray(UBound(rarray)) = resarray
        Else
            'nothing
        End If
    Next i
    
    For m = LBound(rarray) To UBound(rarray)
        If dict.exists(rarray(m)) Then
            dict.Item(rarray(m)) = dict.Item(rarray(m)) + 1
        Else
            dict.Add rarray(m), 1
        End If
    Next m
    
    a = 1
    

Select all Open in new window

…

I am looking for few things to be automated in AD- through script or any other better available solution

1.To Send email notification after AD user creation
2. To send reminder Email on password expiry  (before 1 Day, 10 Day's, 20 Day's)
3. Generate password automatically  and then send it on email

Thanks in Advance for prompt support .

Hi,

I am using Jupiter to write a read csv line.

So far,I wrote>>

(1)      import pandas as pd
(2)      pd.read_csv('C:/Users/USER1/Documents/Exports/ItemStatus.csv', sep=',')

but its giving me error. See text file. What I need to change to make this work…
python-read-error.txt

I want to import a huge number of very small text files (content is 1 line per file) parse the line and convert it to another text file using delphi. Using the simplest assign(f) etc approach will take several weeks to execute. The bottleneck might probably be the opening/closing of each file. Is there any other way of doing this a lot faster?  maybe using another scripting language? which one?