public IActionResult Bandwidth([FromBody] RequestIdentity identity)
{
try
{
var mapper = new Mapper(_cassandraCore.GeSession(KeySpaces.hawkeye));
var query = string.Format("SELECT \"event_timestamp\", \"BytesReceived\", \"BytesSent\", \"Speed\", \"TimeStamp\" from " +
"hawkeye.hawkeye_network WHERE \"workspace_uuid\"='{0}' AND \"event_timestamp\" >= {1} AND \"event_timestamp\" <= {2}",
identity.WorkspaceId, identity.StartDate, identity.EndDate);
if (!string.IsNullOrEmpty(identity.SensorId))
{
query += string.Format(" AND \"sensor_uuid\"='{0}'", identity.SensorId);
}
query += " LIMIT 10 ALLOW FILTERING";
var data = mapper.Fetch <BandWidth>(query);
if (data != null)
{
return(Ok(data));
}
return(NoContent());
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(NoContent());
}
}
public IActionResult RecentWebsites([FromBody] RequestIdentity identity)
{
try
{
var mapper = new Mapper(_cassandraCore.GeSession(KeySpaces.pathfinder));
var query = string.Format("SELECT \"cat\", \"domain\", \"dest_ip\", \"private_ip\" from " +
"beacon.beacon_website WHERE \"workspace_uuid\"='{0}' AND \"epoch_timestamp\" >= {1} AND \"epoch_timestamp\" <= {2}",
identity.WorkspaceId, identity.StartDate, identity.EndDate);
if (!string.IsNullOrEmpty(identity.SensorId))
{
query += string.Format(" AND \"sensor_uuid\"='{0}'", identity.SensorId);
}
query += " LIMIT 10 ALLOW FILTERING";
var data = mapper.Fetch <Websites>(query);
if (data != null)
{
return(Ok(data));
}
return(NoContent());
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(NoContent());
}
}
public IActionResult RecentFiles([FromBody] RequestIdentity identity)
{
try
{
var mapper = new Mapper(_cassandraCore.GeSession(KeySpaces.pathfinder));
var query = string.Format("SELECT \"Username\", \"FileName\", \"Action\" from " +
"pathfinder.pathfinder_activity_workspace WHERE \"workspace_uuid\"='{0}' AND \"event_timestamp\" >= {1} AND \"event_timestamp\" <= {2}",
identity.WorkspaceId, identity.StartDate, identity.EndDate);
if (!string.IsNullOrEmpty(identity.SensorId))
{
query += string.Format(" AND \"sensor_uuid\"='{0}'", identity.SensorId);
}
query += " LIMIT 10 ALLOW FILTERING";
var data = mapper.Fetch <FileActivity>(query);
if (data != null)
{
return(Ok(data));
}
return(NoContent());
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(NoContent());
}
}