I have already addressed a couple of issues with OAv2 Alpha 0.2.
It doesn't like PHP 5.3 - the short tags are ON in the code. Have replaced them. PHP 5.3 depreciates the "ereg" function(s) - I've replaced them with "preg_match" functions.
Look for Alpha 0.3 soon.
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
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
Thursday, February 4, 2010
OAv2 Alpha update
I have sent the Alpha to one of our Developers (Andy Hull).
Andy has sent some feedback, which we are working on.
I'll post the download link here, when I make a public upload (when I get home tonight).
** As promised - try this - http://www.open-audit.org/OAv2.zip
Things to bear in mind.
THIS IS ALPHA SOFTWARE.
IT WILL EAT ALL YOUR DATA.
Now that I've scared you...
Check back here later for a download link (I'm such a tease :-) ).
** As promised - try this - http://www.open-audit.org/OAv2.zip
Andy has sent some feedback, which we are working on.
I'll post the download link here, when I make a public upload (when I get home tonight).
** As promised - try this - http://www.open-audit.org/OAv2.zip
Things to bear in mind.
THIS IS ALPHA SOFTWARE.
IT WILL EAT ALL YOUR DATA.
Now that I've scared you...
- I would NOT recommend this for running in Production.
- Sure, you might audit a production system, but I wouldn't rely on this as a replacement for Open-AudIT right now. Feature wise, it's still a way behind.
- There is no install routine. You will need to know how to setup MySQL databases, et al. There IS a readme in the file detailing basic steps needed to do this. Please don't ask for help. If you cannot install this, then you shouldn't be playing with it !!! One of the things high on the todo list is an installer (both for Windows and Linux).
- Linux auditing probably wont work. I have spent most of my time on the Windows side of things. Linux auditing is on the list - and indeed there is a basic script in the download. I haven't even opened it for months though, so I'm guessing it wont upload into OAv2 correctly.
- SQL Server doesn't have a database creation script. Simply because the database schema still isn't finalised.
- Manual running of the audit script and inserting it into the web form. Running the audit script against a remote system. Running the audit script and auto uploading (via Explorer).
- Dynamic Groups. I haven't built the web forms for static groups yet.
- OAv2 users and Group permissions.
- Locations and assigning systems to them.
- Editing manual values in web forms.
- Creating / Editing / Deleting Users, Groups and Locations.
Check back here later for a download link (I'm such a tease :-) ).
** As promised - try this - http://www.open-audit.org/OAv2.zip
Monday, January 25, 2010
OAv2 Alpha is inbound
Well, I have today (Mon) and Wed off from work.
Am coding my butt off to get OAv2 into an Alpha state.
Have spent a couple of hours on it this morning, and I think be Wed night (at the latest), I will look to push the code to SVN.
Looking "good enough" at this stage.
As per my last post, the status on various items are...
* - Audit script runs on PCs and submits to database. DONE.
* - Users can be created and assigned rights to groups. DONE.
* - Groups can be created/edited/deleted. DONE.
* - Devices can be viewed with all submitted audit details. DONE.
* - Devices can have their "manual" fields edited. DONE.
* - "List" type pages (based on groups) complete DONE.
It's more about cleanup and release readiness than anything else now.
Am coding my butt off to get OAv2 into an Alpha state.
Have spent a couple of hours on it this morning, and I think be Wed night (at the latest), I will look to push the code to SVN.
Looking "good enough" at this stage.
As per my last post, the status on various items are...
* - Audit script runs on PCs and submits to database. DONE.
* - Users can be created and assigned rights to groups. DONE.
* - Groups can be created/edited/deleted. DONE.
* - Devices can be viewed with all submitted audit details. DONE.
* - Devices can have their "manual" fields edited. DONE.
* - "List" type pages (based on groups) complete DONE.
It's more about cleanup and release readiness than anything else now.
Tuesday, November 3, 2009
Apologies
Apologies for the lack of recent updates.
Unfortunately, not a great deal has happened lately.
Damn "real life" keeps getting in the way.
So, what HAVE I managed to do...
Well, I have a MSSQL Server compatible database script.
I am working on a bug in the Software audit processing routine.
For an Alpha, I'd like to get basic functionality complete. By basic functionality I mean:
* - Audit script runs on PCs and submits to database.
* - Users can be created and assigned rights to groups
* - Groups can be created/edited/deleted
* - Devices can be viewed with all submitted audit details
* - Devices can have their "manual" fields edited
* - "List" type pages (based on groups) complete
Most of these items are nearly complete (as in 90%). It is more a matter of "finishing them off".
Realistically, I think it would be (maybe) 30 hours work. Not sure there. Might be way off.
My main problem is having a "real" job and a young family (and a slight World of Warcraft addiction, forgive me).
I also have to go back through the models (in CodeIgniter) and check the functions work with MSSQL. I've had a few enquiries about MSSQL compatibility lately, and want to make sure it's all OK. I've also had people say they (think Govt Dept Managers), don't want to use OpenSource. Not PHP, Linux, Apache or MySQL. They would like it rewritten in DotNet and MSSQL. It's frustrating that people STILL have this attitude. I don't mind catering to database abstraction, but the actual code ??? Sure, I'll just re-write the complete application, because you have a completely misguided notion of what "secure" means... sigh. Apologies for the slight rant.
Anyway - what you all want to know (well, the two people who bother to read this) is "WHEN CAN WE HAVE THE CODE ?". All I can say is that's there's not that much left to do for an Alpha and I want it done as much as you do.
Unfortunately, not a great deal has happened lately.
Damn "real life" keeps getting in the way.
So, what HAVE I managed to do...
Well, I have a MSSQL Server compatible database script.
I am working on a bug in the Software audit processing routine.
For an Alpha, I'd like to get basic functionality complete. By basic functionality I mean:
* - Audit script runs on PCs and submits to database.
* - Users can be created and assigned rights to groups
* - Groups can be created/edited/deleted
* - Devices can be viewed with all submitted audit details
* - Devices can have their "manual" fields edited
* - "List" type pages (based on groups) complete
Most of these items are nearly complete (as in 90%). It is more a matter of "finishing them off".
Realistically, I think it would be (maybe) 30 hours work. Not sure there. Might be way off.
My main problem is having a "real" job and a young family (and a slight World of Warcraft addiction, forgive me).
I also have to go back through the models (in CodeIgniter) and check the functions work with MSSQL. I've had a few enquiries about MSSQL compatibility lately, and want to make sure it's all OK. I've also had people say they (think Govt Dept Managers), don't want to use OpenSource. Not PHP, Linux, Apache or MySQL. They would like it rewritten in DotNet and MSSQL. It's frustrating that people STILL have this attitude. I don't mind catering to database abstraction, but the actual code ??? Sure, I'll just re-write the complete application, because you have a completely misguided notion of what "secure" means... sigh. Apologies for the slight rant.
Anyway - what you all want to know (well, the two people who bother to read this) is "WHEN CAN WE HAVE THE CODE ?". All I can say is that's there's not that much left to do for an Alpha and I want it done as much as you do.
Tuesday, July 14, 2009
Comparisons, Templates and Items
Bit of a brain dump here.
Apologies if it doesn't make much sense.
Was talking with some collegues this morning, and the subject of reporting on systems with a config (or sections of a config) that do not match the SOE.
Naturally, I am thinking in terms of OAv2 and what it's database can provide.
Brain dump follows.
Want to compare items on a system with predefined items or a template.
Say we want to check a group of systems (WinXP) have a specific list of Group Accounts and that those Groups consist of a given list of Users & Groups.
Take a given system that fits what we want to check click "make a template".
Details on selected sections (thinking DB tables), ie - Groups for example are "imported" into a table and flagged as "Template 1".
Compare the systems in a given group to the "Template 1".
Report differences -
group does not exist,
group exists and is the same,
group exists but has these differences,
this additional group exists.
That would compare against all items (say all groups) on a group of systems.
Remember - a single system can belong to it's own group, so single systems are catered for.
Also need to define a single item, ie - software called "XYZ".
Need to compare against all systems in a group - the single line item.
Report differences -
software extsis
software does not exist
software exists with a differing version number
End goal - show me all our systems that do not meet a given Template, and give me the reasons they don't.
Code in such a way to allow for abstraction - don't care what item or table is catered for in a template. Can compare on a complete system or just selected tables (users, software, groups, etc, etc).
Brain dump finished.
Apologies if that doesn't make much sense...
Apologies if it doesn't make much sense.
Was talking with some collegues this morning, and the subject of reporting on systems with a config (or sections of a config) that do not match the SOE.
Naturally, I am thinking in terms of OAv2 and what it's database can provide.
Brain dump follows.
Want to compare items on a system with predefined items or a template.
Say we want to check a group of systems (WinXP) have a specific list of Group Accounts and that those Groups consist of a given list of Users & Groups.
Take a given system that fits what we want to check click "make a template".
Details on selected sections (thinking DB tables), ie - Groups for example are "imported" into a table and flagged as "Template 1".
Compare the systems in a given group to the "Template 1".
Report differences -
group does not exist,
group exists and is the same,
group exists but has these differences,
this additional group exists.
That would compare against all items (say all groups) on a group of systems.
Remember - a single system can belong to it's own group, so single systems are catered for.
Also need to define a single item, ie - software called "XYZ".
Need to compare against all systems in a group - the single line item.
Report differences -
software extsis
software does not exist
software exists with a differing version number
End goal - show me all our systems that do not meet a given Template, and give me the reasons they don't.
Code in such a way to allow for abstraction - don't care what item or table is catered for in a template. Can compare on a complete system or just selected tables (users, software, groups, etc, etc).
Brain dump finished.
Apologies if that doesn't make much sense...
Tuesday, May 19, 2009
Bling
Added some sparkle to the List pages today.
When you mouse over a system, you get selected details appearing.
Done via jQuery and ajax.
When you mouse over a system, you get selected details appearing.
Done via jQuery and ajax.
Subscribe to:
Posts (Atom)
Posts
