Tuesday, May 4, 2010

Alpha 0.2 released

A new public Aplha of OAv2 has been uploaded. We're getting there slowly - but damn real life keeps getting in the way !!!

You can grab the code here:
http://www.open-audit.org/OAv2_02.zip

Some release notes...

The "system display" page still looks a bit weird in Internet Explorer.
The headings are in blue (should be dark grey).
The background of the sections overflows vertically.

Best not to alter a Groups - (eg: rename a Group).
When you alter a Group, it is not catered for when importing a system and a duplicate group is created.
It thinks the Group no longer exists and creates a new one if need be (think network groups).
I need to fix this ASAP.

There have been a few database changes.
Best to create a new database and go from there.

Not all man_ type fields are displayed on the "system display" page - to do.

Under the "Queries" menu, you will only see two options now.
Choose Groups and from there click the Group Name to see the systems.
Once a Group is being viewed, "Reports" menu becomes available.
You can run a "Report" on all systems YOU can see (not just one specific Group), by replacing the Group_id in the URL (the last number) with a zero - 0.
If you can view the "All Devices" group, it's better (SQL wise) to use that option.

The "Installed Software" SQL need attention.
Running it across ~3,000 systems takes so long, I haven't seen it actually complete.
Need to revise the SQL.
The main problem is the counting of how many installs a particular piece of software is on.
Have removed that and it is OK, but we NEED that functionality.
To be addresses ASAP.

Created a couple of seperate scripts to audit your domain or a list of PCs.
They both take the PCs and run audit_windows.vbs against them.
Check the scripts for details.
NOTE - if submitting online, make sure to set the URL in audit_windows.vbs

1 comment:

  1. One way to overcome this would be to use pagination, this way you have the ability to limit the amount of records returned and give the user the ability how many records they can see in one page at a given time. All while allowing sorting on the entire scope and acess to all the data just not in one big html table. Data is retrieved upon need instead of all at once. Not sure if tablesorter allows for this. I used jqgird which had a lot more features than tablesorter has. I have used it with oav1 but my lack of knowledge of codeigniter and the whole mvc is going to take a steep learning curve to implement. But I can show you maybe you can do it quicker. shoot me an email or contact me through the oav forums 'wnyhelpdesk' is the username.

    ReplyDelete