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()); } }