The following table lists some useful AIDA queries. Click on the links to execute the queries.
Oracle Database
AIDA Query |
Description |
|---|---|
All the EPICS "device names" (type:area:unit, or area:type:unit if SLC) in the LCLS system.1 |
|
Table of all Beam Synchronous PV "root names", and their MAD element, whether EPICS or SLC, sorted by Z 1 |
|
Table of all beamline elements, whether they are MAD modelled or not, epics device name, etc 1 |
|
Table of all beamline elements, whether they are MAD modelled or not, epics device name, etc, sorted by Z 1 |
Archive Queries
Summary AIDA query |
Description |
|---|---|
U*:T*//HIST.lcls REL_TIME=LAST_DAY (https://seal.slac.stanford.edu/aidaweb/dispatchQuery?Time+Range+Index=2&History+View+Mode=Plot&Query=U*%3AT*%2F%2FHIST.lcls+REL_TIME%3DLAST_DAY&Query+Action=List+History+Names) |
Gets a list of Undulator EPICS PV archive names matching pattern U*:T*, click one to get plot of last day's data for that PV |
Model Data Queries
Aida Query |
Description |
|---|---|
Table of Gold model runs |
|
Latest Design Full Machine (Cathode to Dump) model Rmats for all devices |
|
Latest Design Cathode to Gun Spectrometer model Rmats for all devices |
|
Latest Design Cathode to 135 Mev Spectrometer model Rmats for all devices |
|
Latest Design Cathode to 52 line model Rmats for all devices |
|
Latest Extant (from actual device settings) Full Machine (Cathode to Dump) model Rmats for all devices |
|
Latest Extant (from actual device settings) Cathode to Gun Spectrometer model Rmats for all devices |
|
Latest Extant (from actual device settings) Cathode to 135 Mev Spectrometer model Rmats for all devices |
|
Latest Extant (from actual device settings) Cathode to 52 line model Rmats for all devices |
|
Latest Design Full Machine (Cathode to Dump) model Twiss, Z, LEFF, for all devices |
|
Latest Design Cathode to Gun Spectrometer model Twiss, Z, LEFF, for all devices |
|
Latest Design Cathode to 135 Mev Spectrometer model Twiss, Z, LEFF, for all devices |
|
Latest Design Cathode to 52 line model Twiss, Z, LEFF, for all devices |
|
Latest Extant (from actual device settings) Full Machine (Cathode to Dump) model Twiss, Z, LEFF, for all devices |
|
Latest Extant (from actual device settings) Cathode to Gun Spectrometer model Twiss, Z, LEFF, for all devices |
|
Latest Extant (from actual device settings) Cathode to 135 Mev Spectrometer model Twiss, Z, LEFF, for all devices |
|
Latest Extant (from actual device settings) Cathode to 52 line model Twiss, Z, LEFF, for all devices |
1 Note for using AidaWeb with these queries. These AIDA queries return many rows, so switch the preferences to style >1000 rows to see all data. Alternatively, and bearing in mind that for these big result queries, HTML styling may be taking about a second on it's own, check radio-button "Display Raw Data" and set "Max number of AIDA names to list" to like 5000. Then you'll get a fast response and get all data.
Aida one-liners
Command |
Description |
|---|---|
aidaget LCLS//epicsDeviceNames | grep BEND |
Get the device-name of all the BEND devices in LCLS |