CN113837719A

CN113837719A - Method, system, electronic device and medium for acquiring computer office location

Info

Publication number: CN113837719A
Application number: CN202111079815.XA
Authority: CN
Inventors: 张晓晨
Original assignee: Ctrip Travel Network Technology Shanghai Co Ltd
Current assignee: Ctrip Travel Network Technology Shanghai Co Ltd
Priority date: 2021-09-15
Filing date: 2021-09-15
Publication date: 2021-12-24

Abstract

The invention discloses a method, a system, electronic equipment and a medium for acquiring computer office locations, wherein the method comprises the steps of respectively acquiring initial office locations of computers from a plurality of systems; the initial office location comprises at least one of an office city and a specific address within the office city; and judging whether the acquisition timestamps corresponding to all the initial office places are the same, if so, selecting the initial office place with a specific address in the office city from all the initial office places as the actual office place of the computer, and if not, selecting the initial office place corresponding to the latest acquisition timestamp as the actual office place of the computer. The invention improves the accuracy of acquiring the office location of the computer, and further provides accurate basic data of the PC online location when enterprises carry out centralized deployment of software or pushing of patch packages to office PCs of various locations.

Description

Method, system, electronic device and medium for acquiring computer office location

Technical Field

The present invention relates to the field of computer technologies, and in particular, to a method, a system, an electronic device, and a medium for acquiring a computer office location.

Background

Office sites of large-scale centralized office enterprises, office PCs (computers), and employees are distributed around the world. When an enterprise performs centralized deployment of software or pushes patch packages to office PCs in various places, local engineers generally deploy local PCs, and therefore basic data capable of distinguishing online places of the PCs is needed to serve as a basis for deploying denominators. An enterprise usually judges the attribution of equipment through an asset management system, but in the method, due to the fact that the timeliness of maintenance of the asset management system is not high, the inventory period is relied on, and the equipment is input purely manually, so that the problem that data is not obtained accurately exists.

Disclosure of Invention

The invention aims to overcome the defect that the computer office location is not accurately acquired in the prior art, and provides a method, a system, electronic equipment and a medium for acquiring the computer office location.

The invention solves the technical problems through the following technical scheme:

the invention provides a method for acquiring a computer office place, which comprises the following steps:

respectively acquiring initial office locations of computers from a plurality of systems; the initial office location comprises at least one of an office city and a specific address within the office city;

and judging whether the acquisition timestamps corresponding to all the initial office places are the same, if so, selecting the initial office place with a specific address in the office city from all the initial office places as the actual office place of the computer, and if not, selecting the initial office place corresponding to the latest acquisition timestamp as the actual office place of the computer.

Preferably, the step of acquiring initial office locations of the computers from the plurality of systems respectively comprises:

respectively acquiring basic data and log data of a system from a plurality of systems;

acquiring the MAC address of the computer based on the basic data and the log data;

if the computer is accessed to an enterprise network in a wired mode, acquiring online port data of a corresponding switch according to the MAC address of the computer, and acquiring switch information based on the online port data to acquire the switch information; the switch information comprises office location information of the switch;

if the computer is accessed to an enterprise network in a wireless mode, acquiring corresponding wireless router information according to the MAC address of the computer; the wireless router information comprises office location information of the wireless router;

and determining the initial office location of the computer according to the office location information of the switch or the office location information of the wireless router.

Preferably, the step of acquiring initial office locations of the computers from the plurality of systems respectively further comprises:

if the computer is independently accessed to an enterprise network in a VPN mode, acquiring a VPN log;

acquiring corresponding executive employee information according to the VPN log;

and determining the initial office location of the computer according to the information of the office location to which the employee belongs in the executive employee information.

Preferably, the acquiring method further includes:

before the step of respectively acquiring initial office locations of computers from a plurality of systems, defining cities and office locations of the computers in a coded form in advance;

and/or, periodically executing the step of acquiring the initial office locations of the computers from the plurality of systems, respectively, at intervals of a preset time period.

The present invention also provides an acquisition system of a computer office site, the acquisition system comprising:

the acquisition module is used for respectively acquiring initial office places of the computers from the systems; the initial office location comprises at least one of an office city and a specific address in the office city;

the judging module is used for judging whether the acquisition timestamps corresponding to all the initial office places are the same or not, if so, the first selecting module is called, and if not, the second selecting module is called;

the first selection module is used for selecting the initial office place with a specific address in an office city from all the initial office places as an actual office place of the computer;

and the second selection module is used for selecting the initial office place corresponding to the latest acquisition timestamp as the actual office place of the computer.

Preferably, the obtaining module includes:

the system comprises a first acquisition unit, a second acquisition unit and a third acquisition unit, wherein the first acquisition unit is used for respectively acquiring basic data and log data of a system from a plurality of systems;

and the second acquisition unit is used for acquiring the MAC address of the computer based on the basic data and the log data.

A third obtaining unit, configured to, if the computer is wired and accesses an enterprise network, match online port data of a corresponding switch according to the computer MAC address and obtain switch information; the switch information comprises office location information of the switch;

a first determination unit for determining an initial office location of the computer according to office location information of the switch or wireless router office location information;

preferably, the obtaining module further comprises:

a fourth obtaining unit, configured to obtain a VPN log if the computer independently accesses the enterprise network in a VPN manner;

a fifth obtaining unit, configured to obtain corresponding executive employee information according to the VPN log;

and the second determining unit is used for determining the initial office location of the computer according to the office location to which the executive staff belongs.

Preferably, the acquiring system further comprises:

the definition module is used for defining the city and the office place of the computer in advance in a coding mode;

and/or the presence of a gas in the gas,

the acquisition module is further used for periodically and respectively acquiring initial office places of the computers from the multiple systems at preset time intervals.

The invention also provides an electronic device, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor executes the computer program to realize the method for acquiring the computer office location.

The present invention also provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements the computer office location acquisition method as described above.

The positive progress effects of the invention are as follows:

the invention discloses a method, a system, electronic equipment and a medium for acquiring computer office places, wherein the method comprises the steps of respectively acquiring initial office places of computers from a plurality of systems, analyzing and comparing the initial office places of all the computers according to an acquisition timestamp and whether the computer office places are specific places of a city, determining the computer office places, and periodically acquiring the computer office places at intervals of preset time periods, so that the accuracy of acquiring the computer office places is improved, and accurate basic data of PC online places are provided for enterprises when centralized deployment software or patch packages are pushed to office PCs of various places.

Drawings

Fig. 1 is a flowchart of an acquisition method of a computer office site according to embodiment 1 of the present invention;

fig. 2 is a first flowchart of step S103 in embodiment 1 of the present invention;

fig. 3 is a second flowchart of step S103 in embodiment 1 of the present invention;

fig. 4 is a third flowchart of step S103 in embodiment 1 of the present invention;

fig. 5 is a flowchart of an acquisition method of a computer office site according to embodiment 2 of the present invention;

FIG. 6 is a block diagram of an acquisition system of a computer office site according to embodiment 3 of the present invention;

fig. 7 is a first block diagram of an acquisition block in embodiment 3 of the present invention;

fig. 8 is a second block diagram of an acquisition module in embodiment 3 of the present invention;

FIG. 9 is a block diagram of an acquisition system of a computer office site according to embodiment 4 of the present invention;

fig. 10 is a schematic structural diagram of an electronic device according to embodiment 5 of the present invention.

Detailed Description

The invention is further illustrated by the following examples, which are not intended to limit the scope of the invention.

Example 1

As shown in fig. 1, the present embodiment discloses an acquisition method for a computer office location, the acquisition method including:

step S101, respectively acquiring initial office locations of computers from a plurality of systems; the initial office location comprises at least one of an office city and a specific address within the office city;

step S102, judging whether the acquisition timestamps corresponding to all the initial office places are the same, if so, executing step S103; if not, executing step S104;

step S103, selecting the initial office place with a specific address in the office city from all the initial office places as an actual office place of a computer;

and S104, selecting the initial office point corresponding to the latest acquisition timestamp as the actual office point of the computer.

As shown in fig. 2, in an implementation manner, if the computer is wired to access the enterprise network, for example, the switch information of each office point is maintained by a proprietary system for its city and office location, step S103 includes the following steps:

step S1031, respectively obtaining basic data and log data of the system from the plurality of systems; specifically, the basic data and log data include computer names: PcName, computer IP: IPadress, computer MAC: MacAddress. The multiple systems can be desktop management software, network access systems, instant chat tools in enterprises, network IP distribution services and other systems. The basic data and the log data in the present embodiment are not limited to the above 4 kinds of data listed, and the plurality of systems are not limited to the above 4 kinds of systems listed, and other types of systems may be selected according to the actual use and the actually required data may be obtained from the selected systems. Wherein, the data of the city can be directly acquired from part of the system.

Step S1032, obtaining the MAC address of the computer based on the basic data and the log data;

step S1033, according to the computer MAC address, obtaining online port data of a corresponding switch and obtaining switch information based on the online port data; the switch information comprises office location information of the switch;

and S1034, determining the initial office location according to the office location information of the switch.

As shown in fig. 3, in another implementation manner, if the computer accesses the enterprise network wirelessly, for example, through wifi (wireless communication technology), step S103 includes the following steps:

step S1061, respectively acquiring basic data and log data of the system from a plurality of systems; specifically, the basic data and log data include computer names: PcName, computer IP: IPadress, computer MAC: MacAddress. The multiple systems can be desktop management software, network access systems, instant chat tools in enterprises, network IP distribution services and other systems. The basic data and the log data in the present embodiment are not limited to the above 4 kinds of data listed, and the plurality of systems are not limited to the above 4 kinds of systems listed, and other types of systems may be selected according to the actual use and the actually required data may be obtained from the selected systems. Wherein, the data of the city can be directly acquired from part of the system.

Step S1062, acquiring the MAC address of the computer based on the basic data and the log data;

step S1063, acquiring corresponding wireless router information according to the computer MAC address; the wireless router information comprises office location information of the wireless router;

step S1064, determining the initial office location according to the office location information of the wireless router.

As shown in fig. 4, in another practical implementation manner, if the computer independently accesses the enterprise network by way of VPN, step S103 includes the following steps:

step S1071, obtaining VPN logs;

step S1072, obtaining the corresponding executive staff information according to the VPN log;

and step S1073, determining the initial office location of the computer according to the information of the office location to which the staff belongs in the executive staff information.

In this embodiment, a computer office location obtained by accessing a computer to an enterprise network in a wired manner or in a wireless manner is referred to as an independent networking office location; the computer is independently accessed to the enterprise network in a VPN mode, and the acquired computer office location is called a non-independent networking office location.

In the present embodiment, after step S104 is performed, step S101 may be performed periodically with a preset time period. Specifically, the initial office location of the computer and further the actual office location of the computer may be acquired from the plurality of systems, respectively, at intervals of 3 hours. Because the online computer data acquired each time is not the full amount of computer data and the online city information of the computer cannot be acquired each time, the actual office location of the computer acquired each time can be independently stored in a data table, so that the data in the data table can be updated every other period.

Because there may be a case that the office location of the computer is changed from the non-independent networking office point to the independent networking office point when the employee goes on business, in order to more comprehensively display data, the data table may simultaneously display the office points of the independent networking and the non-independent networking, for example, as shown in table 1, the data table records the Pc name, the Pc non-independent networking and the online city of the independent networking, the Pc non-independent networking and the online office point of the independent networking, the Pc non-independent networking and the online office time of the independent networking, the Pc online city, the Pc online office point, and the data refreshing time. Wherein, the Pc online city and the Pc online office point are the latest acquired computer office locations.

In one embodiment, for example, an employee on business may change their computer from a non-standalone networking office to a standalone networking office, and the data table is shown in Table 1.

TABLE 1

The embodiment discloses an acquisition method of computer office places, which comprises the steps of respectively acquiring initial office places of computers from a plurality of systems, analyzing and comparing the initial office places of all the computers according to an acquisition timestamp and whether the computer office places are specific places of cities, determining the actual office places of the computers, and periodically acquiring the computer office places at intervals of preset time periods, so that the accuracy of acquiring the computer office places is improved, and accurate basic data of PC online places are provided for enterprises when the enterprises intensively deploy software or push patch packages to office PCs of various places.

Example 2

As shown in fig. 5, this embodiment is a further improvement of the method for acquiring a computer office location based on embodiment 1, and the method specifically includes:

steps S202 to S205 in this embodiment are the same as steps S101 to S104 in embodiment 1, and are not described again here.

Step S201, defining the computer office place in advance to a city and an office place in a coding mode.

Specifically, a set of uniquely identifiable location codes is designed according to the names of office locations in various regions of the world, the names of the text and the English are configured, the countries and the cities to which the locations belong are configured, and the names of the countries and the cities are fixed and have no ambiguity. In a specific embodiment, for example, the city code of table 2, the city "Shanghai" of table 2, the city "Edinburgh" of table 2, and the office point "Shanghai-SOHO building" of table 3, are "SHALK" and the office point "british-einburgh" are "EDIFB".

TABLE 2 City code

site_code	name_zh	name_en
			Shanghai	Shanghai province	Shanghai
Edinburgh	Edinburgh	Edinburgh

TABLE 3 office Point code

The embodiment discloses an acquisition method of a computer office place, which is characterized in that a city and an office place are defined in advance in a coding mode before the initial office place of a computer is respectively acquired from a plurality of systems, so that the names of the office places in all parts of the world are consistent, a system using data of the computer office place can read and identify the office places according to the codes, and accurate basic data of the PC online place is provided for enterprises when the enterprises intensively deploy software or push patch packages to office PCs in all parts.

Example 3

As shown in fig. 6, the present embodiment discloses an acquisition system of a computer office site, the acquisition system including:

the system comprises an acquisition module 1, a processing module and a display module, wherein the acquisition module is used for respectively acquiring initial office places of a computer from a plurality of systems; the initial office location comprises at least one of an office city and a specific address in the office city;

the judging module 2 is used for judging whether the acquisition timestamps corresponding to the initial office places of all the computers are the same or not, if so, the first selecting module is called, and if not, the second selecting module is called;

the first selection module 3 is used for selecting the initial office location of the computer with a specific address in an office city from the initial office locations of all the computers as the computer office location;

and the second selection module 4 is used for selecting the initial office point of the computer corresponding to the latest acquisition timestamp as the office point of the computer.

In an implementation, as shown in fig. 7, for example, the switch information of each office is maintained by a proprietary system for its city and office, and the acquiring module 1 includes:

a first acquiring unit 11 configured to acquire basic data and log data of a system from a plurality of systems, respectively; specifically, the basic data and log data include computer names: PcName, computer IP: IPadress, computer MAC: MacAddress. The multiple systems can be desktop management software, network access systems, instant chat tools in enterprises, network IP distribution services and other systems. The basic data and the log data in the present embodiment are not limited to the above 4 kinds of data listed, and the plurality of systems are not limited to the above 4 kinds of systems listed, and other types of systems may be selected according to the actual use and the actually required data may be obtained from the selected systems. Wherein, the data of the city can be directly acquired from part of the system.

A second obtaining unit 12, configured to obtain a MAC address of the computer based on the basic data and the log data;

a third obtaining unit 13, configured to, if the computer is wired to access an enterprise network, for example, switch information of each office point is maintained by a proprietary system in a city and an office, match online port data of a corresponding switch according to the MAC address of the computer, and obtain switch information; the switch information comprises office location information of the switch;

if the computer is accessed to an enterprise network in a wireless mode, for example, the computer is accessed to the enterprise network through wifi, and corresponding wireless router information is obtained according to the MAC address of the computer; the wireless router information comprises office location information of the wireless router;

a first determining unit 14 for determining an initial office location of the computer based on the office location information of the switch or the wireless router office location information.

As shown in fig. 8, if the computer independently accesses the enterprise network by way of VPN, the acquiring module 1 further includes:

a fourth obtaining unit 15, configured to obtain a VPN log if the computer independently accesses the enterprise network in a VPN manner;

a fifth obtaining unit 16, configured to obtain a corresponding executive employee according to the VPN log;

and a second determining unit 17, configured to determine an initial office location of the computer according to an office location to which the executive employee belongs.

In this embodiment, the obtaining module is periodically called at intervals of a preset time period. Specifically, the initial office location of the computer and further the actual office location of the computer may be acquired from the plurality of systems, respectively, at intervals of 3 hours. Because the online computer data acquired each time is not the full amount of computer data and the online city information of the computer cannot be acquired each time, the actual office location of the computer acquired each time can be independently stored in a data table, so that the data in the data table can be updated every other period.

TABLE 1

The embodiment discloses an acquisition system of computer office places, this acquisition system, through respectively obtaining the initial office places of computer from a plurality of systems, according to whether the acquisition timestamp and computer office places are the concrete place in city, carry out analysis comparison to the initial office places of all computers, determine the actual office places of computer, and the interval presets the time quantum, periodically obtain the computer office places, thereby improved the accuracy of obtaining the computer office places, and then when carrying out centralized deployment software or propelling movement patch package to office PCs in various places for the enterprise, provide accurate basic data of PC online place.

Example 4

As shown in FIG. 9, this embodiment is an improvement of embodiment 3 in the acquisition system of the computer office, and the acquisition system

The system comprises an acquisition module 1, a judgment module 2, a first selection module 3 and a second selection module 4 in embodiment 1, and further comprises a definition module 5.

The definition module 5 is used for defining the city and the office place of the computer in advance in a coding mode;

TABLE 2 City code

TABLE 3 office Point code

Example 5

Fig. 10 is a schematic structural diagram of an electronic device according to embodiment 5 of the present invention. The electronic device comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor executes the program to realize the method for acquiring the computer office location provided by the embodiment 1 or the embodiment 2. The electronic device 40 shown in fig. 10 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiment of the present invention.

As shown in fig. 10, the electronic device 40 may be embodied in the form of a general purpose computing device, which may be, for example, a server device. The components of electronic device 40 may include, but are not limited to: the at least one processor 41, the at least one memory 42, and a bus 43 connecting the various system components (including the memory 42 and the processor 41).

The bus 43 includes a data bus, an address bus, and a control bus.

The memory 42 may include volatile memory, such as Random Access Memory (RAM)421 and/or cache memory 422, and may further include Read Only Memory (ROM) 423.

Memory 42 may also include a program/utility 425 having a set (at least one) of program modules 424, such program modules 424 including, but not limited to: an operating system, one or more application programs, other program modules, and program data, each of which, or some combination thereof, may comprise an implementation of a network environment.

The processor 41 executes various functional applications and data processing, such as the acquisition method of a computer office provided in embodiment 1 or embodiment 2 of the present invention, by running the computer program stored in the memory 42.

The electronic device 40 may also communicate with one or more external devices 44 (e.g., keyboard, pointing device, etc.). Such communication may be through an input/output (I/O) interface 45. Also, model-generating device 40 may also communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the Internet) via network adapter 46. As shown, the network adapter 46 communicates with the other modules of the model-generated device 40 over a bus 43. It should be understood that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the model-generating device 40, including but not limited to: microcode, device drivers, redundant processors, external disk drive arrays, RAID (disk array) systems, tape drives, and data backup storage systems, etc.

It should be noted that although in the above detailed description several units/modules or sub-units/modules of the electronic device are mentioned, such a division is merely exemplary and not mandatory. Indeed, the features and functionality of two or more of the units/modules described above may be embodied in one unit/module according to embodiments of the invention. Conversely, the features and functions of one unit/module described above may be further divided into embodiments by a plurality of units/modules.

Example 6

The present embodiment provides a computer-readable storage medium on which a computer program is stored, the program implementing, when executed by a processor, the method for acquiring a computer office space provided in embodiment 1 or embodiment 2.

More specific examples, among others, that the readable storage medium may employ may include, but are not limited to: a portable disk, a hard disk, random access memory, read only memory, erasable programmable read only memory, optical storage device, magnetic storage device, or any suitable combination of the foregoing.

In a possible implementation, the present invention can also be implemented in the form of a program product comprising program code for causing a terminal device to perform an acquisition method of a computer office space that implements the methods provided in embodiments 1 or 2, when the program product is run on the terminal device.

Where program code for carrying out the invention is written in any combination of one or more programming languages, the program code may be executed entirely on the user device, partly on the user device, as a stand-alone software package, partly on the user device and partly on a remote device or entirely on the remote device.

While specific embodiments of the invention have been described above, it will be appreciated by those skilled in the art that this is by way of example only, and that the scope of the invention is defined by the appended claims. Various changes and modifications to these embodiments may be made by those skilled in the art without departing from the spirit and scope of the invention, and these changes and modifications are within the scope of the invention.

Claims

1. A method for obtaining a computer office location, the method comprising:

2. The method for acquiring an office location of a computer according to claim 1, wherein the step of acquiring initial office locations of computers from a plurality of systems, respectively, comprises:

3. The method for acquiring an office location of a computer according to claim 1, wherein the step of acquiring initial office locations of computers from a plurality of systems, respectively, further comprises:

4. The method of acquiring a computer office location of claim 1, further comprising:

5. An acquisition system for a computer office location, the acquisition system comprising:

6. The computer office site acquisition system of claim 5, wherein the acquisition module comprises:

a second obtaining unit configured to obtain an MAC address of the computer based on the basic data and the log data;

a first determination unit for determining an initial office location of the computer according to office location information of the switch or wireless router office location information.

7. The computer office location acquisition system of claim 5, wherein the acquisition module further comprises:

8. The computer office site acquisition system of claim 5, wherein the acquisition system further comprises:

and/or the presence of a gas in the gas,

9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the computer office location acquisition method according to any one of claims 1 to 4 when executing the computer program.

10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, implements the acquisition method of the computer office site according to any one of claims 1 to 4.