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

Abstract

The present invention discloses a method, system, electronic device and medium for obtaining the office location of a computer. The method obtains the initial office location of the computer from multiple systems respectively; the initial office location includes at least one of an office city and a specific address in the office city; it is determined whether the acquisition timestamps corresponding to all the initial office locations are the same, if so, the initial office location with the specific address in the office city is selected from all the initial office locations as the actual office location of the computer, if not, the initial office location corresponding to the latest acquisition timestamp is selected as the actual office location of the computer. The present invention improves the accuracy of obtaining the office location of the computer, and further provides accurate basic data of the online location of the PC for enterprises when they centrally deploy software or push patch packages to office PCs in various places.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a method, system, electronic equipment and medium for acquiring a computer office location. Background Art

[0002] The offices, office PCs (computers), and employees of large-scale centralized office enterprises are distributed all over the world. When enterprises centrally deploy software or push patch packages to office PCs in various locations, local engineers usually deploy local PCs. Therefore, a basic data that can distinguish the online location of PCs is required as the basis for the deployment denominator. Enterprises usually use asset management systems to determine the location of equipment, but this method has the problem of inaccurate data acquisition due to the low timeliness of asset management system maintenance, reliance on inventory cycles, and pure manual input. For example, when PCs change with the flow of employees, such as business trips or job transfers, the office location also changes, but the asset management system cannot obtain the changed data. Summary of the invention

[0003] The technical problem to be solved by the present invention is to overcome the defect of inaccurate acquisition of computer office location in the prior art, and to provide a method, system, electronic device and medium for acquiring computer office location.

[0004] The present invention solves the above technical problems through the following technical solutions:

[0005] The present invention provides a method for obtaining a computer office location, the method comprising:

[0006] Obtaining the initial office location of the computer from the plurality of systems respectively; the initial office location includes at least one of an office city and a specific address within the office city;

[0007] Determine whether the acquisition timestamps corresponding to all the initial office locations are the same. If so, select the initial office location with a specific address within the office city from all the initial office locations as the actual office location of the computer. If not, select the initial office location corresponding to the latest acquisition timestamp as the actual office location of the computer.

[0008] Preferably, the step of respectively obtaining the initial office locations of the computers from the multiple systems comprises:

[0009] Obtain system basic data and log data from multiple systems respectively;

[0010] Acquire a MAC address of a computer based on the basic data and the log data;

[0011] If the computer is connected to the enterprise network in a wired manner, obtaining online port data of the corresponding switch according to the MAC address of the computer and obtaining switch information based on the online port data; the switch information includes office location information of the switch;

[0012] If the computer accesses the enterprise network wirelessly, the corresponding wireless router information is obtained according to the MAC address of the computer; the wireless router information includes the office location information of the wireless router;

[0013] The initial office location of the computer is determined according to the office location information of the switch or the office location information of the wireless router.

[0014] Preferably, the step of respectively obtaining the initial office locations of the computers from the multiple systems further comprises:

[0015] If the computer is independently connected to the enterprise network via VPN, the VPN log is obtained;

[0016] Obtaining corresponding execution employee information according to the VPN log;

[0017] The initial office location of the computer is determined according to the information of the office location of the employee in the executing employee information.

[0018] Preferably, the acquisition method further comprises:

[0019] Before the step of obtaining the initial office locations of the computers from the plurality of systems respectively, the office locations of the computers are pre-defined in the form of codes for the cities and office locations;

[0020] And / or, the step of obtaining the initial office locations of the computers from the multiple systems is performed periodically at preset time intervals.

[0021] The present invention also provides a system for obtaining a computer office location, the system comprising:

[0022] An acquisition module, used to acquire the initial office location of the computer from multiple systems respectively; the initial office location includes at least one of an office city and a specific address in the office city;

[0023] A judgment module, used to judge whether the acquisition timestamps corresponding to all the initial office locations are the same, and if so, call the first selection module, and if not, call the second selection module;

[0024] A first selection module is used to select the initial office location with a specific address in the office city from all the initial office locations as the actual office location of the computer;

[0025] The second selection module is used to select the initial office location corresponding to the latest acquisition timestamp as the actual office location of the computer.

[0026] Preferably, the acquisition module includes:

[0027] A first acquisition unit is used to respectively acquire system basic data and log data from multiple systems;

[0028] The second acquisition unit is used to acquire the MAC address of the computer based on the basic data and the log data.

[0029] A third acquisition unit is used to match the online port data of the corresponding switch and acquire the switch information according to the MAC address of the computer if the computer is connected to the enterprise network in a wired manner; the switch information includes the office location information of the switch;

[0030] If the computer accesses the enterprise network wirelessly, the corresponding wireless router information is obtained according to the MAC address of the computer; the wireless router information includes the office location information of the wireless router;

[0031] A first determining unit, configured to determine 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;

[0032] Preferably, the acquisition module further includes:

[0033] a fourth acquisition unit, configured to acquire a VPN log if the computer independently accesses the enterprise network via a VPN;

[0034] A fifth acquisition unit, configured to acquire corresponding execution employee information according to the VPN log;

[0035] The second determining unit is used to determine the initial office location of the computer according to the office location of the executing employee.

[0036] Preferably, the acquisition system further includes:

[0037] A definition module, used to pre-define the city and office location of the computer office location in the form of coding;

[0038] and / or,

[0039] The acquisition module is further used to periodically acquire the initial office locations of the computers from the multiple systems at preset time intervals.

[0040] The present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the aforementioned method for obtaining the office location of a computer when executing the computer program.

[0041] The present invention also provides a computer-readable storage medium having a computer program stored thereon, and when the computer program is executed by a processor, the computer office location acquisition method as described above is implemented.

[0042] The positive and progressive effects of the present invention are:

[0043] The present invention discloses a method, system, electronic device and medium for acquiring computer office locations. The acquisition method acquires the initial office locations of computers from multiple systems respectively, analyzes and compares the initial office locations of all computers according to the acquisition timestamp and whether the computer office point is a specific location in a city, determines the computer office location, and periodically acquires the computer office location at preset time intervals, thereby improving the accuracy of acquiring the computer office location, and further providing accurate basic data of PC online locations for enterprises when they centrally deploy software or push patch packages to office PCs in various locations. BRIEF DESCRIPTION OF THE DRAWINGS

[0044] Figure 1 This is a flowchart of a method for obtaining a computer office location according to Embodiment 1 of the present invention;

[0045] Figure 2 This is a first flow chart of step S103 in Embodiment 1 of the present invention;

[0046] Figure 3 is a second flow chart of step S103 in embodiment 1 of the present invention;

[0047] Figure 4 is a third flow chart of step S103 in embodiment 1 of the present invention;

[0048] Figure 5 This is a flow chart of a method for obtaining a computer office location according to Embodiment 2 of the present invention;

[0049] Figure 6 This is a module diagram of a system for acquiring a computer office location according to Embodiment 3 of the present invention;

[0050] Figure 7 This is a schematic diagram of the first module of the acquisition module in Embodiment 3 of the present invention;

[0051] Figure 8 This is a schematic diagram of the second module of the acquisition module in Embodiment 3 of the present invention;

[0052] Fig. 9This is a module diagram of a system for acquiring a computer office location according to Embodiment 4 of the present invention;

[0053] Fig.10 This is a schematic diagram of the structure of an electronic device according to Embodiment 5 of the present invention. DETAILED DESCRIPTION

[0054] The present invention is further described below by way of examples, but the present invention is not limited to the scope of the examples.

[0055] Example 1

[0056] like Figure 1 As shown, this embodiment discloses a method for obtaining a computer office location, and the method includes:

[0057] Step S101, obtaining the initial office location of the computer from multiple systems respectively; the initial office location includes at least one of an office city and a specific address in the office city;

[0058] Step S102: determine whether the acquisition timestamps corresponding to all the initial office locations are the same, if so, execute step S103; if not, execute step S104;

[0059] Step S103, selecting the initial office location with a specific address in the office city from all the initial office locations as the actual office location of the computer;

[0060] Step S104: Select the initial office location corresponding to the latest acquired timestamp as the actual office location of the computer.

[0061] like Figure 2 As shown, in an practicable manner, if the computer is connected to the enterprise network by wired means, for example, the switch information of each office point is maintained by a proprietary system with respect to its city and office location, step S103 includes the following steps:

[0062] Step S1031, respectively obtain the basic data and log data of the system from multiple systems; specifically, the basic data and log data include computer name: PcName, computer IP: IpAddress, computer MAC: MacAddress. The multiple systems can be desktop management software, network access system, enterprise internal instant messaging tool, network IP allocation service and other systems. The basic data and log data in this embodiment are not limited to the above four types of data listed, and the multiple systems are not limited to the above four systems. Other types of systems can be selected according to actual needs and the data actually needed can be obtained from the selected system. Among them, the city data can also be directly obtained from some systems.

[0063] Step S1032: acquiring a MAC address of a computer based on the basic data and the log data;

[0064] Step S1033, according to the computer MAC address, obtaining the online port data of the corresponding switch and obtaining the switch information based on the online port data; the switch information includes the office location information of the switch;

[0065] Step S1034: Determine the initial office location according to the office location information of the switch.

[0066] like Figure 3 As shown, in another practicable manner, if the computer accesses the enterprise network wirelessly, for example, via wifi (wireless communication technology), step S103 includes the following steps:

[0067] Step S1061, respectively obtain the basic data and log data of the system from multiple systems; specifically, the basic data and log data include computer name: PcName, computer IP: IpAddress, computer MAC: MacAddress. The multiple systems can be desktop management software, network access system, enterprise internal instant messaging tool, network IP allocation service and other systems. The basic data and log data in this embodiment are not limited to the above four types of data listed, and the multiple systems are not limited to the above four systems. Other types of systems can be selected according to actual needs and the data actually needed can be obtained from the selected system. Among them, the city data can also be directly obtained from some systems.

[0068] Step S1062: acquiring a MAC address of a computer based on the basic data and the log data;

[0069] Step S1063, obtaining corresponding wireless router information according to the computer MAC address; the wireless router information includes the office location information of the wireless router;

[0070] Step S1064: Determine the initial office location according to the office location information of the wireless router.

[0071] like Figure 4 As shown, in another practicable manner, if the computer independently accesses the enterprise network through a VPN, step S103 includes the following steps:

[0072] Step S1071, obtaining VPN logs;

[0073] Step S1072: Obtain corresponding execution employee information according to the VPN log;

[0074] Step S1073: Determine the initial office location of the computer according to the information of the office location of the employee in the executing employee information.

[0075] In this embodiment, the computer office location obtained by connecting the computer to the enterprise network by wire or wirelessly is called an independent networking office point; the computer office location obtained by independently connecting the computer to the enterprise network through VPN is called a non-independent networking office point.

[0076] In this embodiment, after executing step S104, step S101 may be periodically executed at intervals of a preset time period. Specifically, the initial office locations of the computer may be obtained from multiple systems at intervals of 3 hours, and then the actual office locations of the computer may be obtained. Since the online computer data obtained each time is not the full amount of computer data, and the online city information of the computer may not be obtained every time, the actual office locations of the computer obtained each time may be separately saved in a data table, so that the data in the data table may be updated every period.

[0077] Because when employees are on business trips, the computer office location may be transferred from a non-independent network office location to an independent network office location. In order to display data more comprehensively, the data table can display both independent network and non-independent network office locations. For example, as shown in Table 1, the data table records the PC name, the online city of the PC non-independent network and independent network, the online office location of the PC non-independent network and independent network, the online office time of the PC non-independent network and independent network, the PC online city, the PC online office location, and the data refresh time. Among them, the PC online city and the PC online office location are the latest computer office locations.

[0078] In a specific embodiment, for example, an employee is on a business trip and his computer is changed from a non-independent networked office location to an independent networked office location. The data table is shown in Table 1.

[0079] Table 1

[0080]

[0081]

[0082] The present embodiment discloses a method for acquiring the office location of a computer. The method acquires the initial office locations of the computers from multiple systems respectively, analyzes and compares the initial office locations of all computers according to the acquisition timestamp and whether the computer office point is a specific location in the city, determines the actual office location of the computer, and periodically acquires the computer office location at preset time intervals, thereby improving the accuracy of acquiring the computer office location, and further providing accurate basic data of PC online locations for enterprises when centrally deploying software or pushing patch packages to office PCs in various locations.

[0083] Example 2

[0084] like Figure 5 As shown, this embodiment is a further improvement on the method for obtaining the computer office location based on the embodiment 1, and the obtaining method specifically includes:

[0085] In this embodiment, steps S202 to S205 are the same as steps S101 to S104 in Embodiment 1, and are not described in detail here.

[0086] Step S201: pre-define the city and office location of the computer office location in the form of coding.

[0087] Specifically, a set of uniquely identifiable location codes is designed based on the naming of office locations around the world, and the Chinese and English names are configured, and the countries and cities to which these locations belong are configured. The names of the countries and cities, whether in Chinese or English, are fixed and will not be ambiguous. In a specific embodiment, for example, Table 2 shows the city codes, the code of the city "Shanghai" in Table 2 is "Shanghai", the code of the city "Edinburgh" is "Edinburgh", and the code of the office point "Shanghai-SOHO Building" in Table 3 is "SHALK", and the code of the office point "Edinburgh, UK" is "EDIFB".

[0088] Table 2 City codes

[0089] site_code name_zh name_en Shanghai Shanghai Shanghai Edinburgh Edinburgh Edinburgh

[0090] Table 3 Office point codes

[0091]

[0092] This embodiment discloses a method for obtaining a computer's office location. The method predefines the computer's office location in the form of coding for cities and office locations before respectively obtaining the computer's initial office location from multiple systems, thereby making the naming of office locations around the world consistent, so that systems using computer office location data can read and identify based on the coding, thereby providing accurate basic data on PC online locations for enterprises when centrally deploying software or pushing patch packages to office PCs in various locations.

[0093] Example 3

[0094] like Figure 6 As shown, this embodiment discloses a system for obtaining a computer office location, and the system includes:

[0095] An acquisition module 1 is used to acquire the initial office location of the computer from multiple systems respectively; the initial office location includes at least one of an office city and a specific address in the office city;

[0096] A judgment module 2 is used to judge whether the acquisition timestamps corresponding to the initial office locations of all the computers are the same, and if so, call the first selection module, and if not, call the second selection module;

[0097] A first selection module 3, used for selecting the initial office location of the computer with a specific address in the office city from the initial office locations of all the computers as the computer office location;

[0098] The second selection module 4 is used to select the initial office location of the computer corresponding to the latest acquisition timestamp as the computer office point.

[0099] like Figure 7 As shown, in one possible implementation, for example, the switch information of each office point is maintained by a proprietary system for its city and office location, and the acquisition module 1 includes:

[0100] The first acquisition unit 11 is used to respectively acquire the basic data and log data of the system from multiple systems; specifically, the basic data and log data include computer name: PcName, computer IP: IpAddress, computer MAC: MacAddress. The multiple systems can be desktop management software, network access system, enterprise internal instant messaging tool, network IP allocation service and other systems. The basic data and log data in this embodiment are not limited to the above four types of data listed, and the multiple systems are not limited to the above four systems. Other types of systems can be selected according to actual needs and the data actually needed can be obtained from the selected system. Among them, the city data can also be directly obtained from some systems.

[0101] A second acquisition unit 12 is used to acquire a MAC address of a computer based on the basic data and the log data;

[0102] The third acquisition unit 13 is used to match the online port data of the corresponding switch and acquire the switch information according to the MAC address of the computer if the computer is connected to the enterprise network by wired mode, for example, the switch information of each office point is maintained by a proprietary system with its city and office location; the switch information includes the office location information of the switch;

[0103] If the computer accesses the enterprise network wirelessly, for example, via wifi, the corresponding wireless router information is obtained according to the MAC address of the computer; the wireless router information includes the office location information of the wireless router;

[0104] The first determining unit 14 is used to determine 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.

[0105] like Figure 8 As shown, if the computer independently accesses the enterprise network through VPN, the acquisition module 1 also includes:

[0106] The fourth acquisition unit 15 is used to acquire VPN logs if the computer independently accesses the enterprise network through VPN;

[0107] A fifth acquisition unit 16, configured to acquire a corresponding execution employee according to the VPN log;

[0108] The second determining unit 17 is configured to determine the initial office location of the computer according to the office location of the executing employee.

[0109] In this embodiment, the computer office location obtained by connecting the computer to the enterprise network by wire or wirelessly is called an independent networking office point; the computer office location obtained by independently connecting the computer to the enterprise network through VPN is called a non-independent networking office point.

[0110] In this embodiment, the acquisition module is periodically called at intervals of a preset time period. Specifically, the initial office location of the computer can be acquired from multiple systems at intervals of 3 hours, and then the actual office location of the computer can be acquired. Since 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 every time, the actual office location of the computer acquired each time can be saved separately in a data table, so that the data in the data table can be updated every period.

[0111] Because when employees are on business trips, the computer office location may be transferred from a non-independent network office location to an independent network office location. In order to display data more comprehensively, the data table can display both independent network and non-independent network office locations. For example, as shown in Table 1, the data table records the PC name, the online city of the PC non-independent network and independent network, the online office location of the PC non-independent network and independent network, the online office time of the PC non-independent network and independent network, the PC online city, the PC online office location, and the data refresh time. Among them, the PC online city and the PC online office location are the latest computer office locations.

[0112] In a specific embodiment, for example, an employee is on a business trip and his computer is changed from a non-independent networked office location to an independent networked office location. The data table is shown in Table 1.

[0113] Table 1

[0114]

[0115]

[0116] The present embodiment discloses a system for acquiring the office location of a computer. The acquisition system acquires the initial office locations of computers from multiple systems respectively, analyzes and compares the initial office locations of all computers according to the acquisition timestamp and whether the computer office point is a specific location in a city, determines the actual office location of the computer, and periodically acquires the computer office location at preset time intervals, thereby improving the accuracy of acquiring the computer office location, and further providing accurate basic data of PC online locations for enterprises when centrally deploying software or pushing patch packages to office PCs in various locations.

[0117] Example 4

[0118] like Fig. 9 As shown, this embodiment is a further improvement on the computer office location acquisition system based on the embodiment 3.

[0119] In addition to the acquisition module 1, the judgment module 2, the first selection module 3 and the second selection module 4 in the embodiment 1, it also includes a definition module 5.

[0120] A definition module 5 is used to pre-define the computer office location in the form of coding for the city and office location;

[0121] Specifically, a set of uniquely identifiable location codes is designed based on the naming of office locations around the world, and the Chinese and English names are configured, and the countries and cities to which these locations belong are configured. The names of the countries and cities, whether in Chinese or English, are fixed and will not be ambiguous. In a specific embodiment, for example, Table 2 shows the city codes, the code of the city "Shanghai" in Table 2 is "Shanghai", the code of the city "Edinburgh" is "Edinburgh", and the code of the office point "Shanghai-SOHO Building" in Table 3 is "SHALK", and the code of the office point "Edinburgh, UK" is "EDIFB".

[0122] Table 2 City codes

[0123] site_code name_zh name_en Shanghai Shanghai Shanghai Edinburgh Edinburgh Edinburgh

[0124] Table 3 Office point codes

[0125]

[0126] This embodiment discloses a method for obtaining a computer's office location. The method predefines the computer's office location in the form of coding for cities and office locations before respectively obtaining the computer's initial office location from multiple systems, thereby making the naming of office locations around the world consistent, so that systems using computer office location data can read and identify based on the coding, thereby providing accurate basic data on PC online locations for enterprises when centrally deploying software or pushing patch packages to office PCs in various locations.

[0127] Example 5

[0128] Fig.10 This is a schematic diagram of the structure of an electronic device provided in Example 5 of the present invention. The electronic device includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processor implements the method for obtaining the computer office location provided in Example 1 or Example 2 when executing the program. Fig.10 The electronic device 40 shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

[0129] like Fig.10 As shown, the electronic device 40 may be in the form of a general-purpose computing device, for example, it may be a server device. The components of the electronic device 40 may include, but are not limited to: at least one processor 41, at least one memory 42, and a bus 43 connecting different system components (including the memory 42 and the processor 41).

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

[0131] The memory 42 may include a volatile memory, such as a random access memory (RAM) 421 and / or a cache memory 422 , and may further include a read-only memory (ROM) 423 .

[0132] The 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 may include an implementation of a network environment.

[0133] The processor 41 executes various functional applications and data processing by running the computer programs stored in the memory 42, such as the method for obtaining the computer office location provided in Embodiment 1 or Embodiment 2 of the present invention.

[0134] The electronic device 40 may also communicate with one or more external devices 44 (e.g., keyboards, pointing devices, etc.). Such communication may be performed via an input / output (I / O) interface 45. Furthermore, the model-generated 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 a network adapter 46. As shown, the network adapter 46 communicates with other modules of the model-generated device 40 via a bus 43. It should be understood that, although not shown in the figure, other hardware and / or software modules may be used in conjunction with the model-generated 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.

[0135] It should be noted that although several units / modules or sub-units / modules of the electronic device are mentioned in the above detailed description, this division is merely exemplary and not mandatory. In fact, according to an embodiment of the present invention, the features and functions of two or more units / modules described above can be embodied in one unit / module. Conversely, the features and functions of one unit / module described above can be further divided into multiple units / modules to be embodied.

[0136] Example 6

[0137] This embodiment provides a computer-readable storage medium on which a computer program is stored. When the program is executed by a processor, the method for obtaining the computer office location provided in Embodiment 1 or Embodiment 2 is implemented.

[0138] The readable storage medium may include but is not limited to: a portable disk, a hard disk, a random access memory, a read-only memory, an erasable programmable read-only memory, an optical storage device, a magnetic storage device or any suitable combination of the above.

[0139] In a possible implementation manner, the present invention can also be implemented in the form of a program product, which includes a program code. When the program product is run on a terminal device, the program code is used to enable the terminal device to execute the method for obtaining the computer office location provided in Example 1 or Example 2.

[0140] The program code for executing the present invention may be written in any combination of one or more programming languages, and may be executed entirely on a user device, partially on a user device, as an independent software package, partially on a user device and partially on a remote device, or entirely on a remote device.

[0141] Although the specific embodiments of the present invention are described above, it should be understood by those skilled in the art that this is only for illustration and the protection scope of the present invention is defined by the appended claims. Those skilled in the art may make various changes or modifications to these embodiments without departing from the principles and essence of the present invention, but these changes and modifications all fall within the protection scope of the present invention.

Claims

1. A method for obtaining a computer office location, characterized in that: The acquisition method comprises: Obtaining the initial office location of the computer from the plurality of systems respectively; the initial office location includes at least one of an office city and a specific address within the office city; Determine whether the acquisition timestamps corresponding to all the initial office locations are the same; if so, select the initial office location with a specific address in the office city from all the initial office locations as the actual office location of the computer; if not, select the initial office location corresponding to the latest acquisition timestamp as the actual office location of the computer; The step of obtaining the initial office locations of the computers from the multiple systems respectively specifically includes: Obtain system basic data and log data from multiple systems respectively; Acquire a MAC address of a computer based on the basic data and the log data; If the computer is connected to the enterprise network in a wired manner, obtaining online port data of the corresponding switch according to the MAC address of the computer and obtaining switch information based on the online port data; the switch information includes office location information of the switch; If the computer accesses the enterprise network wirelessly, the corresponding wireless router information is obtained according to the MAC address of the computer; the wireless router information includes the office location information of the wireless router; The initial office location of the computer is determined according to the office location information of the switch or the office location information of the wireless router.

2. A method for obtaining a computer office location, characterized in that: The acquisition method comprises: Obtaining the initial office location of the computer from the plurality of systems respectively; the initial office location includes at least one of an office city and a specific address within the office city; Determine whether the acquisition timestamps corresponding to all the initial office locations are the same; if so, select the initial office location with a specific address in the office city from all the initial office locations as the actual office location of the computer; if not, select the initial office location corresponding to the latest acquisition timestamp as the actual office location of the computer; The step of obtaining the initial office locations of the computers from the plurality of systems respectively further comprises: If the computer is independently connected to the enterprise network via VPN, the VPN log is obtained; Obtaining corresponding execution employee information according to the VPN log; The initial office location of the computer is determined according to the information of the office location of the employee in the executing employee information.

3. The method for obtaining the computer office location according to claim 1 or 2, characterized in that: The acquisition method further includes: Before the step of obtaining the initial office locations of the computers from the plurality of systems respectively, the office locations of the computers are pre-defined in the form of codes for the cities and office locations; And / or, the step of obtaining the initial office locations of the computers from the multiple systems is performed periodically at preset time intervals.

4. A system for obtaining a computer office location, characterized in that: The acquisition system comprises: An acquisition module, the acquisition module comprising: a first acquisition unit, a second acquisition unit, a third acquisition unit, a third acquisition unit and a first determination unit; The first acquisition unit is used to respectively acquire system basic data and log data from multiple systems; The second acquisition unit is used to acquire the MAC address of the computer based on the basic data and the log data; The third acquisition unit is used to match the online port data of the corresponding switch and acquire the switch information according to the MAC address of the computer if the computer is connected to the enterprise network in a wired manner; the switch information includes the office location information of the switch; If the computer accesses the enterprise network wirelessly, the corresponding wireless router information is obtained according to the MAC address of the computer; the wireless router information includes the office location information of the wireless router; The first determining unit is used to determine 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; the initial office location includes at least one of an office city and a specific address in the office city; A judgment module, used to judge whether the acquisition timestamps corresponding to all the initial office locations are the same, and if so, call the first selection module, and if not, call the second selection module; A first selection module is used to select the initial office location with a specific address in the office city from all the initial office locations as the actual office location of the computer; The second selection module is used to select the initial office location corresponding to the latest acquisition timestamp as the actual office location of the computer.

5. A system for obtaining a computer office location, characterized in that: The acquisition system comprises: An acquisition module, the acquisition module comprising: a fourth acquisition unit, a fifth acquisition unit and a second determination unit; The fourth acquisition unit is used to acquire VPN logs if the computer independently accesses the enterprise network through VPN; The fifth acquisition unit is used to acquire corresponding execution employee information according to the VPN log; The second determining unit is used to determine the initial office location of the computer according to the office location of the executing employee; Used to obtain the initial office location of the computer from multiple systems respectively; the initial office location includes at least one of an office city and a specific address in the office city; A judgment module, used to judge whether the acquisition timestamps corresponding to all the initial office locations are the same, and if so, call the first selection module, and if not, call the second selection module; A first selection module is used to select the initial office location with a specific address in the office city from all the initial office locations as the actual office location of the computer; The second selection module is used to select the initial office location corresponding to the latest acquisition timestamp as the actual office location of the computer.

6. The computer office location acquisition system according to claim 4 or 5, characterized in that: The acquisition system further comprises: A definition module, used to pre-define the city and office location of the computer office location in the form of coding; and / or, The acquisition module is further used to periodically acquire the initial office locations of the computers from the multiple systems at preset time intervals.

7. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the method for obtaining the computer office location according to any one of claims 1 to 3 is implemented.

8. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the method for obtaining a computer office location as claimed in any one of claims 1 to 3 is implemented.

Images