Paradyne SLM 5.5 manual Using AT under Windows to Automate Reports

Page 59

7. OpenLane Maintenance

Using AT under Windows to Automate Reports

Procedure

1.Using a text editor, create a batch script in the c:\opt\pdn\OpenLane directory that contains the commands you would ordinarily use to generate reports. For example, to create reports for all customers, add the following commands:

c:

cd \opt\pdn\OpenLane

.OLCmd processreports

2.Save the script. In this example, the script is called Myreports.bat.

3.Open an MS-DOS prompt window. Type the at command required to schedule your batch script. The at command has the following fields:

\\computername – A remote host on which the command will be executed (optional).

ID – An identification number for the scheduled command (optional).

/delete – Cancels a scheduled command. If id is omitted, all the scheduled commands on the computer are canceled.

/yes – Used with cancel all jobs command when no further confirmation is desired.

time – Specifies the time when command is to run.

/interactive – Allows the job to interact with the desktop of the user who is logged on at the time the job runs.

/every:date[,...] – Runs the command on each specified day(s) of the week or month. If date is omitted, the current day of the month is assumed.

/next:date[,...] – Runs the specified command on the next occurrence of the day (for example, next Thursday). If date is omitted, the current day of the month is assumed.

Command – Is the Windows NT command, or batch program to be run.

For example, to execute MyReports.sh every weekday at midnight and noon on the same computer as the AT command is executed, the correct commands are:

at 00:00 /every:Monday,Tuesday,Wednesday,Thursday,Friday c:\opt\pdn\OpenLane\Myreports.bat

at 12:00 /every:Monday,Tuesday,Wednesday,Thursday,Friday c:\opt\pdn\OpenLane\Myreports.bat

7800-A2-GB32-00

January 2002

7-7

Image 59
Contents OpenLane SLM Copyright 2002 Paradyne Corporation All rights reserved Contents Apache User Access Authentication Installing OpenLane on WindowsConfiguring Distributed Components Adding Devices and Customer Profiles OpenLane MaintenanceBuilding and Using a Firmware Library Index Using XML to Produce ReportsOLCmd Reference Document Summary About This GuideDocument Purpose and Intended Audience Library → Technical Manuals Product-Related DocumentsNetwork Monitoring Easy InstallationIntroduction to OpenLane SLM OpenLane SLMOpenLane Features About These Instructions Installing OpenLane on SolarisPlanning the Installation Software Requirements Installation RequirementsMinimum Hardware Requirements Checking the Java Runtime Environment Version ProcedureCd /opt/OV/pdn/PerfWiz UnInstallToOV Uninstalling DCE ManagerUninstalling Performance Wizard DCEinstallOpt/pdn/OpenLane OpenLane Installation ProgramOpt/apache User = nobody Group = nobody Obtaining a License Key Installing from Paradyne’s Web SiteSetup.sh Installing from FTP Files Installing from CD-ROMSetenv Display localhostname0.0 Installing Remotely UsingInstalling the Permanent License Key Export DISPLAY=localhostname0.0OLCmd key Locating the License Key On an Installed SystemMigration to Current Release for Oracle Displaying the License Key Expiration DateStopping OpenLane Web and Database Services Starting OpenLane Web and Database ServicesConfiguring Apache to Use a Different Port Installing OpenLane on Solaris January Installing OpenLane on Windows MHz Processor Web Client Software Requirements Cd \opt\OV\pdn\PerfWiz uninstalltoov \opt\pdn\OpenLane \Program Files\Apache Group\Apache\opt\apache Procedure Cd \opt\pdn\OpenLane Migration to Current Release for Oracle Starting OpenLane Web and Database Services Stopping OpenLane Web and Database Services Http//olserver.com8080/openlane Installing OpenLane on Windows January OpenLane Distributed Components Configuring Distributed ComponentsOpenLane in /opt/pdn/OpenLane Setting Up Web Server DistributionSolaris Http//172.20.1.10/OpenLane Operational NotesCd /opt/pdn/OpenLane/uhpoller mkdir pollerpoller1 Setting Up the Distributed Poller and ReaderDistributed Poller/Reader Management Server Setup Cd /opt/pdn/OpenLane OLControl stopOLCmd logsvc OLCmd Dbconfig ‘-m 172.20.1.10’OLCmd Dbconfig ‘-m 172.20.1.101521’ Cd /opt/pdn/OpenLane OLControl startREADERDOMAIN=default Distributed Poller/Reader Poller/Reader SetupDOMAIN=default OLControl stop User Access Authentication Apache User Access AuthenticationChange to the /opt/apache/bin Solaris or c\opt\apache\bin Configuring Http Challenge/ResponseCd /opt/apache Solaris cd \opt\apache Windows OLCmd confauth off Removing a User’s Access\opt\pdn\OpenLane Windows OLCmd confauth onApache User Access Authentication January Adding Devices and Customer Profiles Accessing the OpenLane Web ApplicationsAdding a Device AdminNew Device Field Names Field Description Adding a Customer Profile 7800-A2-GB32-00 January Adding Devices and Customer Profiles Task Importance Ideal Frequency OpenLane MaintenanceOracle Database Backing Up OpenLane FilesOpt/pdn/OpenLane/data Gzip -d /backupdir/backup.tar.gz tar xvf backup.tarBacking Up OpenLane Under Solaris Restoring OpenLane Under SolarisRestoring OpenLane Under Windows Backing Up OpenLane Under WindowsFrequency Deleting Older Records from the DatabaseCd /opt/pdn/OpenLane OLCmd processreports Using Cron Under Solaris to Automate ReportsGenerating Scheduled Reports Automating the Generation of Scheduled ReportsCd \opt\pdn\OpenLane OLCmd processreports Using AT under Windows to Automate ReportsRebuilding Oracle Database Indexes SQL Database Log File Monitoring Log FilesApache Log Files Legacy Logger Log Files OLCmd clean logs .logArchiving and Deleting Log Files Click on Click here to schedule the tasks Uploading ConfigurationsOpenLane Maintenance January 01.02.01=R010201.ocd Building and Using a Firmware LibraryBuilding a Firmware Library Version=filename9880=fw9880 New Device Models Not Supported by OpenLaneModel=directory Dslasn Model=devicetypeDbm DslaanDownloading and Activating Firmware Building and Using a Firmware Library Building and Using a Firmware Library January OLCmd Reference Olcmd viewlog -h OLCmd HelpsCd \opt\pdn\openlane olcmd confauth on OLCmd addcust Rent-a-Phone.com Rent-a-PhoneGmbH Rent-a-PhoneUSA OLCmd addcust -a realtime -c ExactCorporationOLCmd assigndev -c ExactCorporation -l exactdevices.txt OLCmd assigndevOLCmd assigndev -c ExactCorporation -a OLCmd chgrawfileext -d dallas -o bad -e raw OLCmd chgrawfileextOLCmd chgrawfileext -o raw -e ftp OLCmd clean \opt\apache\logs .log 21 admin OLCmd cleanOLCmd confauth on off OLCmd confauthOLCmd dbage OLCmd dbconfig -d c o -a instance -l -h OLCmd dbconfigUrl OLCmd dbcopy d OracleStatsDB OLCmd dbcopyOLCmd dbip OLCmd dbipOLCmd dbip address OLCmd dbroll -e 20010101000000 -r OLCmd dbrollDatabaseinstance IpaddressOLCmd delcust -l ex-customers.txt OLCmd delcustOLCmd delcust -ccustomer -lcustomer-list OLCmd deldev OLCmd deldevOLCmd deldev ipaddress OLCmd dumpldap host OLCmd dumpldapLdiffile OLCmd importldifOLCmd importldif -h host ldiffile OLCmd key WZBCK-AAM6E-U898Q-MX5HK OLCmd keyOLCmd key licensekey OLCmd OLCmd ldapmodify -D c=US -w admin -a -c data/new.ldifOLCmd ldapmodify OLCmd ldapsearch OLCmd ldapsearch -n-D bindDN -w password -h host -p portDebuglevel OLCmd logsvc ipaddress OLCmd logsvcOLCmd processreports -date 05/13/2001 -customer ExactCorp OLCmd processreportsDate date Enddate enddateOLCmd snmpget 135.26.10.37 OLCmd snmpgetOLCmd snmpget communityname ipaddress objectid ObjectidOLCmd snmptest 135.26.10.37 nmswrite Ipaddress Is the address of the device to be accessedOLCmd snmptest OLCmd snmptest ipaddress communitynameOLCmd sync OLCmd sync Poller-name OLCmd uhread -ccommand -npoller-nameCommand OLCmd uhreadOLCmd unassigndev -c ExactCorporation -l exactdevices.txt OLCmd unassigndevOLCmd unassigndev -c ExactCorporation -a OLCmd viewlog OLCmd viewlog -f fi -sd 05/07/2000 -ed 05/13/2000 UHReader Firmware/Configuration/Feature MaintenanceUHLister Poller Controller UHReader Database ReaderXsltransformfile OLCmd xmlreportXmlrequestfile XmloutputfileOLCmd Reference January XML Reports Using XML to Produce ReportsCommand Line Interface OLCmd xmlreport Opt/pdn/OpenLane/samples/xml/reports/xmlentry.html. You can Servlet Interface SlvXmlServletWriting an Interface to the Servlet Opt/pdn/OpenLane/OLServlets/pdn.webcgi.SlvXmlServletOpt/pdn/OpenLane/samples/xml/reports/DeviceReports/Reports XML and XSL ExamplesAdditional Resources Opt/pdn/OpenLane/samples/xml/reports/DeviceReports/RequestsUsing XML to Produce Reports January IN-1 IndexIN-2 IN-3 IN-4