Subversion Repositories computer_asset_manager_v1

Rev

Rev 14 | Rev 36 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 14 Rev 16
Line 11... Line 11...
11
 * V0.9 20160203 RWR
11
 * V0.9 20160203 RWR
12
 * Changed to use yaml for the configuration file. Had to take the
12
 * Changed to use yaml for the configuration file. Had to take the
13
 * anonymous functions which parsed the different file types and convert
13
 * anonymous functions which parsed the different file types and convert
14
 * them to simpl eval() blocks.
14
 * them to simpl eval() blocks.
15
 * 
15
 * 
-
 
16
 * V0.9.2 20160217 RWR
-
 
17
 * Fixed issue where if a device was marked as part of a Xen machine, it
-
 
18
 * was being deleted by pci updates.
-
 
19
 * 
16
*/
20
*/
17
 
21
 
18
require 'library.php';
22
require 'library.php';
19
$VERSION='0.9.1';
23
$VERSION='0.9.2';
20
 
24
 
21
 
25
 
22
class sysinfo {
26
class sysinfo {
23
   private $report; // this will hold an entire report
27
   private $report; // this will hold an entire report
24
   private $messages = array();
28
   private $messages = array();
Line 665... Line 669...
665
                                    device_id
669
                                    device_id
666
                                 from
670
                                 from
667
                                    device join device_type using (device_type_id)
671
                                    device join device_type using (device_type_id)
668
                                 where
672
                                 where
669
                                    device.part_of = <device_id>
673
                                    device.part_of = <device_id>
-
 
674
                                    and device_type.show_as_system <> 'Y'
670
                                    and device.removed_date is null
675
                                    and device.removed_date is null
671
                                    and device.name not in ( <keys> )
676
                                    and device.name not in ( <keys> )
672
                              ) as b
677
                              ) as b
673
                              )";
678
                              )";
674
      
679