Open-AudIT

If there was a way to run the Audit script from the Admin Page, it would save a lot of time for because sometimes I'm not at my computer to run the scripts. I already have a schedule task to run the script daily and that works well.

Although, I can't get the "Audit My Machine" to work. My computer is always throwing a script error saying file not found.

Yeah, the error it throws is that it can't find the audit.config file. We haven't yet found a good way to implement auditing from the web interface.

[quote="mikeyrb"]Yeah, the error it throws is that it can't find the audit.config file. We haven't yet found a good way to implement auditing from the web interface.

Originally Mark wrote it for direct insertion in the DB, but that meant you had to install an ODBC connector on any machine that would execute the audit. Also, direct insertion by the script is potentially dangerous, as it's easier to manage the input server side (check that the data is good, etc). Plus, we would have to write a database insertion method for linux as well as windows, thereby duplicating the code. Not the best idea, imo.

[quote="mikeyrb"]Originally Mark wrote it for direct insertion in the DB, but that meant you had to install an ODBC connector on any machine that would execute the audit. Also, direct insertion by the script is potentially dangerous, as it's easier to manage the input server side (check that the data is good, etc). Plus, we would have to write a database insertion method for linux as well as windows, thereby duplicating the code. Not the best idea, imo.

Thought for making this work....

We could use the method used by the launcher, to modify the audit.vbs code. We then tell audit.vbs if it has no external audit.config, then use the internal defaults, which would be set by the launcher, and configured from a separate setup screen....

Worth a try?

I kind of think that's overkill. It shouldn't be too hard to have the scripts either on a file share, or in a zip file that you can download and then run. Am I totally wrong on that assessment?

[quote="mikeyrb"]I kind of think that's overkill. It shouldn't be too hard to have the scripts either on a file share, or in a zip file that you can download and then run. Am I totally wrong on that assessment?

[quote="mikeyrb"]I kind of think that's overkill. It shouldn't be too hard to have the scripts either on a file share, or in a zip file that you can download and then run. Am I totally wrong on that assessment?

I'm not really sure how you would implement a web front-end. First of all, linux machines can't directly talk to the WMI implementation on windows. Second, PHP has no code for connecting to WMI.

So, it would be mighty hard to implement this on the web side, short of launching wmic from php and grabbing the output. This would only work on linux.

Internet Explorer can run vbs code, but it would run in the permissions of the user, so it wouldn't help for your technicians.

All I can think of is some kind of service that runs as an administrator user that your technicians can pass computer names which it would then audit.

[quote="mikeyrb"]I kind of think that's overkill. It shouldn't be too hard to have the scripts either on a file share, or in a zip file that you can download and then run. Am I totally wrong on that assessment?

I was able to get the audit working by commenting out the line that looks to the audit.config and paste the audit.config info into the audit.vbs file. Unfortunately, the newest version doesn't have that option in the admin section.

Anyone know how I can get it back? I currently have a backup of the old code running on my webserver so I can access it. Here is what my audit.vbs looks like:

'''''''''''''''''''''''''''''''''''
' Open Audit '
' Software and Hardware Inventory '
' Outputs into MySQL '
' (c) Mark Unwin 2003 '
'''''''''''''''''''''''''''''''''''
Dim verbose
Public online
Dim strComputer
Dim mysql
Dim input_file
Dim email_to
Dim email_from
Dim email_failed
Dim email_server
Dim audit_local_domain
Dim local_domain
Dim sql
Dim comment
Dim net_mac_uuid

audit_location = "l"
verbose = "n"
online = "ie"
strComputer = "."
ie_visible = "y"
ie_auto_submit = "y"
ie_submit_verbose = "y"
ie_form_page = "http://********/admin_pc_add_1.php"
input_file = ""
email_to = ""
email_from = ""
email_server = ""
audit_local_domain = "n"
local_domain = "LDAP://"
hfnet = "n"
Count = 0
number_of_audits = 20
script_name = "audit.vbs"
monitor_detect = "y"
printer_detect = "y"
software_audit = "y"
uuid_type = "uuid"

form_total = ""

' Below calls the file audit_include.vbs to setup the variables.
'ExecuteGlobal CreateObject("Scripting.FileSystemObject").OpenTextFile("audit.config").ReadAll

Uncomment line 154 of include_menu_array.php:

[code]"60"=>array("name"=>"Audit My Machine", "link"=>"scripts/audit.vbs", "image"=>"images/audit.png", "title"=>"",),[/code]

sweet. thanks! works great!

Why dont we.....


Put a default config in the audit.vbs file, and then overwrite it with whatever we discover in audit.config IF THE FILE EXISTS... that would allow us to configure audit.vbs from the web page as per the launch {management}.vbs scripts. It would also allow us to audit from the web page.. we would however have to re-instate the configure audit page in one form or another.. Sounds like a plan