Useful AIDA queries
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 MAD modelled or not, epics device name, etc 1 |
|
Table of all beamline elements, whether they MAD modelled or not, epics device name, etc, sorted by Z 1 |
Archive Queries
Summary AIDA query |
Description |
|---|---|
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 |
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 |