Unprotected Count for Most Recent Search
Joined: 24 Nov 2010
Location: Penn State
Posted: 06 Dec 2010 at 1:19pm
One of the reports that our units find useful shows the unprotected count for the most recent search of each endpoint. These reports have been exported from our console and attached to this post. In this post, I'll explain the construction and function of the reports.
There are four reports; Step 1, Step 2, Step 3, and the Main report. The "step" reports feed data to the main report. For each report, the check box titled "This report will either be joined to another report or used for secondary analytics" on the Report tab is selected so that certain columns are made available in the report. This is required so that one report can be related to another report properly.
This report contains two columns from the Search category: Endpoint Identifier and Search Date/Time. The Aggregate property of the Search Date/Time column is set to Max since we want to see data for the most recent search performed.
This report contains three columns: Endpoint Identifier from the Locations category, Search Date/Time from the Searches category, and Unprotected Quantity from the Matches category. The Aggregate property of the Unprotected Quantity column is set to Sum since we want to see the total number of unprotected matches for each search.
This report contains five columns: the two columns from Step 1 and the three columns from Step 2. The Endpoint Identifier and Search Date/Time columns from Step 2 are hidden in this report (this is optional and cuts down on redundant data). Now, since this report is comprised of columns from other reports, relationships must be created so that the reports can be joined properly. Two relationships link the Endpoint Identifier and the Search Date/Time from Step 2 to Step 1. These are left joins since we want all records from Step 1 and any matching records from Step 2 that may be present.
This report contains six columns: Tag Name from the Tags column, Endpoint Name and Endpoint Identifier from the Endpoints category, and Endpoint Identifier, Search Date/Time, and Unprotected Quantity from Step 3. The Endpoint Identifier columns are hidden since it isn't a column we're interested in seeing in the final report. Similar to Step 3, a relationship must be created. This time, we relate the Endpoint Identifier column from Step 3 to the Endpoint Identifier from the Endpoints category. Again, this is a left join since we want to see all endpoints, even if a search hasn't been performed.
Hope this report is useful to others. If anything isn't clear, please ask and I will try to offer an explanation.
Edited by danlehman - 06 Dec 2010 at 1:20pm
|Forum Jump||Forum Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum