Open Audit on Debian 5.03

> aptitude install apache2 mysql-server-5.0 php5-mysql libapache2-mod-php5 php5-ldap php5-gd

> mkdir /var/www/openaudit
> cd /var/www/openaudit
> wget http://sourceforge.net/projects/open-audit/files/open-audit/20081013/20081013.zip/download
> unzip 20081013.zip
> chown -R www-data:www-data /var/www/openaudit
> a2enmod rewrite
> a2enmod ldap

= Access Admin Page
http://<IP ADDRESS>/openaudit/setup.php

= Download VB script and run on Client PC
Go to -> Admin -> Audit my machine



= If you need to get time of windows update, change source code.

> diff /var/www/openaudit/admin_pc_add_2.php /root/work/admin_pc_add_2.php 

2562,2564d2561
<     $au_detect_day = trim($extended[15]);
<     $au_download_day = trim($extended[16]);
<     $au_install_day = trim($extended[17]);
2585c2582
<       $sql .= "au_detection_frequency, au_reboot_timeout, au_noautoreboot, au_detect_day, au_download_day, au_install_day, ";
---
>       $sql .= "au_detection_frequency, au_reboot_timeout, au_noautoreboot, ";
2589c2586
<       $sql .= "'$au_detection_frequency', '$au_reboot_timeout', '$au_noautoreboot', '$au_detect_day','$au_download_day','$au_install_day', ";
---
>       $sql .= "'$au_detection_frequency', '$au_reboot_timeout', '$au_noautoreboot', ";
2601c2598
<       $sql .= "au_detection_frequency = '$au_detection_frequency', au_reboot_timeout = '$au_reboot_timeout', au_noautoreboot = '$au_noautoreboot', au_detect_day = '$au_detect_day', au_download_day = '$au_download_day', au_install_day = '$au_install_day' ";
---
>       $sql .= "au_detection_frequency = '$au_detection_frequency', au_reboot_timeout = '$au_reboot_timeout', au_noautoreboot = '$au_noautoreboot' ";


> diff system_viewdef_report_full.php /root/work/system_viewdef_report_full.php 
577,579d576
<                                                                         "150"=>array("name"=>"au_detect_day", "head"=>__("Last Detect Day"),),
<                                                                         "160"=>array("name"=>"au_download_day", "head"=>__("Last Download Day"),),
<                                                                         "170"=>array("name"=>"au_install_day", "head"=>__("Last Install Day"),),



> diff /var/www/openaudit/system_viewdef_security.php /root/work/system_viewdef_security.php
94,96d93
<                                                                         "150"=>array("name"=>"au_detect_day", "head"=>__("Last Detect Day"),),
<                                                                         "160"=>array("name"=>"au_download_day", "head"=>__("Last Download Day"),),
<                                                                         "170"=>array("name"=>"au_install_day", "head"=>__("Last Install Day"),),
openaudit:~#



> diff /var/www/openaudit/upgrade.php /root/work/upgrade.php
300,302d299
<           `au_detect_day` varchar(20) NOT NULL default '',
<           `au_download_day` varchar(20) NOT NULL default '',
<           `au_install_day` varchar(20) NOT NULL default '',



> diff /var/www/openaudit/scripts/open_audit.sql /root/work/scripts/open_audit.sql
95,97d94
<   `au_detect_day` varchar(20) NOT NULL default '',
<   `au_download_day` varchar(20) NOT NULL default '',
<   `au_install_day` varchar(20) NOT NULL default '',





> diff /var/www/openaudit/scripts/audit.vbs /root/work/scripts/audit.vbs
4052a4053
>
4055,4072d4055
<   'Last Detect Day
<   strKeyPath = "Software\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Detect"
<   strValueName = "LastSuccessTime"
<   oReg.GetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,LastSuccessTime
<   au_detect_day = Clean(LastSuccessTime)
<
<   'Last Download Day
<   strKeyPath = "Software\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Download"
<   strValueName = "LastSuccessTime"
<   oReg.GetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,LastSuccessTime
<   au_download_day = Clean(LastSuccessTime)
<
<   'Last Install  Day
<   strKeyPath = "Software\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Install"
<   strValueName = "LastSuccessTime"
<   oReg.GetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,LastSuccessTime
<   au_install_day = Clean(LastSuccessTime)
<
4077,4078c4060
<                              & au_reboot_timeout      & "^^^"  & au_noautoreboot         & "^^^"  & au_detect_day            & "^^^" _
<                              & au_download_day        & "^^^"  & au_install_day          & "^^^"
---
>                              & au_reboot_timeout      & "^^^"  & au_noautoreboot         & "^^^"
4947c4929
< End Function
---
> End Function
\ No newline at end of file