Open-AudIT

Hello
I am running OA 1.3.2. on Ubuntu 14.04 (originally 12.04).
While I have no issue auditing Linux machine out of the box, I have a load of issues auditing windows machines.
Some, if not most, windows audits simply do not register. The script file gets uploaded to the client, it runs locally, then nothing happens.
I managed to workaround this, basically running the script remotely from another windows machine. Some of them however, do not complete the audit process. Namely, windows machines running SQL Express hang at
[code]Software for 64bit
Software for 64bit (registry)
Software for 64bit (registry) #3
Hotfix info
Services info
mssql$sqlexpress
SQL info
SQL Express: y
SQL Server: y
DB Version: 10.50.1600.1
DB Edition: Express Edition
Instance: SQLEXPRESS
DB Login Type: Not in registry (possibly SQL Express).
DB Port: unknown
DB Type: SQL Server Express
SQL State: Running
Which Instance: SQLEXPRESS
Provider=SQLOLEDB;Integrated Security=SSPI;Persist Security Info=False;Data Source=<hostname>\SQLEXPRESS;Initial Catalog=master;
DB Instance: SQLEXPRESS
DB Count: 8
[/code]
I actually let the script run over the weekend and it didn't complete.
The vbs script hasn't been altered from default installation.
I hope there is something here that can be quoted out, since I am not particularly interested in the contents of these databases.

Move the objRS.Movenext out of the if around line 4138.

So starting at line 4134 it should look like this:
[code] if (number_of_databases > 0) then

Do Until objRS.Eof
' get the filesize
if (not isnull(objRS.Fields("filename")) and objRS.Fields("filename") > "") then
filename = replace(objRS.Fields("filename"), "\", "\\")
set colFiles = objWMIService.ExecQuery ("Select FileSize from CIM_Datafile Where name = '" & filename & "'")
for each objFile in colFiles
filesize = int(objFile.FileSize / 1024 / 1024)
next
database_name = CStr(objRS("Name"))
if debugging > "1" then wscript.echo "DB Name: " & database_name end if
item = item & " <details>" & vbcrlf
item = item & " <details_name>" & escape_xml(database_name) & "</details_name>" & vbcrlf
item = item & " <details_internal_id>" & escape_xml(objRS("dbid")) & "</details_internal_id>" & vbcrlf
item = item & " <details_instance>" & escape_xml(instance) & "</details_instance>" & vbcrlf
item = item & " <details_compatibility_mode>" & CStr(objRS("CmptLevel")) & "</details_compatibility_mode>" & vbcrlf
item = item & " <details_filename>" & escape_xml(objRS("FileName")) & "</details_filename>" & vbcrlf
item = item & " <details_current_size>" & escape_xml(filesize) & "</details_current_size>" & vbcrlf
item = item & " <details_creation_date>" & escape_xml(objRS("crdate")) & "</details_creation_date>" & vbcrlf
item = item & " </details>" & vbcrlf

end if
objRS.Movenext
Loop
end if[/code]

Thanks JPA - included in my code for next release.

_________________
Support and Development hours available from [url=https://opmantek.com]Opmantek[/url].
Please consider a purchase to help make Open-AudIT better for everyone.