Open-AudIT

What's on your network?
It is currently Sun Feb 25, 2018 7:55 am

All times are UTC + 10 hours




Post new topic Reply to topic  [ 12 posts ] 
Author Message
PostPosted: Fri Jun 14, 2013 12:12 am 
Offline
Newbie

Joined: Sun May 27, 2012 1:22 am
Posts: 16
Had an old, corrupted database on my old OA server (v10.something) so I converted the server to use the XAMPPlite version of OA v1.0 and decided to not try to import my old data (5000+ computers).

After running a scan of my AD environment, I noticed that there were some old computer accounts that needed to be cleaned out. I deleted them out of AD, but I can't seem to find a way to delete the computers from OA. In the previous version, I would just select the node and then delete it, or run the "Delete all systems not audited in X days" script to clean it out. Am I just not seeing it or has this feature been removed?

_________________
Server Info: OpenAudit v 1.0.3
OS : Windows 2008 r2
Auditing: 5000+ machines (Public School District)
LDAP: Active Directory


Top
 Profile  
Reply with quote  
 Post subject: Re: v1.0
PostPosted: Fri Jun 14, 2013 1:30 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1254
Feature removed. You now set a systems Status to one of "Production, Retired, Maintenance or Deleted."


Top
 Profile  
Reply with quote  
 Post subject: Re: v1.0
PostPosted: Fri Jun 14, 2013 1:55 am 
Offline
Newbie

Joined: Sun May 27, 2012 1:22 am
Posts: 16
jpa wrote:
Feature removed. You now set a systems Status to one of "Production, Retired, Maintenance or Deleted."


So once a system is in, it's in forever? Machines that get booted off the domain and then have their name changed and rejoined can not be physically removed? Bad adds with inapproprate or incorrect names will always be in there? :shock:

There is no way to prune the database? I used Delete all systems not audited in X days on a regular basis to remove old data to help with system performance. With 5000+ computers on the domain all auditing at login, the server tends to get bogged down with database inserts, and then reports get slowed way down.

Also, the search button is somewhat useless. In the old version when a person called the helpdesk I could quickly type in their username and see what systems they had recently logged into, then use the offer remote assistance link. Now when I type something in the search box and hit search, I can not get it to give me a result. Also, no wildcard search (ie *mcdonald or cmcdon* gives an error.)

_________________
Server Info: OpenAudit v 1.0.3
OS : Windows 2008 r2
Auditing: 5000+ machines (Public School District)
LDAP: Active Directory


Top
 Profile  
Reply with quote  
 Post subject: Re: v1.0
PostPosted: Fri Jun 14, 2013 6:30 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1254
Yeah, I used to do that as well. You can delete the systems from the System database table if you have access to the DB.

Search is broken but fixed in the next version. I don't know when that's coming.


Top
 Profile  
Reply with quote  
 Post subject: Re: v1.0
PostPosted: Fri Jun 14, 2013 9:12 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1944
Location: Brisbane, Australia
There are two functions for this that are not made available in the menus.
SERVER/index.php/admin_db/get_non_production_systems
SERVER/index.php/admin_db/delete_non_production_systems

These will report on and delete from the database systems with a status of "deleted".
NOTE - the "count" column on the report shows the number of systems matching the hostname. It is correct, but maybe not something we are used to seeing. I had several systems that were set to "deleted", but had been put back into service, hence I had multiple systems with the same hostname, but only one with a status of deleted per hostname (if that makes sense).

These functions are not exposed because they are very powerful and there is no warnings or reversing this action. I also had users specifically request that rows NOT be allowed to be deleted because of regulatory requirements. Having the functions but not exposing them in the web interface is my compromise :-) I should probably make it an option to enable them...

I plan on introducing some general database maintenance routines soon (as has been raised here on the forums). I recently upgraded a previous employers version (they were on beta 7 from memory!), and they had 50 million rows in the alerts table. Good times!

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
PostPosted: Tue Jun 18, 2013 2:47 am 
Offline
Newbie

Joined: Sun May 27, 2012 1:22 am
Posts: 16
Awesome. Thanks Mark. That was exactly what I was looking for.

Any suggestions on the search for username in post #3? When we get a helpdesk call it was a tremendous help to search for a username in the search box and see all the systems the user had logged into. I can't seem to make this work even after I patched the m_system.php and main.php. I can search for computers now and it comes back quick, but searching for a username comes back empty every time.

_________________
Server Info: OpenAudit v 1.0.3
OS : Windows 2008 r2
Auditing: 5000+ machines (Public School District)
LDAP: Active Directory


Top
 Profile  
Reply with quote  
PostPosted: Tue Jun 18, 2013 4:35 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1254
Make sure your audits are getting this information. Check a system's "Summary->Windows Details->Last Logged on User Field" for the information.


Top
 Profile  
Reply with quote  
PostPosted: Tue Jun 18, 2013 6:19 am 
Offline
Newbie

Joined: Sun May 27, 2012 1:22 am
Posts: 16
Last Logged on User: cmcdonald@risd (ADMIN)

It's there, you just cant run a search for 'cmcdonald' and have it return anything.

_________________
Server Info: OpenAudit v 1.0.3
OS : Windows 2008 r2
Auditing: 5000+ machines (Public School District)
LDAP: Active Directory


Top
 Profile  
Reply with quote  
PostPosted: Tue Jun 18, 2013 6:28 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1254
It's working for me but I don't know why yours is not working. A search for my username hits on the Windows User Name attribute in the Windows table.

The username search already has a front and back wildcard applied as well. So "ministra" should get "Administrator".


Top
 Profile  
Reply with quote  
PostPosted: Wed Jun 19, 2013 12:36 am 
Offline
Newbie

Joined: Fri Sep 24, 2010 2:24 am
Posts: 6
Glad I found this post, as I was hoping to remove some systems from my DB. I marked theses systems as "deleted". I tried to use the index.php/admin_db/delete_non_production_systems function, however I'm receiving an error:

Fatal error: Call to a member function result() on a non-object in /usr/local/open-audit/code_igniter/application/models/m_system.php on line 561

The report function does not give an error, however it returns 0 results.

Any thoughts?


Top
 Profile  
Reply with quote  
PostPosted: Wed Jun 19, 2013 1:25 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1254
The systems with a man_status of deleted should be gone but the function is not quite correct and it errors.

Basically it's expecting a result from the Delete query which does not return results. Both the controller and model need to be fixed so until Mark does that you'll need to live with the error.

Edited thread title from [help] to [bug]


Top
 Profile  
Reply with quote  
PostPosted: Sat Jun 29, 2013 12:36 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1944
Location: Brisbane, Australia
I cannot replicate the search issue.
It works for me.

I have fixed the error when running the delete_non_production_systems function.

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 12 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group