CN105931016A - Automatic daily audit method and system - Google Patents
Automatic daily audit method and system Download PDFInfo
- Publication number
- CN105931016A CN105931016A CN201610230638.3A CN201610230638A CN105931016A CN 105931016 A CN105931016 A CN 105931016A CN 201610230638 A CN201610230638 A CN 201610230638A CN 105931016 A CN105931016 A CN 105931016A
- Authority
- CN
- China
- Prior art keywords
- day
- checks
- automatization
- data
- template
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- Computational Linguistics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Engineering & Computer Science (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention relates to an automatic daily audit method and system. The method comprises the steps that 1) a host is logged in to obtain index data; 2) daily audit is carried out on the host and the system automatically according to the index data, and an audit result file is generated; and 3) the audit result file is sent out according to setting in advance. An excel template of automatic daily audit is configured, a background program is used to implement daily audit on the system automatically, a daily audit result in the excel format is generated automatically, the daily audit result is sent to a set mail box, the automation degree is high, and manual participation is reduced greatly. The audio result is displayed in the file format, and can be checked and counted conveniently; different indexes of daily audit are analyzed automatically, whether the indexes are abnormal is determined, abnormal indexes are displayed in different colors, and the audit result is clear; and an audit point of daily audit is realized by configuring the template, and can be conveniently expanded according to service requirements in future.
Description
Technical field
The present invention relates to the method and system that a kind of automatization checks day, belong to field of computer technology.
Background technology
Telecommunication system be embodied as with in maintenance process, need the hardware index to system and business to refer to
Mark does current check.To this, conventional processing scheme is needing the index checked to list, then passes through
Concrete personnel perform order or inquiry data base checks one by one.This processing scheme exists three and mainly lacks
Point: one is to there is substantial amounts of repeated work, is unfavorable for Project in Operation；Two is that operation threshold is high, and needs
Manual analysis index is the most abnormal, needs professional to carry out checking day；Three is to check that result is directly shown
On backstage, it has not been convenient to statistics.
Summary of the invention
The technical problem to be solved is in telecommunication system daily auditing process for prior art
In need professional, carry out a large amount of repeated work and check the problems such as result is the most directly perceived, it is provided that a kind of
Automatically sent by system and check destination file day, and check what result open-and-shut automatization day checked
Method and system.
The technical scheme is that a kind of method that automatization checks day,
Comprise the following steps:
Step 1: log in main frame, obtains achievement data；
Step 2: automatically carry out checking day to main frame and system according to achievement data, generates and checks result literary composition
Part；
Step 3: will check that destination file sends according to pre-setting.
The invention has the beneficial effects as follows: the present invention by the excel template configuration that automatization is checked day,
System is carried out checking day by background program automatically, automatically generates the result of checking day of excel form, and
Realizing day checking, result is sent to the mailbox of configuration automatically, automaticity is high, greatly reduces people
Work participates in；The present invention checks that result is to show as a file format, conveniently checks and adds up；And this
The bright each index automatically checked day is analyzed, it may be judged whether abnormal, by abnormal index with different
Color shows, checks that result is very clear；Checking that day checks a little is realized by configuration template, it is simple to day
It is extended according to service needed afterwards.
On the basis of technique scheme, the present invention can also do following improvement.
Further, described step 2 checks destination file according to the template style generation arranged.
Further, described step 1 specifically includes following steps:
Step 1.1: log in main frame, configuration automatization checks template day；
Step 1.2: the beginning checking that the day automatically write in template checks data day is set according to data base
Position.
Use above-mentioned further scheme to provide the benefit that, according to the data in data base, day is checked template
Starting position be determined, the achievement data making template is complete, day checks number for follow-up being correctly written in
According to.
Further, described step 2 specifically includes following steps:
Step 2.1: automatically carry out checking day to main frame and system, generates checking day of XML format file
Data；
Step 2.2: day check data according to checking that template and starting position resolve day, automatically generate coupling
That checks template day checks destination file.
Further, described step 3 is specially and will check that destination file is sent to pre-set with attachment version
Feedback mailbox in.
Use above-mentioned further scheme to provide the benefit that, automatically day is checked that destination file regards mail attached
Part is sent to attendant and relevant leader.Send all realize from data acquisition, file generated to mail
Automatization.
Further, during checking in described step 2, as found there are abnormal index data in main frame and system,
To corresponding the checking of abnormal index data, destination file is identified.
The technical scheme is that the system that a kind of automatization checks day,
Including data acquisition module, check module and sending module；
Described data acquisition module is used for logging in main frame, obtains achievement data；
Described check module for automatically carrying out checking day to main frame and system according to achievement data, generation is checked
Core destination file；
Described sending module is for according to pre-setting and will check that destination file sends.
On the basis of technique scheme, the present invention can also do following improvement.
Further, check described in module generates according to the template style arranged and check destination file.
Further, described data acquisition module includes login module and configuration module；
Described login module is used for logging in main frame, and configuration automatization checks template day；
For arranging according to data base, described configuration module checks that the day automatically write in template checks number day
According to starting position.
Use above-mentioned further scheme to provide the benefit that, according to the data in data base, day is checked template
Starting position be determined, the achievement data making template is complete, day checks number for follow-up being correctly written in
According to.
Further, described sending module will check what destination file was sent to pre-set with attachment version
In feedback mailbox.
Accompanying drawing explanation
Fig. 1 is the method flow diagram that a kind of automatization described in the embodiment of the present invention 1 checks day；
Fig. 2 is the system architecture diagram that a kind of automatization described in the embodiment of the present invention 1 checks day；
Fig. 3 is the method flow diagram that a kind of automatization described in the concrete example of the present invention checks day.
In accompanying drawing, the list of parts representated by each label is as follows:
1, data acquisition module, 2, check module, 3, sending module.
Detailed description of the invention
Being described principle and the feature of the present invention below in conjunction with accompanying drawing, example is served only for explaining this
Invention, is not intended to limit the scope of the present invention.
As it is shown in figure 1, the method checked day for a kind of automatization described in the embodiment of the present invention 1, including
Following steps:
Step 1: log in main frame, obtains achievement data；
Step 2: automatically carry out checking day to main frame and system according to achievement data, generates and checks result literary composition
Part；
Step 3: will check that destination file sends according to pre-setting.
The method that a kind of automatization described in the embodiment of the present invention 2 checks day, on the basis of embodiment 1,
Described step 2 generates according to the template style arranged and checks destination file.
The method that a kind of automatization described in the embodiment of the present invention 3 checks day, at the base of embodiment 1 or 2
On plinth, described step 1 specifically includes following steps:
Step 1.1: log in main frame, configuration automatization checks template day；
Step 1.2: the beginning checking that the day automatically write in template checks data day is set according to data base
Position.
The method that a kind of automatization described in the embodiment of the present invention 4 checks day, in the arbitrary reality of embodiment 1-3
On the basis of executing example, described step 2 specifically includes following steps:
Step 2.1: automatically carry out checking day to main frame and system, generates checking day of XML format file
Data；
Step 2.2: day check data according to checking that template and starting position resolve day, automatically generate coupling
That checks template day checks destination file.
The method that a kind of automatization described in the embodiment of the present invention 5 checks day, in the arbitrary reality of embodiment 1-4
On the basis of executing example, described step 3 is specially will check that destination file is sent to set in advance with attachment version
In the feedback mailbox put.
The method that a kind of automatization described in the embodiment of the present invention 6 checks day, in the arbitrary reality of embodiment 1-5
On the basis of executing example, during checking in described step 2, as found there is abnormal index number in main frame and system
According to, to corresponding the checking of abnormal index data, destination file is identified.
As in figure 2 it is shown, the system checked day for a kind of automatization described in the embodiment of the present invention 1, including
Data acquisition module 1, check module 2 and sending module 3；
Described data acquisition module 1 is used for logging in main frame, obtains achievement data；
Described check module 2 for automatically carrying out checking day to main frame and system according to achievement data, generate
Check destination file；
Described sending module 3 is for according to pre-setting and will check that destination file sends.
The system that a kind of automatization described in the embodiment of the present invention 2 checks day, on the basis of embodiment 1,
Described checking in module 2 checks destination file according to the template style generation arranged.
The system that a kind of automatization described in the embodiment of the present invention 3 checks day, at the base of embodiment 1 or 2
On plinth, described data acquisition module 1 includes login module and configuration module；
Described login module is used for logging in main frame, and configuration automatization checks template day；
For arranging according to data base, described configuration module checks that the day automatically write in template checks number day
According to starting position.
The system that a kind of automatization described in the embodiment of the present invention 4 checks day, in the arbitrary reality of embodiment 1-3
On the basis of executing example, described sending module 3 being checked, destination file is sent to set in advance with attachment version
In the feedback mailbox put.
As it is shown on figure 3, the method that a kind of automatization described in the concrete example of the present invention checks day, specifically wrap
Include following steps:
Step 1, the excel template that configuration automatization checks day, the content item will checked in template arranges
Out, need the cell dynamically filling in data to leave a blank, need the line number according to dynamic data and columns feelings
Condition Prearranged elements lattice, it is impossible to be reconfigured at other in the region that may generate dynamic data and check project, otherwise
May fill in during dynamic data capped in step 4.Excel file arranges conditional formats rule,
Normal data and abnormal data different colours are filled, to facilitate judged result the most normal.excel
Can be according to practical situation in template, excel worksheet is configurable to be shown and multinomial checks content, also
Can check that content is separately shown in different operating table by multinomial.
Step 2, in data base's allocation list, according to excel template, configures each and checks in content and need
Being automatically filled in the starting position of data, including worksheet names, line number, columns, each checks that content is joined
Put a record, a configuration ID is set.
Step 3, Automatic dispatching background program, according in excel template check item obtain check data,
Data can be obtained, such as: obtain data by sql script inquiry database table by multiple channel,
Or obtain host processes information by shell script, or read the running log file of other program
Obtaining data etc., generate and check that data export xml formatted file day, each checks that the data of content are used
In step 2, the ID of configuration identifies original position.
Step 4, Automatic dispatching background program, resolve xml document, according to excel template with need automatically
The day inserted checks the starting position of data, automatically generates the destination file of checking day of excel form, will
The data parsed in xml document are filled up to check day in the correspondence position of destination file.
Step 5, checks that file is sent to the postal configured with attachment version automatically by the day of excel form
Part address.
In the present embodiment, described step 1 configures the excel template that automatization checks day, an excel
The configurable displaying of worksheet is multinomial checks content；Described step 2 configures each check content needs from
The dynamic starting position inserting data, including worksheet names, line number, columns；In described step 3, from
Dynamic scheduling background program, hardware index and operational indicator data to system obtain, and generate and check day
Data are to xml formatted file；In described step 4, also include xml document analysis program, according to excel
Template and the starting position checking data the day that need to be automatically filled in, resolve xml document, generates excel lattice
The day of formula checks several file；In described step 5, receive E-mail address and the mail mark checking result day
The configuration of topic, Mail Contents, sends Email automatically.
The foregoing is only presently preferred embodiments of the present invention, not in order to limit the present invention, all in the present invention
Spirit and principle within, any modification, equivalent substitution and improvement etc. made, should be included in this
Within bright protection domain.
Claims (10)
1. the method that an automatization checks day, it is characterised in that comprise the following steps:
Step 1: log in main frame, obtains achievement data；
Step 2: automatically carry out checking day to main frame and system according to achievement data, generates and checks result literary composition
Part；
Step 3: will check that destination file sends according to pre-setting.
The method that a kind of automatization the most according to claim 1 checks day, it is characterised in that described
Step 2 generates according to the template style arranged and checks destination file.
The method that a kind of automatization the most according to claim 1 and 2 checks day, it is characterised in that
Described step 1 specifically includes following steps:
Step 1.1: log in main frame, configuration automatization checks template day；
Step 1.2: the beginning checking that the day automatically write in template checks data day is set according to data base
Position.
The method that a kind of automatization the most according to claim 3 checks day, it is characterised in that described
Step 2 specifically includes following steps:
Step 2.1: automatically carry out checking day to main frame and system, generates checking day of XML format file
Data；
Step 2.2: day check data according to checking that template and starting position resolve day, automatically generate coupling
That checks template day checks destination file.
The method that a kind of automatization the most according to claim 1 checks day, it is characterised in that described
Step 3 is specially and will check that destination file is sent in the feedback mailbox pre-set with attachment version.
The method that a kind of automatization the most according to claim 4 checks day, it is characterised in that described
During checking in step 2, as found there are abnormal index data, to abnormal index data in main frame and system
Corresponding checks that destination file is identified.
7. the system that an automatization checks day, it is characterised in that include data acquisition module, check mould
Block and sending module；
Described data acquisition module is used for logging in main frame, obtains achievement data；
Described check module for automatically carrying out checking day to main frame and system according to achievement data, generation is checked
Core destination file；
Described sending module is for according to pre-setting and will check that destination file sends.
The system that a kind of automatization the most according to claim 7 checks day, it is characterised in that described
Check module generates according to the template style arranged and check destination file.
The system that a kind of automatization the most according to claim 7 checks day, it is characterised in that described
Data acquisition module includes login module and configuration module；
Described login module is used for logging in main frame, and configuration automatization checks template day；
For arranging according to data base, described configuration module checks that the day automatically write in template checks number day
According to starting position.
10. the system checked day according to a kind of automatization described in any one of claim 7-9, it is special
Levy and be, described sending module will check that destination file is sent to the feedback pre-set with attachment version
In mailbox.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610230638.3A CN105931016A (en) | 2016-04-14 | 2016-04-14 | Automatic daily audit method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610230638.3A CN105931016A (en) | 2016-04-14 | 2016-04-14 | Automatic daily audit method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105931016A true CN105931016A (en) | 2016-09-07 |
Family
ID=56838166
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610230638.3A Pending CN105931016A (en) | 2016-04-14 | 2016-04-14 | Automatic daily audit method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105931016A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108769103A (en) * | 2018-04-04 | 2018-11-06 | 卓望数码技术（深圳）有限公司 | A kind of control method and system for checking result displaying based on communication service data |
| CN109828884A (en) * | 2018-12-14 | 2019-05-31 | 深圳壹账通智能科技有限公司 | Carry additionally service data processing method, system, computer equipment and storage medium |
| CN111416740A (en) * | 2020-03-16 | 2020-07-14 | 北京思特奇信息技术股份有限公司 | Auditing method, auditing system and electronic equipment |
| CN111639478A (en) * | 2020-06-05 | 2020-09-08 | 远光软件股份有限公司 | Automatic data auditing method and system based on EXCEL document |
| CN112508526A (en) * | 2020-12-15 | 2021-03-16 | 中国联合网络通信集团有限公司 | Data auditing method and device |
| CN112564963A (en) * | 2020-12-01 | 2021-03-26 | 中盈优创资讯科技有限公司 | Device and method for checking abnormal conditions of STN (standard test network) |
| CN113010488A (en) * | 2019-12-19 | 2021-06-22 | 阿里巴巴集团控股有限公司 | Data acquisition method, device, equipment and storage medium |
| CN114418675A (en) * | 2021-12-30 | 2022-04-29 | 中国电信股份有限公司 | Audit point configuration method and system |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473643A (en) * | 2013-09-10 | 2013-12-25 | 北京思特奇信息技术股份有限公司 | Product management data auditing method and system for BOSS system |
-
2016
- 2016-04-14 CN CN201610230638.3A patent/CN105931016A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473643A (en) * | 2013-09-10 | 2013-12-25 | 北京思特奇信息技术股份有限公司 | Product management data auditing method and system for BOSS system |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108769103A (en) * | 2018-04-04 | 2018-11-06 | 卓望数码技术（深圳）有限公司 | A kind of control method and system for checking result displaying based on communication service data |
| CN109828884A (en) * | 2018-12-14 | 2019-05-31 | 深圳壹账通智能科技有限公司 | Carry additionally service data processing method, system, computer equipment and storage medium |
| CN113010488A (en) * | 2019-12-19 | 2021-06-22 | 阿里巴巴集团控股有限公司 | Data acquisition method, device, equipment and storage medium |
| CN113010488B (en) * | 2019-12-19 | 2024-05-28 | 阿里巴巴集团控股有限公司 | Data acquisition method, device, equipment and storage medium |
| CN111416740A (en) * | 2020-03-16 | 2020-07-14 | 北京思特奇信息技术股份有限公司 | Auditing method, auditing system and electronic equipment |
| CN111416740B (en) * | 2020-03-16 | 2022-03-25 | 北京思特奇信息技术股份有限公司 | Auditing method, auditing system and electronic equipment |
| CN111639478A (en) * | 2020-06-05 | 2020-09-08 | 远光软件股份有限公司 | Automatic data auditing method and system based on EXCEL document |
| CN111639478B (en) * | 2020-06-05 | 2023-09-29 | 远光软件股份有限公司 | Automatic data auditing method and system based on EXCEL document |
| CN112564963A (en) * | 2020-12-01 | 2021-03-26 | 中盈优创资讯科技有限公司 | Device and method for checking abnormal conditions of STN (standard test network) |
| CN112564963B (en) * | 2020-12-01 | 2023-02-10 | 中盈优创资讯科技有限公司 | Device and method for checking abnormal conditions of STN (standard test network) |
| CN112508526B (en) * | 2020-12-15 | 2024-04-19 | 中国联合网络通信集团有限公司 | Data auditing method and device |
| CN112508526A (en) * | 2020-12-15 | 2021-03-16 | 中国联合网络通信集团有限公司 | Data auditing method and device |
| CN114418675A (en) * | 2021-12-30 | 2022-04-29 | 中国电信股份有限公司 | Audit point configuration method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105931016A (en) | Automatic daily audit method and system | |
| CN107678736A (en) | A kind of business Page Template shows method, system and computer installation | |
| CN107807954B (en) | Visual modeling multidimensional analysis system and method thereof | |
| US20130124312A1 (en) | System and Method for Management and Delivery of Content and Rules | |
| CN101452450A (en) | Multiple source data conversion service method and apparatus thereof | |
| CN103593456B (en) | Worksheet self-defining method for designing and device | |
| CN101989256A (en) | Typesetting method of document file and device | |
| CN104123399A (en) | Cross-platform question bank resource structuring method | |
| CN105608066A (en) | Method and device for generating evidence report | |
| US6782400B2 (en) | Method and system for transferring data between server systems | |
| CN103309907A (en) | Method and system for standardized processing of service data from different sources | |
| CN103279454A (en) | Document automatic generation method, device and system | |
| CN105468571B (en) | It is a kind of for automatically generating the method and device of report | |
| CN106547729A (en) | A kind of dynamic creation method and system of data sheet | |
| CN102830947A (en) | Report printing control implemented based on report printing template format | |
| CN106354857A (en) | News tag management system | |
| CN110321539A (en) | A kind of special equipment supervising platform report tool | |
| CN106777106A (en) | The method for exhibiting data of the financial statement based on excel | |
| CN112380823A (en) | System and method for compiling flight manual of civil aircraft | |
| CN109783784B (en) | Data processing method based on minimum form combination and form generator | |
| CN110889261A (en) | Method for automating electronic official document service processing | |
| WO2024131444A1 (en) | Method for ensuring uniform style of website system, and tool | |
| CN102043769A (en) | Method and device for editing documents | |
| CN103034990B (en) | The method and apparatus of publication verification | |
| CN117540723A (en) | Intelligent contract document comparison system and intelligent contract document comparison method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160907 |
|
| RJ01 | Rejection of invention patent application after publication |