Using Grismar's Eve Explorer http://grismar.net/eve/explorer/index.php
- Show Agents
- With level = 4
- With Quality = 18
- In a system with security = 0.5
This list all of them - I'm not exactly sure how to limit it to missions with encounters (putting in 'offering missions of type 'kill' returns only 2 agents so I know its missing something).
This is query is also useful because you can expand it out just a tad more if 4+17 was acceptable, or if 0.6 is acceptable.
Expanding this to >= 17 and 0.5 or 0.6
Corporate Police Force Irjunen II Eratsaka Ogyonin 4 18 SURV
Ducia Foundry Larryn V 1 Anad Hobrork 4 18 SEC
Ducia Foundry Mili VIII 10 Dubahar Veche 4 18 SEC
Imperial Shipment Nalu VII 4 Joasa Asabal 4 17 SEC
Ishukone Corporation Hentogaira I 10 Shuhola Aularoila 4 17 ISEC
Republic Fleet Gelfiven IX 17 Agirtad Dotudink 4 18 SURV
Republic Fleet Emolgranlan VI Vir Honn 4 18 SURV
Sukuuvestaa Corporation Sivala VIII Aakonoshin Piertalen 4 17 ISEC
Theology Council Sasoutikh V 11 Amis Arvadan 4 18 ISEC
As I said, I know its missing some, but Grismar's tool is a great one to do more structured queries.
An alterative to Grismar's tool for structured queries is to get the static CCP dump and load it into your own database.
The query you would want to be looking at would be something along the lines of:
select
nF.itemName faction,
nC.itemName corpName,
nA.itemName agent,
ns.itemName station,
round(aSys.security,2) security,
d.divisionName division,
concat(a.level,'.',a.quality) lq,
count(1) adjacentcount,
round(min(nSys.security),2) lowest
from
ccp.crpNPCCorporations c,
ccp.eveNames nC,
ccp.eveNames nF,
ccp.eveNames nA,
ccp.eveNames nS,
ccp.agtAgents a,
ccp.crpNPCDivisions d,
ccp.staStations s,
ccp.mapSolarSystems aSys,
ccp.mapSolarSystemJumps jSys,
ccp.mapSolarSystems nSys
where
c.factionID = nF.itemID
and c.corporationID = nc.itemID
and a.corporationID = c.corporationID
and nA.itemID = a.agentID
and a.divisionID = d.divisionId
-- and d.divisionName in ('Administration', 'Command', 'Intelligence', 'Legal', 'Security', 'Internal Security', 'Surveillance')
and d.divisionName in ('Command', 'Intelligence','Security', 'Internal Security', 'Surveillance')
and a.locationID = s.stationID
and nS.itemId = s.stationID
and s.solarSystemID = aSys.solarSystemID
and aSys.security >= 0.45
and aSys.security <= 0.60
and a.level = 4
and a.quality >= 16
and aSys.solarSystemID = jSys.fromSolarSystemID
and nSys.solarSystemID = jSys.toSolarSystemID
and jSys.toRegionID = jSys.fromRegionID
group by a.agentID
order by a.quality desc, aSys.security
(swap the divisions to give a wider net)
One bit to note in there is the adjacent count only counts adjacencies in the same region. An agent won't give a mission for another region.
This gives the output of:
faction,corpName,agent,station,security,division,lq,adjacentcount,lowest
"Gallente Federation","Federal Defence Union","Detselard Cebrespauze","Caslemon III - Federal Defence Union Logistic Support",0.58,"Internal Security",4.19,5,0.47
"Caldari State","Corporate Police Force","Asturi Arakenda","Oshaima VII - Moon 1 - Corporate Police Force Assembly Plant",0.45,Surveillance,4.18,3,0.40
"Caldari State","Corporate Police Force","Eratsaka Ogyonin","Irjunen II - Corporate Police Force Assembly Plant",0.52,Surveillance,4.18,3,0.46
"Minmatar Republic","Republic Fleet","Vir Honn","Emolgranlan VI - Republic Fleet Assembly Plant",0.53,Surveillance,4.18,2,0.44
"Gallente Federation","Roden Shipyards","Vienlomandie Slace","Scheenins II - Moon 2 - Roden Shipyards Factory",0.54,Command,4.18,2,0.52
"Minmatar Republic","Republic Fleet","Agirtad Dotudink","Gelfiven IX - Moon 17 - Republic Fleet Assembly Plant",0.56,Surveillance,4.18,3,0.37
"Amarr Empire","Ducia Foundry","Dubahar Veche","Mili VIII - Moon 10 - Ducia Foundry Refinery",0.56,Security,4.18,3,0.45
"Caldari State","Hyasyoda Corporation","Uesi Tuomaitoh","Wuos V - Moon 1 - Hyasyoda Corporation Mining Outpost",0.56,"Internal Security",4.18,1,0.55
"Caldari State","Caldari Navy","Kia Isatoh","Ichoriya V - Caldari Navy Logistic Support",0.57,Command,4.18,3,0.44
"Amarr Empire","Theology Council","Amis Arvadan","Sasoutikh V - Moon 11 - Theology Council Accounting",0.59,"Internal Security",4.18,2,0.57
"Amarr Empire","Ducia Foundry","Anad Hobrork","Larryn V - Moon 1 - Ducia Foundry Mineral Reserve",0.60,Security,4.18,3,0.58
"Gallente Federation","Federal Defence Union","Boncherie Osnins","Villore VI - Federal Defence Union Logistic Support",0.51,Intelligence,4.17,5,0.34
"Caldari State","Sukuuvestaa Corporation","Konuoma Ichodan","Arvasaras II - Moon 1 - Sukuuvestaa Corporation Production Plant",0.52,"Internal Security",4.17,1,0.58
"Gallente Federation","Federal Defence Union","Chaimart Ganette","Jufvitte IV - Federal Defence Union Logistic Support",0.52,Security,4.17,4,0.42
"Caldari State","Sukuuvestaa Corporation","Aakonoshin Piertalen","Sivala VIII - Sukuuvestaa Corporation Warehouse",0.55,"Internal Security",4.17,4,0.42
"Caldari State","Ishukone Corporation","Shuhola Aularoila","Hentogaira I - Moon 10 - Ishukone Corporation Warehouse",0.57,"Internal Security",4.17,3,0.38
"Amarr Empire","Imperial Shipment","Joasa Asabal","Nalu VII - Moon 4 - Imperial Shipment Storage",0.58,Security,4.17,1,0.63
"Caldari State","Lai Dai Protection Service","Sotrentaira Isara","Uuhulanen X - Lai Dai Protection Service Assembly Plant",0.49,Command,4.16,3,0.56
"Gallente Federation","Federal Intelligence Office","Chammegestin Allote","Boystin V - Moon 6 - Federal Intelligence Office Assembly Plant",0.52,Surveillance,4.16,3,0.44
"Gallente Federation","Roden Shipyards","Bruffrer Vria","Junsoraert XI - Moon 9 - Roden Shipyards Factory",0.52,Command,4.16,3,0.59
"Caldari State","Hyasyoda Corporation","Arikio Kuretsu","Wuos V - Moon 1 - Hyasyoda Corporation Mining Outpost",0.56,"Internal Security",4.16,1,0.55
"Amarr Empire","Kor-Azor Family","Aralin Jick","Nishah VII - Moon 5 - Kor-Azor Family Treasury",0.58,"Internal Security",4.16,1,0.64
That should be easy to toss into excel or whatever your favorite spreadsheet is.
