Add scripts to create myops-getqueryview:
[myops.git] / web / query / _attachments / index.html
diff --git a/web/query/_attachments/index.html b/web/query/_attachments/index.html
new file mode 100644 (file)
index 0000000..818d80c
--- /dev/null
@@ -0,0 +1,158 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"\r
+"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">\r
+<html>\r
+\r
+<head>\r
+<meta http-equiv="content-type" content="text/html; charset=iso-8859-1"/>\r
+<meta name="description" content="description"/>\r
+<meta name="keywords" content="keywords"/> \r
+<meta name="author" content="author"/> \r
+<!--link rel="stylesheet" type="text/css" href="../../screen.css" media="screen"/-->\r
+<!--link rel="stylesheet" href="../../style/screen.css" type="text/css"/-->\r
+<link rel="stylesheet" href="style/sphinxdoc.css" type="text/css" />\r
+<link rel="stylesheet" href="style/pygments.css" type="text/css" />\r
+         \r
+<title>MyOpsQuery</title>\r
+</head>\r
+\r
+<body>\r
+\r
+       <div class="header" style="background-color: white; text-align: left; padding: 10px 10px 15px 15px">\r
+               <img align='right' src="images/pl-logo.png"/>\r
+               <div class="title">\r
+                       <h1>Welcome to MyOps-Query:</h1>\r
+                       <h4>A simple collection & query interface for MyPLC deployments.</h4>\r
+               </div>\r
+               <div class="related">\r
+                       <ul>\r
+                       <li> <a href="index.html">Home</a> | </li>\r
+                       <!--li> <a href="index.html">About</a> </li-->\r
+                       </ul>\r
+               </div>\r
+       </div>\r
+\r
+               <div class="sphinxsidebar">\r
+                       <div class="sphinxsidebarwrapper">\r
+\r
+                       <h1>Query</h1>\r
+                       <form action="query">\r
+                       <div>\r
+                               <input type="text" name="filter" class="styled" /> \r
+                               <input type="hidden" name="fields" value="date,hostname" /> \r
+                               <input type="submit" value="Run Query" class="button" />\r
+                       </div>\r
+                       </form>\r
+\r
+                       <h1>Collected Attributes</h1>\r
+                               <ul>\r
+                                       <li><a href="/PlanetLabConf/input.cfg">input.cfg</a></li>\r
+                                       <li>type </li>\r
+                                       <li>date </li>\r
+                                       <li>ts </li>\r
+                                       <li>hostname </li>\r
+                                       <li>boot_state </li>\r
+                                       <li>ip_internal </li>\r
+                                       <li>diskspace_root </li>\r
+                                       <li>diskspace_vservers </li>\r
+                                       <li>free_disk_root </li>\r
+                                       <li>free_inodes_root </li>\r
+                                       <li>free_disk_vservers </li>\r
+                                       <li>free_inodes_vservers </li>\r
+                                       <li>fs_status </li>\r
+                                       <li>install_date </li>\r
+                                       <li>iptables_status </li>\r
+                                       <li>kernel_version </li>\r
+                                       <li>netflow </li>\r
+                                       <li>netflow_live </li>\r
+                                       <li>nm_status </li>\r
+                                       <li>plc_config </li>\r
+                                       <li>princeton_comon_dir </li>\r
+                                       <li>princeton_comon_procs </li>\r
+                                       <li>princeton_comon_running </li>\r
+                                       <li>redundant_procs </li>\r
+                                       <li>rpmprocess_count </li>\r
+                                       <li>running_slices </li>\r
+                                       <li>uptime </li>\r
+                                       <li>uptime_idle </li>\r
+                                       <li>boot_server </li>\r
+                                       <li>bootcd_version </li>\r
+                                       <li>rpm_versions </li>\r
+                                       <li>traceroute_from_host </li>\r
+                                       <li>traceroute_to_host </li>\r
+                                       <li>hardware_system </li>\r
+                                       <li>hardware_processor </li>\r
+                                       <li>hardware_memory </li>\r
+                                       <li>hardware_disk </li>\r
+                                       <li>hardware_network </li>\r
+                                       <li>hardware_pcu </li>\r
+                               </ul>\r
+               </div>\r
+               </div>\r
+\r
+    <div class="document">\r
+           <div class="documentwrapper">\r
+                       <div class="bodywrapper">\r
+                               <div class="body">\r
+                       <h1>Purpose</h1>\r
+                               <p>MyOps-Query allows an operator to <em>very easily</em> define and collect new attributes of a running system, and it provides a simple <em>query interface</em> to report and select these observations.  MyOps-Query <em>complements</em> the existing and established mechanisms already running on PlanetLab, such as <a href="http://comon.cs.princeton.edu">CoMon</a> and Func().</p>\r
+                                                                           \r
+                       <h1>Example Queries</h1>\r
+                               <p>The following are example queries that you can perform with MyOps.</p>\r
+                               <p>Many other queries are possible by manipulating the query URL.</p>\r
+\r
+                                 <ul>\r
+                                         <li> <a href="_list/nodelist/node-status?fields=hostname,real_bootcd_version&filter=real_bootcd_version==PlanetLab+BootCD+3.3">filter=real_bootcd_version==PlanetLab BootCD 3.3</a> </li>\r
+                                         <li> <a href="_list/nodelist/node-status?fields=real_bootcd_version,real_bootcd_kernel_version,hostname&filter=real_bootcd_version=~PlanetLab+BootCD+3%26%26real_bootcd_kernel_version=~2.6.1">filter=real_bootcd_version=~PlanetLab+BootCD+3&amp;&amp;real_bootcd_kernel_version=~2.6.1</a> </li>\r
+                                         <li> <a href="_list/nodelist/node-status?fields=hostname,free_disk_root&filter=fprobe_size%3E=5000000">filter=fprobe_size&gt;=5000000</a> </li>\r
+                                         <li> <a href="_list/nodelist/node-status?fields=date,hostname,netflow&filter=netflow==Bad">filter=netflow==Bad</a> </li>\r
+                                         <li> <a href="_list/nodelist/node-status?fields=hostname,plc_config&filter=plc_config==KO">filter=plc_config==KO</a> </li>\r
+                                         <li> <a href="_list/nodelist/node-status?fields=hostname,redundant_procs&filter=redundant_procs!=">filter=redundant_procs!=</a> </li>\r
+                                         <li> <a href="_list/nodelist/node-status?fields=hostname,rpmprocess_count&filter=rpmprocess_count>=1">filter=rpmprocess_count&gt;=1</a> </li>\r
+                                         <li> <a href="_list/nodelist/node-status?fields=hostname,free_disk_root&filter=free_disk_root<=0.2">filter=free_disk_root&lt;=0.2</a> </li>\r
+                                         <li> <a href="_list/nodelist/node-status?fields=hostname,free_disk_root&filter=free_disk_root<=0.4%26%26free_disk_root>=0.2">filter=free_disk_root&lt;=0.4&&free_disk_root&gt;=0.2</a> </li>\r
+                                         <li> <a href="_list/nodelist/node-status?fields=hostname,kernel_version&filter=kernel_version=~2.6.32">filter=kernel_version=~2.6.32</a> </li>\r
+                                         <li> <a href="_list/nodelist/node-status?fields=hostname&filter=running_slices=~princeton_comon">filter=running_slices=~princeton_comon</a> </li>\r
+                                         <li> <a href="_list/nodelist/node-status?fields=hostname&filter=rpm_versions=~fprobe-ulog-1.1.2-6.planetlab">filter=rpm_versions=~fprobe-ulog-1.1.2-6.planetlab</a> </li>\r
+                                         <li> <a href="_list/nodelist/node-status?fields=hostname,rpm_versions&rpmpattern=vsys-scripts.*">rpmpattern=vsys-scripts.*</a> </li>\r
+                                         <li> <a href="_list/rpms/rpm-to-host?group=true&startkey=[%22rpm%22]&endkey=[%22rpm%22,{}]">List RPMS per host</a> </li>\r
+                               </ul>\r
+\r
+\r
+                       <h1>Supported Operators</h1>\r
+                                 <ul>\r
+                                       <li><strong>==</strong> String comparison for equivalence.</li>\r
+                                       <li><strong>!=</strong> String comparison for non-equivalence</li>\r
+                                       <li><strong>&lt;=</strong> Given a number, &lt;= converts the parameter into a number and compares it to the specified value. i.e. "root_free_disk&lt;=0.2"</li>\r
+                                       <li><strong>&gt;=</strong> Given a number, &gt;= converts the parameter into a number and compares it to the specified value. i.e. "root_free_disk&gt;=0.2"</li>\r
+                                       <li><strong>=~</strong> Given a regular expression, =~ will return rows when the attribute matches this pattern.</li>\r
+                                       <li><strong>!~</strong> Given a regular expression, !~ will return rows when the attribute does not match this pattern.</li>\r
+                                 </ul>\r
+                       <h1>Supported Conjunctions</h1>\r
+                                 <ul>\r
+                                       <li><strong>&&</strong> Logical 'and' for combining two or more simple operators.  Also, can be entered on the url as %26%26, AND, or %%.</li>\r
+                                       <li><strong>||</strong> Logical 'or'. Also can be entered\r
+                                       on the url as OR.</li>\r
+                             </ul>\r
+                       \r
+                 <h1>Supported Parameters</h1>\r
+                                 <ul>\r
+                                       <li><strong>fields</strong> a comma separated list of attribute names to report.</li>\r
+                                       <li><strong>filter </strong> a simple logic expressions for filtering which values are returned.</li> \r
+                                       <li><strong>within </strong> only return node records that have been updated in less than <strong>within</strong> seconds. (default is 3 hours (10800 sec)) </li> \r
+                                       <li><strong>skip_header </strong> do not print the attribute names as the first line.</li> \r
+                                       <li><strong>rpmpattern </strong> a pattern to match against the rpm_versions attribute. Useful for checking a single package version.</li> \r
+                                 </ul>\r
+               </div>\r
+       </div>\r
+       </div>\r
+       </div>\r
+       \r
+\r
+\r
+\r
+<div class="footer">&copy; 2006 <a href="index.html">Website.com</a>. Valid <a href="http://jigsaw.w3.org/css-validator/check/referer">CSS</a> &amp; <a href="http://validator.w3.org/check?uri=referer">XHTML</a>. Template design by <a href="http://arcsin.se">Arcsin</a>\r
+</div>\r
+\r
+</body>\r
+\r
+</html>\r