Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Fri Apr 19, 2024 3:40 pm

View unanswered posts | View active topics


Board index » Open-AudIT » Discussion

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 4 posts ] 
  Print view Previous topic | Next topic 
Author Message
MistaJayAr
PostPosted: Mon Aug 06, 2012 11:32 pm 
Offline
Newbie

Joined: Mon Nov 21, 2011 3:46 am
Posts: 13
Hello !

I have two questions:

How can i remove old printers and old PCs? I can't find the delete button :-/

Thanks for your help!
Top
 Profile  
Reply with quote  
jpa
PostPosted: Tue Aug 07, 2012 1:27 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1259
By design there is no Delete button in OA v2. You should set the "Status" of items to "Deleted" or "Retired."

You'll need to run custom SQL delete queries against the DB to really purge items from the DB.
Top
 Profile  
Reply with quote  
piperfect
PostPosted: Sat Aug 11, 2012 9:07 am 
Offline
Newbie

Joined: Fri Aug 10, 2012 7:33 am
Posts: 5
What is the custom SQL needed to run so I can enable the missing delete button?

I need to delete a computer that is showing up as a printer and is causing an error on line 2192 of the audit_windows.vbs.
Top
 Profile  
Reply with quote  
Mark
PostPosted: Sat Aug 11, 2012 10:14 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1964
Location: Brisbane, Australia
[quote]What is the custom SQL needed to run so I can enable the missing delete button?

It's not missing - it's by design. Having said that, backup your database and run this directly on the database (log in using mysql console).
[code]DELETE FROM system WHERE system_id = XXX;[/code]
Replace XXX with the system_id (grab it from the web interface). When you view a system's details, the last item in the URL should be a number - this is the system_id.
You should also be able to set the "status" on a system to something other than "production" (maybe "deleted") and it should "disappear" from the web interface. The next time you submit an audit from it, it should appear as a "new" system and not try to update the old entry.

_________________
Support and Development hours available from [url=https://opmantek.com]Opmantek[/url].
Please consider a purchase to help make Open-AudIT better for everyone.
Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 4 posts ] 

Board index » Open-AudIT » Discussion

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 2 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