Server inventory trends

• US 9,483,561 B2
• Filed: 01/24/2014
• Issued: 11/01/2016
• Est. Priority Date: 01/24/2014
• Status: Active Grant

• Current Assignee: Bank of America Corp.
• Original Assignee: Bank of America Corp.
• Inventors: Javvadi, Ganesh, Tripathy, Priyanka
• Primary Examiner(s): Luu, Le H
• Application Number:
  US14/163,513
• Publication Number:
  US 20150215178A1
• Time in Patent Office: 1,012 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: H04L 41/024 using relational databases for representation of network management data, e.g. managing via structured query language [SQL]
• CPC Class Codes: H04L 41/0253 using browsers or web-pages for accessing management information
• CPC Class Codes: H04L 41/0853 by actively collecting configuration information or by backing up configuration information
• CPC Class Codes: H04L 41/22 comprising specially adapted graphical user interfaces [GUI]
• CPC Class Codes: H04L 43/06 Generation of reports
• CPC Class Codes: H04L 43/065 related to network devices

Abstract

Methods for monitoring and reporting server inventory trends are disclosed. An authorized user may access a website and input a specified time period and platform to view pertinent server inventory trends. A managing computing server receives the request for server inventory trends and may run one or more procedures to retrieve relevant information from at least one database. The relevant information may be transferred from the database to a fusion chart to be plotted for display. The managing computing server may display a report of server inventory information, such as the number of active servers, added servers, and retired servers for the platform over the specified time period.

Claims

1. A computer-implemented method, comprising:

receiving, at a processor of a managing computing server, a request for server inventory trends, wherein the managing computing server is in communication with one or more support servers, wherein the one or more support servers operate on one or more platforms, wherein the managing computing server is in communication with one or more databases comprising pertinent server information associated with the one or more support servers, and wherein the request comprises a trend selection;

responsive to receiving the request, executing, at the processor, one or more Structured Query Language (SQL) procedures and one or more SQL queries, wherein the one or more SQL procedures and the one or more SQL queries cause the processor to retrieve the pertinent server information from one or more databases based, at least in part, on the trend selection, and wherein the pertinent server information comprises whether the one or more support servers are active, deactivated, retired, when they were added, and when they were retired;

transferring, at the processor, the pertinent server information from the one or more databases to a fusion chart as an Extensible Markup Language (XML) data string, and storing the fusion chart in the managing computing server;

plotting, at the fusion chart, the pertinent server information, wherein the plotting generates output data; and

outputting, at the processor, the output data, wherein the output data includes modified stats and total stats associated with the one or more support servers, and wherein the output data is displayed at intervals.

2. The method of claim 1, wherein the trend selection comprises a specified time range and platform.

3. The method of claim 2, wherein the pertinent server information comprises server statistics for the specified time range and platform.

4. The method of claim 2, wherein the pertinent server information comprises a number of active servers, a number of retired servers, and a number of added servers for the platform during the specified time range.

5. The method of claim 1, further comprising outputting server identification information comprising at least one of a support server'"'"'s serial number, name, mailcode, and operating system.

6. The method of claim 1, wherein output data comprises graphs depicting the pertinent server information.

7. The method of claim 1, wherein the pertinent server information transferred to the fusion chart comprises an Extensible Markup Language (XML) data string.

8. A non-transitory computer-readable storage medium having computer-executable program instructions stored thereon that, when executed by a processor, cause the processor to:

receive, at a managing computing server, a request for server inventory trends, wherein the managing computing server is in communication with one or more support servers, wherein the one or more support severs operate on one or more platforms, wherein the managing computing server is in communication with one or more databases comprising pertinent server information associated with the one or more support servers, and wherein the request comprises a trend selection;

responsive to receiving the request, execute one or more Structured Query Language (SQL) procedures and one or more SQL queries, wherein the one or more SQL procedures and the one or more SQL queries cause the processor to retrieve the pertinent server information from one or more databases based, at least in part, on the trend selection, and wherein the pertinent server information comprises whether the one or more support servers are active, deactivated, retired, when they were added, and when they were retired;

transfer the pertinent server information from the one or more databases to a fusion chart as an Extensible Markup Language (XML) data string, and store the fusion chart in the managing computing server;

plot, at the fusion chart, the pertinent server information, wherein the plotting generates output data; and

output the output data, wherein the output data includes modified stats and total stats associated with the one or more support servers, and wherein the output data is displayed at intervals.

9. The non-transitory computer-readable storage medium of claim 8, wherein the trend selection comprises a specified time range and platform.

10. The transitory computer-readable storage medium of claim 9, wherein the pertinent server information comprises server statistics for the specified time range and platform.

11. The transitory computer-readable storage medium of claim 9, wherein the pertinent server information comprises a number of active servers, a number of retired servers, and a number of added servers for the platform during the specified time range.

12. The transitory computer-readable storage medium of claim 8, wherein the computer-executable program instructions further cause the processor to output server identification information comprising at least one of a support server'"'"'s serial number, name, mailcode, and operating system.

13. The transitory computer-readable storage medium of claim 8, wherein output data comprises graphs depicting the pertinent server information.

14. An apparatus comprising:

a memory;

a processor, wherein the processor executes computer-executable program instructions which cause the processor to;

receive, at a managing computing server, a request for server inventory trends, wherein the managing computing server is in communication with one or more support servers, wherein the one or more support servers operate on one or more platforms, wherein the managing computing server is in communication with one or more databases comprising pertinent server information associated with the one or more support servers, and where the request comprises a trend selection;

responsive to receiving the request, execute one or more Structured Query Language (SQL) procedures and one or more SQL queries, wherein the one or more SQL procedures and the one or more SQL queries cause the processor to retrieve the pertinent server information from one or more databases based, at least in part, on the trend selection, and wherein the pertinent server information comprises whether the one or more support servers are active, deactivated, retired, when they were added, and when they were retired;

transfer the pertinent server information from the one or more databases to a fusion chart as an Extensible Markup Language (XML) data string, and store the fusion chart in the managing computing server;

plot, at the fusion chart, the pertinent server information, wherein the plotting generates output data; and

output the output data, wherein the output data includes modified stats and total stats associated with the one or more support servers, and wherein the output data is displayed at intervals.

15. The apparatus of claim 14, wherein the trend selection comprises a specified time range and platform.

16. The apparatus of claim 15, wherein the pertinent server information comprises server statistics for the specified time range and platform.

17. The apparatus of claim 15, wherein the pertinent server information comprises a number of active servers, a number of retired servers, and a number of added servers for the platform during the specified time range.

18. The apparatus of claim 15, wherein the computer-executable program instructions further cause the processor to output server identification information comprising at least one of a support server'"'"'s serial number, name, mailcode, and operating system.

19. The apparatus of claim 14, wherein output data comprises graphs depicting the pertinent server information.

20. The apparatus of claim 14, wherein the pertinent server information transferred to the fusion chart comprises an Extensible Markup Language (XML) data string.