Challenge 2: Detect most recent server location and status [+]

Document created by cdavidson@apptio.com Employee on Mar 31, 2018Last modified by rhonda on Apr 3, 2018
Version 1Show Document
  • View in full screen mode

 

Chris is back with another TBM Pursuit question for you. You can start playing now and get a piece of the pie, or if you passed the first round, earn your second piece. 30pts and a TBM Pursuit piece for anyone with the correct answer. Give it a shot  

Question closes April 20.

 

 

Christopher Davidson says...

 

Each month, I use Datalink to pull server status logs directly from my configuration management database (CMDB) into my cost transparency project in Apptio (R12).

 

These data pulls are fully automated, and I cannot reroute them to my own computer. Thus, any changes needed have to be made within Apptio, not in an external application (such as Excel).

 

The server logs are hundreds of thousands of lines long. Here's a sample from my Apptio table called Server Logs:

 

No timestamp column is available, but my CMDB team told me that the logs are already in chronological order (from earliest to most recent). Notice that server IP addresses repeat in the logs, reflecting their change in status (offline vs. online) and change in location (UNK = unknown).

 

In Apptio, my Servers object is already backed by a list of all valid servers and their respective IP addresses.

The list has a few thousand entries, and no Server ID values are duplicated. Quick sample:

 

See those Latest Status and Latest Location columns above?

That's where I need your help.

Given the sample server logs seen earlier, I want my Servers object table results to look exactly like this mockup:

...because for instance 96.49.8.6 has two entries in the logs, but its last found entry is online / Las Vegas.

 

 

Is this possible within Apptio? If so, what should the Latest Status and Latest Location column formulas be?

 

Attachments

    Outcomes