IT asset data processing and display method, device and computer equipment

Abstract

The present application relates to a method, device and computer equipment for processing and displaying IT asset data. The method includes: extracting IT asset data from a database using an automated script and performing preprocessing operations to obtain preprocessed data; performing statistical calculations on the preprocessed data according to at least one preset statistical dimension and at least one statistical indicator to obtain at least one set of statistical results; sorting and filtering at least one set of statistical results based on processing rules to obtain processed data; displaying the processed data in the form of a chart through a front-end display layer, and displaying a form interface; wherein the form interface is used for users to customize IT asset query conditions. The use of this method can comprehensively improve the overall efficiency of IT asset data management, analysis and display.

Description

Technical Field

[0001] The present application relates to the field of information technology, and in particular to an IT asset data processing and display method, device and computer equipment. Background Art

[0002] With the rapid development of information technology, data processing and visualization technologies have become increasingly mature and widely used in various industries. In the field of enterprise information technology (IT) asset management, the amount of data has exploded, and a large amount of IT asset data needs to be effectively managed and utilized.

[0003] However, there are many problems with the current traditional IT asset data processing and display methods. First, the manual data extraction method consumes a lot of manpower and time, and the data accuracy is difficult to guarantee. Secondly, the single-dimensional statistical analysis cannot provide a comprehensive and in-depth basis for the enterprise's IT asset management and decision-making, which can easily lead to problems such as unreasonable resource allocation and unscientific equipment maintenance plans. Furthermore, the simple display form is not conducive to the rapid communication and understanding of information, which limits the effective use of IT asset data by enterprises and reduces the efficiency and quality of enterprise IT management. Summary of the invention

[0004] Based on this, it is necessary to provide an IT asset data processing and display method, device and computer equipment to address the above technical issues.

[0005] In a first aspect, the present application provides an IT asset data processing and display method, comprising:

[0006] Use automated scripts to extract IT asset data from the database and perform preprocessing operations to obtain preprocessed data;

[0007] Performing statistical calculations on the preprocessed data according to at least one preset statistical dimension and at least one statistical indicator to obtain at least one set of statistical results;

[0008] Sorting and screening the at least one set of statistical results based on the processing rules to obtain processed data;

[0009] The processed data is displayed in a chart form through the front-end display layer, and a form interface is displayed;

[0010] The form interface is used for users to customize IT asset query conditions.

[0011] In a second aspect, the present application also provides an IT asset data processing and display device, comprising:

[0012] A preprocessing module is used to extract IT asset data from a database using an automated script and perform preprocessing operations to obtain preprocessed data;

[0013] A statistical module, used to perform statistical calculations on the preprocessed data according to at least one preset statistical dimension and at least one statistical indicator to obtain at least one set of statistical results;

[0014] A processing module, used for sorting and screening the at least one set of statistical results based on a processing rule to obtain processed data;

[0015] A display module, used to display the processed data in the form of charts through a front-end display layer and display a form interface;

[0016] The form interface is used for users to customize IT asset query conditions.

[0017] In a third aspect, the present application further provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the method described in the first aspect is implemented.

[0018] In a fourth aspect, the present application further provides a computer-readable storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the method described in the first aspect.

[0019] In a fifth aspect, the present application further provides a computer program product, comprising a computer program, which, when executed by a processor, implements the method described in the first aspect.

[0020] The above-mentioned IT asset data processing and display method, device and computer equipment can use automated scripts to extract IT asset data from a database and perform preprocessing operations to obtain preprocessed data; perform statistical calculations on the preprocessed data according to at least one preset statistical dimension and at least one statistical indicator to obtain at least one set of statistical results; sort and filter the at least one set of statistical results based on processing rules to obtain processed data; display the processed data in the form of a chart through the front-end display layer, and display a form interface; wherein the form interface is used for users to customize IT asset query conditions. By using automated scripts to extract data and perform preprocessing, the efficiency and accuracy of data acquisition are improved, and the errors and time-consuming problems caused by manual operations are reduced. Statistical calculations based on at least one preset statistical dimension and statistical indicator can achieve multi-dimensional and in-depth data analysis and mine more valuable information, such as generating rich and targeted at least one set of statistical results to provide a comprehensive basis for subsequent decision-making. Sorting and filtering statistical results based on processing rules can make data presentation more in line with user needs and actual application scenarios, so that important information can be highlighted. The front-end display layer displays data in the form of charts and provides a form interface with customizable IT asset query conditions. This not only makes data display more intuitive, clear and easy to understand, but also meets the personalized query needs of different users, allowing users to flexibly obtain the required data according to their own focus, thereby comprehensively improving the overall efficiency of IT asset data management, analysis and display. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the related technologies, the drawings required for use in the embodiments or the related technical descriptions are briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0022] Figure 1 A system architecture of an IT asset data processing and display method in one embodiment;

[0023] Figure 2 is a flow chart of an IT asset data processing and display method in an embodiment;

[0024] Figure 3 is a flowchart of another IT asset data processing and display method in one embodiment;

[0025] Figure 4 A schematic diagram of displaying an asset overview in an Excel spreadsheet in one embodiment;

[0026] Figure 5 A schematic diagram showing the distribution of each device category of IT assets in the form of a pie chart in one embodiment;

[0027] Figure 6 A schematic diagram showing statistics of various brands of IT assets in the form of a bar chart in one embodiment;

[0028] Figure 7 A schematic diagram of a form interface in an embodiment of the present application;

[0029] Figure 8 is a structural block diagram of an IT asset data processing and display device in an embodiment;

[0030] Fig. 9 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0031] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0032] like Figure 1 As shown, the embodiment of the present application provides a system architecture of an IT asset data processing and display method. The system architecture may include: a front-end display layer, a back-end service layer, and a database. Among them, the front-end display layer is responsible for interacting with users and displaying statistical charts and forms; the back-end service layer is responsible for data processing and the implementation of business logic; the database layer stores IT asset data.

[0033] In an exemplary embodiment, Figure 2 As shown, a flowchart of an IT asset data processing and display method is provided, which can be implemented by the backend service layer in the above system architecture. In actual application, the backend service layer can be implemented in the server. The method includes the following steps 201 to 204:

[0034] 201. Use automated scripts to extract IT asset data from the database and perform preprocessing operations to obtain preprocessed data.

[0035] The above-mentioned automation script refers to a pre-written program code that can automatically perform specific tasks according to set rules and logic. In this IT asset data processing and display method, the role of the automation script is to extract IT asset data from the database and perform pre-processing operations such as data cleaning and conversion. These repetitive and regular data processing tasks can be completed without manual intervention, thereby improving the efficiency and accuracy of data processing.

[0036] The preprocessing operation includes: data cleaning operation and data conversion operation; performing data cleaning operation on the extracted IT asset data to remove duplicate data and erroneous data in the IT asset data to obtain cleaned data; performing data conversion operation on the cleaned data to obtain preprocessed data formatted into a preset format.

[0037] The above data cleaning operation can process the extracted IT asset data through specific algorithms, with the aim of identifying and removing duplicate data and obvious erroneous data. For example, the same device information may be recorded repeatedly, or some fields may contain obvious errors that do not meet the specifications (such as incorrect date format, values ​​outside the reasonable range, etc.). The data cleaning operation is to eliminate these problems and make the data more accurate and standardized.

[0038] The above data conversion operation is used to format the cleaned data into a format preset by the system. For example, there may be inconsistent date fields in the original data, which can be unified into the format of "YYYY-MM-DD" through data conversion operation, where "YYYY" represents the year, "MM" represents the month, and "DD" represents the specific date.

[0039] In some embodiments, after obtaining IT asset data, during the pre-processing operation, a data cleaning operation is first performed, which can use an algorithm to identify and remove duplicate data and obvious erroneous data in the IT asset data, thereby obtaining cleaned data. Then, a data conversion operation is performed on the cleaned data to format it into a format pre-set by the system, and finally the pre-processed data is obtained.

[0040] In some embodiments, the above-mentioned preprocessing operation may also include an integration operation. Exemplarily, after performing a data conversion operation on the cleaned data to obtain data formatted in a preset format, the integration operation may be performed. For example, if there are different data tables that respectively record related but scattered data such as equipment basic information and equipment maintenance records, the integration operation may merge these data tables according to certain rules.

[0041] The backend service layer can obtain IT asset data from the database by using an automated script as the execution subject. In actual applications, the backend service layer can be implemented by a server.

[0042] 202. Perform statistical calculations on the preprocessed data according to at least one preset statistical dimension and at least one statistical indicator to obtain at least one set of statistical results.

[0043] The above statistical dimensions refer to the different angles or classification standards used when conducting statistical analysis on IT asset data. The equipment category, operating years, brand, supplier, user department, operating status, etc. mentioned in the article are all statistical dimensions. By collecting data from these different dimensions, we can understand the various situations of IT assets in a more comprehensive and multi-faceted way. For example, by counting the number of equipment categories, we can know the distribution of different types of equipment, and by counting the operating years, we can understand the distribution of the newness and oldness of assets.

[0044] The at least one preset statistical dimension may include but is not limited to at least one or two of the following:

[0045] Equipment type, age, brand and supplier.

[0046] The at least one statistical indicator may include but is not limited to: quantity and / or proportion. For example, under the statistical dimension of brand, the number of devices of each brand and the proportion of the number of devices of each brand in the total number of devices are counted.

[0047] 203. Sort and filter at least one set of statistical results based on the processing rules to obtain processed data.

[0048] In some embodiments, at least one set of statistical results is sorted and filtered based on processing rules to obtain filtered data, including: aggregating at least one set of statistical results to obtain aggregated data; sorting and filtering the aggregated data based on processing rules to obtain filtered data.

[0049] In some embodiments, the data aggregation step includes generating a list of brands and suppliers ranked top in number.

[0050] In some embodiments, the processing rule is determined based on the IT asset query condition that was previously customized by the user; or, the processing rule is a default setting.

[0051] In some embodiments, in the process of implementing the above step 203, a data aggregation operation may be performed first, which aggregates at least one set of statistical results according to the processing rules, for example, generating a list of the top 10 brands and suppliers. Then, the aggregated data is sorted and filtered based on the processing rules. The processing rules may be determined based on the IT asset query conditions defined by the user last time, or may be set by the system default. The sorting operation is based on the sorting algorithm, such as sorting brands and suppliers from large to small according to quantity; the filtering operation is based on the set conditions, such as filtering out data with a quantity greater than a certain threshold, and finally obtaining the processed data.

[0052] In some embodiments, during the process of processing the statistical results, multiple groups of statistical results are aggregated according to the processing rules. For example, generating a list of brands and suppliers ranked at the top (such as the top 10) is to aggregate the statistical results related to brands and suppliers according to certain rules, summarize and organize the scattered data, so as to facilitate the subsequent clearer presentation of data highlights and targeted sorting and screening operations.

[0053] 204. The processed data is displayed in a chart form through the front-end display layer, and a form interface is displayed.

[0054] Among them, the form interface is used for users to customize IT asset query conditions.

[0055] In some embodiments, the form interface is used for the user to select a statistical dimension and / or set a time range as a custom IT asset query condition.

[0056] The user can select statistical dimensions and / or set a time range in the above form interface to update the chart display results in real time.

[0057] Exemplarily, the above statistical dimensions may include but are not limited to: equipment category, years of operation, brand, supplier, user department, operating status, etc.

[0058] In some embodiments, the above-mentioned chart display may include display in the form of Excel tables, bar charts, pie charts, etc.

[0059] In some embodiments, the content displayed in the above-mentioned chart display may include: asset overview, results of quantity statistics by equipment category, results of quantity statistics by operating years, etc.

[0060] The above-mentioned IT asset data processing and display method, device and computer equipment can use automated scripts to extract IT asset data from a database and perform preprocessing operations to obtain preprocessed data; perform statistical calculations on the preprocessed data according to at least one preset statistical dimension and at least one statistical indicator to obtain at least one set of statistical results; sort and filter the at least one set of statistical results based on processing rules to obtain processed data; display the processed data in the form of a chart through the front-end display layer, and display a form interface; wherein the form interface is used for users to customize IT asset query conditions. By using automated scripts to extract data and perform preprocessing, the efficiency and accuracy of data acquisition are improved, and the errors and time-consuming problems caused by manual operations are reduced. Statistical calculations based on at least one preset statistical dimension and statistical indicator can achieve multi-dimensional and in-depth data analysis and mine more valuable information, such as generating rich and targeted at least one set of statistical results to provide a comprehensive basis for subsequent decision-making. Sorting and filtering statistical results based on processing rules can make data presentation more in line with user needs and actual application scenarios, so that important information can be highlighted. The front-end display layer displays data in the form of charts and provides a form interface with customizable IT asset query conditions. This not only makes data display more intuitive, clear and easy to understand, but also meets the personalized query needs of different users, allowing users to flexibly obtain the required data according to their own focus, thereby comprehensively improving the overall efficiency of IT asset data management, analysis and display.

[0061] In an exemplary embodiment, Figure 3 As shown, Figure 3 As shown, a flowchart of another IT asset data processing and display method is provided, the method includes the following steps 301 to 306:

[0062] 301. Use automated scripts to extract IT asset data from a database and perform preprocessing operations to obtain preprocessed data.

[0063] 302. Perform statistical calculations on the preprocessed data according to at least one preset statistical dimension and at least one statistical indicator to obtain at least one set of statistical results.

[0064] 303. Sort and filter at least one set of statistical results based on the processing rules to obtain processed data.

[0065] 304. The processed data is displayed in a chart form through the front-end display layer, and a form interface is displayed.

[0066] For the description of the above steps 301 to 304 , reference may be made to the description of the above steps 201 to 204 , which will not be repeated here.

[0067] 305. Receive IT asset query conditions that are input by the user in the form interface.

[0068] Among them, the front-end display layer provides users with a form interface, which has the function of allowing users to customize IT asset query conditions. Users can enter the corresponding IT asset query conditions in this form interface according to their own needs and concerns. For example, users can select specific dimensions from the system's preset statistical dimensions (such as selecting "computer" for device category, "3-5 years" for operating years, etc.), or set the time range (for example, set it to "January 1, 2023-December 31, 2023"), or perform dimension selection and time range setting at the same time, so as to complete the action of customizing the input of IT asset query conditions. The system will obtain these specific condition information entered by the user for subsequent processing.

[0069] 306. Update processing rules based on input IT asset query conditions.

[0070] If an IT asset query condition inputted by a user in a form interface is received, the processing rule is updated based on the inputted IT asset query condition.

[0071] After executing step 306, the process returns to step 303. That is, based on the updated processing rules, at least one set of statistical results can be re-sorted and screened to obtain updated processed data, and the updated processed data can be re-displayed in the form of charts through the front-end display layer.

[0072] After receiving the IT asset query conditions that the user inputs in the form interface in step 305, the processing rules can be updated based on these newly input conditions. The processing rules may have been set by the system default or determined based on the last user operation, and now they need to be adjusted accordingly based on the newly input query conditions. For example, if the user reselects the statistical dimension in the form interface, or changes the time range and other settings, the system will analyze these new conditions and modify the rules originally used to sort and filter at least one set of statistical results. For example, if the rule originally sorts brands from large to small by quantity and filters out brand data with a quantity greater than 10, if the user sets a different statistical dimension or time range, the system will re-determine the sorting basis (which may be changed to sorting from large to small by proportion, etc.) and the filtering conditions (such as quantity greater than 5, etc.) based on the new conditions to complete the update of the processing rules.

[0073] In the above-mentioned IT asset data processing and display method, first, the IT asset data is extracted from the database and preprocessed using an automated script, which greatly improves the efficiency and accuracy of data acquisition, effectively reduces the errors and time-consuming problems caused by manual operations, and lays a solid foundation for subsequent accurate analysis. Then, statistical calculations are performed based on the preset rich statistical dimensions and indicators, which can deeply explore the value of the data and generate at least one set of targeted statistical results to meet the needs of multi-dimensional and in-depth data analysis, and provide a comprehensive and valuable basis for decision-making. Then, the statistical results are sorted and filtered based on the processing rules, so that the data presentation is more in line with the user's actual application scenarios and needs, and key information is highlighted. In particular, the charts of the processed data are displayed through the front-end display layer, and a form interface with customizable query conditions is provided, which not only makes the data intuitive, clear and easy to understand, but also meets the personalized query needs of different users. Moreover, after receiving the IT asset query conditions customized by the user in the form interface, the processing rules can be updated in a timely manner, and the statistical results can be reprocessed and displayed based on the new rules, so that users can flexibly obtain the required data according to changes in their own focus, thereby comprehensively improving the overall efficiency of IT asset data management, analysis and display, greatly enhancing the system's adaptability and responsiveness to user needs, and making the entire IT asset data processing and display process more flexible, efficient and intelligent.

[0074] For example, Figure 4 A schematic diagram showing an asset overview in the form of an Excel spreadsheet. Figure 4 In the interface of the chart display, an Excel table is shown, which includes the number of assets of each unit in the enterprise, that is, the number of IT resources of each unit (that is, each department) in the enterprise, and the total number of IT resources of each unit. Figure 4 As shown, an "Export Excel" control is also set in the interface of the chart display, through which the Excel table can be exported from the interface of the chart display, so as to facilitate the subsequent use and editing of these data.

[0075] For example, Figure 5 A pie chart showing the distribution of IT assets by device category. Figure 5 In the chart display interface, a pie chart is used to show the distribution of devices of various device categories, including: packaged software, storage devices, security devices, network devices, application system software, computer room environment software, auxiliary equipment, servers and PCs. The pie chart can intuitively understand the distribution of each device category.

[0076] For example, Figure 6 It is a statistical diagram showing IT assets of various brands in the form of a bar chart. Figure 6 In the interface of the chart display, a bar chart is used to show the number of IT assets of the top 10 brands. From the bar chart, the number of IT assets of each brand can be intuitively seen.

[0077] In the embodiment of the present application, various processed data can also be displayed in the interface of the chart display in combination with one or more of the above forms, for example: asset overview, statistical results by equipment category, statistical results by operating years, etc.

[0078] For example, Figure 7 It is a schematic diagram of a form interface in an embodiment of the present application. Figure 7 The form interface shows the selection boxes for "operation years", "operation status" and "user department". Through these selection boxes, users can enter the query conditions for "operation years", "operation status" and "user department", for example, more than 5 years of operation, operation status is not in operation, user department is human resources department, etc. Figure 6 The "Statistics" control shown in the figure can display the processed data in the form of charts according to the input query conditions. Figure 6 Click the "Reset" control shown in the figure to clear the selected query conditions for "Operation Years", "Operation Status" and "Using Department", and reselect the query conditions.

[0079] In the embodiments of the present application, the application scenarios of the above method may include but are not limited to:

[0080] Application scenario 1: Enterprise IT asset management scenario

[0081] Within the organizational structure of the enterprise, the IT department uses a system that can realize the data processing and display methods of Shanghai Su IT assets to carry out multi-dimensional statistical analysis and efficient management operations for IT assets across the enterprise. Based on the asset overview chart presented by the front-end display layer, the enterprise management can quickly and intuitively grasp the overall situation of the enterprise's IT assets, obtain key information such as the quantity distribution and proportion of various types of assets, and thus provide strong data support for macro decision-making. At the same time, the IT department can accurately formulate highly targeted IT asset maintenance plans and management strategies based on the detailed statistical results generated by the system according to preset statistical dimensions such as equipment category and operating years. For example, for equipment categories with a long operating life, the maintenance frequency can be appropriately increased and the equipment update budget can be planned in advance; for equipment that specific key businesses rely on, key monitoring and resource optimization can be carried out according to their categories to ensure the stable operation and efficient use of the enterprise's IT assets, to meet the needs of the enterprise's daily operations and business development for IT infrastructure to the greatest extent, and to enhance the overall digital operation efficiency and competitiveness of the enterprise.

[0082] Application scenario 2: Data center operation and maintenance scenario

[0083] In the complex operating environment of the data center, operation and maintenance personnel can implement real-time dynamic monitoring and accurate statistical analysis of core IT assets such as servers and storage devices by utilizing a system that can implement Shanghai Su IT asset data processing and display methods. Through the system's in-depth statistical functions based on dimensions such as brand and supplier, operation and maintenance personnel can comprehensively and meticulously evaluate the actual performance and quality level of equipment provided by different brands and suppliers. For example, based on long-term operating data statistics, compare the differences in key performance indicators such as stability, failure rate, and processing power of servers of various brands, as well as the performance of storage devices from different suppliers in terms of read and write speed, data reliability, and expansion flexibility, thereby providing key quantitative basis for subsequent equipment procurement decisions and ensuring that newly introduced equipment can better meet the business needs and technical standards of the data center. At the same time, based on these precise statistical analysis results, operation and maintenance personnel can also formulate more scientific and reasonable operation and maintenance strategies for existing equipment, such as focusing on maintenance and allocating resources to equipment with excellent performance, planning replacement plans in advance for equipment that frequently fails, and optimizing the compatibility and collaboration issues of equipment from different suppliers. This will ensure the continuous and stable operation of the data center, improve the overall service quality and operational efficiency of the data center, and provide solid and reliable underlying support for the smooth development of various digital businesses.

[0084] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include at least one step or at least one stage, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0085] Based on the same inventive concept, the embodiment of the present application also provides an IT asset data processing and display device for implementing the IT asset data processing and display method involved above. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the above method, so the specific limitations of one or at least one IT asset data processing and display device embodiment provided below can refer to the limitations of the IT asset data processing and display method above, and will not be repeated here.

[0086] In an exemplary embodiment, Figure 8 As shown, a structural block diagram of an IT asset data processing and display device is provided, including:

[0087] The preprocessing module 801 is used to extract IT asset data from the database using an automated script and perform preprocessing operations to obtain preprocessed data;

[0088] A statistical module 802 is used to perform statistical calculations on the preprocessed data according to at least one preset statistical dimension and at least one statistical indicator to obtain at least one set of statistical results;

[0089] A processing module 803 is used to sort and filter the at least one set of statistical results based on a processing rule to obtain processed data;

[0090] A display module 804 is used to display the processed data in a chart form through a front-end display layer and display a form interface;

[0091] The form interface is used for users to customize IT asset query conditions.

[0092] In some embodiments, the apparatus further comprises:

[0093] An updating module 805, configured to update the processing rule based on the IT asset query condition input by the user in the form interface if receiving the IT asset query condition;

[0094] Based on the updated processing rules, the at least one set of statistical results is re-sorted and screened to obtain the updated processed data.

[0095] The display module 804 can display the updated processed data in a chart form again through the front-end display layer.

[0096] In some embodiments, the processing rule is determined based on the IT asset query condition that was previously customized by the user; or, the processing rule is a default setting.

[0097] In some embodiments, the processing module 803 is specifically used to:

[0098] Aggregating the at least one set of statistical results to obtain aggregated data;

[0099] The aggregated data is sorted and filtered based on the processing rules to obtain filtered data.

[0100] In some embodiments, the preprocessing operation includes: data cleaning operation and data conversion operation; the preprocessing module 801 is specifically used to:

[0101] Performing a data cleaning operation on the extracted IT asset data to remove duplicate data and erroneous data in the IT asset data to obtain cleaned data;

[0102] A data conversion operation is performed on the cleaned data to obtain the pre-processed data formatted into a preset format.

[0103] In some embodiments, the form interface is used for a user to select a statistical dimension and / or set a time range as a custom IT asset query condition.

[0104] Each module in the above-mentioned IT asset data processing and display device can be implemented in whole or in part by software, hardware and their combination. Each of the above-mentioned modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory in the computer device in the form of software, so that the processor can call and execute the corresponding operations of each of the above modules.

[0105] In an exemplary embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as shown in FIG. Fig. 9As shown. The computer device includes a processor, a memory, an input / output interface (Input / Output, referred to as I / O) and a communication interface. The processor, the memory and the input / output interface are connected through a system bus, and the communication interface is connected to the system bus through the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store data. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a method for processing and displaying IT asset data is implemented.

[0106] Those skilled in the art will understand that Fig. 9 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0107] In an exemplary embodiment, a computer device is provided, including a memory and a processor, wherein a computer program is stored in the memory, and when the processor executes the computer program, the following steps are implemented:

[0108] Use automated scripts to extract IT asset data from the database and perform preprocessing operations to obtain preprocessed data;

[0109] Performing statistical calculations on the preprocessed data according to at least one preset statistical dimension and at least one statistical indicator to obtain at least one set of statistical results;

[0110] Sorting and screening the at least one set of statistical results based on the processing rules to obtain processed data;

[0111] The processed data is displayed in a chart form through the front-end display layer, and a form interface is displayed;

[0112] The form interface is used for users to customize IT asset query conditions.

[0113] In one embodiment, when the processor executes the computer program, the processor further implements the following steps:

[0114] If an IT asset query condition inputted by the user in the form interface is received, the processing rule is updated based on the inputted IT asset query condition;

[0115] Based on the updated processing rules, the at least one set of statistical results is re-sorted and screened to obtain the updated processed data, and the updated processed data is re-displayed in the form of a chart through the front-end display layer.

[0116] In one embodiment, the processing rule is determined based on the IT asset query condition that was customized by the user last time; or, the processing rule is a default setting.

[0117] In one embodiment, when the processor executes the computer program, the processor further implements the following steps:

[0118] The step of sorting and screening the at least one set of statistical results based on the processing rules to obtain screened data includes:

[0119] Aggregating the at least one set of statistical results to obtain aggregated data;

[0120] The aggregated data is sorted and filtered based on the processing rules to obtain filtered data.

[0121] In one embodiment, the preprocessing operation includes: a data cleaning operation and a data conversion operation; when the processor executes the computer program, the processor also implements the following steps:

[0122] Performing a data cleaning operation on the extracted IT asset data to remove duplicate data and erroneous data in the IT asset data to obtain cleaned data;

[0123] A data conversion operation is performed on the cleaned data to obtain the pre-processed data formatted into a preset format.

[0124] In one embodiment, the form interface is used for a user to select a statistical dimension and / or set a time range as a custom IT asset query condition.

[0125] In one embodiment, a computer readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, the following steps are implemented:

[0126] Use automated scripts to extract IT asset data from the database and perform preprocessing operations to obtain preprocessed data;

[0127] Performing statistical calculations on the preprocessed data according to at least one preset statistical dimension and at least one statistical indicator to obtain at least one set of statistical results;

[0128] Sorting and screening the at least one set of statistical results based on the processing rules to obtain processed data;

[0129] The processed data is displayed in a chart form through the front-end display layer, and a form interface is displayed;

[0130] The form interface is used for users to customize IT asset query conditions.

[0131] In one embodiment, when the processor executes the computer program, the processor further implements the following steps:

[0132] If an IT asset query condition inputted by the user in the form interface is received, the processing rule is updated based on the inputted IT asset query condition;

[0133] Based on the updated processing rules, the at least one set of statistical results is re-sorted and screened to obtain the updated processed data, and the updated processed data is re-displayed in the form of a chart through the front-end display layer.

[0134] In one embodiment, the processing rule is determined based on the IT asset query condition that was customized by the user last time; or, the processing rule is a default setting.

[0135] In one embodiment, when the processor executes the computer program, the processor further implements the following steps:

[0136] The step of sorting and screening the at least one set of statistical results based on the processing rules to obtain screened data includes:

[0137] Aggregating the at least one set of statistical results to obtain aggregated data;

[0138] The aggregated data is sorted and filtered based on the processing rules to obtain filtered data.

[0139] In one embodiment, the preprocessing operation includes: a data cleaning operation and a data conversion operation; when the processor executes the computer program, the processor also implements the following steps:

[0140] Performing a data cleaning operation on the extracted IT asset data to remove duplicate data and erroneous data in the IT asset data to obtain cleaned data;

[0141] A data conversion operation is performed on the cleaned data to obtain the pre-processed data formatted into a preset format.

[0142] In one embodiment, the form interface is used for a user to select a statistical dimension and / or set a time range as a custom IT asset query condition.

[0143] In one embodiment, a computer program product is provided, comprising a computer program, which, when executed by a processor, implements the following steps:

[0144] Use automated scripts to extract IT asset data from the database and perform preprocessing operations to obtain preprocessed data;

[0145] Performing statistical calculations on the preprocessed data according to at least one preset statistical dimension and at least one statistical indicator to obtain at least one set of statistical results;

[0146] Sorting and screening the at least one set of statistical results based on the processing rules to obtain processed data;

[0147] The processed data is displayed in a chart form through the front-end display layer, and a form interface is displayed;

[0148] The form interface is used for users to customize IT asset query conditions.

[0149] In one embodiment, when the processor executes the computer program, the processor further implements the following steps:

[0150] If an IT asset query condition inputted by the user in the form interface is received, the processing rule is updated based on the inputted IT asset query condition;

[0151] Based on the updated processing rules, the at least one set of statistical results is re-sorted and screened to obtain the updated processed data, and the updated processed data is re-displayed in the form of a chart through the front-end display layer.

[0152] In one embodiment, the processing rule is determined based on the IT asset query condition that was customized by the user last time; or, the processing rule is a default setting.

[0153] In one embodiment, when the processor executes the computer program, the processor further implements the following steps:

[0154] The step of sorting and screening the at least one set of statistical results based on the processing rules to obtain screened data includes:

[0155] Aggregating the at least one set of statistical results to obtain aggregated data;

[0156] The aggregated data is sorted and filtered based on the processing rules to obtain filtered data.

[0157] In one embodiment, the preprocessing operation includes: a data cleaning operation and a data conversion operation; when the processor executes the computer program, the processor also implements the following steps:

[0158] Performing a data cleaning operation on the extracted IT asset data to remove duplicate data and erroneous data in the IT asset data to obtain cleaned data;

[0159] A data conversion operation is performed on the cleaned data to obtain the pre-processed data formatted into a preset format.

[0160] In one embodiment, the form interface is used for a user to select a statistical dimension and / or set a time range as a custom IT asset query condition.

[0161] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., but are not limited to this.

[0162] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0163] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.

Claims

1. A method for processing and displaying IT asset data, characterized in that: include: Use automated scripts to extract IT asset data from the database and perform preprocessing operations to obtain preprocessed data; Performing statistical calculations on the preprocessed data according to at least one preset statistical dimension and at least one statistical indicator to obtain at least one set of statistical results; Sorting and screening the at least one set of statistical results based on the processing rules to obtain processed data; The processed data is displayed in a chart form through the front-end display layer, and a form interface is displayed; The form interface is used for users to customize IT asset query conditions.

2. The method according to claim 1, characterized in that The method further comprises: If an IT asset query condition inputted by the user in the form interface is received, the processing rule is updated based on the inputted IT asset query condition; Based on the updated processing rules, the at least one set of statistical results is re-sorted and screened to obtain the updated processed data, and the updated processed data is re-displayed in the form of a chart through the front-end display layer.

3. The method according to claim 1, characterized in that The processing rule is determined based on the last user-defined IT asset query condition; or, The processing rules are set by default.

4. The method according to claim 1, characterized in that The step of sorting and screening the at least one set of statistical results based on the processing rules to obtain screened data includes: Aggregating the at least one set of statistical results to obtain aggregated data; The aggregated data is sorted and filtered based on the processing rules to obtain filtered data.

5. The method according to claim 1, characterized in that: The preprocessing operation includes: data cleaning operation and data conversion operation; Performing a data cleaning operation on the extracted IT asset data to remove duplicate data and erroneous data in the IT asset data to obtain cleaned data; A data conversion operation is performed on the cleaned data to obtain the pre-processed data formatted into a preset format.

6. The method according to claim 1, characterized in that The form interface is used for the user to select statistical dimensions and / or set a time range as a custom IT asset query condition.

7. An IT asset data processing and display device, characterized in that: The device comprises: A preprocessing module is used to extract IT asset data from a database using an automated script and perform preprocessing operations to obtain preprocessed data; A statistical module, used to perform statistical calculations on the preprocessed data according to at least one preset statistical dimension and at least one statistical indicator to obtain at least one set of statistical results; A processing module, used for sorting and screening the at least one set of statistical results based on a processing rule to obtain processed data; A display module, used to display the processed data in the form of charts through a front-end display layer and display a form interface; The form interface is used for users to customize IT asset query conditions.

8. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images